Search results

Thanks for your comments gents. I guess I'm still thinking too much IN the box.

Hi Ian Very interesting stuff. (At least for where I am at now.) - Thanks. It certainly does answer SOME questions. What I haven't found an answer to yet (Unless I have mis-read something or not read the relevant piece yet) is... If I have 2 (or more events) as follows. After Update Do X,Y...

In what order, are events processed ? I have an event on a field that must check the following. 1. Is there data in the field (I have placed this in the "Lost Focus" event) 2. If there is data, then generate an account code. (This has been placed in the "After_Update" event. 3. I also want to...

Thanks - will give it a go.

Hi All I have a database that records the Maintenance & Repair costs for vehicles, per Department. I have got the report to give me the usual summary details as follows. Department 1 Vehicle Name1 Repair Item 1 Cost1 Labour1 Repair Item 2 Cost2 Labour2 Total...

Not in List I have a form that is based on a single table. On this form I have 2 combo boxes where the recordsource = CollegeCode (A field in the table) Combo36 is set to Limit to list = Yes Visible = Yes Tab Order = 0 (First field on the form) CollegeCode is set to Limit to list = No...

Hi Matt The answer your question lies in the SAMPLES that ships with access. If my memory serves me correctly, it should be at "C:\Programs\Microsoft Office\Samples" The same sample of what you are wanting to do is in the NORTHWIND database.) If the user is adding a new product, but the...

I am constructing a database that keeps a records of the hours worked as well as the repair & maintenance costs for forklift vehicles in the company. The idea being that at the end of each month the system generates a report that will identify the running cost per hour for each vehicle. I am...

I have a form which shows all the details about a college. Each college has a code (string) to identify it. This code is displayed in a combo box that is limited to list of valid codes. If the user types in a value that is not in the list, a message asks the user if they want to add the new...

I am an extremely frustrated (And/Or slow) learner who has been trying to learn how to use code in "M.S.Access" (On and off for about a year now) but without much success. I have embarked on what should be a VERY simple "Timesheet" project. Its easy to add and edit records using the Switchboard...

Hi Rochelle It sure is nice to know that I'm not alone. I'm also starting out. I noticed that there was a project called "Add to combo box" dated 12/09/2000 slightly down the page. I has been posted by "liteDesk@aol.com" Perhaps your answer lies in the reply to this question.

I think that Im a bit greener than you are, but what about creating multiple reports ? I.E. Pages 1 & 2 in one report and pages 3 & 4 in another report. ETC, ETC.

In trying to learn how access (And VBA) works, I am writting a "contact management" application whereby users need to make telephonic contact with someone and then record what was discussed. The parent form contains data about the contact. The subform records the "DATE" and the topic of what was...