I have a subform which has 3 fields from the last of my 3, 1-Many table relationships. The main form shows data in the fields from the Main table which...

I have a microsoft forms 2.0 scrollBar control attached to a form, but I have three questions on how to use it. 1. Can the background be changed to...

I have a combo box called that is populated by the contents of a field ( from a table (). The field () is a text field in the format of "\Qq-yyyy". When the...

I have a form where I would like to type in a loan number into my "Find_Loan" field, then click a command button next to this field to search for that record. ...

Hi, I have a date field in my table for Invoices and I am trying to create a report where users can print reports of outstanding Invoices based on the date...

Hello there, I am getting stuck with somenthing I had previously worked-around...yes shame on me! I am trying to pop up Stephen's calendar from 2 subForms...

Is there anyway to set up a password for each employee (not including the encrypt system)? I have hundreds of employees and a table with a password for...

Have a simple database, 1 table, I used a query to load a form so that only the records fitting certain criteria are seen, but how can I update records from...

I apologize, but after reading several posts, I'm still having trouble with the requery method. Main form: UpdateTask Combobox on main form - ControlName:...

Hi all, I have a queston about the BoundColumn property. Suppose I set up a combo box with the following two column list: Column A Column B 1 ...

My function down below works great. However, i've tried different ways so that the limit will only be less than 16 and it's not working. Does anyone have any...

Hello, Is it possible to use a form to select which table a Query will utilize.? I have three different tables: 1)Sales 2)COS 3)Income. Each table has 3...

I have a form based on Table A and a linked sub form based on Table B. On the sub form is a drop down combobox based on Table C. The data in the combobox,...

Recently switched from Access 97 to Access 2003. I have a form which contains command buttons to open various reports in Print Preview. Shortly after I open...

Hi, I would like to know how can I highlight a field with a bright coulour automatically if it is left blank , so that the next time the database is opened, we...

I have placed a command button on a form, that when clicked prompts for a number, then should goto that record. Here is my code: Command Button on click:...

When I try to click any button to open any form or try to open the module, it always give me the following error and then close the mdb: "Microsoft Access...

I need to disable the keyboard and the mouse temporary on an event as this event takes more than several seconds to complete. I am not sure if I should use...

I have a form with a combobox setup to find a record with combobox selection. When the form is opened, all the fields have information from the first record...

I have a oncurrent event thatd diplays the record count. Me.rec_count.Caption = "Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount However on...