Search results

In that case you may wish to investigate the DLOOKUP () function (see Access HELP). As long as your database is not overly large (many thousands of records) the DLOOKUP is ok to use. Another alternative not knowing exactly how your data is layed-out might be to use a multi-table query as the...

I didn't know that. Live and learn something everyday. Always was taught to use VBA. How simple -- your idea. Thanks. jt

If the Combo Box is based on the Orders table, do you have multiple fields showing when the drop-down opens. If so, on the After Update property of the ComboBox, use this type of VBA code... [OwnerName].Value = [Owner].Column(0) where OwnerName is one of the fields you want filled-in, Owner...

Yes. On the After Update property of the ComboBox this is an example of code you will need... [CategoryID].Value = [CategoryName].Column(1) [CategoryDesc].Value = [CategoryName].Column(2) The numbering pattern starts at 0 'zero' for the first column shown when the drop-down is open, then 1...

Don't know if this will help you, but have had success with it a while back for similar circumstances. Align the Title control just slightly above (horizontally) the Text Box (field printing). HTH jt

I won't claim to be an expert in SQL, but according to my experience an SQL statement can have a lot of different sections. According to Access Help, "A string expression that's a valid SQL WHERE clause without the word WHERE." Is it possible you attempting to provide more than what Access...

If I'm catching what you need, you would want to utilize the TOTALS capability of a query to summarize your data. You would proabably want a Group by field and the Count(s) on appropriate field(s). If done successfully, this query can probably be the source for yur graph. HTH jt

Let me see if I can give you some info about your situation. First it is a mis-conception among many new users of Access that selecting a value from a drop-down, with say 3 columns, will 'automatically' fill the other two fields on their screen from the remaining 'other' fields in the...

For your button, go to it's properties, click on the CLICK or DOUBLE-DLICK event, whichever you want (we always use Double-Click so it doesn't get hit accidentally), then the VBA code line is what you say here DoCmd.Quit . That should do it. Good luck. jt

When set to YES, the record selector 'bar' shows down the left edge of the form and usually has the black triangle representing 'Record Pointer'. This is generally used such that if you click on it, it selects that record you're viewing, then if you hit Delete for an example it will proceed to...

In Access 2002 - When displaying a form, a HELP box appears on right side of the screen level with the menu bar ("Type a question for Help"). Have used a custom menu built in a macro. Have Main Menus and Toolbars shut-off in STARTUP, yet this little monster keeps appearing. Can't find anything...

See previous response in your other similar thread concerning sum. To count... In a query use the field tat has the numbers, click on the Totals button (looks like a funny 'e') on the toolbar in the query design window, then in the grid row Totals, select Count, set your criteria to >4 and the...

Although you placed this question in the Reports area, my recommendation would be to do a summation query to get the result you want. If you need this answer on a report, then create a subreport on your main report to show the query's results. In a query use the field tat has the numbers...

Can you programmatically set the margins and page orientation of an Access 97 report ? For some reason one of our reports insists on changing it's pre-defined items when it needs to be printed. Only occurs once in a while. So for consistency we would like to be able to 'tell it what to do'...

We've been looking at two products which allow selection to print PDF files from an Access Report when printing. What we would like to know has anybody used either of these products and most importantly can either (or another) be programmed using a macro or VB code to bypass the SAVE AS window...

Thanks Mile-O-Phile, your idea worked great. JT

Does anyone have the code for marking a field like "Date Updated" with today's date ONLY IF DATA HAS CHANGED on that record's input via a form ? Any suggestions greatly appreciated. Access 97 version. Thanks. JT

You can also use two actions in a macro... RunCommand with Command argument = Select Record Printout with Print Range argument = Selection HTH JT

Rich Actually each user has s separate copy of the databases on their C: drives during class. The databases are all clean, compiled copies which we start with. And by the way two of the 8 PC's don't have the "Coummincating with the OLE server" error occurring. Don't you just love...

Rich Just reviewed the thread you pointed me to. I understand that thread I've seen that problem in A2K. But it's NOT the problem I've described here which is in Access 97 and the databases have NO module code whatsoever. Any other ideas ? JT