Search results

Hi, I'm using this code to power a form button which previews reports generated from a filtered list of instruments. The feeder query is a date order listing of instruments which are of a number of types each type requiring a different report. The code steps through the list matching the...

Hi, This should be an easy one but I can't figure it out. I have both Office 2003 and 2007 on my machine. There is not problem in calling up either version of either Excel or Word but if I call for Access 2003 after using 2007 the Installer runs and similarly if I call for 2007 after running...

Hi, A week or two back, with some invaluable help from this forum, I installed a button on a form which enabled me to produce a set of prints being one of each of a number of records selected by the backing query to that form. This saved me a great deal of time. Since then I've added a Select...

I am setting up a button on a form to print a group of of records which have been filtered by the form's underlying query. For test purposes the number of records has been limited to two. The report comprises two pages. The intention is that the procedure will call the report, print the first...

I am operating a database which tracks maintenance and inspection history for electrical equipment and instruments at a chemical plant. The database includes references to manufacturer's data sheets and test certificates carried out by external agencies. This information is readily available...

I want to make groups of records in a table read only. This is to protect existing records from being altered when new records which are started from copies of the earlier records are being added to the table. Does anyone have any ideas?

I operate a database which is used for recording the inspection of instrumentation on a chemical plant. The printing of inspection sheets and the results can involve hundreds of records and is an ideal candidate for automation. I decided to give it a go. Generated a much reduced and...

This is a ridiculous query but I'm foxed. I'm running Access 2000 and want to write a macro. However the Macro drop down menu will only allow me to write VBA ie the macro bit is greyed out. I thought it might be an Add-on feature but apparently not. Has anyone any ideas?

I have a database table comprising inspection records for about 300 process control instruments. A new record is entered for each inspection so that an inspection history builds up for each instrument. For one report I need to extract all the records with the only the latest inspection date...

I am working on a report in Access2000 which is getting information from several tables via a number of queries. I am using nested IIf() functions to combine text formatted data in a calculated query field before using it in a report. One such IIf() function is Desc_col: IIf([HOVR -...

I have been combining a number of query fiields in a report field. In the main it has gone well. I am finding however that in each case (this report has 3 such fields) there is one query field which will not function. If I insert it I get an "Error" output. I have checked that all fields are...

I have been running Access97 since '97 most of that time on a network. I have just updated to Office 2000 and Access has converted time/cost and company cost databases to 2000 format. When attempting to open either of these across the network I am getting an error message like "Jet cannot open...