Search results

I have a form based on a query where the data can be filtered by the AutoNumber ID. What is interesting with this is only certain ones will show data and others pull up blank. The function is to show an expanded view of the entry selected. The only criteria is this AutoNumber so something...

I have a button on a form that exports a query to Excel. When trying to export I get a prompt to enter a parameter value. I'm not entirely sure what would cause this. Everything has been verified as being spelled correctly and past that I am lost. I do not have access to the database and...

I have a form which I want to use to update data as needed. I keep receiving the notice that the recordset is not updateable. While trying to figure out why I came across this Now unless I am reading this wrong, this says I can make changes to the data on the "many" side without any issues...

I have a form that allows a user to add new suppliers to the database and add all the relevant information. The suppliers are grouped into categories and sometimes one supplier fits multiple categories. When adding the information, how would do account for the possibility of the supplier being...

This is more of a just curious type of post: Can details be grouped in a form like they can in a report? I have contractors that I am wanting to display based on criteria from an unbound form. There are some contractors that belong to multiple categories and this causes extra records to be...

I am in the process of creating a database component for the contractors allowed on location. The idea behind the end product will be allowing the user to select a work type (Electrical, Mechanical, Environmental, etc) and then display all the contractors of that type. The part I am confused...

I understand the title says it is for Excel but bear with me because the code is being run through Access. I am exporting data to Excel to generate charts. I am about 98% done with this task but I am missing one chart that I am trying to base off a pivot because I do not know a better way to...

I am stuck on how to solve this issue. I have a query that I am running to get specific issues based on supplier and date range. For the date range portion, I am applying a filter directly to the form when it opens. By doing this however, I am unable to export the filtered results. I have tried...

I have code that is sorting data and putting it in various cells on different sheets in Excel. I created the code in a test database and it worked like a charm. However, putting it into the database that will distributed for use it errors. The relevant code is below. Dim xl As Excel.Application...

I have a generating a subform based on user selections from a previous form. Subform is based on a query. One of the options is to sort the data by date. Instead of using the date as criteria for the query, I am applying it as a filter when the subform opens. It all filters and displays the data...

If DLookup("[Supplier Code]", "tblSuppliers", "[Supplier Code]= '" & Me.cboSearchByCode & "'") Then DoCmd.OpenForm "frmTaxInfo" Forms!frmTaxInfo.Form.Requery Else MsgBox "Supplier Code not found" End If I am using the above code to test if the supplier code exists in tblSuppliers...

I am curious how focus is set during a continuous form. I have a continuous form that displays the information from a user selection. The user has the option to not select any information, thus the creation of the continuous form. I have a few hidden fields on my form and based on the value in...

I am creating a database where one of the functions is to display a contact rep's address. I have created tables for the different components of the address (i.e. States and Countries) and have set the relationships to the contact table as appropriate. In the states and countries tables there...

I recently launched my first ever database and I am receiving feedback about all sorts of bugs with it. I built it as a intern project and I am afraid when I leave, if it messes up anymore, it will make it useless. It is not a problem since I am still here and can fix/add things as needed. I...

I am receiving the error above when I am trying to move file locations from within Access. Files are being moved from a local computer location to a shared server location. The file types will vary but will be, for the most part, PDF PowerPoint or Excel. I have run through the process that is...

I have an unbound form with various criteria selections available and I am trying to add a new one to the ones already there. I am wanting to add a text box to perform a partial field match on a table. I have put the text box name in both the criteria field and the parameters menu and it works...

Simple question: When any changes are made to a record in a continuous form, are they saved when moving to the next record automatically or at some other point? Basically I am having three fields that need to be populated via a form and for user simplicity would like a button that saves any...

With .Workbooks.Open("R:\0.2.2 Procurement Dept - Shared\3.0 Groups\SQD\FTTQ Charts.xlsx") lngLastDataRow = .Worksheets("ChartData").Cells.SpecialCells(11).Row .Worksheets("ChartData").Range("A" & CStr(lngLastDataRow)).CopyFromRecordset rst...

I have a form that allows the user to select criteria and have a query return the results. The problem I am having is with using dates. Right now, I am using a filter on the resulting form to get results in a date range. The end goal is to send the results to Excel and I do not believe mixing...

Set sMyPath = Application.FileDialog(msoFileDialogOpen) strFolderPath = Me.FolderPath Debug.Print "Looking for: " & strFolderPath & "*" & strBodyNo & "*" strFile = Dir(strFolderPath & "*" & strBodyNo & "*") Debug.Print strFile If (strFile <> "") Then Response = MsgBox(strMessage2, vbYesNo...