Search results

is there a separate table for students in each year? or a field in a table which defines what year they are currently in?

No that's fine bob you go right on ahead. I'm here learning, like the rest :)

The IF IS NULL syntax is correct, it should be before the object name would it be possible to upload your DB? if you'd prefer to send it private to just me then i can supply my hotmail if youd prefer not to post thats cool with me just a thought try adding END IF directly after the THEN So...

It must have been one of my teachers preference's then as we were taught to code SQL straight into VBA not take it from the query builder, there isnt much difference in content apart from the obvious formatting etc, thanks for clearing that up bob anyway better end that small convo there before...

really? i was taught to put spaces before the verbs, or is it just a programmer style thing? anyway ive removed the previous comment to avoid confusiong

Comment removed

hmm not quite sure what you are after? but maybe this might help Otherwise, underneath the variable declarations (dim var as string, etc) put After Line "Set LRS = Nothing" put is this what you are after?

i imagine that youve either got the SQL syntax wrong or the Field name wrong (assuming there's SQL involved)

swap for and for try that (the difference is the added spaces just so you know) you usualy put spaces between the initial speach marks and the SQL command(from, where etc) EXCEPT for the initial "SELECT

O i am sorry autoFill, i thought you said autoComplete i think a DLookUp or a Select SQL would go here making all your form controls (Textboxes etc) equal to their respective values Name = Table.Name for example

Bobs so correct he's solved my problem as well, and i didnt even have to post it! Haha Cheers bob

i could be wrong, and have recommended this somewhere else on the forum, but have you tried a recordset search?

i could be completely wrong here but a recordset search might be helpful First i would ensure that each Current User(Complainer) has a ID or something you can use to identify them, depending on what you use to search for, this could be telephone or address or just a auto-number field (ID)...

Not fully understanding your problem but these two links might help, very usefull site http://www.w3schools.com/sql/sql_insert.asp http://www.w3schools.com/sql/sql_update.asp

Sorry to have to do this but i need 10 posts to post links for some strange reason, hence the double post

Cheers Red, your a saint, Thanks and Rep given! just discovered the w3schools site, brilliant guides to loads of SQL commands Thanks again! PS sorry for posting in the VBA section the code was later put into VBA code if its any consolation :rolleyes:

Hello all, im working with access 2007 and i have a listbox that should display all the records from a table the problem i have is one of the fields is called Index1 and another called File Title as the listbox is displayed it goes: (Table.Field) Loan.LoanID - Loan.Name - Loan.Index1 -...

hi david, ive just found the soloution to the problem, instead of putting all the radio buttons and code etc in a differnt form, ive put it on the form with the listbox. problem solved. thanks for your help, ive given rep and thanked ;)

The listbox is used for other things mainly to display bookings, i simply wanted to give the user the option to sort the records, am i going the wrong way about this? this also has to be written in VBA as the a-level course requires the program to be written in a high level programming...

i am not sure what you mean by what does it say,it contains the code for the SQL statement do you mean the error message? "Run-time error 424 object required" is the message returned by debug.print Regarding the posting of the Database, it is an A-Level project so i would prefer not posting...