Search results for query: *

Hi all, I have read a few posts similar to what I'm trying to acheive but without anyone actualy seeming to come up with an answer. The problem I have is :-- Sheet 1 contains all my report data. I want to strip certain values/cells into a new sheet to for a table. I want to do this by...

I have a database that was created in Access 2000. I'm in the process of testing the database in 2003, however if I try and edit any of the vba code in 2003 I get a C++ runtime error and the prgram closes without saving. I have tried to convert the db to 2003 and this makes no difference...

I currently have a form with two list boxes. The first list box call up an SQL statment. I then have a command button which using an addition query allows you to select one row at a time and add it to the second List box. I also have a second command which copies all the entries across...

I have been trying to write a sub which would look in a folder and delete only certain file types. for example the folder would have three file types but I only want to get rid of 2. I hav tried something like this. Dim PathnameDGN Dim PathnameDWG PathnameDWG = DrgDest & "*.dwg"...

I have been working on this module for a while now. I have made progress with help on a previous posting but I seem to have hit a wall. Basically I have a recordset that I want to loop through. Within each loop I want to set VARIABLES from certain feilds within the Recordset. I then use the...

what i'm trying to acheive is basically done in 3 stages. 1) I have a select query which displays in a list box. 2) I would then like to use that information from the list box as a recordset to allow me to extract a common data from each record. 3) Based on that extracted data I then want to...

I have two question I would be grateful of some help with. 1) I have a query that I'm exporting to Excel using the transferspreadsheet method. This works fine apart from I keep getting randon errors when the code reaches the format part. Eg exApp.Rows("1:1").Select Selection.RowHeight = 35...

What I'm trying to do is retreive a specific entry from a table to help create a default path. i.e I have a table with all my drawing data in. This includes a path to the drawings. I want to be able to extract that path data into my code in order to help create a new folder below it...

I have a command button which allows the user to open a drawing in autoCAD based on an entry in the database. what I would like is for the drawing to open and run a series of commands automatically. I.e. After the drawing has opened in searches the paperspace and locates a drawing border and...

I'm trying to open a specific autoCAD drawing from access. My code is :- stAppName = "C:\Program Files\AutoCAD 2005\acad.exe" stFilename = Me.CADFilename & ".dwg" stPath = Me.Path FullSpec = stAppName & " " & stPath + stFilename Call Shell(FullSpec, 1) This opens AutoCAD but...

I know this seems to be a common theme but as I'm new to prgramming I'm having trouble understanding how I can do this. I have a code:- Private Sub Command62_Click() Dim strFileFolderName As String Dim cmdlgOpenFile As New clsCommonDialog Const clngFilterIndexAll = 5 cmdlgOpenFile.Filter =...

I have a text file like this. # This file was automatically generated by MicroStation v8 DATA_FORMAT 2.1 GENERATOR MicroStation_v8 DINLASTUPDATED 2004-02-13 15:51:50 START GENERAL BASENAME S11-00 DOCDIR G:\81120\STR\ DOCTYPE MicroStation AUTHOR cbs DOCFILEREF S11-00...

I have a txt file as shown below which is automatically created via AutoCAD. What I want to do is then extract certain information from the txt into my access table. This is a sample of the txt file :- # This file was automatically generated by ARX Module # written at: 16 December 2003...