Search results

I have a text box on a form whose after update event is taking the value that was entered into the field and sending it to a query. If i perform this manually, meaning run the query in the after update it works just fine. But I want to learn how to do is set a Recordset equal to it. So what I...

Wondering if there is an easy way to do this: I have a combo box that is populated by a TableA with Product #'s. I also have another TableB that holds "miscellaneous items" and their Product #'s. I would like a combo box to show both sets of records in its list but I don't want to combine the...

I'm sure simple solution here: I have a form that runs on DB start-up. But now, more often than not, when it loads in form view the properties box also pops up for one of the control boxes on the form? Did I accidentally turn this option on? So basically a user will open the database and be...

Dim fmName as string Dim InUseVar as string fmName = "Test1" InUseVar = DLookup("[In_Use]", "All_Forms", "[Form_Name] = ' " & fmName & " ' ") Basically, I just want to take the value of the field In_Use found in table All_Forms and set InUseVar equal to it, when the field Form_Name =...

I have a control button that opens FormA. On the "OnClick" event I want to : 1. Check the value of a variable named YesOpen in a table called FormOpen. 2. If YesOpen = 0 then, open FormA and then write to the table FormOpen to change the value of the Variable YesOpen to 1. Else if...

I have a multi-user database which is used by 2 people over our network. Occasionally, the 2 users will access the same form(there are dozens). Because most of the forms OnOpen event clears the underlying table, I don't want a second user to be able to open it. I tried record locking, but...

I am running into a curious situation... I have text boxes in a report footer. They are summing the values in columns in the main report. However, if the column happens to contain all zeroes, the summing does not show a zero, it shows nothing. How can I get to see the zero in the summed text...

I have the following in an AfterUpdate event of a combo box: Shelf = DLookup("[Shelf_Life]", "Shelf_Life_Tbl", ("[Stock_Number] = " & Me![stock].Column(0) & " And [Company] = " & Me![Shelf_Company].Column(0))) Basically I want to look up the shelf life in another table based on the values...

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...

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...

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...

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...

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...

The following code runs without errors but also does not update the table correctly. If I take the values of the 3 variables below and plug them into the SQl, it works correctly and makes the updates. How do you reference variable? I went through Access Help but could not find my mistake...

Hi, I have a question regarding an update query. I have a column called Segment that is blank for 10,000 records in table A. Table A also has a column called Prod Type. I am trying to write an update query that searches for some criteria in the Prod Type and then assigns a value to the...

I found many posts close to what I need but not quite. I have a column in a table with about 10,000 records. The field holds product descriptions that can have anywhere from 1 to 25 words in them. By default, when I import the list, everything comes in CAPS. Example: WIDGET FROM MEXICO I...

I have a linked table (Main_Tbl) with 20 or so fields and 1000's of records. Product_# is the primary key. I also have a separate table that keeps a list of Product #'s that should have their descriptions note that they are in Spanish. Product_# is also the primary key in that table...

I am trying to use a Make Table Query. Its based on table 1. It takes 3 fields from table 1. Now I want to create a 4th field that is based on one of the first three. Field1 is ID, Field2 is Name, and Field3 is Height. I want to create a field4 called Category. Category should = NA if Name...