Search results

OK, OK, before I get kicked from the forums, step three is purely optional.

Hey! You posted this same question to the General forum! Make up your mind.

Another approach is to use a combo box which is linked to a table of authorized state or province abreviations. If you make the combo box "limit to list," users may only enter those you determine are correct. If you make that list upper-case only, the combo box will replace the upper-case...

Look in Tools /Add-Ins/Linked Table Manager. This opens a window which shows which tables are linked, and the path where the DB expects to find them. If they have moved, and you know where they now reside, you may re-link them by doing the following: 1. Put a check next to tables you want to...

Something must trigger the code to execute. Where do you have the formula / function? Wherever it is, it will only happen when that event takes place, such as ON OPEN of the form, or ON EXIT of a particular control.

If it were me, I'd reload Access. It's not too big a deal if you have the CD. -Curt

Another way to go is to create a delete query, and then open it in the ON EXIT property with docmd.openquery queryname -Curt

Where is the field which holds the quantity to be printed? Is it in a table, query, textbox on a form, or where? If on a form, you'd use: qytprint = forms![formname].[textboxname] substituting the formname with the name of your form, and textboxname with the name of the textbox. Is this...

If you always want formB to check about all or single records, why not simply invoke the printing/previewing from formB, and when printing is complete, close formB and return to formA? -Curt

Here it is! I did some revisions to fix the bugs. The entry rules are: numbers, spaces, hyphens and commas only. Numbers are dilineated by spaces OR commas, ranges are dilineated only by a hyphen between two numbers. "1 2 3" will add up to 3 "12 3" will add up to 2. "1,2 3" will add up to 3...

This is what writing code is ALL about! John, I thought it WOULD look at multiple ranges, but then I didn't test it properly for that, and as is the rule, untested is undone. I'll take a look and see if I can alter the code just a bit to make it work correctly. -Curt

TRY THIS! This does what you were talking about. It uses two textboxes on a form: txtInput and Answer. No doubt the code could be cleaned up to be more elegant, but it works. It should be placed in the On Exit module for the txtInput textbox. [SIZE=3][FONT=courier new] Private Sub...

Just for the record, you could simplify this by changing to: Private Sub Check7_Click() 'If Check7 = true, test is visible. If false, not visible. Me!test.Visible = (Me.Check7 = -1) End Sub

I don't think there's a specific command to specify the number of records displayed. The size of the form in relation to the data determines how many records you can see on the screen at one time.

Thanks, but... It doesn't work. I get an error: Data Type Mismatch in Criteria Expression. Looks like too many quotes to me. If I cull down the quotes until I don't get an error, the query returns nothing. Seems the problem is in how to pass criteria via a string. How's it supposed to be...

I'm, trying to make a query work which searches for one or more keywords. The form which calls the query has an input textbox. I have code which strips and parses this input and concatenates it into a string with asterisks, etc. If the input textbox contains dog bark loud the string ends...

Try this… Private Sub Check_Stock_NotInList(NewData As String, Response As Integer) Dim msg As String msg = "My Text Here." MsgBox (msg) Response = acDataErrContinue End Sub The Response tells Access what to do. See "NotInList Event - Event Procedures" in the Access Help. Good Luck

Try this… I hope I understand the question, but I think this would work on your report. Instead of using formatting, just bind the report's textbox with the following as Control Source: =iif(forms![formname].[textboxA]="" or isnull(forms![formname].[textboxA]),"","labeltext: " & [fieldname])...

What do you mean by... pages? Do you mean convert a form to a printed report, or do you mean something else? -Curt

This is not difficult. Check in your Access Help under "menus, creating menu bars" and Toolbar Buttons, adding to toolbars. All you've got to do is either write some code or create macros which launche the different forms, then assign the code or macro to either the menubar or toolbar button.