Queries

[aaliah]

Hi there
I work on Ms Access and its VB.
i have two problems:

First:
I'd like to hve some line(s) of code(s) that would prevent the query on which my form is based, from running the first time that my form is loaded.

Because presently, a dialog box opens up and asks me for the argument/value to pass in my query when my form loads up -->which i have to hide from the end-user (who wont understand this obviously)

Second:
My forms are based on queries. On adding new records (or updating an existing record) to my tables, I have the following errors/MSaccess comment:
"MyDB cant't append all the records in the append query."
Help says that it's because i'm using an action query, but i know nothing about how to solve that.

Thanks for your response and solutions.

[sonu5588]

Hello miss aaliah,
Asalam o Alaikum,
Waqasbutt Here,

You should be use the DAO object library for your records
Udations,Movmen ts,Deletions and Searching .
The Data Control components u can can use for this aim.

For more details U can Call me on +xxx-xxx-xxxxxxx

ok Allah Hafiz
Waqasbutt

[debasisdas]

Do not expect us to gues sand solve your problem.
Please specify your doubts clearly.

also post the code that you have tried to solve the problem for reference of our experts.

[Killer42]

Personally, I think you'd get a better response on this one from the Access forum.