Search results

Helllo, to all, I have a select clause, it executes fine, BUT the totamt is not calculated. The field is Amount. I have checked various helps, including VBA's help function, BUT the code is not working. strSQL = "SELECT Account, Dept, " & "Sum([Amount])" & " As [totamt] FROM TB201410 GROUP BY...

@AOB, I have declared storage via as DIM Tel AS Double It seems fine, will test it on site tomorrow. Thanks for your help, God Bless.

@AOB, Thx, On my laptop, without OPTION EXPLICIT being set the code goes through, it works fine. With OPTION EXPLICIT set, it bombs out at TEL = 0 with a message that the variable is not set. Do I use a DIM statement to set it?

Good day to all the Access Professionals, I have a program running with VBA coding, whereby the user enter a password which then sets the field attributes to enable the user to change them. This is working on my laptop, on the client's LAN, it also worked through REMOTE DESKTOP, but the Head...

Re: [Solved] SETVALUE Argument can not run in disabled Mode @Paul Tanks! Quite "Lekker", Most enjoyable, Pleasant.:)

I am using A2007 I am starting to explore VBA. The issue is I am looking up data in a second form, and would like to transfer the fields to the original form (the first form) I know one has to get focus, I think? The Me. field name only works in the current form. Maybe just help me with the VBA...

@Paul Thanking you for your assistance. On the embedded macro window, the "Show All Actions" is greyed out. It is not "live" so to speak.

Hello Again, Blessings to all. I don't know, I have noticed that the SETVALUE argument is not openly available in the lookup tables when setting a macro. (But that aside) I have set my drives c:\ and d:\ as trusted, and also thicked the sub folder option. :banghead: Your comments will be...

Yip! It is working. Thank you kindly and Blessings.:D ps! How do we mark this thread as resolved?

[Resolved] Hello and Herewith a syntax problem Hello to all, Blessings to you all. I am Kobus Dippenaar, MSAccess programmer, Photographer, and Website Developer. My problem is in reading a DAO recordset containing a text field of 12 Characters. Here is my extracts; The Find First statement...