Search results for query: *

Hi everyone, I created a database that writes to a text file. This was working fine when I was using it on Windows 98. However, when I changed offices and got an XP computer, I got an error. The following lines: Set fs = CreateObject("Scripting.FileSystemObject") Set A =...

Hi everyone, I have two questions, and would appreciate any help you can give me. 1. I have a crosstab query, that lists job number vs date vs a number of items. I want to make the criteria for the job number the openargs from a form. However when I put in [Forms]![IssueForm].[OpenArgs] as...

That's pretty much exactly waht I needed. Thanks Anthony.

Thanks Darrylle, What I want to do is interrupt stop my code, fill in all the boxes on my new form that I open, click the command box to finish, and then return to my first form and resume my code from where I left off, with new instructions that depend on what I put on the second form. I hope...

Hi everyone, Sorry if this is an easy one but my little Einstein guy is not working at the moment. Anyway, what I would like to do is have my code pause and open a new form. I then click a button on that new form and, depending on what the button is, my code then goes on its merry way. I am...

Hi Everyone, My six month project is nearly complete. The last thing (maybe) I need help with is getting rid of the automatic warnings that come up when I enter this code: DoCmd.RunSQL "DELETE * FROM NewTable;" Is there any way of getting around this? Thanks, Joe

Hi Everyone, I'm using the following code to loop through query records and add them to a table when my form opens: Set rst = db.OpenRecordset("Companies For Job") rst.MoveFirst Do While rst.EOF = False Set rstCompanies =...

Try controlName = "cmd"&i Me.Controls(controlName).Caption Could work. Joe

Hi all, I am using the following code to put data from a textbox (text8) in my Access form into a Form Field in a word template called "Discipline": Set oApp = CreateObject("Word.Application") oApp.Visible = True oApp.Documents.Add...