Recent content by Coolzie1

My apologies as stated above the code is all at my workplace so I am not able to access it. I am also doing this whole thread off of my phone so it is a little harder to do it all as I have had to type out all of the above with the memory of what my code looked like and improvise. I do have in...

Hi, Unfortunately as it is for a work database and I am not at work or able to provide the full exact code for data protection reasons I cannot give a full overview however a rough example of what I am trying to do would be something like... If recordset = 0 then Msg = "no results found, is...

Hi all, I am working on a form where you will search for results held in a table and the form is going to run a continuous set of results if any are found. I have attempted to set up a series of message box's in the event that nothing is found as this would mean a few different things. However...

Thank you so much, I never knew that was specifically what was being done with the asterisk as I've used a pre-set bit of code from online and adapted it to fit my form and table. I feel stupid for spending hours searching through websites and it could have been sorted in 5 seconds.

Hi all, As you may have seen in a previous post of mine I am quite new to access and VBA. I am setting up a search database which will be being used by the team I work for at work and need to search through all of the postcodes in the UK as part of our job role to see what delivery Windows are...

Yeah I originally said there was 3 tables because I will have 3 plus tables which will be used in the final search form however for the purpose of finding out how to fit the 2 search screens into the one form and then I could work from there to add more as required was why I removed the other...

Hi all, Please find attached the database with rough tables set up for 2 of the searches. I have left the main menu on there, it is the bottom button (the only one which will work anyway and is labelled as AgentSearch) any help is appreciated, if this gives more of an idea of what I am going...

I have stripped all of the unnecessary data, all that is left it the main menu with the button to the search screen and it currently works the same as it does when I have all of the data I need in it correctly in place. I will do this once I get a chance tonight, thank you all for the help :)

Hi, Thank you for your fast response, I tried to reply last night however after typing out my response I got a lovely message on the screen saying "No internet connection" so it was a waste of about 20 minutes responding. I have looked at the link that you have posted and I don't think it will...

Hi Everyone, I am one of the noobs to both here and access, I am picking up the basics currently with watching and reading as much as I can to help me progress fast. About me in general I am 21 (today) and live in the UK (North East), I have 1 son and 1 dog. I work for BT currently and am...

Hi All, I am quite new to Access and VBA so I don't know whether this is a quite simple problem and I am just missing something? To give a basic idea of what I am needing is a tabbed form with 3 tabs at the moment to show 3 different tables on a continuous form kind of screen and search...