Recent content by louize

i think this is too much for me! ultradev said to select the database u want the data to come from--done then select the table from the access databse in ultradevs 'databinding' table so they link to the fields on the ultradev screen-done BUT every other table selected from my access...

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...

no, the clause 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...

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?