Recent content by ecastro

Drag & Drop Docs Form (.doc,.pdf,etc) and Automatically Copy File to Windows Folder I have been looking for months now and can't find a sample database or a step to the right direction for creating an Access Form form that I can drag and drop .doc, .xls, .pdf files into it and having the form...

I am sorry you are correct, its the opposite way around, it is giving me 10 instead of 09, on the new records created. How would I change this?

Hello everyone, I hope someone can help me with this vb code for an afterupdate event. The code works but for some reason it is not recognizing the Fiscal year I thought I set it up for. For example FY2009 will end March 31st, 2010. The new FY2010 will begin April 1st,2010. But if I tried to...

THANK YOU GUYS!!!!! I DEFINITELY BOOKMARK THIS WEBSITE! IN CASE ANYBODY IS WONDERING HERE'S THE CODE SETUP: Private Sub DockDoor_AfterUpdate() If Len(Me.DockDoor & vbNullString) > 0 Then If Nz(DLookup("Status", "tbl_YardDockDoors", "DockDoor_ID = " & Me.[DockDoor]), "") = "INUSE" Then MsgBox...

I know DockDoor_ID is a number but how can I tell if DockDoor (form text box) is?

If messages are displaying but for some reason if its null it is displaying a runtime error 3075 " syntax error (missing operator) in query expression 'DockDoor_ID='. Here's the code I have: Private Sub DockDoor_BeforeUpdate(Cancel As Integer) Cancel = True Dim stDoorStatus As String...

This is what I tried.... Dim stDoorStatus As String stDoorStatus = DLookup("Status", "tbl_YardDockDoors", "DockDoor_ID = " & Me.DockDoor) If stDoorStatus = "IN USE" Then 'What to do if In Use MsgBox "In use", vbOKOnly, "In use" If stDoorStatus = "INACTIVE" Then 'What...

For some reason, they are not working. I am not well with code. Is it better if add this code in an after event or before event?

I am creating a database for a Warehouse Yard Management where a user can detect which dock doors are in use, inactive, or available. But its not working like it should. Basically if a truck driver arrives we assign it a dock door. After we assign a dock door then it checks that dock door is "In...