Search results

Ok, I think I might be close....I took out the Query name and only used the table name. The results are close, if I type a number in the text box and hit the enter key and then click my image(button) it works. But, if I don't hit enter after keying in the number (in the text box) it does not...

Yes, if I look at the query in design mode, the table is in it..... Thanks David

Well, I have checked and double checked and can seem to get this working right. If I open the form and type a number in my Text field and hit enter, then run the query directly from the query, it works. But, If just use the form it brings up a blank report with no records? Here is my code I am...

Thanks for the info, but I have a question? The code you sent, is that behind the button or Field? I tried it behind the button and it pops up a box to enter the search string. Really want it to do a straight search no pop ups. Thanks Again David

I know this can't be that hard, but I am slammed for time and need to find a quick way to do it. I have a simple form, that has an image(button)and a text box, that's it. I would like to be able to enter text in the box and onClick of the image (button) it searches my database for that value...

I have built a simple form that runs a query against an Oracle Database. It works very good, but I would like to take it a step further by adding it to my web server. How can I present this form to a user in a Browser? Thanks David

I am trying to run a query against my database that will average the date/time fields. I have two fields, one is an open date/time and the other is a closed date/time. I would like to be able to select a date range and average the open closed time. In other words, I want to see all tickets for...

Hey Matthew- My sub forms are not embedded in my main form, I have buttons on the main form to access the sub forms. I added the following behind the save button on the main form to gotfocus : If IsNull(PRO_HSTA) Then PRO_HSTA = Forms![frm_HOTSHOTS_WORKSHEET]![PRO_HSTA] Else End If...

I have three forms, HOTSHOTS_WORKSHEET, HOTSHOTS_ADDENDUM and INVOICE, I have the HOTSHOTS_WORKSHEET Form setup to generate a unique number in the field called PRO_HSTA. I would like to pass that number and open the subforms when I save the original record. I am using Access XP, also, I am new...

I have three forms and the first one generates a unique number, I would like that number to be passed to other forms. The main form generates the number and I have two other buttons on the form to access the other forms. When I click on the button for the other forms, I would like to pass the...