A problem with queries

[buncey]

Hi

I have a number of standard queries based on a primary table.

I have created various forms with embedded macros to filter out the information required.

The bit that I can't work out is, when I run the queries they are adding records to the primary table, I could understand it if they were Append Queries but they aren't

As an example the marcos are typicaly:

Action = Open Query 
Argument = qryProjectManagerReadyForInvoicing
Action = Apply Filter 
Argument= [Forms]![Project Manager Invoice Status Form]![cboPMInv] & [Forms]![Project Manager Invoice Status Form]![cboStatus]

Any suggestions as to what on earth I may have done wrong would be greatly appreciated

[NeoPa]

I'm afraid most of us never use macros in Access. You may get lucky & find someone who can help, but very few professionals use them.

[buncey]

Er!

So what are the options?

For the most part for the stuff that I alone use I simply use a couple of perameters and that's that.

What I'm trying to do is create a "Joe Soap" interface I.E a basic form!

[NeoPa]

The alternatives to using macros is to use VBA code.

For creating basic forms there are a number of very helpful wizards. Loads of options to choose from.

Welcome to Bytes!

[buncey]

Please point me in the right direction

[NeoPa]

What do you want to do? I don't really have a very clear idea of what you're after.

If you use the wizards there are various options to choose from. With what you've told me so far how can I possibly be more precise?

What I can say, if this is where you're stuck, is that the Insert menu is where you need to start (to find the wizards). Select the Form option to get help creating a form. To get the form to be bound to a particular table then select that table before you start the process. I hope this is some help.

PS. I don't know why, but all your posts seem to start out as moderated. They only become visible generally when I approve them. I've checked the status of your account and see nothing wrong there. Do you have any understanding as to why all your posts are moderated?

[buncey]

Hi
First off I have no idea why my posts are moderated?

Now the odd bit, I have no problem with creating forms that are bound to tables or queries, can I find the insert menu, can I heck as like, where on earth is it? I'm using 2007..........Perhaps I'm having a senior moment?

[NeoPa]

Hi Buncey.

I musty have missed this when you posted. Sorry. I don't like to leave members hanging. I only caught it as I'm going over some older threads adding best answers where sensible.

I'm not very familiar with A2007 though I'm afraid. Perhaps Interactive: Access 2003 to Access 2007 command reference guide can help.

[nico5038]

It's impossible for a SELECT query to add rows to a table.

So, as you're sure that rows are added, I would like to know or these rows are only visible in the output or does the table really "grows" with a number of records.

If the latter is the case, then there's something else in your form's code/macro's that's adding rows. If the first option is the case, than there's possibly a JOIN with another table causing rows to repeat.

Can you post the code of the original query ?

Nic;o)