Search results

I would like to make a Word product catalog from product data stored in an Access 2007 database. How do I make the connection with the text data and how do I make the images display in the word document with the attribute right aligned and anchored with the text paragraph (how to set the Word...

Case closed! I put the function in the forms module (of course): That solved it! Wonder why... Thanks!!! :)

Thanks for the help! The typo is not in the database it just above (didn't copy and paste the code). As I said the =[Forms]![Customer Form]![ID]; worked fine in a textbox and its exactly the same in the Listbox. Do I have to call the sub from somewhere or does it autorun when put in the...

Just a typo! What is "requery the combobox" ?

How do I make a listbox on a form to list all recommended customers? The form, named "Customer Form", is based on a simple table named "Customers" with the fields ID,Name,Recommended_by. The field "Recommended_by" has the datatype Long Integer and just stores another custromers ID number. On...

Thanks! Now it works all the way... Case closed!

Thanks for all help so far. I think I'm almost there! I have succeded in changing the categoriID column to a combobox, and I can also make the combobox to display the CategoryName by inserting a SQL statement in the Rowsource. But It now it is trying to store the CategoryName text instead of the...

Well this isn't really my cup of tea... Can I change the "subform-table" to a continious form with a click, or should I delete the subform table and insert a new subform? In the last case, how do I make that subform continious?

How do I change the Category field to a combobox if the subform is a basic table?

I have three tables: 1. PRODUCTS ProductID ProductName 2. PRODUCT_CATEGORY Product_CategoryID ProductID CategoryID 3. CATEGORIES CategoryID CategoryName I want to make a Form where I can edit one product at the time and on that form have a subform where I can add categories to that...

Well first I do the lookup on the CategoryID field at the junctiontable (Products_Categories_Spec). Then, when clicking the "+" sign at the left side on each post in the Products table the Categories ar opened in a sub table and I can add as many categories I like. So far so good. While still...

Yes I tryed making a temporarily lookup and then the form wizard, and it worked AS LONG AS THE LOOKUP REMAINED. When I removed it from the Product table it wes no longer in the form. By the way, the form wizard just put the Categories table in the subform and didnt do any combo box at all.

What text boxes? When I open the Products table and click make form, the Products_Categories_Spec table is inserted in a child form as a table with ID numers.

In Access 2007 I have a Many-To-Many relation set up between Products and Categories (with a Products_Categories_Spec junctiontable between), so one product can have many categories and one category can belong to many products. I'd like to make a Form where I can easily set the categories for...

Data normalization? Thanks for the observation, but I don't really think that is the question here. The problem is that I have "productcategories" on the "many"-side of a one-to-many relationship (actually there's a junction table between the products- and categories table that makes it...

Another way? I was afraid of going into the VB code. But isn't it possible to solve this way? From this table: ProductName / ProductSort juice / cool juice / tropical juice / natural cola / cool cola / artificial To a new table: ProductName / ProductSort1 / ProductSort2 / ProductSort3 /...

I have an Access 2007 table with two fields, ProductName and ProductSort: ProductName / ProductSort juice / cool juice / tropical juice / natural cola / cool cola / artificial And I want it to become like this: ProductSum juice, cool, tropical, natural cola, cool, artificial ..etc In other...