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: : "Delete * From [Learning Activity Dataset] where [learning activity dataset].[learn_id]=" & 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 " but before the Me!
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 " after runsql and there is another " 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 "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 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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.