Recent content by mike7352

Sorry, I edited my original post right after your replied. Have you tried this in a 64-bit installation of Office? My InfoSec department locks that down, but curious if you might be able to test that. Also, how can we report this to Microsoft as a bug? I have never done that before but this is...

I have this exact problem in Windows 11 but have noticed that the 100 row limit with autoexpand in a combo box appears to only be a bug in subform combo boxes. When I have a combobox with more than 100 rows in a main form, all rows appear. I also am using .accdb frontend, not .mdb. Curious...

Thank you @ebs17, I was doing everything correctly, but needed to use 0 instead of vbBinaryCompare.

Hi there, this thread is quite old but I have relevant question. I am trying to change this ugly yet functional nested replace function to use vbBinaryCompare so that it will only replace it if matches all CAPS. I cannot seem to get the syntax quite right...

Thank you all. I fixed it by putting the form controls inside Eval(). I also didn't understand that variables need to be outside of the sql string and concatenated and fixed that as well. I would like to explore the function from @theDBguy at some point but for now the issue is solved. I also...

Actually @The_Doc_Man, the from and to fields are just text boxes on a form, they are called in other recordsets that are based on table paylines. paylines itself doesn't have a from and to field. Not sure if that matters. I'm going to propose a workaround. I can have an InputBox for from date...

Hi @theDBguy, so strSQL is going to be the query WITH the form control, correct? Set rs = fDaoGenericRst(strSQL, dbOpenDynaset) yields the following error: Expected variable or procedure, not module.

Thank you @Gasman

@Gasman it's hard for me to see how the tempvars work without seeing how they are defined, could you add that code? @The_Doc_Man, the form is bound to a table called paylines which is the same table that my SQL statement is based on. I'm really curious what you're suggesting. I've never...

Hello. I inherited a 17 year Access database and am learning on the fly. I have questions related to OLE Automation that I look forward to getting answered!

Are there any prerequsites to getting debug.print to work? I tried to do that and nothing is coming up in the Immediate panel after I click run.

@Gasman, here is the full string. I think this is simple? SELECT paylines.name, lastname([name]) AS last_name from paylines WHERE [between two form controls, what I'm struggling with] ORDER BY lastname([name]) I will look through other threads but some of the answers are too advanced for me.

@Gasman, if you are proposing that I define a variable with the single quotes around the form control and call that in the sql statement, I have tried that. I found this function online. A) Does this work? B) I have never created a custom function and am not sure how to use it in a sub...

Hello. I have created a recordset that uses the following WHERE clause WHERE (((paylines.date)>Now()-Weekday(Now()-1)-14 And (paylines.date)<Now()-Weekday(Now()-1))) I would like to change the WHERE clause to be based on a form control. I know I can't use the following: WHERE...