Search results for query: *

I am having a heck of a time getting fileDiolog box to open so a user can select a file to import into an access tbl. I am using the following code but get a compile error stating that ahtAddfilterItem "Sub or Function Not defined" Dim strFilter As String Dim strInputFileName As String...

I am exporting a query to excel using the following code: DoCmd.OutputTo acOutputQuery, "AllOut", acFormatXLS, , True It creates a new excel file called AllOut and places the information in a worksheet that it names AllOut. Where that works I would like to take this to the next level and just...

I am having a problem keeping formatting after a mail merge has completed. Here is the issue. I have formatted in access a field as a percent. In access I see 50%. But when I mail merge it, to a word document reads .50 does anyone know how to make word read as 50%? Thanks’ Andy

I have a command button that, updates data in a table then starts the mail merge wizard. The user then selects the directory and the name of the file to merge a presto works great. Here is that code Dim StrName As String ' This deletes the content of a table and replaces it with new...

I need help in setting up a command button to mail merge a query with a Microsoft word Document. The word .doc already has the fields set up in it so only need to have the user hit the button within a form and it opens the doc with the merged fields. I did try using a hyperlink to the...

I have a form that when is opened executes a parameter query. What happens is the form opens and the first thing asked is to enter a date, so the user Types in a date (fat fingers) and poof the record set selected and only returns the desired date. Once the parameter query has been...

I am having a difficult time applying a filter to a form. What I have is a form that’s control source is a Query with several fields on the form. One of the fields is named JobFunction and that is the field I want to apply the filter too. What I would like is for the user to open a form then...

I have a form that has 2 sub forms within. I also am using a Combo box to select data then have that data updated to field located within the form that the combo box is located.. What I would like to do is have the combo box update (with the same data) a field in the sub form. Is that...

Is there a way to have a command button output a Report to outlook email as a snapshot or excel file?

What I would like to do is have the user be able to select a file located in a directory using a combo or list box. So when the user clicks on the combo box a drop down list appears that lists all the files in a specified directory. Can that be done and if so how would I set it up?

Is there a way to have a combo box, or a list box, list the files on a Directory? If so how would I set it up?

Is there function that will delete all files within a table?

I want to import data from a txt file and update fields within a table. More specifically what I am looking to do is have the txt file open then evaluate each record within a table to match a unique identifier. When the match is made I want the “Empty (null)” fields within that file to be...

I am importing a TXT file into a table in access. Each field and each comma delimator has been set up and there are no errors in importing the text file. What I want to do is set up a command button and a function so that the user can click on a command button and import the file from a saved...

I Want to update a memo field in one table with several different records of another table Text field. Here is my issue I have two tables. One is the main table with several fields one of them being a Memo field. The other table is where each record has a field with text data and another...