Dynamic query setup with 2 criteria’s ?

Hi , (1) is it possible to create a dynamic query through a form that’s based off 2 inputs criteria that will then generate the query ? (2) If so , will I then be able to transfer the dynamic query result into a report ? submitted by /u/whoslookin_ [link] [comments]

Inventory Solutions

My job is selling vehicles to companies. However, we may not always have what they are looking for at moment’s notice. My solution: Create an ongoing access database that hold’s the customers specifications and is linked to their contact information. Upload the excel file with our current inventory so if something matches all the specs … Read moreInventory Solutions

Created a form button that copies the text from another field, but how do I prevent a null error in the event that a user clicks the button when that other field is blank?

So I have the below code set up in a macro button. The button is intended to copy the text from the “Start Date” field on the form for the same record when clicked. The problem is, I am getting error “Run-time error 94: Invalid use of Null” when the button is clicked and the … Read moreCreated a form button that copies the text from another field, but how do I prevent a null error in the event that a user clicks the button when that other field is blank?

Issue with Space in Query Name

Function Export_Query_Loop(query As String, fname As String) Dim db As DAO.Database ‘used for opening connection to current database Dim qd As QueryDef ‘var for holding copy of sql query for passing variables Dim strSQL As String ‘var for holding copy of sql query for passing variables Dim i As Integer ‘counter for loop Dim Path … Read moreIssue with Space in Query Name

How can I update a form field’s Control Source to request a count (from a SharePoint list) of items that match an account number currently displayed in the current form record’s Account Number field?

So, I have the following Control Source setup in an unbound field in a form to display a number count of the # of specific items in a SharePoint list… =DCount(“[ID]”,”SharePoint List”,”[Status] = ‘Pending'”) …but how would I update this Control Source for an additional, unbound field that would make the same query, but ultimately … Read moreHow can I update a form field’s Control Source to request a count (from a SharePoint list) of items that match an account number currently displayed in the current form record’s Account Number field?