Search results

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?

Ok, I think I'm getting somewhere I just have a few more questions: 1) In the form, combo box 1 is linked to TBL_Items. In the row source, would it be the same if I just selected TBL_Items from the drop down or do I need to specifically type in the code? I also did not use an ItemID in my...

Hi, I'm quite new to Access so I'm not sure if I understood the different examples correctly. What I'm looking for is the following: For example, I have a list of names in a table. Then, in the form, I have 2 combo boxes, both with the table as rowsource. When I choose Name A in the first...

Hi, I have 2 combo boxes in my form that are related to the same query. This means that they have the same selections in the drop down. Is it possible to have the drop down for the second combo box to update itself such that the selection made in combo box 1 does not appear? Thanks a lot for...