Recent content by craigachan

Thank you all for your suggestions. It sound like if I get a list of all the city names in AZ, and then run the AddressCity against that, then I can separate everything else. I'll give it a try and see what happens. I'll post back my solution if it works. Thanks everyone.

Thanks you for all of your suggestions. I have no problem converting the PDF to text. My problem is with the next step. I have 1500+ postal addresses that would make it very cumbersome to cut and paste each one. I can get the list into a .txt file that looks like this: As you can see the...

I'm looking to extract the addresses from a set of mailing labels (pdf) into my database. The labels are scanned copies of Avery labels 3 across. Does anyone have any idea how to do this. I have about 1500 address to extract. Any help would be appreciated, even if I have to purchase an OCR...

Here is my code. Keep in mind that this is based on a sql db that doesn't alway cooperate with MSAccess Queries. The way I found around it was to create a tables of the queries that I want and then it converts field data correctly. Thanks for everyones input. Based on the main...

Thank you all so much. I finally realized what arnelgp was explaining. It all works now. Here is my code: Dim startDate as date, endDate as date, dDate as Date, msql as string startDate = dDate - Weekday(dDate) + 1 endDate = dDate - Weekday(dDate) + 7 If...

Sorry about that: SELECT * FROM (SELECT *, DateSerial(ledger.[year], ledger.[month], ledger.[day]) AS DOS FROM ledger WHERE ((ledger.[year] + ledger.[month] + ledger.[day]) is Null) = False) WHERE DOS >= #9/25/2022# AND DOS <= #10/1/2022#

Like this? I get runtime 3065 cannot execute selected query

Sorry, to clarify my dDate is a date. So it is in the right format. I've attached a pic of the final sql.

Thank you so much. So here is what I have now. dim dDate as date, startDate as date, endDate as date, msql as string, msqlA as string startDate = dDate - Weekday(dDate) + 1 endDate = dDate - Weekday(dDate) + 7 msqlA = "SELECT *, DateSerial(ledger.[year], ledger.[month]...

I inherited a database where instead of a date field, the month, day, and year are in separate string fields in the table. If the dates that I want to filter span the end of one month to the beginning of the next month, how do I write this code: Example dates: 9/25/2022 to 10/1/2022...

Hi theDBguy. Thanks for your reply. I worked 2 days on this and in hind sight should have come to this forum first. I did have the 2201 update. So I rolled it back to the previous version and everything worked fine again. Of course I turned off auto updates for now. Well at least I cleaned...

I'm hoping someone has some knowledge of this issue. I have an FE and BE. Each workstation (the max using the front end is 3 persons) has the FE on their computer in \documents. My BE is on a server and has 2 databases that the FEs link to. ( I use alot of temptables when possible) one that...

Moke123. Thank you. I'll give it a try. I'm still trying to understand Class Modules and how they work. You make a lot of sense.

SOLVED - Works Perfectly how I initially wanted it to. A couple of things to take note of. 1. It won't work if you set the listbox.columnwidths with code. you must do it thru the access application interface. 2. Following MajP's examples for FindAsYouTypeListbox, in the actual form code I...

moke123 -Very nice idea, but should a certain filtered list exceed the number of buttons or form fields then what?