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 Mike Lewis 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: *

  • Users: Roe
  • Order by date
  1. Roe

    InStr Function for Criteria of Query

    Thanks tlBroadbent It work brilliantly. The StartDate was a narrative the actual field was Start. I have used the InStr funtion on a previous query for example it was used to produce a report with the option for the user to enter a Client of go for ALL Clients. Mind you if there is a easier...
  2. Roe

    InStr Function for Criteria of Query

    I'm having problems creating a InStr Function in a query to print out a report. The user enters the StartDate (date format) for the Job Number Report but I would like the option of ALL, leaving the user with the choice of entering a date or leaving the prompt box blank. The InStr Function in...
  3. Roe

    SOS - Database Security?

    Under the FAQ 7.c. I found a nice piece of coding from elizabeth to capture the ID of users from the network in MS Access. I have pasted this coding into a module but being very very new to access I'm not sure if 1. I need to create a table with a user names? 2. Do I have to place the fields...
  4. Roe

    Design a query by form to produce a report

    Being a Novice I'm having difficulty in knowing where to start. I want to design a query by form to selecting several or some items from Combo box's: Client, JobID, Ops Controller, Nominal Code and Sales (all from seperate list tables), and use toggle boxs for the Status selection which needs...
  5. Roe

    Help with Query By Form to produce Reports

    I'm having difficulty in knowing where to start. I want to design a query by form to selecting several or some items from Combo box's: Client, JobID, Ops Controller, Nominal Code and Sales (all from seperate list tables), and use toggle boxs for the Status selection which needs to include a...

Part and Inventory Search

Back
Top