Search results

To get data into a query, you need to save it in a table. You might want to find a good Access reference book (try the Que books, there are others). If you just want to reference a form field in a report, do something like this in the control source of a text box...

Two things might be happening. One is that there is an absolutely boundary that your printer can't go beyond. Depending on how close you are to the edge, you may just have found it. The other is that you may have "name autocorrect" set on. Try turning that off. As a side effect, it can keep...

Taking a different tack... Running a date-based report is not necessarily going to give you the same results as saving a report that is a point-in-time picture of your data (what about deleted records???) (what if you change the table structure???) If you want to archive a report, you can do...

This is how I filter records to show a specific plant, selected from a combo box: ' Dim these fields Dim theFilter As Variant Dim thePlant As Variant 'then in your filter button click event 'you would want to add error routines, etc thePlant = Me.cboPlant theFilter = "[Plant] = '" & thePlant...

Or use the constants True and False. Much easier to remember: If [Tax] = True then 'calc tax else If [Tax] = False then 'you do not live around here...

I'm not entirely sure that I understand what you want to do, but it sounds like rather than seeing: Answer A. Answer B. Answer C. You want to see: Answer A. Answer B. Answer C. To do this, put a text box on your report, give it a name, then set up the control source like this: =[FIELDA]+ "...

Maybe this will help. Basically, there are forms that pull in their data from a query or table ("bound" forms), and forms that don't ("unbound"...a menu would be a good example). You can tell by looking at the properties for the form, and seeing if the Record Source is filled in. If your form...

You might want to do this in the after update event for Box 1. You'll need to use the value from Box 1 in a Dlookup statement, which will find the value for Box 2, and then put that into Box 2. Guess I don't mind answering questions at all, but you have to put a little effort into it, too...

Do you want the data inside each box to wrap, or the entire row of boxes to wrap?

If you are using Access 2000, this is a know problem with the "Name Autocorrect" settings. If you have autocorrect set on, Access very kindly "autocorrects" the margins for you. (And if your users have this option set on, the margins will get messed up there...) You can reset the option in...

What do you mean by "inside"???

I think that you would have to do a dlookup in VBA to see if the field was already used.

Hmmm...exactly when do you want the background to change? You need to put (or call) the code in the proper event. Also, are you familiar with the debug window? I'd set a breakpoint & then watch to see if the code is ever executed.

Here's a way to cycle through groups of fields on a form. You could easily modify this to go though all the fields, but usually I've found that there are some that I do not want to change. Here goes. Use the "tag" property for each field that you want to change, and give them a common name...

Have you tried the "Keep Together" property???

Maybe it would help to step back a minute... First, a query. Sometimes you can just run with the query that your form is based upon. Otherwise, this may need to be a parameter query that will use some screen field (hopefully the record ID?) to select the right record(s). (Hint: Open the...

More information please. What sort of database are you using? Is your data in Access or in SQL Server or Oracle or ??? The answer depends on this. Then on part two, once a table is updated, then any query will include the latest data. If you want to set up a query that uses beginning & end...

I'm not really clear whether you have one query or more than one. If I were doing this, I would make as many queries as I needed to get the various elements, then join those queries into one for use in the report.

If you are using Access 2000, there is a weird bug that can change your page setups without your knowledge. The fix is to turn off the "name autocorrect" feature (tools==>Options, General tab). The problem is that everyone has to do this on their own machine... It is possible to reset this...

I would try changing this: strEmail = rsEmail.Fields("EmailAddress").Value DoCmd.SendObject , , , strEmail, , , rsEmail.Fields("Matric No").Value, "This is an automated e-mail. Please do not respond", False To this: strEmail = rsEmail.Fields("EmailAddress").Value Iif(len(strEmail) > 0 then...