Search results

What I was intending was for the information to show within a report. That way my users can print or view the report from their screens. I just don’t know how to make the color dots associated with a particular job status?

I am using Access 2007 – I am trying to determine a way that I can visually indicate the status on projects we are managing. I need to know if I can create a report that will show dots to indicate complete or non-completed project. However, I would also like to have does dots indicate...

I am using MS Access 2003: I am attempting to create a report – this report will display my company expenses. Therefore, I am attempting to keep it in the same format. However, I am having difficulties creating two detail areas within the body of the report. On the top half of the page, I...

Is there another method I can use to get the same end result? Is there another method I can use to get the same end result? I simply want a field that I can have multiple entries – which I was attempting to make with a subform for Specialty within my Doctor database. However, I am not getting...

My form / subform is still not working My form / subform is still not working. However, when I created the third table (tblDoctorSpecialty) – I was not able to create each of the fields. I managed to create: tblDoctorSpecialty (Table) SpecialtyID (autonumber primary Key) DoctorID (foreign...

I am having trouble establishing a subform connection (relationship) to a main form. I am using Access 2003. I am creating a medical record database where I already have one form / subform relationship established that works. However, I created another form where I want to indicate the...

I am using Access 2003. I am creating a subform [Billing]! that is intended for collecting billing information. I have the [Start] and [Stop] times for appointments calculated to provide the amount of [minutes]. I than need these minutes converted to billable units. [Stop] – [Start] =...

I am looking at creating an in-house contact manager program. It would be very basic and carry only information that pertains to our line of work. The issue I have is how do I create security? I will have three to four salesmen inputting their own leads for record keeping. I want to create...

Is there a simple way to group data from different fields (still using the same table)? Should I go back and restructure my table? I attempted the Grouping function - and its not working very well. One issue, is that I have too much empty space on my report.

Let me attempt to simplify my question even more. I thing I am not using the correct terms. What I have is a form that looks like: Qty Product Price Serial # 1 AA 102 Product $1,234.34 4374-1 4 DD 123 Product $1,133.22 5612-1 3 AM/FM Radio $0 In my...

I do not understand the "hierarchy" you mentioned or the grouping (which I beleive I can only use in a report). I was looking for the answer in a query. But, are you saying that I can combine field directly in a report? You you be able to simplify your answer? Thanks again

I am trying to create a report that will display all products sold for the month. My Issue is that form uses fields listing; Product-1,Product-2..etc - as they appear in the table. How do create a query that will combine the field Product-1,Product-2 under the a field that list just "Products".

Anauz, I just wanted to add my name to the users who would like a copy of your code. Regarding the auto fit to screen forms. Thanks, Leo admin@hufcorairwall.com