Search results

Thanks for your suggestions

I did read that, thanks Spikepl

OK, thanks for your help, much appreciated

It happens to various databases, however the one I regularly see it happen on is my own testing database as I am using it constantly so I am the only one using it, there is no autoexec macro running on open, however when the main form opens it does load the custom ribbons etc... I can't see it...

In the database that I use at work sometimes when we OPEN it we get an immediate error saying out of memory, therefore we close it and reopen and all is good. This is a problem when the average user logs on as they don't close it, they just continue on and then start experiencing issues. I...

Tried that also and same result, it still shows 0 values.

No, balance is a calculated field

So I have the following query field which calculates another field. How do I Filter the records in this calculated field to only return TRUE, as if I put "TRUE" in the Criteria for this field (or anything at all) then a parameter message box pops up asking for [Balance]. Balance1...

jdraw, it didn't have a space in the actual query criteria, I just added it in the thread as it looked strange without a space, I thought that someone might pull me up on it.

I found a way around using another query. I added another field with the following and it is working. Balance1: IIf([Balance]<>0,"TRUE","FALSE")

No, they are not null, they show as zeros.

I have a calculated field which is based on one field less another. In the calculated field I put < > 0, yet it keeps returning zero's. I then put >1 And < -1 so if there are decimals affecting the results. Still zeros are shown. I then put the decimals to 10 places and none show as being any...

I found the answer finally, it locks the form to the screen whether you are in access or not. http://support.microsoft.com/kb/184297 In the form open event put Private Sub Form_Open(Cancel As Integer) Dim lR As Long lR = SetTopMostWindow(Forms!Form5.hwnd, True) ‘change...

That's OK, I found a script to lock the access form to the front. ‘In the form open event put Private Sub Form_Open(Cancel As Integer) Dim lR As Long lR = SetTopMostWindow(Forms!Form5.hwnd, True) ‘change Form5 to your access form End Sub ‘In a module put. Option...

That works great, is there a way to then set a form to permanently be the top form, or should I post another thread for this.

Hi Jhb, I had to change the code to PtrSafe and I get a message saying sub or function not defined, I have marked it in red Private Sub Command0_Click() Dim sCaption As String Dim lLen As Long Dim topHwnd As LongPtr topHwnd = GetTopWindow(topHwnd) Do While topHwnd If...

I found the following API which I converted to suit Win7 but it doesn't lock the form, but it does lock the access window so that you can not use any other application including the vba editor, may come in handy sometime to prevent users from exiting access. I put the OnTop...

Thanks JHB, a bit over my head though.

What is extra popup, never heard of it? is that a joke?

Every form is set to popup as that is how my boss like's the forms, he likes the look of popups and they also cover the ribbon and taskbar without having to add in other scripts