Search results

I think use macros for simple operations. VBA codes are much stronger and faster. If you want to be good, you should always use the foremost technique.

If you want to hide the access window and you have a form opened at the beginning, the path I suggest is ideal. Window hiding and maximum sizing can be done in Autoexec macro.

You have 3 alternatives for this situation. The first is the code you have applied, The second is to write a DLookup command directly to the control source of the Text boxes, and the third is to open a set of records and check the records. Whichever of these is fast, VBA code you have applied.

You can create a simple autoexec macro for this. If you command Open Form, then maximize and set the name of the macro to autoexec, you can automatically maximize the screen when you open the application.

Hello Theo, welcome to us. :)

Use at least 3 tables for the image, using the best way to configure DB tables. 1-Staff Information 2-Symptoms 3-days Your staff master table will be associated with your main table in rechargeable tables.

I can suggest you a way like this. First, create an empty database, then transfer all the objects in your old database to your new database using table, form, report etc. import method. then run the Repair database command, it needs to be fixed.

(y) You're perfect! cheekybuddha

Did the code in the 6th message fail again!

I assume that the table field you assigned to the filename variable is not empty.

Attachments.Add filename

You already assigned FormLocation to a variable in the upper line, change the line that gives the error to .AddAttachment = filename

I am here to solve your Access problems.

After disabling the Close button in your form's design mode, add a button to your form and type the following line in the Click event. This is the most safe and gentle method of exit from MS Access. Application.Quit

You can check your users' login and logout with two sub-procedures. You can then see which users log in and out with the help of a query. You can know that they are active by listing the users who are logged in and not logged out. I give the sub procedure codes below. You can place the LogInUser...

plog is a correct naming that causes 2020 domain name mess. instead you should use a name that clearly describes your domain. Example: =DSum("ProductYear", "resources", "[Role ID]=" & [text124] & " AND [ref no]<>9999")

Hello Why didn't you define the Account Number field as a mandatory field from the beginning?

Hello You should first focus on the subform, then go to the New record with the help of DoCmd. Me.SubFormName.SetFocus DoCmd.GotoRecord ,"SubFormName",acNewRecord

Red It's a very nice movie. A man's quest for justice Watch you will be impressed.