Search results

I believe you might be able to get the absolute path if you change the base url property to something like file://

Hi. Welcome to AWF!

Unfortunately, the "Like" operator ignore null values. To include them, you'll have to use something like: Like "something" AND FieldName Is Not Null

Hi. Welcome to AWF!

Hi. Welcome to AWF!

Does the code you found examines the LACCDB file to get the user info?

Hi. Welcome to AWF!

Glad to hear you got it sorted out. Good luck with your project.

Go to the Properties Window of the Form while in Design View and select Yes for Popup and No to Modal.

Perhaps you didn't mean to create a Modal form. Try using a Popup form instead.

I think that's normal behavior that scrollbars don't show up until the control with large content gets the focus (you could check this by simply tabbing to the subform, instead of clicking on it). If you want the scrollbars to constantly show, you may have to use an API for that.

I was actually going to ask about this. Are they paying clients? Just curious why you were giving them a ACCDE product, if they paid for a custom application. If you can give them a ACCDB version, they can easily find out if it will work as-is for them or not.

Glad to hear you got it sorted out. Good luck with your project.

What error were you getting? I think the RunSQL method only applies to action queries (Append, Delete, etc.) It looks like you're trying to run a Select query though.

Here's some blurb about it. https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-ovba/79685426-30fe-43cd-9cbf-7f161c3de7d8

You will have to loop through each appointment and examine its contents. Or, maybe you could try to link to each calendar, so you can use a query.

Oh, I just thought of another possible approach. Perhaps you could ask the user to enclose the delimiter in quotes and just trim them out in your code? Just thinking out loud...

Hi. Welcome to AWF! I think that's happening because Access is maybe cleaning up the empty Textbox before it uses it. If you want to use a space, one possible approach is to use a Combobox. That may work, but it may not be an acceptable solution. The only other approach I could think of is to...

Hi. Welcome to AWF! Perhaps you can attach an Excel file with sample data and the results you want?

You're welcome. Good luck with your project.