Search results

I have several .csv files in a common directory that are sporadically updated. Utilizing a Start Date prompt and an End Date prompt, I want to import the files in the directory that coincide to those prompted dates. Start date: 7/12/2010 End date: 7/14/2010 Files in directory...

I was wondering if anyone had code examples for emailing the contents of an entire folder? The folder can have multiple file types in it (excel, pdf, word, etc) but every file need to be linked to the Outlook e-mail that Access produces. I was trying to use this, but it completely ignores this...

Ok, this is driving me nuts.... Utilizing Access 2007 I have a report that I want to export as a PDF. The report is based on a query that calls for the specific ID number from a form (ID = [Forms]![frmPeerValid]![ID]). Query works fine, and if you open the report it works fine, but when I...

I have an Access 2000 Db that exports information out to an Excel Doc for analysis by individuals in another department. These individuals are not Access savvy and need it to be in Excel. They open the document make changes and save it. Upon request they tell me to add additional information to...

Hi All: I am in need of any samples someone may have to insert rows into Excel and then sum data based on the individuals ID numbers. An example of the export is attached with both the way the export is delivered to excel and what it needs to look like after the update. Any help would be...

Hello All: I've drawn a blank and for some reason can't get my code for exporting out records to multiple excel sheets to work. The code is as follows: Dim MyRS As Recordset Dim SID As String Dim MyQD As QueryDef Dim StDt As Date Dim EdDt As Date Dim MyStr As Variant SetWarnings = False...

Hello All: I have written a module that creates a .bat file and runs it to generate a specific Lincese key for a customer. The procedure works great: 1. Creates the .bat file 2. Pauses while the DOS cmd opens 3. SendKeys ENTER to run the .bat 4. .bat returns a .txt file containing the license...

Afternoon Folks... I have an export that comes out of Siebel that we import into an Access 2000 Db. I import the csv file into a temp table to do some separation into two tables (this Normalizes the information in the database). The problem that I have is that when there is a NULL value in a...

I was wondering if anyone had some experience with creating a module to rank according to a priority. I know how to create a module and query to rank based on a cost or date, but this is a little different. I have a table tblTicketEsc that contains the following fields: TicketID - Unique...

Ok I'm stumped...I had the following code on the OnClick event of a command button: Private Sub cmdExpCust_Click() Dim strPath As String Dim xlApp As Object Dim xlSheet As Object Dim rdCnt As Variant Dim rwSet As Variant txtDat = Format(Date, "mmddyy") strPath =...

Anyone have any suggeestions on how to convert the following query output: VclID Option 1 Power Steering 1 Power Windows 1 Cruise Control to VclID Option 1 Power Steering, Power Windows, Cruise...

I've been reading throught the old posts, but can't seem to grasp this: I have a table of Bids containing the following MemberID, VehicleID, AuctionDate, ChoiceNumber. What I need to do is to rank the bids from 1 to ....(however many there are) based on the lowest BidAmount within the form by...

I have a form that contains a listbox with Emergency Contact information for employees. When a user selects one of the rows in the listbox the detailed emergency contact information is populated on the form (Name, Address Phone number, Order Number, etc). One of the detail items is Order...

I have created an Access 2000 database and have utilized the Microsoft DAO 3.6 Object Library for some of my code. When converting this to 97, an error "Your computer is missing at least one of the Microsoft Access 97 object libraries. Your converted database will not work...blah, blah, blah". I...

Ok, here we go... I have a field called Attributes in a table which is fed from a website download and looks like this: Example 1: Axis:90; Base Curve:8.6; Color:Aqua; Cylinder:-0.75; Diameter:14.5; Power:+0.25 Example 2: Base Curve:8.4; Diameter:14.0; Power:-5.25 Example 3: Base Curve:9.1 (...

I have a listbox (based on a Like "*" query) on a form that needs to update when a user enters names into a textbox on the same form. Here's the catch, the listbox needs to update after each letter is entered. In otherwords, if I am looking up SMITH, after I type "S" all the names like "S"...

I have a current form with a Tab Control Containing 3 Pages: Page 1: User enters Customer Number and gets all information Customer Page 2: A subform on this page pulls all order numbers and limited order information for the customer (based on data entered on Page 1) in a continuous form view...

I have 3 queries each one is built from seperate tables, but all can be linked by a unique ID number. I need a query that by matching the ID number will give me each line of data from each query in consecutive order. Example: Query 1 has ID number, Name, Address Query 2 has ID number, Area...

I have code that exports a Query to Excel via VB Code. I was hoping that someone knows of code to add rows in Excel to the beginning(2 Rows) and end of the export(1 Row). I have attached an example of what the final export needs to look like in Excel once completed and below is the code...

A car company currently has a Color field in main table of their database that is linked to a sub table containing a list of colors (black, red, blue, yellow, etc). I want to change it so that on the Main form, when a user clicks a command button the color pallet appears and they can select the...