If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SQL statment
Would like to know if I'm doing a form, where can I enter my SQL statement??
Sorry ah, Newbie with Access. |
#2
|
|||
|
|||
SQL statment
Open the form in design view, open the form properties, press Alt+Enter or
select view properties from the menu bar. Click on the top left corner of the form, now the you have the form properties, select all in the TAB, the most top property called RecordSource. You can either paste the SQL there or, on the Button on the right, with the three dots, press on it, and a query type of form will be opened, select SQL and paste your sql. -- The next line is only relevant to Microsoft''s web-based interface users. If I answered your question, please mark it as an answer. It''s useful to know that my answer was helpful HTH, good luck "Swish" wrote: Would like to know if I'm doing a form, where can I enter my SQL statement?? Sorry ah, Newbie with Access. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Upsizing design considerations | philr | New Users | 9 | September 12th, 2005 06:51 AM |
Append sql statment | Frank | Running & Setting Up Queries | 2 | March 23rd, 2005 12:27 PM |
Using an SQL statment in a report in Access 97 | Jack Dawson via AccessMonster.com | New Users | 8 | March 2nd, 2005 04:00 PM |
Using sql insert with memo field truncates text data | Graham Meredith | General Discussion | 1 | September 1st, 2004 03:11 AM |
Function isn't available in expressions in query expression | Reiner Harmgardt | General Discussion | 4 | July 21st, 2004 09:30 AM |