Search results

I have user form where products for an order are entered. 1 record per product entered. The first field is a combo box where a company is chosen. Then a combo box for the product. After the first product is entered, I would like for the company combo box to not be editable. Other words, once...

I created an append query, viewed its SQL code, copied it and pasted into the OnClick event of a form button. Here is what I pasted: INSERT INTO Total_List ( [Company#], Company_Name) SELECT Selected.SlctCompany, Selected.Slct_Company2 FROM Selected; I keep receiving a syntax error in code...

That worked perfect. Thank you again. Can this technique be used on any event in a form? It seems very powerful concept.

Is there way to customize error messages? I would like to have my own text be displayed when a user tries to enter duplicate value for an indexed field. Its run time error 3022. I found previous posts on this topic BUT, my duplicate is on a composite key, two primary keys, so I am unsure how...

I have a form where I choose a company and then choose a product #. Each of these is a combo box. I am storing my choices in a table called "Selected". I want to make sure that the same Product-Company combination is not allowed to be entered. I know how to not allow duplicates for one...

I created a database level module (module1) with 2 functions in it called Open1 and Close1. I have found documentation on using: docmd.openmodule "module1", "Open1" How can I actually run the function rather than just opening it? I am trying to put this in on OnClick event on a command...

I am still a new user so please no laughs... I have Form1 where I can view product information. The form has its recordsource as Query1 which takes values form Products table. In addition to product info, each product also has associated costs (also in Products table). I want to create a...

I am a new user so please bare with me. I have form with a subform as a datasheet. One of the columns in the subform is combo box of Item #'s. Another column is combo box of Product #'s. The reason I have it like this is that one time I may only know the item # and another only the product...

I have a form (form1) whose record source is Table1. I have another form (form2) whose record source also is Table1. One of the buttons on the form closes form1 and then opens form2. I keep receiving the error that Table1 is in use by another user or by the interface. Why is this happenning...

I am running a Find Duplicates Query when a button is selected on a form. Is there a way, in Vb or otherwise, to check if the query returned any results. In other words, the user clicks a button, the query runs in the background and IF it returns no duplicate values one thing should happen...

I will try to explain this clearly because sometimes it confuses even me: I have a company table that has two columns, CoID(pk) and Company Name. On MainForm I have a combo box where a user will select a company. I make the Company name what is visible and what a user selects, but the...

Perfect, thank you very much. I am about to post a new question too!

I am probably not being clear at all and apologize! ... I will start from the beginning. I have a table with Product Information, a table with Company list and a table called 'Selected' that holds the records created on the form. Selected, I am guessing, is where I need to set up the foreign...

I am a beginner with this so bare with me, but in the northwind db their joined tables assume you know all the suppliers for each product. In other words, they know ahead of time that Product X has suppliers a, b and c. In my situation, I have a table with 1000 products, and a seperate table...

I have a form where a user first selects a company from a combo box, and then selects a product from a seperate combo box. I would like to prevent duplicates of the same company/product combo. Of course, a company could have multiple products, or a product bought by multiple companies so I can...

I know this is a simple question, but I am new to this so please bare patience. I have a main form where users select a company from a combo box and then fill in the product they purchased, quantity, price, etc. I want another combo box at the top of the form that would allow the user to...