Search results

Hello, I have a continuous form in which I'd like to set the visibility for a button "cmdViewImages" individually for each record on the form. The form shows the names of a bunch of items in table "Items". The items may or may not have images associated with them in table "Images". If there...

Hello all, In my database I have a table "images" that is ODBC linked to a SQL Server table. I have two forms for this table, frmAddImage and frmEditImage. I have no problem adding data and updating data using the two forms, but I cannot delete records using the forms. I can however, delete...

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...

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...

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...

Hello! I'm working on an archives database and I'm trying to make the user interface a little easier. I have a form that looks like this: Some of the items in the database have over a hundred associated persons, and I want to make it a little easier for the archivists to find associated persons...

Hello! I apologize that I may not be using the right terminology here, but this is my situation. For some controls, DoCmd.OpenForm will open the requested form and immediately switch the view to the tab containing the form. On other controls, the view will remain on the display form. I can't...

Hello! I have a subform to edit items from table [Items] in which multiple items from table [Persons] can be selected in a combobox called cboNameSelect. The subform also includes a command button that opens a form to enter a new item into the [Persons] table if that person is not yet in the...

Hello all! In the database I'm working on, I have an form to edit entries on table "items" that includes a subform to add associated persons from table "persons". I have a combo box that allows the user to select the associated person, and it displays a few data points on each entry from the...

Hello Access Wizards! I have a fairly simple thing I would like to do with a couple of forms. I have an entry form linked to one table that has a button that opens a pop-up form if the user needs to add a field to a related table. When the pop-up form is closed, the earlier entry form reloads...

Hello all! I've started work on what should be a rather simple database for a school archive, but right away I've come across a quandary I can't solve. In order to make this simple, I've downsized the database to only the relevant tables and fields to show the relationships in question...

Hi everybody! I have a form with three unbound text boxes that are to be used as three different search functions. I have control buttons next to each text box that open a report based on parameters collected from the text boxes. I'd like the user to be able to just hit the enter key after...

Hey y'all, I have a database that generates a lot of reports based on parameter queries. However, I'd like to add a search box to the reports so that the user doesn't have to keep returning to the home navigation form in order to open a new report. I've put some leg work in to get it to work...

Hey y'all! You know this box: Does anybody know if there's a way to get the "Enter Parameter Va... ?" text banner at the top of the box to not appear? Or change the text there? Best- Mike

This has really stumped me.... I have two identical reports, "School Search by Name" and "School Search by Address". The only difference between them is the parameters used to load the reports. Three fields in each report are conditionally formatted to appear the same colour as the background...

Hello, My name is Michael Nyby, I'm an LIS worker in Canada, currently employed in a school board archives. I learned how to use Access in a Database Management class I took last year as part of my MLIS but I'm going much further in depth with Access in designing a database for my archives...