Search results

I have a field in my form that will update a directory table if the name of the person is not already in the directory. How can I then update another field relevant to that person in the directory. So if I am adding Joe Bloggs but I also want to update a yes/no field that Joe Bloggs is a...

Hi guys, I am grabbing some old code and I can see it working in the database I have grabbed it from but having issues with this instance. Once I enter the value, it prompts not in list as expected, I can add it then it loops back to not on list again. If I select no I don't want to add it I...

Hi experts! I have one form in my database that will simply not open in design view. Any clues? All of the others will. It is a form that came from someone else but I cant see why that would be it? Thanks in advance

I'm sure this can be done I'm just struggling to think out the process. (I've been out of access for some time & relearning) I want to concatenate some fields based on elements of my form. STATE=AUTONUMBER+FINANCIAL YEAR From the the job entered date which self calculates I can get Financial...

Hey experts! I have a form that I want the user to be able to search for relevant jobs with a number of fields. I want to use unbound text boxes for project name and client then (at this stage while I am testing) get a query to return relevant records. I've used wildcards in each of two fields...

The title is from an old thread that is now closed. I have built a form that has multiple fields, some combo box and some free text unbound. The search button calls a query which I designed from the awesome example from Jon K in the original post. The example opened the records on the query...

Hey experts! Im recycling code from another database I have where I ask the user to enter the project number they want to go to and it either goes to it or has an error message. The only difference is that the project number is a string in this new database (at least thats what I think the error...

I have the lovely task of creating a job management database from one big gnarly excel table. I really havent used access for over a decade and some is like riding a bike but some more difficult. I think more difficult too as I am using existing data rather than starting fresh. I want to split...

Hi team, I confess to have not used access for a very long time. I developed a job management database that was a beast and is still in place now (15yrs later) at my old workplace but havent done much since. I have since been asked to create one for a client and have had some use to generate...