Search results

I don't think that's an option, however, you can set the PDF printer to not prompt for a file name. Right-click on the Adobe PDF printer in your control panel, and select 'Printing Preferences'. Uncheck the 'Prompt for PDF File Name' and 'Ask to Replace existing PDF file' checkboxes. Of...

Are there any advantages/disadvantages to either? I've been told that Access works better with mapped drives than UNC...any truth to that? TIA, Jonathan Kok

;) Thanks! Worked like a charm!

The SHIFT+OPEN trick doesn't seem to work on my Access 2000 files when I try to open it with Access 2003. I imagine it's the dialog box concerning possible dangerous code that's messing it up. Any ideas how to resolve this? Converting it doesn't seem to be an option; Access crashes about 1/2...

Just a thought, have you tried using a capitol "Z" instead of the lowercase one? Could be your barcode font is misinterpretting the lowercase letter. HTH! EDIT: Just checked my own barcode-printing DB, has the same thing, but with other letters (Q, L, etc.) I used a font called "39251", no...

I've created a database to track downtime of a machining cell. I've got two fields, stop and start times. The user can enter the times either by hitting a button, in which case it inserts the current date/time, or by typing the time in the field manually. The trouble I'm having is that it has...

Or, you can click in the little box to the left and above the rulers, that'll select the form. Or, click on the dark grey area that doesn't contain anything.

OK, Elena's idea will find a record based on what you type, but it will not create a new record if that's what you want to do. What I would suggest is this: 1st, set your form's "Allow Additions" property to 'No' (you'll see why in a minute). Also, LOCK the 'projectnumber' field. Add a...

If you use the combobox idea and set the 'Limit to List' property to 'Yes', then you can make use of the 'On Not In List' event to run code that will do whatever you want it to. In your case, you'd get it to run a msgbox asking if the user wants to try again.

In the form footer, create a textbox ([txtRecordCount]) that calculates the total records, ie: =Count(*) Reference this textbox in your form, ie, create another textbox and set the source to [txtRecordCount] or whatever you named the above field.

Try using this code (instead of Docmd.Save...): DoCmd.RunCommand acCmdSaveRecord

Assuming your [fieldname] is something that's already been entered... Create code that sets the ValidationText property of your date field to be what you want, ie, [txtDateField].ValidationText = "The date should be greater than" & [referencefieldname]. Depending on what your...

Don't know if this will help, but... Add a Yes/No field to your table. This will be your 'locked' field. Add the field to your entry form. On your form, create an 'On Current' event. Check to see if the record is locked by referencing this field in the On Current event. if it's locked...

Shhh....it's a secret!

If you change the 'Back Style' of the tab to 'Transparent', and change the colour of your form, that sort of works. Except the actual tabs will still be grey.

Shouldn't the second one be Forms![Mainform]![Subform1].txtSubForm1 (lose the 2nd 'form')? Try that...

btt

Yup, I know that works already, and I've done that with a different one. I can't do it like that with this one b/c the tab control I'm trying to insert will (eventually) have subforms on it, and they have to relate to the master form. If I did it your way, it would then become the subform of a...

What's the purpose of Name AutoCorrect? What's going to change if I disable it? (I'm having the same problem with forms taking forever to load)

ARRGGGGGHHHHHHH!!!!! OK, how can I insert a tab control within a tab control? Everything I've tried has resulted in placing the tab pages ON TOP OF the tab control. I can't seem to get it to insert the tab control on the tab page. Any ideas? Thx!