Search results

That first one was very easy for me to follow... thanks! 2) I am running AccessXP on WindowsXp. Thanks again, this is already much help. Marco

If you could be so kind, could you give me a really brief example of both. My dataset currently is not large but may grow to be. So I figure learning both would be best. I really appreciate it! Thanks Marco

I have the following code on the OnClick of a button on a form: strSQL = "SELECT Shelf_Life_Tbl.Shelf_Life " & _ "FROM Shelf_Life_Tbl " & _ "WHERE (((Shelf_Life_Tbl.Stock_Number)=2544) AND ((Shelf_Life_Tbl.Company)="Company1")) " docmd.runSQL strSQL How do I store the value returned by this...

Forgot one part: Under ComboBox1's AfterUpdate event enter code that says something like: Me.TextField1 = Me![ComboBox1].Column(0) Me.TextField2 = Me![ComboBox1].Column(1) Me.TextField3 = Me![ComboBox1].Column(2) Substituting TextField# with whatever you named them and the...

In case you choose this method here's how I do it: ComboBox1 with fields Cust, Dest, Route. Add three text fields. Under properties<>Data, set each one's control source to Cust, Dest, and Route respectively. Now go under the Format tab and change their Enabled property to False and their...

I don't think there is a way to actually display multiple columns once you have chosen a value... atleast not that I have ever found. What I do in the case that I want a user to see more of the columns is I put locked and not enabled text boxes that are controlled by the various columns in...

Very simple question here! I have added some code under the NotInList event of a combo box. It works fine and the message appears as needed, but after clicking 'OK' to my custom message box, I still receive the default Not in list message box from Access. How do I stop it from popping up and...

I am having major brain failure here... I have a form whose record source is table1 and contains about 25 fields. If a user edits the value of a certain field (field1) they are given the option of saving this new value separately. If they want to save it, then the value, along with a second...

That was it... You were right that DAO didn't matter and also I was combining the syntax incorrectly. Thanks again!!

Jay, You were right.. I was looking at the wrong set of properties! But, looking at your original solution, I don't see where the sub form name comes into play? You had : set rst = Me![SubformFieldName].Form.RecordsetClone So I coded: set rst = Me![Formula_Number].Form.RecordsetClone...

I keep receiving a type mismatch error using the following code: Dim rst As dao.Recordset Set rst = Me![Formula_Number].Form.RecordsetClone Do Until rst.EOF stAppName = rst!appname Call Shell(stAppName...

I have a form where a user can select anywhere from 1 to 20 "products" (1 at a time). Once they select a product from the combo box and click the "add product" button, the item is added to a sub form that acts kind of like a shopping cart. One of the options then becomes for them to View the...

If the form does not have an underlying record source, it will NOT give you the third option to Find a record(as you mentioned). Once you select the record source for the form, the combo box wizard will provide the 3rd option because now has something to search through. Hope that helps, marco

OK, then what you want to do is: 1. Make the record source of the "search form" be whatever table the "entry form" stores your records in. 2. Add all the fields to the form that you eventually want to view of the "found record". 3. To make this really easy with minimal code, make sure the...

Could you give a little more information about this? Are you trying to search through a form that is also where you enter new records? Or are you creating a whole seperate form that is only used for searching? Either way can be done, but it changes how to approach it just a little bit.

I have a form called "Main Form" and a subform within it. The main form lets people choose a product from a combo box and then hit a control button called "Add Product" which places their selection in the underlying "Selected_Tbl". It then moves to a new record, making all fields look empty...

I am trying to close the current access database at the end of some code that is run off of a control button. I found some help on the "CloseCurrentDatabase" method but am having a hard time implementing it. Here is what I have as given in the help screen: Dim appAccess as Access.Application...

Doc Man, Thanks for the reply. The reason I posted here was that, in the past, I have used the Call(Shell, ...) method of VBA to succesfully open the same worksheets. Recently, some of our users have upgraded to XP while others are still on 97. Using the Shell method requires stating the...

Using the code from a previous post I was able to open an excel spreadsheet through VB on a control button. However, when the spreadsheet opens, it's external data ranges (which use Microsoft Query to get data from the DB) do not refresh. Their properties are set to refresh on file open and...

Sorry for long delay... your suggestion worked just as hoped. I had to modify something slightly but it was because of a requirement change. The code itself worked. Thanks as always. Marco