Search results

Morning Minty I tried that but it then doesn't filter (as per the frmDatasheet) My button press codes to open with a filter surely "OnLoad" Filter "" will then negate this? I was thinking that a refresh all "After" the fact would be better or open the report normally and then apply the...

Thanks DBGuy Perfect!! There is one little bug bare !! When I filter my dataset and open the report everything is fine, however when I close and revisit the dataset (showing all of the data) it reverts to showing the previous filtered data. Wondering how best to refresh the report ? Perhaps on...

Hi there DBGuy. Could you illustrate what you mean using my example form/report names?

My frmHolding has an unlinked sub form frmDatasheet My rptSummary has a linked sub report rptDetails I'm trying to open my frmHolding, filter frmDatasheet and then press a button (on frmHolding) to print rptSummary (with the linked rptDetails) based on the chosen frmDatasheet filter. This is...

Hi Minty I want to study an alternative to Access, sorry that that wasn't clear.

I have my SQL back end and my all singing, all dancing Access Front End. What would I use to replicate my front ends over my company network, with a nod to a Cloud environment in the future?

Think I've fixed it !!! Dim AllDate As Date AllDate = Format(Me.AllocationDate, "mm/dd/yyyy") and then stFilter = "([AllDateTU] <= #" & AllDate & "#) Ill confirm in a bit......

Ot Oh !!!! Something went wrong !!!! Me.AllocationDate is an unbound textbox set as short date (with datepicker) dd/mm/yyyy However the date that is entered does not correspond to the the date needed to filter. It's as though it is filtering by US not UK ! I tried a static filter and sure...

I have used this code to add days to a date and if the required date lands on a Saturday or Sunday, then move the date on by Two days if its a Saturday and One if its a Sunday. the Sunday part works ie. Date to Use: 05/03/2019 add five days gives 12/03/2019 but I am at a loss to why...

Thanks for your time and effort. I think that the query route is the safest at this stage.

What Im trying to do is count how many unique ClientRefs there are in a table and then show this on a form. the table holds 25k Client References (with duplications) However there are just 15k unique Client References. I just want my form to open and to populate an unbound field with the...

Hi Minty That's fantastic. It's a much better structure. I guess I was trying to do it too quickly. Many thanks, works a treat.

Can you just help me with this syntax please? Im trying to filter my form where the field USER = "...to be allocated" AND where the AllDateTU field is less than an unbound date field on my form called AllocationDate This is what I tried but Im getting a 3175 runtime error which Im stuggling to...

The error is saying that it can't find the table !!!!strSQL = "SELECT tblClients.Ref FROM tblClients GROUP BY tblClients.Ref;" I have changed my function to RefGCount = DCount("*", strSQL)

Hi All Im looking to open a form (for the purposes of checking) that counts the grouped reference number in a table's field, however I'm getting myself into a muddle. This is what I have at the moment: Dim strSQL As String Dim RefGCount As Integer strSQL = "SELECT tblClients.Ref FROM...

Found it. File Options Current Database scroll to: Filter lookup options for........ tick the ODBC fields radio button. Restart Dealt with.

I've established that the list is there on my old Access system but doesn't work when the data is in the SQL server

I have just moved my data to SQL. I have a split form that I can filter in the datasheet area. It normally has a list of all the options within that column but the list has disappeared. It now has a to z sort and "Test filters" etc I'm trying to understand what I have done wrong in order for...

Thanks guys. Plenty of homework there, however I feel that this "simple".... "ask" by a user is ultimately unachievable. The editable query etc is too complex for the user.

I have a split form that I distribute and create as a runtime. I would like the user to be able to sort the columns in their chosen order and for this to be retained as opposed to the default pre-designed order every time it is opened. Is there a field within the properties of the form or will...