Search results

Hi guys, Trying to develop what should be a straight forward report but having problems with the queries. Is there a way to return multiple columns in a query with sums of a particular field under different criteria? To be more specific, I am trying to write a query which returns the sum of...

Hi guys, I have a subform that is filtered by a combobox on my main form. The subform filter is set and enabled in the AfterUpdate event of the ComboBox as described here: https://access-programmers.co.uk/forums/showthread.php?t=172503 Works fine. The problem is that after the filter is...

[Solved] Queries with a table of related records Hi guys, Having a problem here and I can't seem to figure it out. I have a query that provides records for a form. That query has its primary table which holds associations between records in another table. The query has duplicate 'cascades'...

I have a form that does some checking in a Command_Click event to see if the associated record is valid to be updated. Everything works fine EXCEPT that the user can still save an unverified record by changing some of the fields and hitting SHIFT+ENTER. I have looked around and it seems the...

Hello, One of the functions my database needs is to inventory equipment in relay racks (a couple of thousand). The way I had in mind to implement this is to have a table of racks that users enter with the size in rack units (with other information) and a separate table of 'rack positions' that...

Hi guys, I have a report based off of a query which pulls data from multiple tables. I also have a search form to locate a specific record. The search form works fine and on the form I have a button to open the report with: DoCmd.OpenReport strReportname, acViewPreview, , strCriteria No...

Hello, I know how to sort the results of a query alphabetically but I was wondering if there is an easy way to have one specific value out of order. I have a list of about 30 options with one of them being 'N/A'. Is there a way to have the options sorted alphabetically but then move N/A to the...

Hello everyone, I have a form that uses a search example from John Big Booty (which works flawlessly, thanks John!) that populates a list box with search results as a user types. I would like to take it a step further and populate text boxes on the same form with the currently selected record...

Hank from NY, just signed up. I am currently working on a large inventory database and re-learning programming in the process. Many years ago, I knew Visual Basic 3 well enough to write several programs and I have a basic/beginner understanding of Access and trying to pick up VBA. I was looking...