Search results

hello i changed it to this code but i have compile error can you help me please? DoCmd.RunSQL ("insert into checks_projects([Creation date]) select a.[Creation date] from (select [Creation date] from CheckPoints) as a left join checks_projects b on a.[Creation date]=b.[Creation date] where...

it has this error this time: "the specified field creation date could refer to more than one table listed in from clause of your sql statement" can you help me please?

thank you i made it correct but still i have the same problem

thank you for your answer but it has syntax error in this part: where checks_projects.projectname= '" & Text0.Value & "' and IsNull(checks_projects.[Creation date];")

hello i have a two tables in ms access: "checkpoints" and "checks_projects" i have a form and there is a date text box in it. i added data to checks_projects table form checkpoints where the creation_date field of the checkpoints is less than this textbox. but after sometime some new data will...

hello i attached it again maybe this time is better i explained it as : i have a form i have three text boxes in it as date i can enter date in these text boxes i want to make a query and one of my columns in this query is creration date i want that this creation date would be less than max...

because these data is saved in another table and by runnung this append query the data from my table is inseted to another table that i want i wrote this in criteria of creation date field in my query but it doesn't work <Max([Forms]![frmlocalprojects]![Text5]...

hello i attched it again

i have a form i have three text boxes in it as date i can enter date in these text boxes i want to make a query and one of my columns in this query is creration date i want that this creation date would be less than max value(date) of these text boxes. cany ou guide me please?

yes i saw it can you see the attach file now?

hello i attached the file did ayou see it? i want that in my query the creation date will be less than max of some values of some textboxes in one of my forms i know macx function

hello i want to make a query and one of my criteria is that one of my fields will be less than of two textboxes in my form. can you help me please? thank you i attached the pic

But my data come from a query and I don't want to enter the data How can I bring the data from my query to this form?

i want to insert data from a query to a table when a button is clicked. so because of that i need that this append query run automatically

hello i have an append query and i want to run it automatically do you know how i can run an append query automatically through a macro? thank you

I have a table and i want to have data of this table with some criteria in another table. i want to add some other fields to this table and do something on them. i have a table as checkpoints: Id checkname questions creation date ... i have a table as projects id projectname real time ...

no i want to do this many times automatically

thank you very much for your answer can you explain it more please? I really have problem and don't find any solutions I want to insert data from a query to a table in ms access web i don't want that the data should be shown in a form i don't know exactly what to do? thnak you

hello but there is no append query in ms access web. this feature is not existed in ms access web.

hello i want to add data from a table with some criteria to another table. when i use foreachrecord i have the error that create a record cannot be used in foreachrecord order. i Want to know what can i use instead of that? can you help me please? my problem is extreme and emergency and i...