Hey everyone. Can anyone help me come up with a script that will allow me to import a text file...
(More)
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file that's in the format shown below? I'm trying to import this file into an Access database table. The file has spaces between each line which is what is giving me a fit. Please look at the file layout and example below. Text File Layout: a = Lockbox #: (6) digits and (4) leading spaces. Postions 1 - 10 b = Site ID: (2) digits and (8) leading spaces. Postions 11 - 20 c = ISA #: 10 spaces. Postions 21 - 30. Not used currently d = Cust #: 5 spaces. Postions 31 - 35. Not used currently e = RG Key: 11 spaces. Postions 36 - 46. Not used currently f = Tran Code: (4) digits (4) spaces. Postions 47 - 50 g = Record #: 4 spaces. Postions 51 - 54. Not used currently h = Count #: 2 Spaces. Postions 55 - 56. Not used currently i = Volume (17) digits, zero padded to the left of volume. Postions 57-73 j = Dollars (14) digits, zero padded to the left of volume. Postions 74-87 k = Description: 240 spaces. Postions 88 - 327 l = GL #: 23 spaces. Postions 328 - 350 m = Adjustments: 3 spaces. Postions 351 - 353 Text File Example: 105243 12 4101 00000000000009552 105243 12 4102 00000000000000325 105243 12 4108 00000000000043838 105243 12 4110 00000000000043838
I am getting the message "Module not found" after deleting a form that I no longer use...
(More)
I am getting the message "Module not found" after deleting a form that I no longer use anywhere in the database. If I put the form back - issue goes away. If I rename the form - comes back. Something is calling this form but I can't see what. Nothing references it in VBA, macro, query, etc. Where can I look next to see what is calling this thing?
I have a database built. In the Form I enter a Center and in a seperate box the County it is in....
(More)
I have a database built. In the Form I enter a Center and in a seperate box the County it is in. When I send out my surveys each Center is assigned a number that is only for that Center. I want to speed up my data entry, so I'm wondering if there is a way to simply enter my assigned numbers so that when it is entered, it will come up as the specific County and Center for all of my reports. Can this be done with a query or a Macro? I figure I would have to build a spreadsheet for the program to reference but I don't know where to go from there.
I have 2 tables: Customer Data that only ever contains one row of data for each customer booking,...
(More)
I have 2 tables: Customer Data that only ever contains one row of data for each customer booking, within this table there is a Column called Deposit Value Requested which is manually updated e.g. £50.00 Payment Data containing multiple rows of data depending on the number of payments received for each booking. I then have a query that contains all the columns from the Customer Data and a summarised total of the payments received for each booking, this is so that I can see the total payments received for each booking. I would like to add an additional column to the above query that calculates the value of deposits received. I have tried an Iff formula to establish this e.g. Iff(Payment Value >=Deposit Value Requested, Deposit Value Requested, Payment Value). This works providing there is only ever one payment, however when more than one payment is received I need to somehow add a summary within the Iff statement that says something like this: Iff(Sum of Payment value>=Deposit Value Requested, Deposit Value Requested, Sum of Payment value) Any help?