Search results

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

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

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

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

I have a membership database which contains [amongst other things, and in a variety of tables], members names, offices held, and the 'from' & 'to' years for each office held. I set up a crosstab query to enable me to produce a tabular report showing all the offices each member had held and when...

I am using Access 2003, running under Windows XP SP3. I do not know whether this is an Access problem or not, but cannot find any suggestions anywhere for a solution. A user modified a report and has problems with the new version. In trying to resolve these, I set up a db with both the original...

I use Access 2003 running under Windows XP SP3. I have a number of databases which I use [amongst other things] to produce envelopes and/or labels. I use several different sizes of envelope, but use the same method for all envelopes and all databases: I create a report, with dimensions...

I have an Access 2003 database residing on a server and used by multiple users. The only security is that a password is required to open the file. It is common practice for some of the users to create one-off reports, etc. to meet ad hoc information requirements. Until recently, the database...

I am using VBA [TransferSpreadSheet] to export a table from an Access 2003 database to Excel 2003. I have no problems at all with the data, but the resulting spreadsheet has the 'MS Sans Serif' font, whereas the defualt font in Excel is 'Verdana'. I can find no settings in Access or Excel which...

I have a couple of applications which, on loading the database, automatically run a report in 'preview' mode. Without me having set any parameters, in Access 97, the window size is set to 100%, which means that I can read the report easily. Having now converted the databases to Access 2003, the...

Hi, I have a procedure to send the same email to a selection of people. The procedure works ... almost. Whilst testing it, using breakpoints, all was well, but when run 'live', only one email message is created. The addressees in it are successively overwritten, so I end up with just the last...