Search results

Dear GalaxiomAtHome, I am well aware that the forms are unlikely to be efficient; as I said in my original post, it is not the way I would do things, but I have inherited the situation. There are several forms with up to 18 'DLookUp' fields and I was hoping for something more efficient as a...

David, Thanks for the input, but the syntax is OK; I've simply put ELookUp in place of DLookUp statements in the fields on the form. Bob, In answer to your questions, first see above. There are 18 fields on the form which contain an [now] ELookUp statement; all of them give the 3061...

I have now located and copied 'ELookup', but am having problems with it. I used it as a straightforward substitute for 'DLookUp', but get an error message [the same one] on every field where I have used it. The statement which causes the error is: Set rs = db.OpenRecordset(strSql...

Bob, Many thanks for your prompt reply; I'll certainly look at ELookUp. As to the 'split database' argument, I got within a whisker of getting agreement to split the file. However, as the most senior [and most knowledgeable] user is about to retire, my users decided they would rather not...

I have inherited a database which uses a practice that I'm not sure about. Normally, when I create a Form, I set up a Table or Query as the source, and ensure that all the fields on the Form are contained in the source object. The inherited database has several Forms where a dozen or more...

Bob, That's excellent; just what I needed. Thanks for all your help.

Bob, Thank you for that. It is useful, but somewhat long on the "how" [which I know] and short on the "why" [some of which I know, but would like to know if there is anything more]. If you are aware of anything else in this area, I would be grateful for a link.

Bob, I'd be very grateful if you could post a current link for the 'split database' file as I think that is what I am going to have to do.

I have an Access 2003 monolithic database on a server, being accessed by a number of users, running Windows XP SP3. Since very few of the users make 'structural' changes, the lack of "Exclusive Access" is not usually a problem, and I only make changes when everyone else is logged out at the end...

Stoss, I don't know if it would work with 'OutputTo', but what I had was several reports, each with up to six different sources, each report being run via a command button on one of several forms. What I with did was: 1. Defined a public variable which I set, in each of the command button 'On...

I've just seen this whilst looking for answers to my own problem, so this is just a quick thought ... I'm fairly sure you can change the data source of the report in your code, thus enabling you to have a single report, but two queries.

Many thanks to Bob Larson and The Doc Man. Bob: I know about the benefits of splitting and am in the process of trying to persuade people that it is a "must do". The notes you pointed me to will help me win the "argument". Doc Man: Brilliant! You've hit it on the head; I found out late...

I have a shared Access 2003 database with multiple users all on Windows XP. One user gets a 3011 error, but the message does not give an object or file name; it simply gives two single quotes at the end of the "cannot find" message. None of the other users gets this problem when executing the...

I have now tried again on a different PC. As far as I am aware, both Windows and Access are set up the same on this and the original PC, both being up to date. However, on the 'new' PC, CSD Tools works for Forms and Reports! The challenge I now have is to find what might be different between the...

In answer to Jeff's questions: 1. It's Access 2003 SP3. 2. I have quite a few reports that I have set to preview, and that I then print without problems. 3. Yes, there is a default printer specified. 4. In some databases, I have a few linked tables, but most tables are 'native'. NB The...

I have created a new database, and added only one object, a form with no data source, and I still get the 3421 error, whether I choose 'forms & reports' or 'forms only'. I also tried with just a single report in the database and got the same results.

I had previously tried 'Compact & Repair' with no change in results. I've now tried the new/import suggestion, but still get the same error.

Rural Guy, I don't have Jeff's email address, plus his site recommends asking questions via Newsgroup Help, but I'm not sure what that is, so asked the question here as I've had some help from AWF members in the past. As Jeff kindly supplies the software free, I don't expect him to provide...

On this site and elsewhere, I have read great things about Jeff Conrad's free software, CSD Tools. I have downloaded and installed V2.0 of the software to use with Access 2003 under XP SP3. Most things seem fine ... but when I try to create a report for Forms/Reports, I get "Error 3421 Data...

The crosstab query extracts data from three tables. The main table contains a record for each Office that any Member has held: 'Member Name', 'Surname', 'Office Held', 'From Year', 'To Year'. Data is brought in from two other tables: 'Date Joined' [when the Member joined] from a Members table...