Search results for query: *

...table so they link to the fields on the ultradev screen-done BUT every other table selected from my access database will work apart from the $%^&* one i want it is a sandwich databse i set up in Access trying to do the online ordering for pickup no pricing or calulations involed(i WAS...

the SQL statments is SELECT * FROM Order this is why i'm confused? i've done some SQL programming and i can't see anything wrong. i value your advice and will start studying the code but wanted to see what the finished product looked like. i will be studing ASP etc later at uni but wanted to...

...was never created by myself-i selected the table i want my records to come from the pull down menu. so i'm assuming the SQL satement is SELECT FROM * order or something like that as a said if i selected one of the other tables from the pull down menu,then press 'test' button they work fine...

i'm a new user and followed a tutorial every step of the way untill i went to insert the recordset and it give the error [!Microsoft][ODBC Microsoft Access Driver]Syntax error in FROM clause but the from clause is simply insert all?? i've three tables in my databse, the others work apart...

tanks but i fixed it i had saved the design layout in a seperate file so i've just add new buttons with the command to run the particular query and this time it let me save it --yippeeee cheers for the help Louise

i just created a form with lots of button that run queries. they all work but for some reason it wont let me save it because of an 'automation error'--please help!! i don't want to lose my work

i just created a form with lots of button that run queries. they all work but for some reason it wont let me save it because of an 'automation error'--please help!! i don't want to lose my work

help! trying to put in an overall aggerate function in the footer of my report but they alway give the response. i'm using a text box but changing the control source to something like =Count([OrderID])

ohh wrong handle

please please please help!! how do i setup the program to read a text file that will count the number of a particular word in the file?

well do they? i've got a query that counts the no of items delivered in a particular sailing which i based a report on. i grouped it by port and it looks well but i'd likean total at the bottom at gives the over-all total of items delivered.....soooo...do i need to set up a new query to include...

ahhh very very clever idea terry, thanks

i really really wanted a macro that would move a record to an archive file to eventually be delete to prevent little whoopsies but i'm very opened minded and up 4 anything so feel free to suggest anything (marco related of course!) :-)

jus trying to make the most of a dull sitution. i have a lovely zebra print folder to hand it in in. wot can i say i brighten up my lecturers

cause i'm in work so i'm do it whie i'm getting paid :-) its very rough, r u sure u could handle it?? its for an assignment so i'mm trying to make it work first then i'll make it all pretty is peter@accuflight.com ok address?

i'm from Northern Ireland i'm so confused/frustrated! gonna give up coz i lack the brain power!! thought i'd need these queries to attach to the button event on the form so the current record wouldn't be deleted forever do u ever work? ur always here or r u my knight in shining armour?

detective and programmer is there no end to ur skill?? i am from the uk how about urself? i know its very cosy but ain't getting many funky marcos wrote! u must be scaring them all off LOL (tee hee)

jus good ol' bob the builder i fixed it! silly me changed field names to get some SQL queries to work but then every other query that used the old field names were slightly confussed, but panic over. thinking i'll need to do some sort of make-table query to make the archive table then make the...

Evening sweetie sob,sob i cant get it to work. think i'm tring to take too much on!

i didn't mean to leave but i had a situation with my database-its all fixed now. what do u mean grown-up bit of my msg?better to be young at heart if u ask me. i'm goin to try ur advise now,cheers