Search results

I have a couple of fields in a form which are either calculated fields or get their values from another place(a subform). I need a way to "sense" when the values of these boxes has changed (the user never changes these values) Any idea?

Thanks goergedwilkinson I was in the process of implementing your suggestion when I realized, my PoItems table already has a auto-number primary key, which inevitably increases every time I enter a new line item... so I used it instead of a fimestamp... Same method, just different data type...

I have a form in which I enter information to create a purchase order. The Main form has basic information, like vendor, shipping location, job, po number etc. There is a subform that links to another table which records the items purchased on that one PO. I have a button that when I click...

Again.. need help here. I have a form that generates a report from a table that contains a list of purchase orders. The fields in the table go like this [PO Number] | [DATE] | [Vendor] | [JOB] In my form I have added a textbox and formatted to a short date (1/01/1980). so what I'm looking for...

Definitely!.... I can't believe it flew by me... It works now Thank you very much. Now... while we're on the subject.., how do we make these only take effect if populated?

Thanks for the reply my fellow Houstonian. Unfortunately, that did not work Actually, these are numerical values (the comboboxes are bound to the ID (keys) but only display the text, so does the report. Both combos are setup exactly the same way what gets me is that it works fine when only one...

I'm starting to think this is not the right way of doing this... Can anyone drop in and help?

I'm getting a "Type Mismatch" error when I try to use 2 conditions on the where statement. Can you give me an example? here is the code I'm using now DoCmd.OpenReport stDocName, acViewPreview, , "PoJob = " & Me.cbSrchJob And "PoVendor = " & Me.cbVendrName, acWindowNormal

Is there a limit as to how many AND instances you can have in the statement? And what about wild cards? For example, I want to be able to clear out the VendorControl and have it bypass that option

While developing this database, I wanted to try the splitting thinng... so I split my database into front and backend. But I'm still developing this thing... so Is there a way to put it back to gether? I will need it split, but later on... not now and I dont know how to put it back. Any...

I need to create a report based on a query using multiple criteria. Here is my example I have a table with several records of purchase orders. [PO Number] | [DATE] | [Vendor] | [Job] I can run a searh using the job or vendor fields using the following line DoCmd.OpenReport stDocName...

I'm trying to create a query based off a table. Is it possible to create a calculated field in a query? For instance, the table has fields for QTY and PRICE Can I create a field in the query to multiply these 2 values without adding a field to the table? If so, how is this done?

I'm trying to get the user name value on a form I know you can user Environ("UserName") but that gives me the login name (the name used at the Windows login prompt But instead of that, I want the name displayed on top of the start menu in win XP Anyone know how to get this name?

The form is open. This is how the events are happening I open the FrmPorecords which contains the FrmPoItemsDetails subform. I've setup a doublic-click event on one of the fields in FrmPoItemsDetails to open up this form. So the form is open, but as soon as I double click on the new form to...

Re: Form to search table help please -- Updated I've managed to get the search feature working using a combobox to select the category and a listbox to display the results.. Now the question is... How do I send the selected item back to the form that this originated from? I'ved tried this...

Thanks.. that helps

I want to set up a double-click event for an object and I want it to open another form. I've tried Forms![Name_Of_Form].activate but the debugger keeps saying it can't find the form I'm specifying. Anyone know how this should be done?

I should probabbly add, that I want to be able to take the selected value off that listbox (columd 0) and throw it on to another form

Form to search table help please - updated I've created this form th at has a combobox. This combobox is populated from a table that only has 2 fields, Key and Category. I've also got a listbox right below it. This listbox is to be populated from another table called PartsList with the...

Amazing!.... Thanks a bunch bob