Query VBA coding

[xlt-hunter]

Hi all,

Is there any coding around that will rerun a query in report mode to enter extra lines of data on the same report with different conditions?

Thanks

 

[namliam]

If I am getting you right... No, you will have to create seperate query/report for it.

 

[xlt-hunter]

ah, okay - is there anything on access can allow me 1 row of info, and another etc...

ie like a paramenter query - then entering, and typing in a break to get the next string of information.

"Ingred1, Ingred2, Ingred3, etc..."

and puts these on a report

Ingred1
Ingred2
Ingred3
etc....

With all of the data needed for each Ingred?

Many thanks

 

[namliam]

Sorry I read your post like 5 times, but cannot really make sence of it....

 

[xlt-hunter]

I have "[Enter Ingredient Code]" in the criteria section on one column of a query, this gives me a popup when starting the report to enter the code. I would like to have this reappear to enter more information. Maybe the action to with another pop up box like after the data has been entered

"Would you like to add another ingredient"
"Yes" "No"

Click on yes and the query will rerun and enter the data in, select no and the report is made.

Doesn't have to be query, something to make it work like the above

M

 

[namliam]

To do something like this in a query is IMPOSSIBLE....

You can however have a user fill a table of names they want to search, then link that table (or use it in a subquery) to extract the information you need to show...

Probably not clear enough, but lets give it a shot...

 

[xlt-hunter]

Bingo - that just triggered something.

(off to play...)

 

[namliam]

Good...

And Good Luck... Please let me know if I triggered something that actually ended up solving your problem...

 

[xlt-hunter]

It has worked

What I did in the end was to link a few tables up in the relationships.

Made a new query that builds a new table (once off)
Then made a append query that searchs the code I am after and enters the data again. To enter another row I run append query again and so on, a report is linked to this temp table and I can do print outs.

On close of the report the delete query takes over and clears out the data in the temp table.

Brillant

 

[namliam]

Using a temporary table is a total last resort, most probably you could do it with queries alone....

But atleast (for now) it works, now you have time to find out about union queries and stuff...