Search results

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?

Class Module - ColumnListBox Option Compare Database Public CLB As New ColumnListBox Form CodesDx Option Compare Database Private WithEvents mListBox As Access.ListBox Private mColWidths As New Collection Private mClickedColumn As Integer Private mClickedValue As String Private Sub...

Thank you for all of your help. I'm learning a lot as I go along. I'm now having a problem with a different error. My listbox is me.lstDx. So I've modified the code to "CLB.Init Me.lstDx" in the Form_Load(). But now I'm getting a runtime "424-Object required" that error right at the same...

Thank you for your response MajP. I think your solution is exactly what I'm looking for. I'm trying to apply your code to my application but am having an issue. At first I added all of your code with the necessary changes to apply to my listbox. But I got: "The expression On Click event...

Thanks bastanu. I was hoping there might be a great way to do this. But I guess my only way is to create a single column listbox and then when the user clicks it will be column(0). Thanks for all of the input. Thanks GPGeorge also. I'm going to use a group option buttons at the top of the...

Thank you for your responses. What I'm getting as is if the user clicks 'Wave'. How does the code know when the user is clicking row 1 and column(3)? I don't understand how the code knows which column the user is clicking? Does that make any sense? What if the user clicks something in...