Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Joey4Js

    Access denied

    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 =...
  2. Joey4Js

    Crosstab criteria

    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...
  3. Joey4Js

    Pausing code

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

    Pausing code

    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...
  5. Joey4Js

    Pausing code

    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...
  6. Joey4Js

    Getting rid of Warnings

    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
  7. Joey4Js

    Hi Everyone, I'm using the follo

    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 =...
  8. Joey4Js

    Find out the contents of a variable

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

    Sending Data to Word

    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...

Part and Inventory Search

Back
Top