I have written the following Nested IF function: =IF(K13="N","NA",IF(K13="1","A",IF(K13="2","B",IF(K13="3","C",IF(K13="4","D"))))) However, once applied, only...

I am a new user of Access and need some help with subdatasheets. I have a database set up with a one table that has a subdatasheet and that subdatasheet has...

How do you get the arro and the two zeros "00" to show when the relationships are set? They use to show in the one to many the arrow means one and the 00...

I have this function to download data from a Pervasive SQL into MS Access Public Function get_hrs(WOPRE As Double, WOSUF As Double) Dim sql As String sql =...

In the MainForm there is an unbound box MainformTotal showing total from Subform. Its Control Source goes: =.! and it works perfectly. When the...

Hello, I have created a tabbed form that has four sub forms. The parent child links are the (PK, AutoNumber) NCMR_Number and PTC_Part_Number. The database is...

In a response I received to a question, it mentioned that I should create a unique index on the three or four column candidate key. How do I do that? It also...

I have a Combo box setup to Display last names of People. What I am having trouble with is everytime I try to add a name that isn't in the combo box list I...

I am just beginning to learn VBA & have run across the following syntax in some of the lessons I am following online: 'Retrieve the hourly salary ...

I've just learnt that some of my forms allow to view the Properties Window and change it parameters without switching to Design View, while others don't let...

I was wondering if a few of you could share your wisdom regarding lookup fields. I could be mistaken but it seems that I have read some posts that have...

Hello, I have a combo box that im using to display departments in the list using: SELECT tblDepartment.DptID, tblDepartment.Department FROM...

Workgroup Administrator does not appear to be available in Access 2007. How can you join a Workgroup (System.mdw) in this version, which I know was...

I need to enter addresses. Im using the fields StreetNumber, Direction, StreetName, BuildingNumber, and Suite. They are contained in tblAddresses with the...

I have a simply query, Two of the fields being First Name and Surname. All the fields in the database are in upper case. I would like to format the query so...

Hi, we have made a database that contains pictures with 1280 records, when the database goes over 1.99 Gig, access goes into repair mode and we lose...

I have installed a working Data Base on another Computer, but when the user attempts to open the Data Base, an error message is recieved "You do not have the...

Hi, I am exporting data to MS Excel ID, WOPRE, WOSUF, WOOPER 1, 5230, 23, 10 2, 5230, 23, 20 3, 5230, 23, 30 4, 5230, 30, 10 5, 5230, 30, 20