Search results

I have a query not working correctly with the dates field DateProv = DateTime ie '15/07/2017 10:12:10' string FromDate = ShortDate ie '15/07/2017' SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND Format(DateProv, 'dd/mm/yyyy') >= #" & FromDate & "#" Sometimes it will select...

I want to put a customized menu bar on my form and looking for advise. I have seen custom functions online that are placed in a module to create menubar, popups and buttons. However Where would these functions be called from?, would it be the forms OnOpen event. And I assume you would need to...

Set dbSAP = CurrentDb On Error GoTo Err_Exit: 'select from Redirects Table strSQL = "SELECT * FROM ReDirects WHERE Redirect = True" Set rstRedirects = dbSAP.OpenRecordset(strSQL, dbOpenDynaset) MsgBox(rstRedirects!Name) The above code will select the...

I have a program that declares several functions in a module, ideally to be used in either 32 or 64 bit environment. ie 32 bit declare function ...... 64 bit declare PtrSafe function ..... can access determine if its 32 or 64 bit so the right declaration is called?

I have tried the following code, which works to hide the access runtime window. However I need to set the main form as popup and modal in order for the form to appear. There are buttons on my main form which open other forms, (the main form still open) however this form also has to be...

I have a form that is refreshed with me.Requery in the On Timer event. I want to display an alert if a new record has been added to the form by another user. Is there a way in VBA To check if a new record has been added to the Record Source after refreshing the form with me.Requery?

I have converted a 2003 .mdb databases into a 2010 .accdb which works fine in a runtime environment except the behaviour of the minimize and restore. The form uses a Form_Open event commend:- DoCmd.RunCommand acCmdAppMinimize to hide the access application window so it appears like a...

user with Experience from access 97