Just saying thanks b/c I never knew the SOLVED option was under Thread Tools when you log in.
If/when I get this whole code working, I will post. Thanks!
I found out what the issue was. I did not mention that I had my code in a module in the PERSONAL workbook.
Set wkbkBilling = Workbooks(1) is the problem.
Since my code is in the PERSONAL workbook, I should have said:
Set wkbkBilling = ActiveWorkbook
ThisWorkbook (and probably Workbooks(1))...
Hello, I have not completed working on the code below, but it is hopefully going to uncheck an item in column B's filter (Filter:=2) of the Billing workbook if the address in column D of the Billing workbook is found in the AddrList workbook.
I have a question about why my variable...
Minty and static, the forum won't let me add to your reputation b/c it says I have to spread it around. I added to everyone's reputation on this thread, so maybe it is b/c I have added to your reputation before. Otherwise, I would add to your reputations. Thank you, again.
jdraw, I just finished getting the db ready to upload when I saw the two replies from Minty and static. Their code works!
Thank you so much for your help and willingness to upload the db. Thanks, again!
static, thank you so much. It works! I can't believe I didn't catch the change you made with DateNetwork. Thank you also for the flexibility with the msgbox so that if there is missing info in the Begin or End date or both, it will give a msgbox.
Thank you very much, again, for your patience...
Hello Minty,
This is the sSql line in the immediate window.
SELECT DateNetwork FROM tblNetworkPerformance WHERE BeginDate = #2/1/2017# OR EndDate = #2/1/2017# ;
But here is the issue, after I looked at statics code, it's DateNetwork =, etc.:
sSql = sSql & "WHERE DateNetwork = #" &...
static, thank you. Can you take a look at my reply to Minty b/c I get Run time 3061 error Too few Parameters for both codes, but yours is Expected 1. I thought OpenRecordset had optional parameters to it except for the first one.
I made adjustments per my reply to Minty but I still get that...
Minty, thank you for your reply. I'm trying yours and static's code and I'm getting similar errors.
For your code I left everything as you wrote it, except changed the dbOpenSnapshot to dbOpenDynaSet and the <> to = in the WHERE statement.
The error I get is Run Time error 3061 - Too few...
Cronk, thank you very much for your reply. Would you take a look at my response to jdraw? I would like you to see my new code, based on yours, and see the new Compile error I'm getting, if you don't mind. Thank you, again.
jdraw,
I've changed the code now to Cronk's suggestion and I get a different error, so let me list two issues below:
1) The 1st error you are asking about is on the line below. I am confused on having two criteria for a WHERE statement, and I am lost on how to use the quotes.
With just 1...
Thank you, jdraw. I tested it and it will still filter the form b/c I think IsDate is seeing if there is a date in the text box, which there is, but I need a msgbox if a user puts in a date that does not exist in the underlying table of the form.
For ex: if the table only has dates of 2/1/2017...
Hello,
I have a BeginDate field and an EndDate field on my form that filters via a command button the data on the form to just the dates within the range entered by the user. I just have a form, frmNetworkPerformance (no subform), based on a table, tblNetworkPerformance.
The code in the On...
Thank you very much, CJ_London. I appreciate you replying and providing an example/alternative of what I can do. I mentioned to the others, I am going to try all of these out and reply back re: the outcome. Thank you again for your help. (Pardon the late reply.)