Search results

Also one other thing.....how can I then export the form data (filtered) into a report?

Works great, I have used it on another search form also (y) One thing..... If I want to search LIKE "*" & xxxxx & "*" for say the Invoice Number how do I put this into theFilterForm code? I've tried several times and cannot seem to get it right!

MajP.....this is awesome, thank you very much!! Very much appreciated....would have taken me days to try and figure this out.....greatly appreciated

Thank you everyone for replies.....so I am not going crazy then, just approaching it the wrong way, that is at least something!! I'll try and get my head around the VBA and revert. Thanks for the filter version @MajP, although this is a good solution I'd really like it less generic looking for...

Hi All, I am about to go crazy 😩 Attached is a sample db of what I am doing. In the Expense search form there is some combo boxes and text boxes that can be used for search criteria, they are linked back to ExpenseQQ query. Currently I have just set the search criteria for the date, person...

I changed the reference in the query and it works fine now, thank you very much

Ah OK, thanks for this, so I just need to change the references in the query....am stacked out today but will let you know how it goes

Thanks for this. If the subform opens first then how come when opening 'Accounts' form normally the subform shows the results of the query based on the data in the main form? Surely if the subform opened first then it would not have the data to run the query as the mainform isn't effectively...

Hi All, I have a subform within a form, the subform shows data based on a query that uses the main form for its criteria, when I open the main form 'Accounts' it works fine without any issues and the subform shows what it should. Problem I have is that the 'Accounts' main form is in a tab of a...

Hi All, I have three tables Expenses - Parent LineItems - Child Currency - Linked to the child with a drop down menu to select a currency All works fine and I have a form to enter the information into. However I have a field in the LineItems table called HomeCurrency, I need to add some VBA...

Thanks for the info, the sample I posted is only just that, on my main DB it's substantially bigger and also includes a 3rd option to archive someone, so the combo for options would work well for this, however I do have another subform in there (part of the original tabbed form and not the sub...

Thank you so much gents, sometimes you can't see the wood for the trees! Have a great day

Hi All, Attached is a sample DB of an issue I'm having. Is easier to see the DB to see the problem. In the People Tab and then Sign on/off tab I have 2 subforms. I have code on click when you click onboard or onleave on the two subforms, in this code I have Me.Requery which requeries that...

How do I do that?

Didn't work unfortunately have this set

Hello All, I have a query suppling a subform in a tabbed form. In the form I have a textbox that acts as the criteria for the query (LIKE "*" & ...... & "*" ) when the form it opened it returns all the records until a surname if typed into the textbox, so it works fine. Problem is that I want...

Thanks very much Pat, much appreciated. Complicated stuff. I guess locally stored on a server with remote desktop for an external office would be the way forward in my circumstance. Thanks again

Thanks very much for this, much appreciated. I had already given myself a year plus to develop this so all good for that, I'll do some research based on the above and more than likely revert on this forum! Thanks again

Thanks for this, communication speed shouldn't be an issue now with Starlink which many ships are using. Ideally I'd like BE on a cloud so can be accessed from any FE user regardless where they are in the world.....from what I've read best solution is SQL Server for the BE but any other...

Dear All, I have a large DB which is currently split, I've worked on it over the last 5 years and as such it's quite disfunctional in that it could be designed much better in how it works (IE much less tables and queries etc.), but as you live and learn you figure out better ways to do things...