Search results

Hey ,i have a main form which is called "categories-products", whith 3 childforms "products","Nestle Prices" and "PFD Prices" . "Products" is linked to my main form via [CategoryID]. My other 2 subforms are linked "products" via [productid] and products.form![ProductID] . When u move threw the...

Thanx pbaldy,so simple but yet so difficult if u dont know

Hey I have 2 Product tables which are the same in structure and I would like to get all the products from them. Which type of querie would I run. The reason I have 2 Products tables is that the one Product table is Nestle products.The price lists for these products is based on a system Nestle...

Hey midmented thanks for the code, came right with a password form, but will try your code out. Hey bob goodluck with your project. Their is still one thing i'm batling with. Is their a way i can use dlookup or similar to lookup values in a sum query that calculates my totals for an order...

Hey bob, thanx again. My database is so to say finish thanx to say everbody's help on this site. C u around

Hey there, i c the input box has no input mask for password. Is their some other activex control i can use. What tried to do is: i designed a function getpassword that opens a form to get a password using a textbox with a password input mask.the form stores the password in a global variable just...

Help plz. My database's startup form is called "main switchboard". I use docmd.maximize in the form on load event. But each time i click on a button that opens a form using "openforms" as in Northwind and i close the form my switchboard isn't maximized any more. How do i get my main switchboard...

Hy ddaddy. Thanx 4 replying again. Where r u from? I'm working on my first database. I have sum vb6 experience.The database i'm designing is 4 sumbody who is starting up a business and want to use it to manage customers, orders,products,stock etc. The Northwind database helped me alot. I am...

Thanx DDaddy and DCrake. Can u maby help me with one more thing. I put in a "previous" and "next" button ,using docmd.gotorecord,so u can scroll threw ur customers. How do i check if the current record is the first or last so that i can disable previous and next accordingly.thanx bj

Help plz! How do i backup a database with code? And is their any i can update fields with docmd.RunSQL without the update message comin up?bj

Thanx, I would like to import values from a price list in excel and update the prices. How would i go about that?i also wan ba ckup the database by code. Which method would i use? And lastly remeber my function field VAT = ccur([TaxableAmount]/100*14) in my orders detail extended. how do i get...

Thanks Thanks guys 4 the input. I tried changing the lookup at field level but it made no difference.I changed the strFilter to the one with the single quotes and it worked. What does the single quotes do?Why did it make a difference? The database i'm disigning is 4 a for a neighbour who is...

Hey there, wondering if anybody can help me. I am designing a database similar to the example Northwind database. I used Northwind as a guideline as it is my first database. My Orders form and Orders Subform is basically the same as northwind. In the Orders Subform is use the following code...