Search results

I'm using the query for a standard report in Access and for a data dump to a spreadsheet. So with this approach I would not really use the static query as such right? Just defining it in the code (including the strWhere string) and then update the data source for the report (and excel export)...

Many thanks for all the great input! The way you describe it, Tim is how I would do it for a form filter and just apply the strWhere to the Me.Form.Filter. I'm not a wizard at this so maybe there is an obvious answer to it - but could I apply this strWhere to a static query? Meaning could I go...

Hi, I have been looking around for a while now trying to figure this out. Would really appreciate some assistance. I have a form with some combos to allow the user to pass filter criteria to a query. When one combo is left empty I want this criteria to be disregarded in the filtering - meaning...

Hi, Hope someone can help me with this one. I have an Access database that replicates to an SQL server with a number of append and update queries. Part of this is of course to identify the most recent and the newly added records. This is done with time stamps on all records. In our Swedish...

Thanks for your quick reply. More specifically the problem can occur in different ways; In the English environment it doesn't occur at all. In another Swedish environment it will cause a runtime error "3061 too few parameters, expcted 1". Yet in another (also Swedish) environment it will not...

Thanks for your support. Let me try to be clearer. Here is my function: ------------ Public Function MilestoneStatus(MyMilestoneStatus As Boolean, MyMS As Long, MyProjectID As Long) As Integer Dim CntRecYes As Integer Dim CntRecNo As Integer Dim CntRecAll As Integer Dim rs As Recordset Set...

I would really appreciate some help on this one! I have database that include two linked subforms. When one form is updated, related fields on the other form are updated with calculated values that comes form a CurrentDb.OpenRecordset (pulling relevont recordset form the database) combined...

Great! This seem to be what I need! Thanks!

Thanks! That seems definately like the obvious best alternative. That is also where I currently have the requery of the subform which looks like; Forms!frmBase!frmProjects.Form.Requery (just to show the references). Why I'm trying to find another more direct way to address is simply that I seem...

Hi, I have been struggling to get around this long enough and I would really appreciate some real expertise. I have a main form that holds a tab control with a number of sub forms. One of these subforms has a pop up form for adding new records to it. After closing this pop up form I would...

Great! I tried the Me.Dirty = False and it worked like a charm! Many Thanks!

Hi, I have a very strange issue. Im running a form where I update the status in a checklist (continuous form) when I check a box in this form the overall % status is updated on the parent form which is the list of projects (each having a checklist). Here comes the problem. Everything is...