I have a yes/no field set up in a table and on a form as a radio button group. I have the default value in the table set to be nothing, but every time I...

My employer purchased an inexpensive database built on dbf files (in conjuction with .cdx files). I'm decent with access and have been using it to collect...

Hi, Is it possible to insert a hit counter into a database form, also is it possilble to display who last accessed a form and the date which they...

Hello all. I have created a subform from a query based on 2 tables. The main form is also based on the same query. I need to select a tracking number on the...

I have a calculated field on a form that produces a number with several decimal places. Access will automatically round up the result to the nearest...

Hi there, I have an IF statement that I need to use some concatenation with. I grab the VisitNo from the form. I have 10 Visit Flag's in my code named...

XP, Access 2003 I have a list box to display data, but it's rather long. How can I divide the query so that the first record appears in listbox1, the second...

Hi again guys, I've got a form which, among other controls, has two radio buttons beside each other with the labels 'Active' and 'Inactive'. This...

I inherited an application (Access 2007) that is becoming too complex (large) to fit on a screen. The application has 4 levels of subforms. The application...

I have a product form based on a query. The query has the current stock level and the minimum stock level. I would like a flag or notification to show on the...

Hi, I wonder whether someone can help me please. I have created a database which uses data from some Excel spreadsheets that I've inherited from another work...

Is there a way to sort records in a form by either one field or multiple fields? I know in tables you can sort by one field; I tried sorting the table that...

I have a patient that gets evaluated at intake, 3mos, 6mos, etc for up to 10 episodes. I have the form and subform working correctly to add evaluation data,...

Hi There I just created a PurchaseOrder form with a PurchaseOrderDetail subform. How do I restrict someone from first entering data into the subform,...

I want a check box on a data form to simply show a check when the the associated field is not empty. Seems so simple, yet I cannot figure out how to do it. It...

I have set a few text box set to some values on a list box based on the user selection. However the text box is not showing the correct format. The list...

I am using the following lookup on a form =DLookUp("","res_source_step 2"," = !!") the lookup works great except it won't display the value till I touch the...

I was trying to create a check box so that if checked, the fields would be locked. Unfortunately, It also locked me out of unchecking the box to edit prior...

Here is my setup; I have a form which is used for hardware inventory. In the form I have a combo box which refers to a piece of hardware. The item values in...

Hi all, I want to link a column of my form to a column\table in another database xx. mdb. This column should update and refresh with all the new data. at the...