Search results

Hi i hope this may make sense Products is the Table from ist combo box catogories SELECT products.category FROM products GROUP BY products.category ORDER BY products.category; from second combo box item name SELECT products.itemname FROM products WHERE...

hi i can i somwhow just post the form or will this not work .I dont really want to post my entire data base .I have checked out the spelling and all sems ok .does it matter in the querie the order of events .thanks for your help it is midnight in the uk and i am going to bed will look for you...

Hi thanks for your help I followed the tutorial for cascading combo boxes from the first one you suggested ,using queries to do the job .But i cant get it to work .i can get the first combo to work properly,but the 2nd combo when i click on it askf for a parameter to be enterd .It sems that is...

I have a ordering program that works great with my products table with the use of a combo box to find and place products into the table However now i need categories and i cant understand how to get this to work .The combo box lists all the categories but then i need to select a categorie and...

many thanks will give it a try

Many thanks but i really need to automate it What is the best way of doing this

I want to copy and past automatically using a macro .I have a sub form and i want to copy a date into varous other positions after i have entered info into the proceeding field a

I currently have a database wear i use a combo box to look up products then i use a second look up box to select the suppliers of those products .I have quickly realised that i have to many products ,so now i need to look up catogories as well ,this all seems a bit cumberson.Is there a way wear...

I have two fields date of order and fiting date I want my query to count these dates down ,so i can see when a fitting date is getting close. I assume i write some sort of expresion but am not sure how to do this or weare to place it in my query

Hi bob many thanks .Am attempting to fix things now .strange i had noticed the ordid no were not there .but it seemed to work so i imagined it was ok Silly me

none of the records have odrid I have chosen to show the customers surname rather than order id .i kinder imagined the orderid wouldsomehowbe known to access as everything seems to work ok

Hi Bob done that shows all info from orders table including date but only headings fro the order details table prurders

Thank you so much for your help also regards john

Hi Bob do i copy and paste this somewear.?

SELECT orders.ordID, orders.surname, orders.dateoforder, orders.fitdate, orderdetails.ordID, orderdetails.product FROM orders RIGHT JOIN orderdetails ON orders.ordID = orderdetails.ordID;

Hi Accesss newbee I have two tables,orders and order details .In my orders table i have dates for order received and order to be dispatched .In my details table i have no dates . I want ultimately to be able tp produce a report showing the dates from the orders table.And the products from the...

Hi I use a combo box to select products and place in my order details sub form .I now realise i need a catogories table .how can i get my combo to look up a categories table then go the products of that table then enter in my orderdetails. Please keep it simple i am a newbee

I am using a combo box and i am getting the following eror mesage cannot enter value into blank space on one side of outer join I have a customers table that i am tryingto input there names into anorders table .

Hi Bob Yes i have read it and it makes fascinating reading .I still am not shure that i am at this stage .There is only me using the computer using the program and i do all the programming in the evenings .Is it not possible to save my new programming some other way

Thanks Bob I only use it on my computer .do i really have seperate it.it sounds quite difficult is there not an easier way y