Access 2000 Macro solution wanted. I have created a macro that looks at an address field (43 Oxford St)and reads the last two characters entered to complete the address. For example if the last two characters are 'ro' it adds 'ad' to read road. Similarly 'st' would be concatenated with reet' to read street. This works well but there are some two letter sets that have multiple endings, e.g. 'gr' could mean 'grove' or 'green', ['me' = 'mews' or 'meadow']. In the underlying lookup table for these scenarios I have entered 'ove/green' [ws/meadow] as the text to be concatnated. Now I want to alert the person entering the data to select one of the options offered and delete that which does not apply. To do this I need to be able to search for a '/' somewhere in the text string and should one be found have a warning message pop up. If I could use a query I might be able to use Like "*/" but I can not find an equivalent in the macro formula. Anybody got any ideas. In anticipation of your help, thank you.
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?