Search results

I have about 20 queries that a user would need to run, but I want to give them a more user-friendly way of running them, rather than selecting the query manually from the navigation pane. One option I've thought of is to have a combo box that lists all the queries, and when the user selects the...

This worked, thanks!

What do you use instead? Do you just create a switchboard manually that has buttons to open the individual forms? I'm getting the feeling that might be a lot easier! I tried your code and it 'highlighted' the tab (if that's the right word to describe it) but didn't actually switch to that tab :(

I originally had 3 forms: frmConsultations, frmFamilies and frmIndividuals. I then created a Navigation Form called frmNavigation with horizontal tab layout, and dragged my original 3 forms onto the frmNavigation form. Does this then cause my main form to be frmNavigation, and frmConsultations...

Hi, I've got a navigation form [frmNavigation], and all my other forms appear as tabs (subforms I guess?) going along the top. The tabs I have are: frmConsultations frmFamilies frmIndividuals On the [frmConsultations] tab I want to add a Command Button that will take the user to the...

I see. Thanks very much for your help and advice.

Your first option seems to work perfectly and saved me quite a few lines of code, so thank you :D Just out of curiosity in case I need to use it in the future, the code in your second option - is this just added at the very top of the code in SQL view?

I changed to >= and <= but still no luck. These are the 5 dummy records I am using, and whether they were returned or not: FamilyID.......AllocationDate.........Status........ClosureDate 1..................01/04/2016.............Open...

This was my attempt at using your expression: SELECT tblFamilies.FamilyID, tblFamilies.MainChild, tblFamilies.AllocationDate, tblFamilies.AllocatedWorker, tblFamilies.Status, tblFamilies.ClosureDate, tblFamilies.ClosureReason, tblFamilies.OtherDetails FROM tblFamilies WHERE [Start of...

Apologies for not understanding your example. As a beginner I find it difficult sometimes to understand examples that don't include my field names as it gets lost in translation. I also am not familiar with the Nz function, so I struggled to grasp what the line of code you posted would do. This...

Oops! My apologies, sometimes I need an example to slap me in the face before I understand them :( Your solution seems like it would do exactly what I want. Sorry for asking what might be a simple question, but what exactly would my "WHERE" clause be, based on your solution and using my field...

No, what I want to do is display all cases that were 'Open' at any point during Quarter 1 (April 1st - June 30th), but I will also need to do this for future Quarters. I could make a separate query for each Quarter with set dates specified in the query which would do the job, but I thought it...

The main reason for including that field in the query could be put bluntly as 'overkill'. While I'm still figuring out how all my queries work I've been including more fields than necessary to make sure I can keep track of exactly what is happening. Once I grasp it, I remove the redundant parts...

Hi all, this is my first post so apologies if I don't format this correctly or if I'm not doing things properly. Please give me any tips you think would help! I've got a decent enough working knowledge of Access but I'd still class myself as a bit of a beginner and I'm picking stuff up as I go...