Search results

Wouldn't that mean that the user would then be working on local data and not the global SQL data? The data needs to be seen by several parties.

The Front ends are in accdb but with a accdr file extension to open as runtime with the data in a SQL Server.

Yes sorry guys. I would like know how to filter my data in an Access form and for that filter to be the same the next time I open Access?

Each user has their own (same) front end and will filter as they require. Yes I want to store the filter you applied if you applied one?

Pretty much what it says on the tin. I open my customer form and it is filtered by the customers that are in Table1 Easy right? Or I manually filter my form. When I open Access tomorrow the same filter is still applied. Thanks in advance as always

How do I execute the code? I'm being awfully dumb here....please bear with me !

I read that ontimer could cause an issue. I included it just in case. I have tried selecting the beginning, end whole of the line of text and pressed F8....nothing I have tried a blank line and pressed ctrl F8 (expecting the code to run upto the point of the curser....nothing other than a...

I have my OnTimer events These are mainly queries. What is the shortcut in vba to run each line of code within VBA?

Thanks Minty It's just easier at the moment as there are several permutations to go through.

Will putting DoCmd.SetWarnings False into my code when the code is already at a False state cause any errors?

I am much obliged to you all for your comments and thoughts. More Homework me thinks ! Thanks Guys

I am transferring a database to SQL for both performance and scale-ability issues. We are retaining the Access User Front-Ends due to the familiarity that the User has. The Front ends make use of (local) Queries based on the underlying (SQL) data. I am trying to establish what is the best...

When I open my form I have two dates: A bound date and an unbound date that is seven days previous. What Im trying to do is to count how many days between these two dates have the same month as the bound date. eg Bound Form: 04/11/2018 Unbound(onOpen): 29/10/2018 Calculation = 4 This will then...

Minty.That is fantastic Works a treat. Many thanks

I have the following in my query to concatenate my addresses. Address: IIf(IsNull([Address_Line_1]), "", [Address_Line_1] & " " & Chr(13) & Chr(10)) & IIf(IsNull([Address_Line_2]), "", [Address_Line_2] & " "& Chr(13) & Chr(10)) & IIf(IsNull([Address_Line_3]), "", [Address_Line_3] & " " & Chr(13)...

Arnel Thank you so much. works a treat!

I have the following code in my form. It is a cumulative search but I'm really struggling to filter by a specific date. My date field is [SelectedPeriod] When the form opens the fields t6 and t7 are defaulted to two dates that will ensure that all of the the data is filtered ie. t6 -01/01/2000...

Thanks Guys

Easy peasy !! I have a field that creates a number "noreq" I have my field to search "searchfield" I am looking to extract the "noreq"th character fron the "searchfield" eg noreq:7 searchfield:ABCDEFG Result: G Thanks

So I decided to rebuild my form and voila "On Change" works !!!! Bizarre. Sorry for wasting your time guys. missinglink: I put: KeyAscii = 0 in the On Key Press property of the field