Search results

Bob Thank you for your reply. It has been helpful and has given me some ideas. I need to print each record individually in all cases so that I end up with a set of sheets for each instrument. This suggests that I need to use the single print button approach for the "print all" case with a do...

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...

I said it was a dumb question!!!! Thanks a lot! Brian

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?

BrianW/Bob Thanks for the additional code. This call for help was generated by work which I do for a chemical company client for which I am electrical and instrumentation engineer. I'll shortly be getting on an aircraft to spend a week with them - which I do every couple of weeks. So will...

Brian I'm afraid I never could get Max t work for me on this one. I ended up by using Bob Askew's code incorporating an IN statement. However will keep trying when I have a little time and will let you know if I ever make it! Many thanks for your assistance. Brian

Brian, Thanks again. Will look at this a soon as I can. If I can not get it to work will send a modified form of the database over to you. I say modified because it uses two databases for information. One being 9MB & the other 6. I'd need to cut it down and sort out the paths. Will be in...

Hi all - ie Mark, Bob and Brian. I appreciate you all taking the time to help with the problem. There has been some delay in getting back to you and for that I apologise. It is partly because I am on the other side of the world but also I only got back to the office at 5.30 pm today. It's...

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...

Wayne We may be at cross purposes here - and having reread my initial statement I guess it could have been put more clearly. I agree that I am using "&" for concatenation of the initial function which I quoted and which you modified for me. That function which is concatenating strings is...

Wayne Thanks for the prompt reply. I note the change from "Is Not Null" which is what I usually use (is it an archaic form?) to "Not IsNull" and have applied it to the Date/Time formatted IIf() function. Unfortunately running the query still results in the same error code. In the meantime I...

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 -...

Andrew Thank you for the response. I had tried using a query to do this but could not get it to work. However in view of your comment had another go and was successful. I just wasn't handling the query correctly. So everything is working but I would still like to know why it did not work in...

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...