Search results

'Required' is set at the Table level, not the form level. You can use validation on the 'before update' event in its place.

By gum, you're right! Stupid english language... dim dayofdate dayofdate = Day([FieldName]) Select Case dayofdate Case 11 To 13 ending = "th" Case Else datelastdigit = Right(dayofdate, 1) Select Case datelastdigit Case 1 ending =...

It doesn't?

If it does exist...Microsoft buried it well. You CAN reference a label's associated textbox via the 'Parent' property, but there's no reciprical 'Child' property on the textbox. EDIT: Found it. Buried well. Returns the caption of a textbox's associated label: Dim ctl As Control Set ctl =...

The trouble is...it's not clear. On a form, there are labels, and there are textboxes tied to fields. Two different things. Captions only apply to labels--textboxes do not have captions. If you are refering to the Caption property of a Field as set in Table Design mode (NOT on a form), then...

Make sure the new record in the detailed form is saved before opening the short form (docmd.runcommand accmdsaverecord)

You'd probably have to do it manually: Declare variables: dim datelastdigit, ending, thedate Figure out if it needs the 'st', 'nd', 'rd', or 'th' ending by first finding the last digit of the Day: datelastdigit = Right(Day([Fieldname]),1) Then use a case statement to figure out the ending...

Just thought of something...have you considered using subreports to merge your multiple reports into a single one? Combined with the 'Use Specific Printer' setting, it'd probably be easier than figuring out the Acrobat API...

Pshh...excuses, excuses. Perhaps I should decrease your reputation for being late. :p

If it's possible, it'll be through the Acrobat API. You can get the source documentation here: http://www.adobe.com/devnet/acrobat/

So...we all agree :D

How much information is in your database? Hopefully...not much. Because, well...you're going to hate me if there is. You need to re-design your database. You should, instead, have three tables: Employees: EmpID(autonumber/PK), Name, StartDate, Dept, Mgr Class: ClassID(autonumber/PK), Name...

Use the wizard to create the search. Then, take a look at the code the wizard writes. Adjust and apply that code to your own search function. Delete the wizard's combobox and underlaying code, if you want.

The field labels, by default, are called "Label<n>", where <n> is a number. They have a property called "Caption". To read the caption, you might use this: str1 = Label23.Caption You may want to rename your labels to something more meaningful, like 'lblName' or similar.

The ComboBox wizard includes a wizard to go to a specific record. Use that, then convert it to a List Box (though the combobox is the preferred method).

rofl...it's been 5 years away from that for the last what...10 years? ;) But I'll second Dragon Naturally Speaking. Not only does it have top-of-the-class speech-to-text, but its text-to-speech is superior to anything else on the market.

Are you actually converting your database to SQL Server, or are you just moving the database file to a folder on a server that happens to also have SQL Server installed? I'm assuming the latter. After you've moved the database, open it and click on 'Tools-->Database Utilities-->Linked Table...

Even better. What can I say...I've been on a PivotTable kick lately ;)

Put it in the 'After Update' event of the subform (referenced via Forms!formname!fieldname.ReQuery) Wow. That's a lot of fields. And a lot of typing. Try using a 'with' statement to make it easier, ie, instead of forms!formname!fieldname1.requery forms!formname!fieldname2.requery ... Use With...

Via code, you would add a record to the table. Replace the variables with the appropriate ones. Green denotes the form field names, red denotes the table field names. dim rs, db Set db = CurrentDb() Set rs = db.OpenRecordset("TableName") with rs .AddNew !ClientID = ClientID !InvoiceID =...