Search results

Greetings, I was unsure which section this belonged in, we have a database which has a number of functions, my knowledge is very limited on some things with access so excuse me if i need it broken down into more layman's terms. So we have a notes section, which when you fill in the date...

It would need to show the current week and update automatically if possible. (to be honest I am a total novice so this went over my head)

Afternoon! I have quite an extensive database which has many different types of data, I am looking to show on the front page only specific jobs which have a completion date in the current calendar week and older. Currently it shows jobs completing in the month but I cannot seem to figure out...

I have used the Query Method but i can only get it to show the total Files closed, Where would input this code

Ok so sorry to confuse things, Thank you for you assistance to get me the number of Job closed, but how would I change this to show the Remaining open jobs?

Morning all, My Data base is comprised of Tables which is organised by "Clients" and within these fields is a checkbox column. I am looking to calculate all the ticked boxes for each client. Clients are separated by a GroupID but all reside in one Table. very basic view of it below ( there are...

Would anyone be able to help me with code for a list box click through code for VBA I have a search form which i have set up which pulls data from a table but I also have a form set up which displays each individual data row. I would like to be able to search in my form, click the result and...

Ok So Each Table Represents a different client of mine, and each table differs slightly in the columns, I could do some works to normalise some of the columns so they all have the same column headings. But The reference numbers from each all differ, but Ideally I would only like to search for...

So this is what I have so far (the 2 columns have address and zip code) Search works for Name but not for Postcode. Below is the Search Query I have been used for the name but this doesnt seem to work for postcode.

Hello all, I'm new around here and have a fair knowledge of Excel and Access but VBA is not quite my friend yet! I can put together something that has lots of nice and simple features I would say I'm verging on intermediate but not quite pro. Long and short of it, I have an Access Database...