Search results

Thank you all. Very useful information! I solved my problem after I noticed a syntax error involving parentheses.

I am trying to use a msgbox to debug a query I have written in VBA code. However, the msgbox is not large enough to display the whole query. Is there any way to expand the msgbox so that I can see the whole query? sql1 = "SELECT tbl_Authorizations.ID, [tbl_Authorizations].[client_LName] & ', '...

Place a configuration file somewhere on the C drive (It doesn't need to have any contents) of all paying customers during installation. Then check to see if it exists. If not then Quit the app. Dim IsItThere As Boolean '*** Security Check in Login Form. IsItThere =...

cheekybuddha - The first one worked. Thank you so much!!

The stored procedure exists in my SqlServer database. I'm not sure what you mean by "mssql". Where do you see sp_AddUser?

arnelgp - I used your code as a guide for my code below. I'm getting an "ODBC - Call Failed" error. Can you see anything wrong? tbl_Time is a linked table to my Sqlserver database. Do I need a special library? Public Sub Create_SqlUser(NewUser As String) Dim db As DAO.Database Set db =...

Thanks so much. That definitely isn't intuitive!

Any suggestion as to how to keep the image in the background? When I place my controls on top of it they end up behind the image.

Yes. I'm trying that now. It seems to have worked. Thanks so much!

Thanks for your response MajP. I shrunk the form from 13 to 10 inches. Same problem. Anchoring won't work because there's no option for keeping the controls in the center.

The controls in frm_Dashboard (see attached DB) are exactly where I want them in Design view. However, when I switch to Form view all of them shift to another location. I've already played around with all the properties and can't seem to figure out why this is happening. Does anyone know?

:)

theDBguy - Yes. I have code to disable to close button. I will now punish myself for my stupidity.

I have an Access 2016 accdb database that refuses to close when I click the X in the upper right corner. It will minimize when I click the minus sign but will not close when I click the X. I tried a Compact/Repair but no luck. I have to either end the task through Task Manager or right click the...

Yes. Thank you Gemma!

Definitely interesting. Thank you jdraw!

Thank you to all for your help! I decided to use a label and make it visible from the On Open event of Form2. It seems that controls obey the proper sequence of events. Message boxes - not so much!

Interesting. Microsoft docs contradict that (Regarding On Current, On Activate and On Got Focus). Thanks for the tip about the timer. I'll either use that or a label to display my message.

I have Form1 and Form2. If a user is on Form1 and they click a command button to bring them to Form2 I want a message box to appear in certain circumstances. I tried putting the message box in the On Open, On Load, On Current, On Activate and On Got Focus events of Form2. In every instance the...

Yes. As you can see, it has duplicate entries.