Recent content by kevers

Yes, I modified the "where" section of the SQL code instead of using Parameters, and it works well now! Thanks a lot for all the help! K.

Is there no way to replace conditional parameters? I seem to be only able to replace strings, integers and standalone dates. eg. QDF.Parameters(>=Date()-7) = >=Date()-8Because it seems like that is the only major problem I'm having at the moment. Thanks

Here's a simplified version of the query (without all the names). SELECT TableA.[U##SERIAL], TableB.DEF_DATE, TableB.MER, TableC.DEF_CAT, TableD.[U##DEFER_ID], TableE.TYPE, TableE.DEF_ACT, TableD.[U##WO], TableE.WRK_DNE, TableE.DESC, TableA.[U##STATUS], TableD.CLOSE_DATE INTO [Destin_table]...

The query itself just looks for data in a table for a 7 day period (I just set the start and end dates of the week). So in itself, it's not complicated but I would like to replace the start and end dates automatically, which I am struggling with. Would it possible to use the Replace function...

Hi, Thank for your replies. To make things a bit clearer, maybe it's better if I explain what I would like to do ultimately. I would like to run the query (called QRY_a here) for every week between now and the beginning of this year. As the it works on a weekly basis (looks for the data for a...

Hi everyone, I am writing a VBA code to try and modify my query criterion and I'm using QueryDefs and Parameters for that. Unfortunately, I have run into 2 problems: 1) I need to use a conditional criterion, e.g. >date( )-7 and I don't know how to use Parameters for a criterion that is neither...

The Record Source only has the query name in it. But it still doesn't update the fields. So what I've ended up doing is that I created a report with all the fields from the query in it. If the user decides to delete a field in the query, the report will just leave that field blank. I don't...

Thanks for your help. Does that mean that every time I change the query (remove/delete fields), I will have to manually change each field in the report?

Actually, let me repost my problem to make it clear: I have a report linked to a query. The thing is, sometimes, I need to remove/add fields in the query because there's some data that I would like to hide/display depending on the situation. The problem is that when I delete/add a field in the...

Hi, I know what the property sheet is, but I don't understand what you mean by "changing the Control Source property of the control". Will this automatically update my report if I remove a field from the query? Would I have to do change the control source every time I change the query? Thanks

Hello, I have report with a query as record source. The problem is that if I edit the query, for example remove a field, the report does not update itself and only shows the previous query. Is there a way to make the report update itself without having me to go through the wizard every time...

I'm not getting it to work, when I run the command, it just prompts me to input information, which is probably not right. - Did you create a macro or module, or did you just input the code in the "on click" property? - I don't understand what you mean by: "Me.txtcontactID is the field on my...

Hi, I have browsed around and I have seen this question pop up quite often, but I can't seem to find a working solution for me. I would like to have a button that opens a subform in a new window, while keeping all the child/master relations. I have seen this example from one of the entries on...

Ok, I got it to work now. Thanks a million!!

Could you take a look at what I did. I basically tried adding a third combo box. the query seems to work fine, excluding the first and second selections, but combo box 3 does not update accordingly. Am I not setting the row source properly?