Recent content by dunkingman

I wish, but it is the company's db and they wouldn't want anyone outside the company to view the data in it. Tomorrow is my last day working here, but I just wanted to solve this problem before I left. Thanks for offerring to help.

The Access Search Prompt comes up, and it defaults (usually) to searching the current field in the form; however, the search simply doesn't work. It says "Finished Search" but it doesn't really even perform a search. Thanks Keagan, and I understand this is a really vague question, but I simply...

I had form with a search button that initially worked; however, after I added some needed controls to the form (two which autofill with the current date in different formats), the search button doesn't work. Does anyone have any guess as to why the search button stopped working. Thanks

Doug, first off, no more need to help me as I (actually you) figured it out. I just thought that since the ".ControlType" didn't appear in the properties dropdown list, that I couldn't use it, but obviously that's wrong. I can't believe you actually took the time to keep replying to my...

Thanks Doug, I doubt this will help, but . . . 1. Everything works until it reaches the first check box. At this point is where I get the error message. It actually tranfers the check into the invisible check box, but the original check box stays checked. 2. I changed the name of the second...

Doug, I am getting an error message with the folowing code (Formerclient is the checkbox name): ********************************************* Private Sub Formerclient_Click() Dim ctl As Control If Formerclient Then For Each ctl In Controls If ctl.Tag = "ChangeOver" Then...

I have 14 text boxes and 2 check boxes, not including the check box to clear the form. Sorry that I'm such a layman with this subject. Thanks again for your help.

Doug, I have one last question, which is regarding the expression that transfers the code to the hiden textbox/checkbox: I have a question regarding the following code you gave me: ******************************************* If Not isnull(me!TextBox)Then me!NewTextBoxThatIsnotvisible =...

D-Fresh, a few more questions: In the column count property of the combo box, it stated "1", so I changed it to "2." The bound column stated "1" and I didn't change it. Also, I changed the column widths that initially weren't displayed to 4;0. In the AfterUpdate Event of the combo box I...

I am going to make the changes I've made to a database live tomorrow, so this might be the last question(s) I ever ask: 1. If something is selected in a combo box, how do I get a text box to autofill based on the selection? 2. I have a check box that, when checked, clears the contents in...

I have a text box on a form. In this text box the user types in the abbreviated names of clients. In the BeforeUpdate Event, I put a prompt to ask them if they are sure if they want to update this record, and while it works if they click Yes, I need for the following to happen: If the user...

In a text box on a form, users enter how many billable minutes there are. The company I work for only bills the clients in 15 minute intervals (e.g. if the job takes 8 minutes, the clients are stilled billed for 15 minutes, if the job takes 16 minutes the clients are billed for 30 minutes...

This will be my last question for a while (I've said that before, but I'm serious this time): I queried a value into a locked combo box, but the value only displays in the drop down list of the combo box. Is there a way (without unlocking the combo box) to display the queried value in the...

Thanks for the help llkhoutx, but I couldn't get it to work. It might be better if I could find a way to turn a text box into a combo box using code. I know how to query data into a combo box, but do you know how to or if it is possible to change a text box to a combo box using code? Thanks again

To auto-populate a combo box based on some other criteria, I know to use a query in row source, but how do I auto-populate a text box based on some other criteria (e.g. what is selected in an existing combo box)? Thanks [This message has been edited by dunkingman (edited 07-05-2001).] [This...