Search results

All this can be done with power query. VBA may not be needed.

The code works at it should. There is no problem there. What I wanted to know is if this message box (see attachment) can be bypassed or suppressed? After escaping the message box from @MajP code this one pops up when I try to close the form (clicking "x" on the form control box). I think it's...

I'm still getting the "You can't save this at this time" notification. How to suppress this? If I press Esc to undo the record entry, it closes no problem, but as long as a field is populated I get the error before close. Can the form automatically clear the partial record entry then close...

Added db. On the form frmPurchases if I try to close the form I get the error in the pic. I want a way to undo the record entry if I close the from because the other fields are not filled suppressing the error.

There are 4 fields. PDate - Required Item - Required Quantity - Required Cost - Required Vatable (check box) - Can be checked or not So if I start a new record entry and PDate is filled but I scroll up and set focus to a prior record. The New record should be cancelled and undo the data entry...

I have a continuous form, if the record has incomplete fields and I set the focus to a record before, how to cancel the current record entry and clear all the fields that were filled?

You are right @The_Doc_Man. This was the problem.

Not sure I phrased the question properly. I have a form that opens and goes to new record. Data Entry property is set to No. Everything works great for the past couple of months but now I get a Runtime Error (see attachment). Clicking on End opens up the form but I am unable to add records...

Hello all, Is there a module or something available that allows the user to do simple calculation in a text box? For example, if I enter 1+1 in a textbox the textbox value becomes 2. Nothing too elaborate just +, -, x, ÷

Do you have a 64 bit version? Private Declare Function WinHelp Lib "user32.dll" Alias "WinHelpA" (ByVal hWnd As Long, ByVal _ lpHelpFile As String, ByVal wCommand As Long, ByVal dwData As Long) As Long Error at this line

I know there must be a system table or something that stores the Backend address. How do I find it? The Problem: The database being used, the Backend is stored on a server and the Frontend is on the user's PC. The user wants to add some stuff to a report, I am half way across the country but I...

This was done with Access, and even though I signaled to them to secure the database properly, they didn't even try. And I'm not even a db specialist. I'm mediocre at best. That's my obsession with locking down my db frontend.

Well one time, I linked to a clocking machine system table and changed my credentials to admin and I was able to make changes to the clock in/out data. The IT Department controls were sub-par at best.

Yes, you made a point that I didn't even consider. Someone can open up a blank access file and try to link to the server. How do you normally deal with that? That is what I was thinking in the op. Can I hide all system tables on the server side and have only dbo.*** available to view when...

Of course I didn't even think of that 🤦‍♂️. Thanks @GPGeorge This also helped. https://www.access-programmers.co.uk/forums/threads/change-custom-ribbon-with-password.295785/

The user does not need to but they still can click the link table wizard. This what I'm try to prevent. I want to disable the link table/external data button.

I did some testing. I set up passwords and credentials for the SQL sever so in order to link to the server, even if the user finds the dns file, they will need a password to login. The question, Does access store this password anywhere? Can a user 'hack' and find it?

How do you prevent the user from seeing the system tables when using the link table wizard in Access. Is it a Server side setting or MS Access?

Opens fine on my PC. I've attached a zip copy.

Hello all, Let me see if I explain this properly. I am opening a report from a Pop up Form (the pop up is set to open as acDialog). The Report, set to open as acWindowNormal, does not become the main window or the current view screen when the pop up closes, I have to click on tab to view it. I...