I have Sub-Forms in Datasheet view on Forms that are in Form view - but I would like to be able to set the column widths of the Datasheet and prevent the user...

I have a results database with multiple tables (Best Results & Competition). One table (Best Results) holds records of best event results attended per athlete...

For over 5 years, a friend has been (each month) sending me a copy of an Access database over MSN as an attachment to an email. This time Outlook blocked the...

I tried the below code to select the form (Form1), which is aready open, but it does not function : Private Sub Label113_Click() DoCmd.OpenForm "Form2",...

Hello, In a program I'm writing, the command Docmd.OpenForm takes 15-30 seconds for some forms, while other forms (with approximately the same amount...

I want to run a code on Form Timer property only if the form is on focus, I mean on the active screen, therefore , I tried the below code but it does not work...

Hi, I have an option group that has two options in it. Below the option group, I have a couple of drop down combo boxes. I would like to program the combo...

Printing a form in Access=2E -------------------------------- From: Jason Cole I have a database set up in access=2E I print the forms off of the= record...

Posting to this group as i feel it may be more appropriate on a non-coding group, i think! From: "Lee Taylor-Vaughan" Subject:...

I have a table with both imported data and new records. The table contains a phone number and is formatted as follows (xxx) xxx-xxxx. If I try to "filter by...

Is there a way to display records on a form in columns such as record 1 record 4 record 7 record 2 record 5 ...

Hello everybody, I am trying to create a Status Database, you know for weekly statuses of projects, I am trying to create a form that would show current...

I have a form with a option group box, with the options "Denied" and "Approved." If the user selects "Denied," I want to be sure she sees it so I have put code...

Anyone know how to get the windows logon name into a form field of an access form

I have had this expression denating a IDNumber = & Left(,1) & Left(,1) & Now It has stopped working Get Runtime Error 2113 This is the code but I get a #Name?...

Whenever I create a command button using wizard or not, the buttons do not work. Get this error mesage that says; "The expressions you entered produce an error...

Hello, I have VBA code on a form that works fine in Access 7.0, but when I import the form and databases to Access 10.0 gives me the following error: Compile...

Wonder if anyone has a possible solution to my problem. I am working on a bowling database and essentially it manages bowling leagues. I have main form that...

I have the following problem. A textbox shows a dsum operation, this value should be seen also in the table and query with the same field name. I mean that I...

Does anybody know if it is possible to copy the value of a particular field in the last record to the same field in the new record of a form automatically. ...