Search results

hi, I have 2 tables and I can create 2 combo boxes in my form to select the information I want in my report and then put an iff statement in my query to see which information in that report is it possible to create a combo box to look at 2 options then depending on which option you...

hi, when I put a part number in the engineering table can it also go into the sales table at the same time without me having to input it into that table thanks steve

HI , edited this post so last post is still open steve

hi more information . if I remove the invoicedetails table from the query the cdescription is correct but I don't know how to solve it with that table in the query steve

hi , i have attached more tables and forms for more information please open the form sales orders goto record 185 you will see a field called " cdescription" i select the partno but the description goes into the order details table the order number for that record is 670013002 please...

hi, I have a query called " invoice report query" there is a field in that query called " cdescription" this is from the table "order details " in that field there are 5 results called "bulb" and "capacitors" where I run the query all I get is " capacitors " in all 5 results...

thanks I can set it like that but if possible I would like to try and search by column one and still show column 2 in the form and table if possible steve

hi, getting error message compile error method or data member not found steve

hi , thanks I have put this into the after up date me.productid=me.productno.column(1) I did put this in the properties "after up date" is this correct ? but after I enter data I get an error message saying access cannot find the object "me" steve

hI , I am trying to set up a combo box that has 3 columns the first column is the column I want to search on as I know the part number but it is the second column where I want the data to go into the combo box field I cannot get the second column into the database how do I set...

hi, I have a table tat has engineering information in it. I also want to create another table with sales information in it there is a "part number" in the engineering table that will be put into the sales table when the engineering table gets new part put in it can the sales table get...

hi when I try to change the limit to list to NO the error massage says "the first visible column which is determinded the column width property is not equal to the bound column adjust the column widths first then set limit to list " I have tried to do this without success steve

Hi, could you please look at the form "order details" there is a combo box for a product number to be selected from products table I want to be able to also have a free input into this field but it wont let me I have tried to change the "limit to list "b properties but I am unable...

I have attached a sample of my database there is a table called stocklist and one called order details there is a part in both of these tables called GC3446M1 in the stocklist table it is under the heading of stocknumber in the order details table it is umber the heading product...

hi, is it possible to lock the " view design" the user at present could run a query and the view the design and change it this would also include forms thanks steve

thanks all good now , now next problem to find!!

hi , thanks I have put that into the query and it is working. but does that date in the formula look at "<=Now()+91" as with yours I get 114 records but I think I should get 138 steve

hi below is 2 formulas that this forum kindly help me with and works great what I want to do if possible is add another formula is count the amount of records that are waiting purchasing up to 91 days from present day I can have a date field with this in it "<=Now()+91" and...

hi , it is now working it was like you had but I had to put brackets around the fields which I did not know UPDATE [supplier orders] SET [PO Number] = 'cancelled' WHERE [PO Number]=[Enter PONumber]; Really appreciate your time to help me on many of my problems you are very...

hi , managed to use this to get the results