Search results

Wayne, Okay the search field is now working (thanks). But please bear with me as I'm new to VB. I do still not understand what I need to do with the txtsearch2. And when I double clicked on a row in the list box it was supposed to take me to that record in the "New NCm Record" and I get a...

Search Form Wayne, When I use the tatsearch2 in the NCM query nothing shows up in the list box and I don't see what your talking about in the code. If I type in the text box I get a complie error an this is where the code open up to (See attachement): Private Sub txtSearch_Change() Dim...

What I'm trying to do is have a search form "F-NCM Search" open up with a list box containing the information the users need to do a search. I wanted to be able to have the record move up and down in ascending and descending order on clicks (partially works) or be able to type in the search...

I've tried modifying some code I found here to make a search form but it’s not working properly. I can't seem to get it right. Can someone look at the code and see what I'm missing? Private Sub Form_Load() On Error GoTo Err_Form_Load Me.Label55.Caption = "ID" & Me.lblDn.Caption...

Antonio, Thank you very much. I see what the issue is now.

Query/Table Join Issue Anyone have any ideas why I can’t join query Q-Down Time Query Query and Q-PCS Packed Query and get what I'm looking for? Q-PCS Packed Query gives me the pieces packed by press and shift code and Q-Down Time Query Query give me the down time by press shift code. I just...

I have issues with a query for my production numbers. I can not modify anything in the tables sense they were developed years ago before me and contain thousands of records. The two tables I need information from have a common field "Shift Code". One table contained records from the machine...

Thanks Bob. I'm already trying to build the form to handle the data input.

I agree but I ran into a problem. I wanted to use my pop up calendar and selection form, but the field "DATE Code" that was set up before me in the table is input directly from a machine as "200710" for the date October, 2007. Even when I tried to change the format in the form it didn't like it.

I hate to be a pain but I do have one more report that’s a chart I can't get the date range to work. The chart is based on a query and I use the Between [Enter Beginning Date] And [Enter Ending Date] in the query. Sense the date is not a stored value how do I get the date range selected on the...

That’s exactly what I did and it worked great, again thanks!!! This site is a life saver for someone who is just learning to use the code and not just the wizards.

Kinger43 & rainman89, Thanks to both of you. Sorry I'm a little slow but I got it now.

Yes, I have a selection form that pops up with a calendar option to select the dates to and from. So by the file name do mean the names of the form?

I did a search and did not find a solution. I have a report that is based on a query and you have to enter Between dates. How do I get the date rage to print on the report? Thanks for your help, Jerry

Thanks Craig

Craig, The code you gave me is working fine (thank you!). The only question I have now is the reports open up smaller.

Yes in my query I'm using Between [Forms]![F-Date Selector NCM Chart].[txtDateFrom] And [Forms]![F-Date Selector NCM Chart].[txtDateTo]. When I close the date selection form it minimizes my report as well. I fooling around with the code but I'm not getting any where. I'm a newbie as I'm sure...

Where in the code do I place it? I tried and I get an error.

I have a form that opens up and asked you to select the dates you want to run a report for. After that I run the code below in my command button, but the form stays open on top of the report. How can I get my date select form to close after the report opens up? Private Sub cmdCalFrom_Click()...

Thanks! Lisa, Thank you for your help this worked.