Search results

Hi there, I have an annoying problem and hope someone could help me. I created a function which deletes a query and then creates a new one with CreateQueryDef. When I use this function from the immediate window, it works perfectly with no error. But when I call this function from a field in a...

thank you

Thank you for the replies. I created a custom menu (attached a sample). I need to disable some of the items for some users. In my application many users can be registered by the admin, each one with their password. I need to specify which user can have access to which menu according to their...

Hi there, I created a menu for my application in Access 2003. I need to disable some of the menu items for some users. Can anyone help me? Thanks

Thank you so much. I will try it. Cheers

Many thanks. I attached a pdf file. I hope it's clear. Thanks again

Thanks so much. I tried your suggestion and it works fine for a text box on a form but when I use it on a sub form .... There is a sub form on the main form. There is a field in the sub form which I need to put the code on it's double click event. When I do that the co-ordinates of the...

Thanks so much. I will try your suggestion. It's appears to be much simpler. Thanks again. Cheers

Thanks. I can not use simple move method. If a text box (anywhere on the form) is double clicked, a specific form must be opened exactly below that text box. The co-ordinates of the text box relative to the screen is needed (not relative to the form). My code works fine for access 2003 and...

Hello, Thanks for the replies. My code works in one computer with Win10, access 2016 but I have this problem in another computer. My code is calculating the co-ordinates of a text box and moves a form there like a DatePicker. Dim hDC As LongLong, lngRetVal As LongLong hDC =...

Hello there, Many thanks for the replies. I changed all the LongPtr to LongLong and error disappeared BUT... At the beginning of my code I used these functions : hDC = apiGetDC(hWndAccessApp) XPIXELSPERINCH = apiGetDeviceCaps(hDC, LOGPIXELSX) YPIXELSPERINCH = apiGetDeviceCaps(hDC...

Yes. It works fine without error in one computer (Win10, Access 2016). On another computer with Win10 and Access 2016 gives me this "Type mismatch error"???

Hello there, I have used Windows API functions in access 2016 on Windows 10. I used the correct format for 64bit. It works fine in one computer but gives me "Type mismatch error" on another computer with Windows 10 and also Access 2016? Any help would be appreciated. Thanks a lot.

Thank you all. I solved the problem with Me.refresh and also I changed the code procedure to a specific field "lost focus". It works like a charm. Cheers

The code does not matter. Whatever the code is, it doesn't go to the "After_Update" procedure. The purpose is : when a line of record is entered, some fields must be updated in another table. The code works fine but works only when I add a break point and run it line by line. Thanks

Hi there, I would appreciate if someone could help me with this problem. I have a sub-form on a form. In this sub form data must be entered. I need to execute a code when each record is entered in the sub-form. I wrote the code in the "After_Update" procedure of this sub-form. BUT ----...

Hi there, Thank you all for replying. The problem was a frozen column.!!! That's why the tab index was not working for that datasheet. Thanks again. Cheers

Thank you. I don't have Tab control. Just a simple sub-form with 6 columns in datasheet view.

Hi there, I am having a strange problem with TabIndex in one of my subforms. It does not change. I change the numbers but nothing happens and the columns order does not change. (Access 2003) Any idea? Cheers

Thanks for your help.