Search results

In continuation to BarkerD's response, just in case you didn't know how to run the SQL you must type DoCmd.RunSQL strSQL To your second question, you can run any -VALID- SQL statement, including Update and Make Tables etc... tc3of4

Type this in your Form_Load Event DoCmd.GoToRecord , , acLast This should do it... tc3of4

Create a Form, and in the On Load property... type the following Private Sub Form_Load() '/** Type this in DoCmd.OpenReport reportname, acViewPreview Exit Sub Now 1) Go to the Tools section in the Tool Bar (Command Bar) 2) Select StartUp 3) In the Display Form/Page combo box select the...

Yes you can, what you can do is create a temporary table then delete it. Since you are working thru code, here is an example... Code to create tempTable... DoCmd.SetWarnings False '/** Create the temporary table DoCmd.RunSQL "SELECT aTable.* INTO tempTable FROM aTable"...

Since you know how to write a bit of code...(i.e. creating input boxes) then this should be all you need... 1) Create a label or text box to hold the value entered by the user... (in this case lets use a text box called txt_TextBox) Now within the sub procedure you in (in the code section)...

I just tested it out and it seems to work fine. You declared it, and populated properly... tc3of4 There was an a little syntax error with the coding though, --- it's with your Select Case part... I'm sending you mail that will explain [This message has been edited by tc3of4 (edited...

If you want, you can e-mail it to me and I can take a look at it. I was assuming that you had 3 text boxes and you want the values of the first 2 displayed in the 3rd one (after they have been through the CostFactor function) Just wondering, do you enter values within the two text boxes, or...

Since you've changed the format of the List box to a Multi select, the .Value of the ListBox will always be null. You can use two methods of retrieving the selected data. 1) By using the Selected property or, 2) By using the ItemsSelected property Seach in the help file for the above two...

Here is something similar to another person which I helped... ----------------------------- This is probably a very easy question (but hey its late in the week). I have a table [TblKit] which has two fields, floor and platform. On my form i have two combo boxes (named floor and platform). What...

On the form that you want to disable right click, try the following... 1) In design view (of the form) select properties. It should be properties for the Form 2) Select the Other Tab 3) Goto the Shortcut Menu property and change Yes to No That's it. Now, when the form is loaded you see...

The reason why this does not work is because T3 is waiting for some event before it shows a value. Why don't you try this then incorporate it to how you want it to look. You have T1 ,T2 and T3 respectively, now have a command button called let's say Calculate. When the user clicks on the...

Hello, assuming the following: combo_Floor and combo_Platform Within the Floor combobox Event tab, select the AfterUpdate event. You can use this as the code Private Sub combo_Floor_AfterUpdate() combo_Platform.RowSourceType = "Table/Query" combo_Platform.RecordSource =...