Search results

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...

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

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 .

I made a querry to sum each persons total. Then a form to display it by name and sum with Continuous Forms, can I put a textbox in the footer and total the sum LastName Name Sum of totals Total Thank you

I would like to have a querry look up the records for the current year with having to inter the year Thank you for your help

Can I change the way the percent appears in a textbox from 100.00% to 100% Thank you for your help

I’m new at this and the more I get into it the worse it gets. I would like to take 2 columns from a combobox and enter them into 1 textbox in line. Also can I send the contents of a textbox to 2 different tables. Thank you very much for your help.

I have a combobox with 3 columns, column 3 is currency. It shows currency in the combobox when I pull it down. When I send it to a textbox it enters it as text. Properties for the textbox is set for currency. Me!Textbox 1 = Me![Combobox].Column(1) Me!Textbox 2 = Me![Combobox].Column(2) I...

I have a combobox with 3 columns, one is . When I send it to a textbox it enters it as text. Properties for the textbox is set for currency. It is currency in the combobox. Me!Textbox 1 = Me![Combobox].Column(1) Me!Textbox 2 = Me![Combobox].Column(2) Thank you for your help

I have a combobox with 3 columns, one is currency . When I send it to a textbox it enters it as text. Properties for the textbox is set for currency . Me!Combobox = Me![Textbox1].Column(1) Me!Combobox = Me![Textbox2].Column(2) Thank you for your help

Is there any way to add numbers in 5 text boxes without putting a default value in them Thank you for your help

I have text boxes that are unbound that I use for calulating and I want to print them with the record but don't want to save (30 boxes). But when I press the print button it clears the boxes. Is there anything I can do.

I print a record with a command button before I save the record. I have colunns of text boxes that I use to calulate numbers and they are unbound. When I print the form the text boxes return to the defaut values of 0, and print the defaut values Thank You for your help