Recent content by drblackard

Thanks for your comments... No I actually am not an excel user but I guess I can take that as a compliment...I am using the PivotChart to try to force people to come and train on their jobs...a visual aid if you will....show others where you are on your training...it's just a prop....it is...

I am using a combo box to enter Employees names for training hours...I want to use a pivotchart but when i use the training hours table/form the pivotchart gives me the combo box numbers instead of the names. I know there is a formula or something I am suppose to use here or even a query but I...

I am using a combo box to enter Employees names for training hours...I want to use a pivotchart but when i use the training hours table/form the pivotchart gives me the combo box numbers instead of the names. I know there is a formula or something I am suppose to use here or even a query but I...

I have a survey form that contains about 200 questions. It is a training matrix that we use at work. I am trying to automate everything since I have been put over training. I got a medical database from someone here and modified it a little. After entering about 60 questions my form said that it...

I think I got it another way...now can someone help me with the SUM of the training hours in the report for each person...

Thanks Rich ... but I don't have that option or I am not looking in the right place...I selected the report and went to design view...the only sorting that I have is Last Name and First Name to get the groups and it does group them but they are all listed individually...I must be doing something...

Hey! I have searched the forum and I know there is something out there to help me but I can not find it....let me pick someones mind a little...this is probably really simple but I am having problems getting it to work for me....I think I am making it bigger than what it is ..... so here it...

Thanks Bob Larsen. I do understand the function but I can't quite figure out how to use the Dlookup funtion...can't seem to get the information that I need to open/close the form depending on criteria or finding of information entered into table. Sorry i sound so elementary here but this is a...

Hi all! I am looking for some help in how to get a form to open just once on the first launch of the database. This information is the company information of the one using the software. I have a button that one can click if they want to edit or add this information later. Thanks for your help in...

I just like the interface...the windows appearance...I was planning to use this as a login to my database...I like the full screen...then make my database appear with the MSAccess minimize...I was just looking for the login setup, thats all...just a login screen

I downloaded the database sample...is there someway to use this as a login and how would I go about setting up a table for this...Thanks

This is what I did to fix it: I have two list boxes....both containing my list of Standard, Silver, and Gold names and prices....I copied the package box (which contained a list of these plus prices in two columns that I typed in using the form wizard/lookup feature)...pasted it onto the form...

I got it...I used this code and found my spot... Private Sub Form_Open(Cancel As Integer) '''It will allow you to size the form [height & Width] and place the form where you want it. Use the command in the OnOpen event of the form. DoCmd.MoveSize 2500, 1200, 2250, 3500 End Sub...

Disregard...got it!

I have a list box that contains rates (Standard Rates: $350.00; Silver Rates: $450.00; Gold Rates: $500.00)....when I select the rates (Standard, Silver, or Gold) , I want the cost of the rates to show up in the next text box. The text box is a list box and does not refer to a table that I...