Search results

Thanks for your suggestion, however i have already implemented the things you suggested, and i still get the same problems. I have checked the form to the extent that i know the problem lies with the subforms and not the underlying query. I can enter data into the first subform, in the first...

I have created a tabbed form, based on a multi-table query, with 4 subforms in it. Application is the main table in the db, with the primary key,id, being an autonumber and all other tables are related to this table via the id field, which is a number field. For each new record i create, there...

Can someone help, I have a main table in my db called Application, which has a primary key 'Application ID', which is an auto number. 19 other tables are connected to this main table by and ID field (primary key in the one-one tables) which is a number field. These tables either have one-many...

I forgot to mention that i had been using the wizard. Though i wasn't able to do what you suggested, it wouldn't let me. thanks anyway. What i did was to type the characters into the Row Source of the properties, and this worked. Thanks again. anita

When inputting text in to a combo box, is there any way of increasing the number of characters allowed on one line. I have tried the usual... pulling the line out to the right, but it still only allows me to enter a limited number of characters. thanks.

It's ok thanks, i re-created the report by making a few changes, and it now works. Thanks anyway. Anita

I had already tried that, but it was no use. Thanks anyway. Anita

I have a problem, i have a report that details payments made on certain dates. when i run the report, i should get the company name, payments made, and the date the payments were made. If there is more than one payment made, these extra dates and payments should be listed below the company name...

Thanks a milion. with a bit of playing around and a few more errors cropping up, i got there in the end.

This is a shorter query, which gives me the same error message, referring to the first field "APPLICATION FILE ID" SELECT APPLICATION.[APPLICATION FILE ID], APPLICATION.PREFIX, APPLICATION.TOWN, APPLICATION.[DISTRICT COUNCIL], [DC CODES].DC_CODE, APPLICATION.DIVISION, [qry_CURRENT CRISP...

SELECT APPLICATION.PREFIX, APPLICATION.[FILE REFERENCE], APPLICATION.[PROPERTY NUMBER], APPLICATION.[PROPERTY ADDRESS], APPLICATION.TOWN, APPLICATION.[PROPERTY POSTCODE], APPLICATION.POSITION, APPLICATION.DESCRIPTION, ENQUIRY.CONDITION, APPLICATION.TYPE, ENQUIRY.VACANCY, APPLICATION.DIVISION...

I took out these two expression, and i continued to get the same message. So i took 'PREFIX' out of the query, and i got another message saying: "you tried to execute a query that does not include the specified expression 'FILE' as part oof an aggregate function." When i delete 'PREFIX' out of...

I'm building what i thought wasa straightforward query, though i keep getting the following message when i try to run it: "you tried to execute a query that does not include the specified expression 'PREFIX' as part of an aggregate function." 'PREFIX' is a field, the following is the expression...

Audit trail re. ghudson's audit trail code... this code worked well for me in access 2000 Form and tracked any changes made brillantly, so I thought all my probs were solved. Not so. My problem is I am trying to do the same thing in an Access 97 form - the form is called Payments and...

Thanks for that. Brilliant! wouldn't have come up with anything like that in a million years!

What you have advised me sounds ideal, but i am just a beginner, and i wondered would you be able to put that in simpler terms. thankyou.

Brilliant! it does the job. thanks very much. What you suggested about having append and delete in one button, that's exactly what i'm after, but i wasn't sure that there was any way of doing that. do you know how i would do that?

Also, if it can see the DB in my hard drive, then is there a reason why it wouldn't see it on my server?

That sounds like a good idea, but i know that the way i am trying to do it at the moment should work as it worked on my hard drive. what i want to have is a form with 2 buttons, one with 'Append query' and the other with 'Delete query', and the user clicks 'Append query' and they are prompted to...

I have a small database, and I want to archive data held in one of my tables. I intended doing this using the append query. I created another database, called 'Archive.mdb' which I want to append the data to. This worked successfully on my hard drive, and the data was appended accordingly...