Search results for query: *

Hi, I am in need of assistance. I have created the following code to export data from an access project to Excel. After running the code and creating the Excel file and then closing the form that calls the code, I am no longer able to re-open the form. Some of the code that is used to load...

Hello everyone, I have created a similar search form as the one used when pressing ctrl f. I know want to add the same functionality to an unbound combo box, of saving the last 5 search items. I tried adding it through code using value list as the source but I'm unable to do it. Any suggestions...

Hello everyone, I have developed a search form that users can call within the active form by pressing Ctrl + F. The search form is composed of a combo box with the column names of the active form and a text box for the search criteria. I currently pass the name of the form and named of the field...

Hi All, I have setup the database mail for users to send emails without problems. Now the need is to also have it send attachments. I have setup a user account with the specified rights to the network folder where the attachments are located. I am able to send the attachments w/o problems since...

Hey everyone, I currently have a list box in a form that populates the ProductID field based on the multi select options. TableA RecordID = 100 ProductID = MEH, AGH, PVH USER = jdoe I now want to populate and sort a list box on another form based on the values stored on the ProductID field. I...

Hi Everyone, I currently bring in a text file into Access. After deleting all unnecesary data I am left with the following table: Description Totals GroupSet CycleDate Cycle Date 05/19/2006 LOB010 010 OFFSET $500 HISTORY...

I am currently able to transfer a query from access to an Excel file using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, QryName1,CreateObject("WScript.Shell").SpecialFolders("MyDocuments") & "\Reports.xls", False, "". How can I open this Excel file after transfering the data...

Hi All, I was reading thread705-805911 where exporting data to "My Documents" folder can be done through DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "QueryName", _ "C:\Documents and Settings\" & Environ("username") & "\My Documents\" & strFileName & ".xls", True, "" Some...

I currently have a form with several combo boxes where some of the fields are strings (text) and others integers. I am creating a query with criteria based on the combo boxes; however, I am having problems retrieving data when the integer fields are left blank. Here is the code and thanks in...

I am trying to create a multiselection criteria form for users with no prior knowledge of Access. In this form, they would select fields from different tables, one at a time. On one subform, I would like to display those available fields and on the other subform, the selected fields. I then...

Hello everyone, When doing a search on data in an Access form, the dialog box comes up with the "match" drop down defaults to "whole field". Is there anyway to make this default to "any part of field" instead or "Start of the Field"?... Thx!

Hello everyone, I currently have a form that has demographic info like ID, NAME and a search criteria like TASK_ID and LOCATION_ID. I created a button that would open a matching report based on other participants information matching that on the form TASK_ID and LOCATION_ID. When compiling the...