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]
Trying to type code in the Microsoft Visual Basic for Applications screen and the cursor keeps auto backspacing after pressing space, moves around and when I type a quote (“) it adds two or three. Also when typing the cursor will jump to a random spot! What is going on and how can i fix … Read moreMicrosoft Visual Basic for Applications cursor keeps moving
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
Hi guys this is for a telephone call audit tool for work purposes. My project is now completely FINISHED and I owe it so much to you guys thank you for all your help. I am trying to add an improvement where, if one person is in the process of writing an audit for a … Read moreHow to tell if another user is looking at a form on a specific person?
Hi, is there a way to create a report in MS Access that shows the following photo click here for photo Yellow will be an input and based off the input it will return data to the blue cells with respect to the headings in column A. E.g. if we choose code ‘A’ and location … Read morereport formatting with options/criteria
This is more of a SQL question but deals within MS Access so I’ll try both subs. Here is my code: Private Sub FileLocationInsert(FileLocation) Dim sql As String sql = “insert into [REF_LettersFilePath](File_Path) values (‘” & FileLocation & “‘)” CurrentDb.Execute sql End Sub How can I add a WHERE clause to the SQL statement so … Read moreHelp with VBA to insert file path into table.
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?
So I have 2 tables I’m working with here. Table 1 – serial numbers and part numbers. Serial number is the primary key. Table 2 – data about return authorizations. The primary key is just an auto number, in case the drive gets sent out and returned a second time. Goal – have a form … Read moreHaving trouble creating linked forms
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
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?