Search results

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

Can you explain a bit more ?

Hi i would like to retain the date and time once i select a button on my form, i have a macro that puts the date and time into a text box but when i closed the form i loose the date and time from the text box, how do i keep the date and time so when i open the form again i see it.

This maybe of some help http://www.databasedev.co.uk/ms-access-switchboard-forms.html

Display results from combo box into a text box Hi here is my query. See below, this give me the results i want to work with. On my form i have a Combo box and a text box. if i select a month from the combo box i want the CountOfOrder to display in the text box, their will only be 12 rows in my...

Can post my db as the size limit won't allow, its only 1.19mb. Here is my query for the combo box. SELECT Distinct Belgium_Yearly_Orders_Count_Detial.Month FROM Belgium_Yearly_Orders_Count_Detial; So this gives me e.g June May April What i want is to select a month from the combo and from...