Search results

Thank you to you both for taking time out, particularly at this time of year. I'm almost there and I now understand the logic of whats going on. My only stumbling block is on the append query. I'm putting table address into address1 with ID being the problem field so would the code be...

Had a look at the append query help and it would appear that when you set the append up if you drag the auto field to the query grid (as opposed to using the asterisk) then the autonumber won't change when you run the query. Seems to work (I think!)

Hello there Doc Man - thanks for taking the trouble. I'm not 100% clear at the moment. There are no front end/back end issues so I've got one table called Address with the autonumber and another table called Address1, also with the autonumber all within one database. What I want to do is append...

I've 2 databases used essentially for mailing purposes, to be merged into one. Each database is the same - they have a table using an autonumber for each customer. This table is linked by the autonumber to another table that lists products the idea being that for mailing purposes you select a...

Thats very helpful thanks. One more thing though (he says pleadingly) but how would I would I give the option to open the form to add a record, eg, message says "no records found - click yes to enter a record, no to quit"

When a user opens a continuous form that doesn't have any records in it I want a message to come up to that effect (the form looks a bit odd with no records in). Sure this must be pretty easy but cant quite get there.

At last got it!!! Not too sure why it wasn't working but having reread both of your advice with a clear head this morning I've got it to work. Really ought to learn to call it a day when the head starts spinning. Cheers again.

Hello Elana Tried that but didn't work either. Still misses the second message. The user gets a message on each option group when it's selected so they do get a warning - can't do everything for them I guess! Thanks again

I've got 2 separate option groups connected to 2 separate text boxes. In each case when the option value is 2 the text box must be filled in before proceeding to the next record. This works fine for the first option group and text box, but it ignores the second option group message when I go to...

Whoops. I missed out .xls. Only wasted an hour on that one!!!!

Well this seemed to work at home but not in the office. I've got the following code that should send the query toExcel. DoCmd.OutputTo acOutputQuery, "qryAll", acFormatXLS, _ "G:\Fpit D\a_comp\Dominic\Hoffman\Storage" When I run it, the status bar tells me its outputting it to Excel but...

llkhoutx - sorry, this has really got my back up. If you've nothing postive to say, don't bother replying.

Cheers Rich - I'll take a look at that - thanks for the advice. llkhoutx - thanks for your constructive help - it was a wow.

I've a report with a group by title (doctor, mr, mrs). Within each group there are 5 field headings (Excel, Access, Word, etc). If they've attended the course they get a tick. Is there a way I can count up the number of ticks within each group for each course. Eg, Doctor Staff id...

Des - Magic!!! Thanks ever so much for that. Spent hours trying to figure that one out!!! And it's so easy when you know if you know what I mean. Can go off and watch QPR play football happily now! Have a good one!

I've only just realised that I need to change the format of the dates when using SQL. I picked up the info as below from a previous thread but keep getting an error message 3075. It works fine when I do a search including the date field but not when I don't want to include the date field. EG...

Thanks for that. I think I've sorted it in my own very haphazard fashion. After I've opened the dynamic query I put a line in to return to the form, refresh the list which is based on the query. Doubtless the wheels will come off later!!

I've a query by form that opens up the relevant records each with about 15 fields. Is it possible to produce this list of records and then click on a record to bring that specific record up in form view? I've seen a database where there is the QBF form. When you perform the search a list box...

I've a table(1) with a list of organisations. These organisations are involved with different consultations. I've listed these consultations in another table(2). I've another table(3) with 2 fields (both PK) one with the organisation ID and another looking up the list of consultations. I use...

Cheers for that - Access 97 unfortunately!