Search results

Colin, Thanks very much! I will get back to you after I have a look at your db. I know I am so close to getting the data filtered based on the user, but it is just so frustrating getting over the line!

Yes Please! Thanks NauticalGent!

Hi all, I have a created a large access database to be used for multiple users. Each user has an employeeID and I want to filter the data they see when they login, based on the data linked to their employeeID. I know the functionality can be done with this on the login form but I am unsure as...

Hi Mark No the report references nothing from the jobOverview. the reports are accessed form the Job Overview. then you just close the report once done with it. I know the varArgs is optional I just included it for best coding practice. Do you think my last comment of changing the data...

That me.dirty is again giving me an error stating 'invalid use of the me keyword'. This whole thing was for when a user logged in to the database. He could click and load his own financial reports. Some background; - hoping to have about 10 users - all data is in tblJobCosts - can then be...

Paul, The data entry property was set to No as you advised. I figured out a way to display the data. I have a jobOverview tab which displays each job in a list. When you select a job from the list it opens the financial report. I had my code as this then; strFormNameJob = "frmJobOverview"...

Hi Mark, Thank you. The message box is displaying the jobID I want. But again unless the form is previously loaded it opens with no data at all. Its very strange how it is not loading the correct data. I am going to trouble shoot all events where when clicked what exact procedure does it...

I am consistently debugging here it seems to only be the where condition which makes the form open with absolutely no data when I click a jobID in access.

Yea the data field is numeric! Its a 3 digit numeric number. Thanks that debug property has certainly helped! The data is being correctly passed it is just coming back as a blank form which is frustrating. Do you know why this could be?

Paul, thanks for the quick reply!! Perhaps I wasn't as informative as I could have been. I have a sub that calls my procedure; Private Sub cboJobID_Click() Call OpenJobOverviewPopUp(Me.Job_ID) End Sub (Passing the Me.Job_ID as the argument) Then; Public Sub OpenJobOverviewPopUp(varArgs As...

Hi, I am a new access developer. I am trying to have several links in my database with Job Names. Once the user clicks each he can be directed to each jobs information. My VBA code is this in a procedure that accepts the JobID as a varArg ; DoCmd.OpenForm strFormName, acNormal, , "[JobID] = "...