Search results

WOW! That's an interesting approach. But I also want to save information in a table for each photograph, and later add search facility to query the database.

Hello everyone. I have this code that I adapted for one of my projects years back to save images into a table but now I just cant get it to work. When I tried it this time, I was getting an error "The code in this project must be updated for use on 64-bit system", and so I found some suggestion...

Yeah, it that already. Thanks alot

Yeah thank you.

Wow! It works as expected. Thank you so much. Private Sub Form_Current() Dim dteDate As Date 'the next 2 line will give the datetime 20 minutes ago as 1/72 day = 0.138889 dteDate = CDate(CDbl(Now()) - 0.0138889) Me.AllowEdits = True...

Surprisingly it doesn't run as expected. My idea is to disable certain controls after 20 minutes of capturing data. So, i expect that those controls will be disabled when viewing data older than 20 minutes ago. Please, see attached stripped database file for reference. I appreciate your help.

That doesn't change the formatting i am getting within the code i posted earlier. I mean, the windows date formatting was already 24 hour clock i.e 09:45

Hi, I need more help here. I want only to read the minutes as: Me.txtJustTime >= #00:20:00# But that keeps changing itself to Me.txtJustTime >= #12:20:00 AM# Any ideas how I can do this, please.

Thank you dear Paul. You are a life saver.

Noted And YES, It should be Me.txtJustTime >= #00:20:00#

Indeed! So then this should be good to go? If DLookup("[data]", "tblCoordinators", "[userID]='" & Forms!frmEvents_Menus!txtUserID.Value & "'") = -1 Then If Not IsNull(Me.txtEvent_ID) & Me.txtJustDate >= Date() & Me.txtJustTime <> #00:20:00# Then Me.AllowEdits=false End If

Greetings, I want to lock data editing on the details form for the "data" user based on: whether the date the record was added is equal or greater than today's date and the time elapsed is equal or more than 20 minutes If DLookup("[data]", "tblCoordinators", "[userID]='" &...

Oh, please pardon me, I am so sorry. It works just fine.

Okay, just to test it, I have put this code on the openform event. The current record on the form already has all the mandatory field populated, but the subform is not visible: Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If Len(Me.txtEvent & vbNullString) = 0 Or...

So, for each control I should include in that code: If Len(Me.txtEven & vbNullString) And (Me.txtStartDate & vbNullString) And (Me.txtEndDate & vbNullString) = 0 Then MsgBox "You need to fill out SomeControl" Cancel = True Me.SomeControl.SetFocus End If

Hi, I have a form with text boxes for adding new Event. I want to check if the mandatory ones have data in them. I need this to ensure that the subform used to add participants to the Events is visible only when the mandatory text boxes have data. How can this be done?

Yes indeed, you are very right. Please, I will be back if anything. Cheers!

Okay, I have done that. But when I move the back-end file from its usual place to another place, the code just pops up a message that the back-end file cant be found in that directory. Next, I want to have an option to choose the back-end file myself through the open file dialog and I have no...

Hi, Please, where can I find a working sample of how to re-link tables if the back-end has moved to a different directory either automatically or by asking the user to choose the new location for the back-end? I have tried to find some but they don't work that way. The closest I think would...

Hi, I want to recreat my menu form with a switchboard created through the switchboard wizard. The only thing is that the new switchboard buttons aren't catchy; I want buttons with images on them corresponding to the button action. Here is my switchboard for easy reference. I will...