Search results

If your main table has a field for "eac product group", and that is what determines the type of contract to print, then it's not too hard. Let's say you have a form with a "print contract" button. You'll need some code in the "on click" for this button. If your contracts are wildly...

Couldn't you create a report to look exactly like your form, and email that?

Are you absolutely sure that more than 1 record was entered today?

Display the query results in a form or a report. [This message has been edited by Chris RR (edited 09-27-2001).]

I'd take what, to me, is the easy way out, and build a query. First, I'd create a field in that query that is the person's age, in years. That should simply be subtracting the birthdate from today's date and formatting the result. Once that calculation is working smoothly, I'd put the same...

Welll.... I think you could either put a validation rule in your form to disallow either a * or a ? in the Searchbox field. Another alternative might be to do some coding in the after update for Searchbox, and convert the * or ? to some value that will give you a nice default result, whatever...

Two alternatives for Excel... One is to give the user two form buttons, one for Excel, one for results to the screen, and code each accordingly. But, what if you built a toolbar with the "Analyze it with MS Excel" function on it and put that up when you display the results? Then the user...

Working in your receipt database, link to the user table in the user database. Then you need to change the receipt form (or maybe the query that the receipt form is based upon) to look at the user table. You should not really need to change anything in the user database, as you have...

For a number of nasty reasons, I want to write a query in code, then use that query as the basis for my form. (OK, Ok, I'm trying to create an on-the-fly topvalues query...) I can write the query, no problem, but I can't seem to get the form to redisplay using the newly modified query. If I...

This is what I usually use. I would think that you could add other properties as needed: Set frmMyForm = Forms!fMyLovelyForm For Each ctlMyCtls In frmMyForm.Controls If ctlMyCtls.Tag = "Coord_btn" Then ctlMyCtls.Visible = True ctlMyCtls.Enabled = True...

What I usually do is to put two buttons on my forms, one to "Filter Records", and the other to "Show All Records". My combo boxes for the selection criteria are set up with code in the After Update property that does two things. One is to build a string that holds my filter criteria. For...

There are a number of ways to keep users out of what you don't want them to see, but let's start with the basic step: In the Tools menu, go to Startup. Uncheck the Display Database Window option. (Hint: When you want to get into Access & see the database window, hold down the shift key as...

What's the table structure?

Put your code to enable the button into the after update event for textbox1. I don't think that you need to do the me.refresh, but that's a guess. By the way, let me make a pitch here for renaming your fields and buttons. It's a lot easier to follow code (even your own, a few months later)...

Sure. When you do >= [Enter start Date] your user is going to enter a value that Access will perceive as text. Try running your query but responding #10/08/01# or put the date formatting into the query for the user, maybe something like: >= #[Enter start Date in MM/DD/YY format]#

OK, is the A1, A2, etc., code part of your table? Or is this just something that they want printed on the report? Both could be done, but the answer depends on which kind it is.

Instead of basing anything on a parameter, I'd put a field on the form itself, so users can enter the value. Then, base the query on that field.

OK, then, just set off Name Autocorrect for the users: Sub CheckACSettings() Const conText = 0 On Error GoTo CheckACSettingsErr ' Constant represents Text setting of Default ' Field Type option. Dim strMsg As String ' Determine current settings...

Try building your SQL like this. I usually break up the long line into multiple lines for readability, but this is the basic idea: Dim strSQL as String . . . strSQL = "INSERT INTO MASTER_DIE_TABLE (M_DIENAME,M_COLORS,M_LENGTH,M_QUANTITY,M_LOCATION,M_ACTION,M_DATE) VALUES...

Dev Ashish has a great example of how to do a controlled transfer of data from Access to Excel on his web site. It's also really fast. Once you figure out the basic technique, you can use this to control quite a bit of what Excel does with the data. The link is...