Recent content by TomJ58

Thanks for the info. This is my first foray into designing a multi-user db and only my second Access db project. I have learned alot about Access from this forum.

Then how are the front end and back end linked?

They are all sharing the same network copy of the db.

Hi all, I have an Access 2010 db on a shared network drive. All users accessing the db are running Windows 7 OS and have a licensed corporate version of Access 2010. The advanced options "Shared", "Edited record" and "Open dabases by using record-level locking" are turned on. Additionally, the...

I was able to resolve this error with the following code: Set rst = dbs.OpenRecordset(strShiftLogSQL, dbOpenSnapshot) With dbs Set qdf = .CreateQueryDef("tmpShiftLog", strShiftLogSQL) DoCmd.OpenReport "rptShiftLog", acViewDesign With Reports!rptShiftLog...

First, I would indent you IF statement and match up the END IFs. Second you only need one END SUB at the end of the routine. The ELSE statement should prevent the other IF from executing when that particular IF statement is TRUE.

spikelp, The shift logs are created in advance of when they are actually used. Therefore, only the time value is contained in each record and used to determine the order of the records. First shift is from 07:00 to 19:00 and second shift is from 19:00 to 07:00. First shift is easy to sort by...

The .Value is the bound value of a multi-value field . I am trying to use the bound value as a sort parameter. The field options are (1,Before), (2,At) and (3,After). I am using the multi-value field to create a shift log report that starts at 7:00 PM and ends at 7:00 AM. This is the only way I...

Thanks for the reply mdlueck; however, I have already done that in reverse. The SQL statement for "Closing" was copied from a query's SQL view: SELECT tblCostarJobMaster.JobNumber, tblCostarJobMaster.JobName, tblCostarJobMaster.JobNotes, tblCostarJobMaster.SchedSequence.Value FROM...

I am testing a function in the Immediate window. The function uses input from two Inputboxs to select a query and and open a report based on the query selected. strGetShift = InputBox("Enter Shift - First, Second or Closing:") dtGetDate = InputBox("Enter Schedule Date:") When I...

The users will not see the raw query. I am building a VBA subroutine with a CASE statement to select one of three queries based on form input. I use the MS Access query design GUI to create a similar query in order to get the SQL statement syntax correct. I am also testing the subroutine by...

I know the sort without displaying the time is incorrect because I have writen down the correct order by job number. The recordset is roughly 50 records.

I have created a query that is causing an ordering problem. If I use the following SQL code: SELECT tblCostarJobMaster.JobNumber, tblCostarJobMaster.JobName, tblCostarJobMaster.JobNotes FROM tblCostarJobMaster RIGHT JOIN tblSequence ON tblCostarJobMaster.SchedSequence.Value =...

I found the solution. In the form's validation rule for Access 2010 use the following format: =>DMax("[field name]","[table name]")

The job number is not the primary key because the number originates in a MS SQL database. The SQL database is part of a web based design that allowed duplicate job numbers. Also, the job numbers entered in the web designed database were not always sequential entered in the past, but are still in...