Search results

It can be any of them but we can use the third one as an example. I want to get back 1087692 (without the ,) and not 1093432

Data examples: SO#1087692/PO#KK10345678 1087692, KK102345678 ABC10934321/1087692,693,694 As you can see in each line there can be more than one number starting with 10 that would be found it simply looked for 7 digits starting with 10. However, using the delimiters found at the end of the 7...

Could I bother you for one more segment? I need to look for delimiters after the combination. The data seems to be separated by many different delimiters. Any thoughts?

That did it! Thank you so much!

Same data in a field (3 examples): PO# 284523ABR34 / SO# 1087321 BCD3345,1087321 17534 Here is a function I found from a programmer "willybgw" that looks for a 10 character combination beginning with 2 letters followed by 8 digits that works great for finding PO numbers. To get it to find my...

I tired to make this work for me but no luck. This will primarily be used in queries and the field will be of variable length. The 7 digit combination can be anywhere in the field.

I need to test a field to determine if it has a 7 digit number combination that begins with a "10", 20", or "80' and if it does, return that 7 digit number combination. A function to do this would be great. Is this possible?

Thanks for the feedback. The database is for internal use only but I guess I will need to get more familiar with forms!

I have two tables, Invoice and Frt_data. The two are linked using two fields (Customer_number and Process_date). I need to enter the month name in the 'AP_month' column of the Frt_data table based on the Invoice_nbr in the Invoice table. I created an update query containing the fields...

Hope somebody can help with this. I checked the archives but not luck. My continuous form allows entry of 12 records. On the thirteenth record the new row scrolls to the top and all the previous rows disappear. Every new record after that scrolls up out of view and a new blank row is at the top...

Hope somebody can help with this. I checked the archives but not luck. My continuous form allows entry of 12 records. On the thirteenth record the new row scrolls to the top and all the previous rows disappear. Every new record after that scrolls up out of view and a new blank row is at the...

Hello llkhoutx and CEH, Thanks to both of you for your feedback. I have it working now! Thanks again, Kerry

I have a query based continuous form that looks up a serial number entered by the user and allows them to view the matching data. When a user enters a serial number that is not in the database I want a message box to pop up to warn them there is no match. The code I am using makes the msgbox...

Hi KeithG, Thanks for responding. I am getting desperate with this project. Here is a small copy of the database. Thanks, Kerry

Hi KeithG, Thanks for responding. I am getting desperate with this project. Here is a small copy of the database. Thanks, Kerry

Hi group, I am a newbie to Access and VBA programming. My original post was probably not very specific as it was not answered but I really need help on this! TABLE1 stores a list of serial numbers and a status field (it contains the word Pass or Fail). The NEWSN table is used to capture new...

Hello group, I am a newbie to Access and VBA programming and have been struggling with a few problems I am sure is simple for this group to solve. My database has two tables: 'Drive Test Results' containing SERIAL_NUMBER, DATE, TIME and RESULT fields among other data; 'Packing Station Scan'...