I have a split database with a frontend and backend. Users would like to archive the current data that is in the backend and start fresh for a new year. But...

Hi, Well i have a form with a combo box which takes stores the city names of world.now sum of the cities has been entered and sum which not been entered are...

I have a few questions (and I'm working in Access 2007): 1. I have a form with 4 tabs. All the tabs have attachment fields. On the first two tabs, the...

I have 28 tabs on a main form. On each tab are fields from the main table. I want to use a combo box to go to the tab a user selects. I have tried...

I have a subform of continuous forms with conditional formatting that works fine on one computer, but on another computer the conditional formatting makes the...

Hello everyone, I have two tables, one a Staff list and the other an Asset list extracted from seperate databases, the information in the tables has absolutely...

I am trying to install Access 97 on a Windows 2003 R2 Ent Edition machine using 8 gigs of ram. Unfortunately, I have a legacy application (which is no longer...

Is it possible to hide the Add new record button at the bottom of a for? I want the user to be able to navigate through the records using the Next and...

I have been working on a database that would allow a user to select a supplier name from a drop down combo box, then select the quarter from another drop down,...

Access 2007 I may be going about this the wrong way, but I have 4 tables: Customer; Farm; Field; Main. 1. I have a form that I want to be able to enter a...

Hi all, I have a form that shows student information (primary key = student ID). I have buttons on this form to bring up other forms that can be used to...

Hi, I need to add a specific number of dates to a specific date. I'm fine when I'm using the DateAdd() function. I'm able to add days, weeks, months and...

Hi Is it possible to get a form to produce the same format as a report. I would like to be able to have a form which is linked to a query. There are 3...

Below is the error that is displaued when getting the text value for a textbox which the previous line sets the focus to this textbox. Run-time error...

I have several fields on my form that are auto populated by selections made from a combo box. One of these fields is a phone number field. A user MAY enter...

I have a form with an option group with 5 choices available. The fieldname/control source where this info will be stored is BusUnit: All 1 GC 2 GSP ...

Hi Groupies I am using A2K7 I have an unbound form that is used to set up a new service ticket. They select from an existing job and then they enter a date...

I figured out how to write the expression I want to use mystr=right(,8) but I have tried entering it everywhere in the properties for the textbox and no...

This list box has over 30 columns and a complicated source. Whenever another control on the form is focused on AFTER the list box has been 'touched', it...

I have a form called “frmIncidentForm�. Within this form I would like to disable all of the controls expect for a Combo Box called “Type�. Then...