Search results

I have attached what i hope will explain what i would like this to do. I am very grateful for all the help you guys are doing and really appreciate your patience with me.

Is anyone available to help please. Getting to the "want to blow up my PC" phase.

I am so sorry, but i have no idea what any of that meant?

Yes, that would definitely help. frm_Order has a print preview button which is not working, its not my code so i am struggling to find out what is wrong with it. The search option is for the buyers to be able to search the OrderNumber from tbl_ORHeader When you click on the project number from...

Good morning from sunny London, Long story short, i work in a construction firm where the guys on site need to order materials but are very vague about what they are after, often causing mistake orders and delaying construction programme. This database started as an excel spreadsheet (32000+...

Sorry yes its working from there. I couldnt get the print preview button to work but it seems to be working now :-)

The order report is showing all records on one page.... how do i get it so it only shows one order at a time? Again i am so sorry to be a pain, im slowly learning

Yep thats spot on, thank you again.

Attached and thank you so much. Its pretty much the same as the one youve sent me.

Thank you again. How do i add some more information to the tbl_ORDetail? Ive added new fields so that i can pull the information to the reports but its not picking up the information from the frm_Order. Also if i change the naming format on the tables, forms and queries in both access panel and...

@arnelgp Is there any way to make the search bar search more than one word. E.g. clip 50 ... this would then bring up the 50mm clip. I'm trying to narrow down this search function a bit. Thank you for all your help btw, its been amazing :)

This works perfectly thank you very much :-)

Hi everyone, I have created a database that has materials that we order on a regular basis. The idea is for our site team to search the items they want to order, add them to a order request and then send it to our buyers. Our buyers will then take this, pull the records from the O.R and put it...

OMG Thank you you so much! I just did a little jig around the office. Amazing thank you again!

Its got that at the top now but its still not doing anything? Before i added that in, it was coming up as the below string is the issue and i cannot figure out why. I have changed it to SearchText.Value and that doesn't do anything either. SrchText.Value = vSearchString

I have ticked that option and nothing happened? It hasn't done anything?

apologies for not replying sooner. Covid got me :-( I have added in the relationships, and a search query, and a reducing search function that i pinched from a template but its not running on the search for box. Would someone mind having a look at the VBA on it and seeing what I've done wrong...

Hi and thank you for all your responses. Yes the idea is that multiple projects would order multiple materials from multiple suppliers and would be done by multiple people. So the relationship is, tbl_StaffContacts, working on tbl_Projects, wants to put in an rpt_OrderRequest (report not made)...

Hi All, I have previously used access and new enough to get by. I have since been asked to build a material database for our buyers so that they can search for items they need and add them to a purchase order. I have tried various versions of code that i have found on here but nothing seems to...