Recent content by DBug

Although I have made my main from popup and sloats around the screen, if I click the minimise button on the application window it also minimizes my form?

I couldnt run the Database, the code wouldnt compile. So I extracted the module for hiding the App, had the same problem

I have used this code and it hides the Application, but also the PopUp form. I am using Windows 10 64bit Access 2013 I used the PtrSafe in the Declare Function to make it run on 64 bit Any ideas?

Yes I agree, often working out the best solution that works for you

I Found the solution with something I found, by using Int(DateProv) it effectivley removes the fractional part or Time element of the date Value.Therefore it is now comparing ShortDate with ShortDate SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND Int(DateProv) >= DateValue('" &...

I have now expanded my SQL statement to include ToDate SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND DateProv >= DateValue('" & FromDate & "') AND DateProv <= DateValue('" & ToDate & "')" This is working except the query results will not include the date ToDate. For example to be able...

Got it, I used DateValue() firstly I tested the SQL string as: SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND DateProv >= DateValue('26/04/2017')" this worked so I then replaced the date Text with my FromDate String SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND DateProv >=...

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...

Don't want to use command buttons, already have those on the form, want to keep some functions separate. Already using a shortcut menu too. I think I understand now, so just need to create a separate module, run it to create the menus and reference it in the Form Property

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...

i just realised my mistake, another part of the code was setting the first records Redirect to true before calling this code. Its all working now

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?

put the above module in my application then used the following code on the main Form Private Sub Form_Load() ' hide the access ribbon DoCmd.ShowToolbar "Ribbon", acToolbarNo ' set position of access window below visible desktop xg_SizeWindow "Access", 0, 1000, 2, 2 End Sub

Found this code, which I have used to move the access window out of view peterssoftware.com/winmanip.htm