Search results

Hi @Pat Hartman, I certainly was not aware of the etiquette around starting new threads, please accept my apology. The members of this forum, including yourself, have been an incredible source of help for me in learning how to do a job that I'm frankly not qualified for. I certainly don't want...

@Pat Hartman saves the day! I'm going to go back and change all my acSavePrompts to acSaveNos now.

That worked! Point taken on the variable names. I've adjusted my plan a few times to make this work and the variable name was a relic from an earlier conception. One question: What is the point of if len(WhereCondition) = 0 then ???? end if I excluded it from my code and no issues...

Thanks @pbaldy! I knew I had some syntax issues with the quotes around the variable. I've done exactly as you've instructed but it still opens frmAdvancedSearchSelectItem with all records displayed. Here's the code now: Option Compare Database Option Explicit Dim FieldWhere1 As String...

Hello all, I posted this in a comment on another thread, but have realized the issue is not completely related to the original post, so I thought I'd start a new one. I'm working on a multi-field search form and I'm using variables for each search field to prevent my lines of code from...

@Pat Hartman Thank you for your continued assistance. I've now hit a roadblock as I'm having some syntax issues referencing the required variables in the OpenForm where clause. Here's a snippet of code I'm working on: Public Sub BuildSQL() Dim FieldWhere1 As String Dim FieldWhere2 As...

Thanks. @Pat Hartman. Really appreciate the effort you put into this response. I'm going to talk to my higher-ups over here to see if they really need the "OR" and "NOT" operators. I suspect they don't, but have seen how they are used in research databases and would like to implement them here...

Hi @Pat Hartman ! You commented on this post regarding an advanced search form that I'm making and included some example code for making it work without having to enter exponentially multiplying lines of code. I tried to apply your example to my db, but since my form's format is quite a bit...

@Pat Hartman Thank you for this. I've got over half of the code done now (tedious copy/pasting and editing!), but I will have to do another DB for a different department after this one is done. I'll have a good long look at your example at that time. I appreciate it!

OMG WHY IS IT ALWAYS SOMETHING SO SIMPLE. Thanks, pbaldy!

Hello! I'm creating an advanced search page for my organization's database, and if possible, I'd like to return results using if/then statements and where clauses in vba. But I can't make Like work properly in a vba where clause. Here's an excerpt of the code I'm working on: Private Sub...

Whoa, that's news to me! I haven't been using a Web Browser control, I've only had a text box displaying the hyperlink. I'll fiddle with the web browser control tomorrow morning. My work day is done in two minutes!

Literally the first thing I tried. I'm signed in on Edge, I've got an Edge browser window open, I've even tried with the Google Folder in question open. Doesn't make a difference, same error message every time.

I would like to show the images in an Edge browser window. This works for every link I've used except the restricted link. Ultimately I'd also like a thumbnail image to display on the form too, I'm looking into an API for that.

Correct, the error is coming from Access. Sorry if that was not clear from the initial post.

Yes, no problem there.

Yes, using a hyperlink field. It is populated via a form where the user pastes the hyperlink in. The link is displayed in its actual form, so no need to use display values. I've tested this with all kinds of links: to random websites, to unrestricted Google folders, and to local file paths. All...

Hello! My institution is digitizing the archives and saving images in a Google Drive folder with access set so that only users in our local network can view. I'm working on a database to house all the archival data, but the hyperlinks to images don't work on Access, even If I'm signed in to the...

Sure, cboNameSelect is overlaid with a text box 'txtName'. The text box overlaid on the combobox eases the data entry for the user and ensures the name is always displayed. The txtName_Enter event sets focus on the cboNameSelect field. If the user typed a name that is not in the database, a...

@LarryE you did it! Works like a charm! Please let me buy you a pizza. "You will never be able to search any field on this form if it is not a bound field on the form. You can't search a lookup field or SQL-based Control Source like you have." I did not realize this but now that you mention...