Hi, I wonder whether someone can help me please. I am currently using the following coding to auto populate a reference number within a form: If Me.NewRecord...

I have two Access 2003 front-end applications with SQL Server 2005 back-ends. Both have a Client table/form as the root table/form. Both have child...

There seem to be a number of posts related to Pivot Tables and Charts not retaining the data fields. I am using Access 2007 and the piv0t table and chart...

Hi! I have a form with a simple code: Private Sub Form_Open(Cancel As Integer) If Now() Then MsgBox "Service date overdue!", vbInformation, "Service...

I know how to do the basics when it comes to Access (importing data into tables, BASIC queries, etc). However I am new to forma and can’t figure out how to...

What I have is a form in which I can assign a new pattern to a particular manufacturer. The form consists of a parent form with 2 filters at the top. Both...

I have a split form set to display the datasheet on bottom. I have a CommandButton in the Form Header that I want to perform the following commands: 1. ...

I am exporting a query but want excel file name to stay the same but have a date appended to the end. I would want the Date to change to reflect the date...

I have a volunteer database in Access 2003 that has 3 Command Buttons on my main form: Active, Occasional, & Archived. When I press each button, I want it...

I am working on loading a recordset at runtime, and modifying the recordset as needed. The default recordset will typically return about 10 records out of a...

I'm using Access 2003. I understand that the main form is on the one side of a 1 to many relationship and the subform is on the many side of the...

Hi to all, I'm writing to get an help. I'm not really an expert on Access. My father has a website based on a ms access 2000. In this database he would like...

Hello and thanks for helping. I have found many references to this error but none seem to fit. I have a pop-up form where I make a selection which runs a...

I am using Access 2007 I have an expression (IIF statement) as a control source in a form that is dependant on the data entered in an unbound text box in the...

Are there any performance issues when a form is based on a query as to whether the recordsource for the form is a store query or if the recordsource is an...

Sorry, knocked the keyboard and the message posted before it was finished. If you want all the fields saved to the table easily, that happens when the user...

I have a form tied to a table called "WMP Input Table" with Text, Combo & List Boxes. The list box control source named "Joint Call"has a record source...

Hi I have a weird thing happening with one of my systems. I have an online MySQL database that stores customer records. These are downloaded to my Access...

Hi I have a form where managers request for network access for their staff sometimes after the initail request the staff may need exttra access options...

i have this training database i am working on... i am thinking of displaying the training schedule records from my query to a subform. Of course, when i open...