Search results

Using Access 97. I have created a macro whereby it simply runs a series of imports and queries. Some of the queries run on tables that have yet to be imported. Is there a wait / pause / loop / stop until function that run the first macro. Ensures that its finished then goes on to the next...

I'm using Access 97 currently and wish to e-mail a report directly to the user named in one of the report fields. I have a couple of questions:- a) Can I transfer a MS Access report to PDF format before e-mailing? b) Can I specifically specify the e-mail address at "run-time" (this will be...

I wish to link an Access 97 database (networked) (soon to be converted to Access 2000) to SQL tables without the need for a user to setup an ODBC connection on their PC first and therefore not to enter an ODBC password to gain access to these tables. Does anyone know if this is possible...

Hi, Sorry to post a similar question that I've read in the forum but I can't seem to get the answer I want. I have a form consisting of one table (Access 97). One field in this table has a field named StuReqd. After the user has filtered their records, I would like the user to press a button...

Thanks for The Suggestion Thanks for this. We are due to transfer to A200 soon so I'll try it then. If anyone has anoy other suggestion for A97 I would be grateful. Thanks Again Dawn

Hello I have a simple query using A97 whereby I wish to find duplicates. I am accessing third party software that records events. For example, Row no, Event Day, Room, Start Time, End Time, Start Wk, End Wk Row 1 - Monday, 1, 10:00, 11:00, 17/01/03, 17/02/03 Row 2 - Monday, 1, 10:00, 11:45...

Sorry, this was my fault I should have explained myself better. I am accessing a third party SQL database through Access using ODBC. I have no control over this field in this first instance. Thanks Dawn

Hello I would like to be able to search for specific characters using a query. I use MS Access 97. I would like to check the entry of postcodes for example, the correct postcode layout is (XXNN NXX) where X is a character (A-Z) and N is a number (0-9). I want to identify incorrect postcodes...

Many Thanks Jon WHAT A STAR!! :D

Hello Again As I'm new to SQL I don't fully understand this but after an hour trying I managed to get the Worker and Highest Paid Salary as I requested. Thank you. Can I go a step further? .... The above was just therorectical, what I have in one table is:- Table - A field - Student ID...

Hello I've tried this also and it works great .... but in my table I have say, many workers where I want to find the highest salary for each worker in my table not just the highest paid worker themselves. Can I alter this query to show this. Thanks Dawn

Hello There I have a report whereby I have a start date and fields that contains figures. I only want to summarise these figures when the date is after a today's date. Is this possible? Can I use something like Sum if on my report? Thanks Dawn

Hello There I have a master report which includes two subreports. A sum to minus one subtotal for another is located at the bottom of the report. If one of the sub reports contains no data then it does not display on the master report (which is fine) but it also put the word #Error at the...

Hello I have a field which contains a telephone number. I need to remove all the spaces from this field so I am just left with numbers. Ltrim and Rtrim won't work as I want the middle spaces removed not trailing. This function is required in a query and I'm using Access 97. For example...

I would like to establish if a record has been amended. I cannot use the dirty function in a form for other reasons nor can I create query that compares each like for like field against each other. This is too complex and sometimes the query does not run. Has anyone got any suggestions on...

Thanks for this. Just what I required. Dawn

I have a form within Access 97 that has address details. For Example, Add1 Field Add2 Field Add3 Field Add4 Field Postcode Field What I would like to do is combine these details in one field and then use the standard CTRL & C function to copy these details to the clipboard. NOTE: The above...

I have created a report toolbar within Access 97 whereby I would like to include a button - when pressed would only print the even page numbers of my report. Is this possible does anyone now? Thanks Dawn

Thanks! :D

Sorry, I've tried this on the On current form and before update on each field. It's works once OK but when I move to my "Editable" next record it won't let me type anything in. Thanks Dawn :confused: