Search results

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

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

Hi All, I have created a form that adds a new record to a table. One of the fields in the form is call Job Number. The new number entered in this field must be greater than or equal to the last number used. The number does not have to be I have come up with a simple query to determine the...

Hi all, I have VBA code tied to an Add Record Command button. However, when the SQL string is executed, the error message "Run-time error 3061. Too few parameters. Expected 3." is displayed. I have reviewed the SQL string for mismatch parenthesis, but cannot find any. Any help in solving this...

Hi All, I have a master table with about 40 fields. In addition, I created eight child tables with read only datasheet views of limited fields from the master table. The child table views are based on certain critera in the master table and are being refreshed by using delete and append...

Hi All, Our company uses an html application in conjunction with SQL called CoStar to house protocols that the Computer Operations department uses to run all of our daily and adhoc production jobs. Because this application does a poor job of reporting, current leads have resorted to various...

Hello All, My name is Tom. I have worked in IT for my entire career. The majority of my experience was with the Milwaukee Journal Sentinel as a Computer Operator. The last three years have been with the Medical College of Wisconsin were I was recently promoted to an Operations lead position...