Search results

Should have been more specific - compile - syntax error?

Thank you! I copied and pasted and got a compile error?

Help. I'm using Allen Browne's code to list files to a table. I need to include a field that contains the date the file was modified. I've added the field to the Files table and named it fModified, and set the datatype to date/time. Below is the code (which works but doesn't pull in my...

Thank you! The form is a continuous form based on a query, which selects data from several tables based on criteria, and includes the field called LabelHyperlink. This hyperlink field was created in one of my tables as a hyperlink field data type (Access 2016). Two questions: When I go...

The form is still in access. So, not sure what you are asking about how I get the hyperlink....For each item, I've inserted the hyperlinked address into the record for that item, so obviously each hyperlink target is different. One form (in Access) would list all of the records with their...

The hyperlink is to each individual PDF, when you click on it it opens the PDF.

I use an access database (2016) that I developed to track products and submit product label pdfs to various government agencies. I use the database to review the products and develop a subset of products that I am going to submit. After reviewing, I wind up with a form which lists all of the...

I am probably staring right at it - but where is the option to set Access 2010 so that it automatically opens a specified database on startup?

Thanks for your help - I tried using a variety of different syntax options and never could get it to work. I wound up just reorganizing the tabbed controls and set this one up so that you click on a button and it opens the form, then you do the search, and then the macro works. Just...

Just so I'm clear (because I'm not real proficient at code, and want to be sure before I go through and change it).... The issue is in the actual search code, not in the export macro? Because the search still works, and brings in the results, even though its on a subform. Its the export...

Hi - I'm filtering via the form - here's the code: Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.txtFilterUPC) Then strWhere = strWhere & "([UPC] Like ""*" & Me.txtFilterUPC & "*"") AND " End If If Not IsNull(Me.CboFilterCategory) Then...

I'm using Access 2010, and am a self-taught (with the help of forums like this) database developer. I created a form to search for records in a table based on multiple fields, and added a button with a macro to export the search results to Excel. The button/macro works just great on the...

I am relatively new to Access, using 2007. I have a form with a subform, subform in datasheet view. I was successful in setting up NotInList so that when I add a record to the UPC combobox it will update the appropriate table if a new record. However, I've set up the form in datasheet view...