Search results for query: *

Hi all I am doing a mail merge and have a tab delimited text file with 10 fields as the data source. I only need the data from two of them - the product number and price. There are a lot of duplicate records that I would like to not merge into the mail merge template. I cannot alter the data...

Hi all, I have an ADO recordset that is populated from a stored procedure that uses several functions to concatenate one of the fields of the recordset so as such there is not a direct field name to reference in the sort (i.e. <% rs.Sort="CompanyName,ContactName" %> ) I know that there is no...

I currently have a module that has global variables set at the top. I would like to however store these values in a table so that I can build a form for someone who does not know VB and they can go to the form and change the settings, or values of the global variables. I would like to set the...

I am trying to automate an import process and was wondering if anyone has had any luck building an import specification on the fly from VBA. I guess it would have to consider the list of fields and the delimiters etc.. If anyone has, or has any suggestions on how to accomplish this (if even...

Hi all - I m sure this is easy I have just never done it programmatically though... Is there a simple little VBA script that will stuff the fieldname that is the primary key of a passed in table into a variable? Thanks in advance!!!!!!!!!

Hello all- I need to compare two different datasets of identical databases. BY this i mean that I have two databases with identical structure (tables, fieldnames etc) however in one of the databases, some of the data has changed. I need to see the differences in what has changed similar to the...

Hello all - I have a database table that has a column of usernames. the usernames have the domain attached into it. I am looking to strip this domain and leave only the username. so for example.. home/JDoe home/WSmith home/BMorris home/MHunt home/JMama ...would be possible values of the...

Anyone have any ideas how to create a function that would change the datatype of a table field?? I have data that is imported to access so it is put in as text and I am hoping to run a macro to convert the text field to a DATE field so that a report can properly calculate things. was thinking...

HI All- The title sorta sums this one up.. What is the best way in Access 2000 (expression builder) to replicate the COUNTIF functionality of Excel In case you are not familiar with this, it essentially scans a field and counts the number of a specified instance. So my text box calculates...

hi all - I have a form with a lot of records in it ( > 150) on this form is a button which generates a word document report based on the info in the form I need to create a macro/function that will trigger the report generation function advance the form recordset and repeat until it gets to...

Hi all! I have placed the attached code into the code window of MS Word's Normal.dot in the Document_open event so that it will run automatically (I highlight all the docs that I want affected by this script and press enter to fire them all off - this method works fine - just some background)...

Hello- I have a MS Access app that has a form with a list of information. There is a preview button on it that calls VB code which appears to generate a Report on the fly. What I am looking for help with is to then take this report and print it to a PDF. I have run through the process manually...

When trying to fire up the Documenter in Access 2000 (Tools--> Analyze --> Documenter) I get the following error: Object Variable or With Block variable not set any ideas on how to remedy this and get to the documenter?? thanks in advance