Search results

The company I work for is likely going to have a site-to-site VPN setup for their Access database. The problem as I see it is that some employees will not have Internet access and will have to work with a copy of the database while offline. What is the easiest way to get this offline copy of...

Unfortunately I had tried that originally, but it tells me that there are elements that are only for 2010. I will see if there is anything I can do about that though.

I have uploaded the database I am trying to get this to work in if anyone can help. Thank you.

The purpose of my combobox is that when a user needs to change information or use the same values and save to a different date, the user can use the combobox and find the date they need. At the moment I have two forms: frmUserID & frmGenSum frmUserID pops up first and a valid user ID must be...

Thank you rammudali! I had thought about a compound index key, but I didn't think that would work!

I have two tables, a tblUsers and a tblDailyReport. The tblUsers only stores a User ID. The tblDailyReport stores both the Date and the User ID. I have a relationship from tblUsers to the User ID on tblDailyReport. tblUsers has its primary key set to User ID. While tblDailyReport currently has...

Thanks VilaRestal, that's an even better solution!

As always VilaRestal, thank you for the help! You push me to get things done!

However, I just tested this when it is not blank (just a random User ID that isn't in the table). This does bring up the Microsoft error still. It works if it is on a now date without issue. But on a date that already has information, it will give me the Microsoft error. I noticed that...

It's in the actual text field, but I realized, if the user is forced to use the Save button, then it will work there. I couldn't get Me.Undo or Cancel = True in the text field VBA (for BeforeUpdate or AfterUpdate), but since the user has to use the Save button, pressing it gets it to work...

I have a field to input a User ID. It is validated by another table where all the User ID's are stored. The code I have inserted works and makes sure that the user receives a message to describe the problem: Private Sub UserID_AfterUpdate() If IsNull(DLookup("UserNum", "tblUsers", "UserNum =...

Thanks for the help VilaRestal. I ended getting it to work with this: Private Sub txtUserID_AfterUpdate() If IsNull(DLookup("UserNum", "tblUsers", "UserNum = '" & [Forms]![DailyReport]![txtUserID] & "'")) Then MsgBox "UserID Not Found!" Else MsgBox "UserID Found! "End If End Sub

I have two tables, "tblUsers" and "tblDailyReport". tblUsers only records Text for the field "UserNum". tblDailyReport has many fields, but has a direct relationship from UserNum to its own "UserID". People have the ability to add to UserNum to create their own unique user. I have a form that...

After more testing, it is actually not working. It completely ignores the End Date whether or not it is locked now.

It took me forever, but I got it working. I first put in a statement that stated if End Date was locked then 'a' was False. The I used 'if condition a, then condition b'.

It does say locked. I'll have to keep checking, this is puzzling.

Unfortunately it is, that is why I've been confused.

It is locked, disabled, and grayed out.

There is no error number, it gives me the MsgBox that states to put in an End Date. I guess that would be an logic error.

Still asks for End Date as it did before with the other tries.