Search results

Option 2 is "Print Current Week's Timecard (sic)". Two things: 1) Time card is two words. 2) I click it and it works just fine. In fact, here's the printout: You know what I'm starting to think? Have you tried just reinstalling the printer drivers? My printer is a seven year old laser...

Here you go. I made one table (t_Items) and one form (f_Main). Open the form f_Main. It'll work. I made a "Reset" button for you so that you can select stuff from the drop-down and see how it works, and then resetting it will deselect everything and redo the combobox.

Make your drop-down three fields, like this: ItemID ItemName IsSelected 1 ItemA Yes 2 ItemB No 3 ItemC No . . . . . . X ItemX X Setup that drop-down like this in the properties: RowSourceType = Table/Query...

Change this: VALUES ([cboapptdate],[strpatientno],[strpfname],[strpsname],[straddress],[dtdob]); To this: VALUES ("#" & [cboapptdate] & "#, '" & [strpatientno] & "', '" & [strpfname] & "', '" & [strpsname] & "', '" & [straddress] & "', #" & [dtdob] & "#") You need to tell it what each type...

Or, a much shorter version that does the same thing: Private Sub cmdSelectFile_Click() Dim dlg As FileDialog Dim strFilePath As String Set dlg = Application.FileDialog(msoFileDialogFolderPicker) With dlg If .Show = -1 Then strFilePath = .SelectedItems...

You've put the Exit Access code behind the form's OnClick event accidentally instead of on the button's OnClick event.

It's called an UpDown control, and you get to it through the "More Controls" icon in the toolbox that has your label, textbox, command button, etc. (See picture.) Then, look at the properties. The most important one is Buddy Control. That's the textbox you set to match the arrows so that...

What if I just want to open up half a form, add it to a PivotChart, and then export it to Word? Do I need applications for that? ;) (Couldn't resist...)

To delete the records out of any table, it's this in VBA: CurrentDb.Execute "DELETE * FROM YourTableNameHere" In the QBE, just choose new Query, add the table whose content you want to delete, select all the fields (drag the asterisk into the grid), change it to a Delete query, and execute it.

Either sort on a different field, or better, store the quarter info as 2007 Q1, 2007 Q2, etc. You can still display it as Q1 2007, Q2 2007, etc. Just store it as 2007Q1, 2007Q2, etc. and sort on that. For the control, set the display to be: =Right(YourQuarterField,2) & " " &...

You can put a breakpoint on this line: stDocName = "rpttimeclock" Then you can at least step through it. If possible, can you zip up the DB so I can get what's going on here?

I'm not sure what the hell you are talking about with subreports and all this other stuff. (Excuse the French.) Take a look at the attached. It's a small DB with one table that has one field in it. The field has the numbers 1 to 500, sequentially. There are two reports, r_Across_then_Down...

Don't import directly into the table with the PK on it. Setup a temporary table with the ten fields you want to input, do a Transferspreadsheet from Excel into your temporary table, and then do a separate append query from the temporary table to the permanent table with the PK.

This is fixed in Access 2007, but for every version of Access prior to that, percentages either need to be entered as decimals (50% = .5), or you need to put a little code in the AfterUpdate of the percent control on your form, as in: Me.YourControlName = Me.YourControlName / 100 Stupid...

Data Access Pages do not work (and are not supported) in Access 2007.

I wonder if you can too. (Make a query based on the master table, link in the two other tables on the key, and pull the appropriate fields.)

Since the names are identical, it will only find the first one. You can use the arrow keys to scroll without having to use the mouse I suppose, but unless you have the same last name 50 times, it's not that big a deal. If it's that big a deal, then you need to assign unique IDs that are not...

Out of curiosity, how would that launch a default printer driver error? It sets up a variable it never uses and then closes the sub. Have you traced through it? It sounds like something running after that code that is causing the error, so set a breakpoint and then step through it.

There's no parameter because 1stlistbox is a text field. (99% sure I'm guessing that one right.) Make it this: Set rstDelete = CurrentDb.OpenRecordset("SELECT * FROM tblorderlist WHERE productID = '" & 1stlistbox & "'") Changes are in red.

Look at the example here. I did it with If/Then statements and not switches so that it was easier to understand.