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 TouchToneTommy 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: jamessl
  • Content: Threads
  • Order by date
  1. jamessl

    refering to a variable in SQL string

    Hi this should be simple - I just need to refer to a variable in an SQL string in my VB code. The string is - rstUpdate.Open "SELECT * FROM [Customer Orders] WHERE [Cancel Booking] = False AND [Date Ordered] > #08-20-02# AND [Tour Date] > #" & Format(Date, "dd-mm-yy") &...
  2. jamessl

    SQL syntax problems

    Can anyone point me to some kind of reference which points out the ground rules for the SQL syntax in an SQL string in Visual basic. It obviously differs from that you see in the SQL view of a standard Access Query grid. The Access help function only has limited examples it would seem. My...
  3. jamessl

    Date syntax in SQL string

    Hi, does anyone know the correct syntax in an SQL string as part of the Recordset Open method to refer to a field on a form. I currently have - rstBookingsSchema.Open "SELECT * FROM BookingsSchema WHERE Date = " & Forms!BookingForm!Date & " ORDER BY Period", conn, 1...
  4. jamessl

    Create a recordset in a VB module from a table

    First up I am a VB rookie. I am writing a VB module which edits a group of records in a table based on some information entered on a form. I need to write a module as the manipulation/editing of the records is slightly complex. My (simple) question is - I need to select a group of records...
  5. jamessl

    Excel Charts - need help designing/customising charts!

    I think this might be complicated, but I am hoping it isn't. Firstly, I have data that will need to be imported from a table in Microsoft Access. An example of the data fields is - Employee Number Time Out Time In 161 07:00 06:00 84 08:00...
  6. jamessl

    Create Records in a New table based on intervals in a range

    I have a Booking table (fields - Employee number, Date, Start time, Finish time) in which an employee enters a start and finish time for when they will be booking some equipment - eg Employee Number - 1, Date - 23/07/02, Start time - 10:00, Finish time - 18:00. How would I get a query (Code??)...
  7. jamessl

    Filter data by exluding records retrieved by query

    This seems simple enough...but I don't know how to do it! I have a query that selects records based on date criteria from a table called Bookings. The returned data can contain more than one record with the same Employee number (in the Employee Number field). I want a query or form which...

Part and Inventory Search

Back
Top