Recent content by Cdogg

I have a query looking up Yes Or No Check box using LastName, FirstName, ChildsName, Date, and getting the information from 4 textboxes on my form. After I enter the information I would like the checkbox on my form to show yes or no in that record. I ran the query and it works. But I can't get...

Thank you for your help I tried it with no luck xname = [Forms]![Form Name]![Control Name] I take it the Form Name is the name of the report. The Control Name would be the text box with the Name I want it to be saved as. What is Forms Thank You

The field in the table is set for percent 0 places. I have a combo box ( in the combo box its 50.00% )that puts the percent values in into unbound text boxes. instead of being 100% I get 1 or .5 for 50%.I use these boxes for calulations and show. What I don't understand is if I enter .5 in the...

I seem to be having a lot of trouble with unbound text boxes. I have about 40 that I’m doing a lot of calculations in them. Some of them have numbers that are from other tables but don’t need to be saved with the new record. If I bound them the problem goes away. Is there anyway to create...

I want to save the reports to a folder in "My Documents". Can I push the File button and have it save using the LastName from the form or report as the filename so I don't have to go through 2 dialog boxes Private Sub File_Click() On Error GoTo Err_File_Click Dim stDocName As String stDocName...

Can I push the File button and have it save using the LastName from the form as the filename and set rich text without having to go through 2 dialog boxes Private Sub File_Click() On Error GoTo Err_File_Click Dim stDocName As String stDocName = "MyForm" DoCmd.OutputTo acReport...

When I update the record on the form I would like to clear the list box. I can clear every thing but that. Thank you for your help

I have a querry calulating a total. I would like to put the answer into a textbox if it can be done If I can't do that, I could do it with a combo box but I would like to have the first record as default being there is only one record. Thank you for your help

Can I have the first record appear in the combo box instead of being blank Thank you

I have a table the following field names LastName , FirstName , Kids. , Numbers , Date. The LastName and FirstName are one of the adults I ran a Querry to find any body with the LastName and FirstName on a date and to list there kids and there numbers for the day. I would like to show...

I ran a querry using the last name of a family member to get to there first name and there numbers for the day. I would like to see the results on my form. Then I would like to total them and put that number in a textbox I don't know if I can do this. If I put the first name and the numbers...

In my form I have combobox that I enter a Last name and run a querry.The information I get I put into text boxes. I would to run a querry using the using the last name as I lose focus that would total numbers for all the family members and put the numbers into text boxes. Then I want to total...

I figured this one out on my own.I was trying to do to many things when I updated the form. I cleared all the unbound textboxes before form update. It took care of my problem.

After I enter a name into combobox. I ran a querry after update to get different infomation. Is there anyway I can put the results into textboxes. Thank you for your help

I was working on a form when it stopped saving the record. I took off the last thing I did, but it still will not save. It does everything else. I realize it’s hard to know what I screwed up, but are there any common reasons. Also is there a limit to how many things you can do on a form .