Recent content by rookie_user1

I plan to be able to view them and make a report out of them, That was the edit screen i will send u a print screen of my database if you like ?

The project is for products and there shades, its used to enter in the information for products and there shade details The user will enter in the product name and brand. s/he will then enter in the shade details for that product , a product can have more than one shade, but will only show...

ok i have 2 tables one for product and one for shades, as there can be many shades for one product and many products canhave different shades its a many to many relationship so i have to use a junction table called prod_shade on my form i have 2 text boxes the form control source is a query...

the SQL is based on the 3 tables that make up the relationship , SELECT Products.Product_Name, Shade.Shade FROM Shade INNER JOIN (Products INNER JOIN Product_Shades ON Products.Product_id = Product_Shades.Product_id) ON Shade.Shade_id = Product_Shades.Shade_id; tblProducts ProductLineID PK...

Yes i have tried this and it won't work i think my problem is that my form where i enter in the product name and the shade name is based on a query, so i can bound the 2 text boxes. and then when i put in the sub form it does not update. it just shows the new record i entered in for example...

I need Help i showing information on my form, can't firgure out how to show this information. How would you go about displaying all the shades related to a product on a form. Take in mind that i want to show all the shades for a given product on the screen when am entering in the data on my...

Hi i've a form where i can enter in many of the same product names and where products can have many shades but only one color of a kind can be in the shades list. I need to make sure i can have products that can have the same shade but once the product name is different its ok.. so for example...

Hi i have a access database where i have scheduled it to open at a given time on my pc, but i would like to write a macro to use the onclick function instead of me having to click on the button, Can any one help me with this. ?

Is there a setting that is needed or would each table have to have a autonumber ?

Hi is it possible for multiple users to use the same interface to write to a access database ? i know multiple users can open an access DB but can they use a form to update a table at the same time ?

ok i've my batch file built, but the problem i have now is to get the button pressed, Can i create a macro to press the button within the onclick command. What action would i use in the Macro to do this ?

This sounds better and more of what i think would work for me. What i have is a form with 1 button on it, when pressed it updates excel files by refreshing them, through the pivot table. How would i go about creating the bat file that opens Access and passes the name of a macro as an...

Hi i would like to know if it is possible to schedule a a task in access, at the moment i refresh all my excel report by using a button on a form in access and would like ot know if i can do this automatically

I may have went the long way to get this to work but i did in the end so here is how i did it. I created a table with Date and Time columns and set the default for them to Date() time() to always get the the current date and time from the system. Then i created a update query on that table to...

This works fine for the current date and time but i want to save the date and time when the button is clicked and then retrive it when the form is closed and open again... what the code below gives me is the date and time now (in the on click event procedure of your command button put in the...