Search results

No, some contain 10 numbers, other 13, etc. but no less than 8 and no more than 13. Thanks

1 more thing, how can I modify the code to pick up my leading zero's? I have some numbers that begin with a "0" and need to capture that as well. This code is wonderful!!!!!!! Thank you so much for your help.

That's Great!!!! Thanks for your help.

Is there a way to write a query where it will only capture numbers? For example, if I have the following: "Testing transactions 11100202020 in the following order" What I would like to do is capture the numbers that is in the middle of the sentence. I have tried using the len, left, mid, right...

Is this possible to do? With VBA code?

Does anyone know how to have a subform refresh all of its fields and add/delete new fields based off of the query it is linked to? Thanks

Does this have anything to do with settings in MS Word?

I have a HP850 printer on a W2k box. Everytime I print (I had to reinstall W2k), the second page's font grows to like 42. How can I fix this? Thanks for your help.

Hello all, I have a query that on occasion needs to have the criteria updated; however, I don't want to use the docmd.openquery in design method. My users aren't SQL savvy and I am afraid they may mook something up. I need an idea on how to accomplish this. I thought of making a table with...

Thanks Bob

Hello, How do I perform an update query to find a "/" and update it to a "-" and keep all the characters? Thanks

OK, gottcha, I set RST1 within the loop and now it is giving me all of the results in the recordset. How can I tell it to only give me the information from each recordset into each file? Each recordset could have12 to 20 with matching information that I need to see. Can this be grouped by the...

Hello all, thanks to Dennisk and Paul, I am able to move through my recordset and create a directory with each individual name. Now, I am attempting to "FileCopy" an excel template into each directory with the directories name.xls------got this fine. Now I am attempting to copy and paste each...

Paul Gees, I can't believe I missed that......thanks for your help.

Dim rst As DAO.Recordset Dim DIRName As String Dim folder As String folder = "H:\Projects\" DIRName = folder & rst Set rst = CurrentDb.OpenRecordset("tblofficers") Do Until rst.EOF MkDir DIRName ' Process each officer here rst.MoveNext Loop

Paul WHen I try to set the value to the recordset, it wont continue.

Paul- Here is the code that I am using with dennisk's help. I need to create mulitple directories based off of the tblofficers. Thanks for your help. Private Sub command13_click() Dim rst As DAO.Recordset Dim DIRName As String Dim folder As String folder = "H:\Projects\" DIRName =...

When I add mkDIR dirname to the code, it will not go to the next recordset. I stops everytime on the record it sees first. What am I doing wrong? THanks

Where would i put my code to create the directory? I keep getting an Compile error "Loop without Do". At ' Process each officer here, that's where I put my DIR information, correct? Thanks again

Dennisk, Yes, that is exactly what I am trying to do. What would you suggest?