Search results for query: *

Thanks Again Andy. Much Appreciated Ant [smile]

One more question, If i want to add more where statements to the above, how would i go about doing it? Thanks Anthony

Thanks Again Andy. Works great, you're a star. Have a good Weekend. Anthony :-)

Got Ya. Think this is correct. Watches: "Delete * From [Learning Activity Dataset] where [learning activity dataset].[learn_id]=" & Me!List3.Column(0) Value: "Delete * From [Learning Activity Dataset] where [learning activity dataset].[learn_id]=ABLID0424" Type...

Hi Andy, I think i did what you said correctly and received the following:- Change: : &quot;Delete * From [Learning Activity Dataset] where [learning activity dataset].[learn_id]=&quot; & Me!List3.Column(0) : <Out of context> : Variant/Empty : Form_Learning Activity Form - Main.Comm...

Thanks Andy, Think its getting close now. When i click my command button now it says:- Enter Parameter Value Ablid0424 The Ablid0424 is the value in my list box, but seems to be the name of the parameter now. Ant

I get two errors. The one i am receiving now is Complile Error - Syntax Error The other is Complile Error - Expected - End of Statement. On the second error the cursor is flashing after the &quot; but before the Me! Ant

Thanks Again Andy, I copied and paste what you wrote, but i'm still getting a compile error. Regards Ant

Hi MakeItSo and John, Still no luck, i have looked at the FAQ and i still am having problems. Table Name - Learning Activity Dataset List Name - List3 Column Which includes Learn_id - Column(0) Field Name to link to list - Learn_id Am Really confused now. Want to delete from Learning...

Hi John, Thanks Again, however again there is an error. This time it says Compile Error: Expected End of Statement. The it highlights Me! Not sure whats wrong Ant

Hi John, Thanks again, however this time i have the following message:- Compile Error Syntax Error. Any ideas. Is it because that i start the statement with &quot; after runsql and there is another &quot; after =. Ant

Thanks for replying John. That would seem the way to go, however my knowledge of SQL is really basic. So far what i have is:- DoCmd.RunSQL &quot;Delete From [Learning Activity Dataset] where [learning activity dataset].[learn_id] = The rest i am unsure of. I need to say where Learn_id =...

Thanks for replying Eddie. However I cant remove that information from all the tables as my database in connected to a national database which tracks students all over the country. The idea is by having that information in all tables they will be able to track students throughout there whole...

Not Sure if this is possible, but i have a form with a list box on it. The record source for the list box is from a table. Is it possible to select one of the rows in my list box and then delete using a command button. When i say delete the record in the list box, i mean to delete the...

Hi All, Is it possible to update several tables from one query, such as above? If so could some explain please. Thanks Anthony

Thanks Eddie. Have a good Xmas. Anthony

Merry Christmas All. Thanks for all your help over the past few months. I couldn't have done it without your help. Have a good one. Anthony

Hi Eddie, Imported the information into a query but it comes cannot find my tables. My Table Names and Fields are:- Learner Dataset Uniqueid Learn_id Provi_id ULI Table Field1 Field2 Field3 Not sure what im doing wrong. Thanks Ant

Hi Eddie, Would i have to create another table to import the data into? Ant

Hi all, I have a database with a query i have to export weekly. The query has 10 fields:- ULI Learn_ID Provi_id LSurname LForenam and so on. However when i export the query the ULI field is blank and then three days later i will receive a file which has the following fields:- ULI Learn_id...