Search results

Thanks Mario... that was exactly it. Also a note for anyone who might reference this. When I first tried your solution I put "" " and just adding that space between the "s makes it not work. They must be 3 consecutive parentheses: """ & test & """ Thanks again!

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

Could you please explain how that would work, given my situation. I do not know nearly enough about Access to take that answer and run with it. Thanks.

Thank you, that was what I needed but it also brought me straight up to my next road block. How do I move through each record in the table and record its value? Is there an easy way to do this? I am thinking explaining my overall goal may clarify this. I have one table (CriteriaTable) that...

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

In case anyone was wondering what my error was: I needed to add a Like in there because i was searching for a partial string... Category: Switch([NAME] Like "*MIKE*","NA")

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

I have table called Companies with accompanying company id #. 1 Company C 2 Company X etc. The value that I store throughout the db is the number. I now am trying to write code that takes selected company and opens its related spreadsheet. The path name always begins: C:/Files/Spreadsheets/...

Yes, I check to make sure it existed. Often times that sort of thing is my problem, but this case, path should be correct. I found help on this and it said to use double quotes.. which I have so now I really do not know what to do!

I have following code: DoCmd.OutputTo acOutputTable, "Exchange", acFormatXLS, "C:\Document Set\desktop\Original.xlt", False How do I change syntax to handle spaces? Double quotes? Error occurs when code reaches the space between word Document and Set. Thanks as always, Marco

I created a query using SQL on a OnClick event. Query is displayed in datasheet view. I would like for each time query runs, the column widths be auto sized. Data in a few columns will vary in length each time. Is this possible? I looked at columnwidths property etc., with no luck. Hoping...

Thank you. It so simple, but must skipped right over it in help screens. Marco

I put some code into NotInList event of a combo box. Code works well, shows up when it should etc. Only problem is that after my message box appears and is cleared, default system message still appears too. How get rid of the default. Code I wrote below: Private Sub...

I have looked and looked but can not find source of "Syntax Error (comma) in query expression..." See something I am missing, or more likely, I don't know!? strSQL = "SELECT (Company, Description, Net_Weight, " & _ "Gross_Weight, Shelf_Life, Tariff_Fraction ) " & _...

Can I change message appears when someone enters something in a combo box that isn't the list... right now says just "The Text You Entered...". How do I customize? Thanks as always! Marco

I have a form (Form1) with combo box (cbo1). I have global variable (cbo_var) that stores the value. A command button on Form1, opens a new form (Form2). I want the combo box(cbo2) on Form2 to have automatically selected cbo_Var from Form1. How do I do this? I know the combo boxes have...

Perfecto! I now just add a button that says "Change company" to unlock it. Originally I did not want it to lock just on afterUpdate, in case they make an error. But it so simple to add an "unlock", that I will. Thank you very much!

Yes, thank you. I see lock property. But what event signal that the current record is no longer the first one? I want it locked for records 2 and higher, but updateable for the first record of the order. Sorry if very simple!