Search results

Thanks for the replies. Once a query has been created is there anyway of someone knowing whether it was created using the QBE grid or SQL?

Yeah know..but my tutor gets annoyed if we ask too many questions. That makes sense though.

Hi, I am a beginner so please forgive my lack of knowledge on the subject. I have created a database for an assignment with various queries. I understand that there are different ways a query can be created, via the QBE gird (which is the easiest way), by ANSI SQL and by Access SQL. I am...

For an assignment I have to create "1 input form , 1 query form.."from an Access database. I am a bit confused. Is a query form just a query or is it a form that is based on a query? What s an input form? Is it just a normal form in Access?

Thanks for you help, the instructions provided by my college missed out some steps, it is now working.

Yes it's on but not appearing when I click on the option button. Also don't know how to link an option button the the correct field.

Hello again. I am doing a worksheet for college and have been asked to create option groups on a form, but I cannot work out how to do this. The screenshot shows what I have to do but I cannot get the option group wizard to open. When creating my form based on the design in the screenshot I...

Thanks for the quick response, you've been very helpful.

Thanks, I've changed it. I didn't choose the names as I am following a worksheet provided by my uni. I will bear that in mid though when I create forms completely by myself thanks.

Sorry I don't know the correct terminology as I am new to access. Yes it was the driver# field that I could not see. If it text13, I'm assuming I can just change the name so it says driver#.

Hi I am trying to change the tab order but have noticed that some of the fields are missing from the tab order form. I am attaching a screenshot to show which tabs are missing. Any ideas on what's wrong? Thanks.

Ok, that's very helpful thanks.

Sorry not sure what you mean by SQL code. Do you mean the SQL statement (which I posted in my first post) or the type of SQL statement? Which would be CREATE TABLE or the error message code? I kept getting "query must have at least one destination field" and "syntax error in field destination...

Thanks, just a question though. Can you view the SQL statement in datasheet view prior to running the query?

Hi I am doing a distance learning course and was asked to create a table within an existing database using these SQL commands; CREATE TABLE Vehicle (reg_no TEXT(10) CONSTRAINT VehicleKey PRIMARY KEY...

Hi I am completely new to Access and have joined this forum to get help and advice.