Search results

Figure out first error. Now I'm getting a Run Time 3265 error Item not found in this collection....

Hey Les, I tried this today and message around for a while but kept getting this compile error. When you say "(You may actually want to have this in another subroutine in case you don't want to close the form every time after you're done.)" do i put the: me!textbox13 = rs!make In a: Sub...

Thanks I will give this a try

---- Im a little confused... Could you help me with some sample code?

I will give this a try on Monday. I'm sure I'll have some questions.... Thanks for your help!

OK so here's this situation: I have a Inventory DB and i want to integrate scanning. So far i have a table called StockInfo, this table holds information about bar codes (device type, make, model). I have a form called Scan_Barcode, on this form I want to be able to scan a bar code into a text...

I have scanner (Unitech MS335-1G) and my end goal is to scan a product number bar code on a box into a field on a form. Then from what is scanned into the box run a query on another table that has all the info on the product. Then populate other fields on the form. Is this possible? I'm very new...

Unfortunately, i cant post the DB as it has sensitive data. The location table is the kind of the site table. It holds all the individual site information. I have a column called site in each table, location and PC inventory.

Scenario: I have 2 tables, one called Location and the other called PC Inventory. They both have columns called sites. The query is set to search both tables by site name and return the PC's at that site that match the search criteria. The search form has a drop down menu with all the site...

So i have this code from a co-worker that i need help with. First i will start by telling you a little about the DB. It is a Inventory DB. I have it split with a BE and FE residing on a network share and copy of the FE stored on the users My Documents. There is smaller Database called Update...

or maybe im missing something.. sorry

i think your misunderstanding my set up.. I have a form with a subform on it. i have a query setup. At the bottom on that query, in the criteria section, i have have set up a filter. The values are entered on the main form from a combo box and then the results are displayed in the subform. I...

Got it working by using me!subform.requery and setting a criteria in the query to use the values from the combo box.

I have a form that is set to display the results of a query into a subform... How can I get those results to a printer using a button. I don't need it to print the form just all the results that are in the subform.:banghead:

I got it working guys by setting the the critera in my queary to filter using the values entered and also using me!.subform.requery in the vba code. Thanks everybody

I think how i am creating my sub form is wrong What should i be choosing when it ask for tables and quires and i have select what field i want on my sub form

My Main Form is called Location_SRCH and the sub form is lcsub2

Option Compare Database Private Sub Command12_Click() End Sub Private Sub Detail_Click() End Sub Private Sub lcsub_AfterUpdate() End Sub Private Sub Search_Click() End Sub

So where do i do that? and would it look like this? Me !LCsub2.Location_SRCH.recordsource = SELECT .... ??? im confused. My form is called Location_SRCH and the sub form on that form is LCsub2. why do i need my table name or do i? or do i need to just copy what you have above and put my form...

So i have a combo box that has a criteria set for the query. I have a search button that runs the query that users click. What i need to happened is i want the results displayed in the sub form the when query is ran.