Search results

Not if you deploy it to the EndUser with a fancy BAT file that will copy the DLL to system32 and register with Windows.

Or change the system settings to UK and not US. I've got loads of Date/Time fields and by default the dates are in dd/mm/yyyy format.

Try setting the said form to open using the Tools > Startup menu.

You need to change the system settings for UK dates format, not US.

OnMouseWheel event maybe? There's various pieces of code out there on the net, that will do this too. I've even seen one that requires a DLL to be loaded!

Thank you, that works perfectly. I've put both in the same event. With no unwanted effects... Private Sub txtDateOfBooking_BeforeUpdate(Cancel As Integer) If Weekday(Me.txtDateOfBooking, vbSaturday) <= 2 Then Cancel = (MsgBox("The Booking Date is on a " & _...

Yikes, didn't even think about the logic of the tests. I'm not great at VBA, I can get by, but thats about it. "it's not having it" means it's erroring out. Tells me it expected an ")". I guess my syntax is wrong somewhere, but I can't see where. Or I've totally fucked up the MsgBox function...

The MsgBox bit, I've tried taking datAdrenaline's MsgBox code and adapting it, but it's not having it. I'm trying different varations of: If Me.txtDateOfBooking < Date Then Cancel = ((MsgBox("The Booking Date takes places in the past") & vbCrLf & vbCrLf & _ "Do you want to keep this...

In Query Builder, just add the columns [Start Date] and [End Date]. Then in your report, drag the fields from Field List onto the report. Just tested it here and it works fine.

Expanding on namliam first option. In query criteria just put: Between [Start Date] AND [End Date] In the respective field.

I need some more help. I want to add a bit more functionality to this. So as well as having the DB pickup dates entered falling on Saturday and Sunday. I want the DB to alert me if the data entered takes places in the past. Eg: Today's date: 01-12-08 And if I enter 11-11-08 in...

Oooo didn't know that trick. Cheers.

Yeah I guessed that the F11 method is disabled by the checkbox that talks about Special Access keys. And I've read about the BypassShift key function or something. Still learning though!

Just did this on a test DB. Shift method worked. F11 did not. Either way I've learnt something new. Thanks!

Use an IIF statement to check if the book is in or out, then return the value in the availbility field. Edit* Homer simpson moment, I thought we were talking about in the form. Ignore the above. I'm an idiot (see my sig) :D.

Start a new database in access. Then import the database you messed up. Next time keep multiple backups!

Something like this would be a starting point... tbl_Agent tbl_InsuranceCompanies tbl_Customer tbl_Policies tbl_BusinessArea tbl_Claims

Sounds like you are invoking the Parameter function when using [square brackets]. Check all the references to the fields are correct.

^ If you can, upload the DB.

I don't think the Date range prompt should affect that. In the unbound text field, right click on it and select properties. Navigate to the 'Data' tab, and delete everyting in the Control Source line. And replace it with... Please Enter Report Title Exactly as you see it above. It should...