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 Shaun E 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: zepphead80
  • Content: Threads
  • Order by date
  1. zepphead80

    Problem with .UpdateBatch in ADO...

    Hi: I am attempting to pull a backend table into a local recordset, make some changes to it, and commit the changes back to the table. I'm using an ADO recordset in Access 2007. The backend resides on a network drive while the front end is on my C: drive. My code is as follows: Dim...
  2. zepphead80

    Parameterized SQL UPDATE problem

    Hi all: I've got one of those problems that I just can't get around, no matter what! I'm working in Access 2007/VBA, using an ADO command structure. In my code, I've got a SQL UPDATE like: strSaveLeave = "UPDATE tblLeave SET fldLeaveType = @LeaveType, fldLeaveStatus =...
  3. zepphead80

    Problem with DSum / Undefined function in expression error...

    Good morning: I am attempting to use the DSum aggregate function in a VB module that is part of my Access database. The line of code looks like this: Me!txtLostDaysNoPaySeasonal = DSum("getNumberOfWeekdays([tblWC]![fldDateOfNoPayBegin], [tblWC]![fldDateReturned])", "qryTest"...
  4. zepphead80

    Viewing information not in form's record source

    Hi: I know there's a real basic answer to this. I'm fairly new at designing Access forms... I have a form whose primary responsibility is to display information from two different tables, tblEmployees and tblWC. These tables are joined in a one-to-many relationship (one employee can have many...

Part and Inventory Search

Back
Top