Search results

It can access a query (prewritten of course) as well as a table. You can not specify SQL in the dlookup function.

I think (think being the key word) you are expecting the YES criteria to apply to a column, but it does not work that way, it applies to a row. So if you have C1's criteria set to YES and C2's criteria set to YES, and in row 1 C1 = yes, and in row 2 C2's value = YES, and you have the criteria in...

Ok, is each set of entered data unique or rephrased, saved in it's own record? The binding (bound form) of the fields to the underlaying table causes Acces to save new data, or update existing data. If you are using an unbound form (fields not tied to anything) than that is a whole nother ball...

I would create a query that summarizes the training sessions per their max level ),1,2 or 3 with 0 being no level. The query would return Tutor ID and the max level number and the summarized sessions for that level. I would create a second query that would summarize the face-to-face hours for a...

Output to Rich Text, word will open that. Or HTML and allow them to use their browser to open it. A csv file Excel will open. OR google and download a free PDF creator and print to the PDF printer creating a PDF file of your report. My best suggestions.

You can actually put the dlookup (prefixed with an equal sign) in the default value of the field on the form. =DLOOKUP("Penalty Value","Penalties","'Penalty = 'Non-Compliant Docs'")

I like the 360, coming from PS (both ps and ps2). But there are two things I don't like, lack of games I like such as norrath/balders gate and platformers and the fact that the current games are pretty short (result of good video on a dvd sized disk maybe). I like shooters also, so Halo, Gears...

yup, on mens health no less.........

Well I would write a function in VBA you basically would some ID (tutors ID?) and it would return the level number. The function would go rollup the data for you, say via an ADO recordset and a query. Usually the fastest way. You can call the functions from your eports base query, or the report...

You need to go into SQL mode in your query the combobox is based off and replace your order by with what he had. Basically it looks for the "-" and takes the stuff after it as numbers and sorts it numerically.

Do you want an actual report image, or something like a CSV file? For a CSV file use your base query and transfertext macro command to create the file. If a report image, try the outputto command and see if that will work for you.

The add record button usually means bring up a blank form for data input. Typically when you move off the record, close the form, etc. it then saves the data.

If you have the report date associated, why not display that so they know if the report they are keying off of is already entered? I would assume it would be the same report date, no?

As long as the EndreAlle form is open and has a control named Sendt Try this first: A = DSum("AntalAvMasternr", "Query2") And this one you are you saying the column name and the table name are the same? B = DLookup("[Mottaker]", "Mottaker", "MottakerID = " & Forms!EndreAlle!Sendt)

i would guess either your query has a parameter value required (something like [Enter value] in the criteria OR the criteria is looking for a value that it can't find (mispelling, bad reference). Check the criteria of your base query and see what it is looking for.

Yes it is. I would guess the after update even on the form would be where you would use some VBA code to do what you are asking.

Double click the link in designer, and change the join to match all from main table, and those that match from the notes table.

Need more information. Is the report information entered, kept as history, or is the same record updated with the new information each time (over written)? Is there some identifier on each report that makes that report unique?

Write different queries, run them from VBA or a macro.