Search results

I am trying to place two fields from a query into a text box on a report. One is an integer and one text, the report will recognise them both separately but not together. I am using =[Section] & ". " & [SectionTitle] and would like the result to look like 1. Section Revision list Can any...

I am creating a data entry form. where the user will enter the volume number, I am using a button to launch another form which will allow the sections for the volume to be entered. My problem is that I have to refresh the volume query befor I can enter a section record. I know that I can do this...

I am using Access 97 and have a form with a combo box on it. I want to be able to check that a value has been selected fron the combo box before a button is used to select another from. I have been trying this code but somthing is going wrong, which I don't fully understand. I have placed it...

I have two tables, one holds the connections and another holds the hardware. The Hardware is linked together by connections. I have created a query including both these tables and want to be able to select the connections that have not been used in the hardware table. So that I can add new...

I have two tables TblHardware & TblConnection I have created a query with all the fields from both tables and a left hand join between connection. TblHardware TblConnection Switch connection Port Location Connection Description I am using the query and have bound it to a form, which...

I want to join to fields in a query. I am using access 97. I just want to be able to pick up two fields from the query, create a new column and display the details together. the code I am using to create the column is Switch&Port:[switch]&"-"&[port] when i try and run the query i get an error...