Hello, I see that you can put the orderby in VBA do determine sort order like this: Me.OrderBy = "MyOrderByField" Me.OrderByOn = True But how do you make it...

Hi I have a Access 2002 form with 50+ controls. On the form there is a command button to print a report which is based on the form. Where changes to data...

I have a combo box on a form that won't allow me to select a value. The row source is a value list. The combo box is bound to a field in the form's record...

Hi, I have Tbl_BookBasics and a Form F_BookBasics. I also have Tbl_BookPhotoBasics and a form F_BookPhotoBasics to enter data on the photos within the...

Hi; Can you please help with code example to populate a list box based on the value of a combo box. I will need to give the user ability to select/highlight ...

Hello All I have a main form called , which has a subform called (representing a set of people). The subform opens in datasheet view, and includes a field...

I have a database that is split and used by 10 users. On the form there is a button that is used to run a query. One of my users when they click the...

Hi, I have a booking systems database which has 2 tables tblemployee and tblbooking. Employees make the bookings and also have the ability to update the...

I have 2 tables that I need to connect so I can run a query to see what contracts we are getting royalties on. The first table is Contracts and the second is...

I've just had Access 2003 (WinXP Pro) pop up a message about not enough memory to save and eventually crashes. When I restart I cant open the form I was...

I have a form which calculates a total price for various services I provide based on a day rate. I have a bound day rate box on the main form and a subform...

i am using access 2003 - this is my first Form... i want to have a drop list for a field in my form called "Suppliers" which will reference to a Supplier...

I have a form (let's call it recordform) which has its Record Source selecting fields form a table. Text boxes in this form have control sources as fields...

I have a main form that opens when I open my database file with two command buttons; one of them is called office and it opens another form with more command...

I have a simple form with two combo boxes. The first combo box allows selection of an employee; AfterUpdate the second should requery for only that...

Good afternoon all I have a quick question. I have a combo populated with the results form a query. All I want to accomplish is to have the very first combo...

Hiya, Basically I have 2 tables tblEmployee and tblDetails. My database is a shipping database that tracks all the freight in the warehouse. Records are added...

Heres what im trying to do.. I have a form which contains a combo box which displays a list of companies. When I select the company, there is a second cbo...

I have a rounding problem, it works at the check level but if you add all of the sub together then apply the tax it's different. The tax is .0825...I'm...

In Access 2003 and earlier, I used to be able to select fields/controls in design view and move them around in a form - in the 2007 version I seem to be...