Search results for query: *

First Thank you everyone for the great posts here. I have learned alot about access from here. You have saved me unmeasurable time in organizing data. I am trying to maintain a database of all the autocad drawings on a specific public drive. The code bellow allows me to add a new record...

I currently have a button on a form that runs some vb code that takes about 45 sec to run. Because thats a relatively long time to think your computer has frozen up, I want to change text in a text box me.text10 to different values in the code. IE me.text10 = "Starting", me.text10 = "step1...

I am looking for an easyer way to do a task. I want to maintain a database of aproximately 2000 drawings. currently I run a .bat routine to generate a text file that has all the .dwg files on a paticular drive. the routine is simple. make_dwg_lst.bat dir *.dwg /s >dwg_lst.txt This generates...

I am making a database that lists about 2000 drawings. I would like to be able to view a thumbnail of each drawing as I look at its entry. The entry includes path, file_name,type,project_number and a few other bits of information. I can already put 1 thumbnail in but it doesn't change with...

I am trying to help a friend with his database. He currently has a way number (way) and a batch number(batch) the batch number needs to be unique but it is always similiar to some other batch number. He wants to pull a number from a list change it ie BID1111 to BID1112 and then make sure that...

I am looking to create a text file through access. Right now i have code that moves a drawing file (.dwg) to a new location based on some orginzational criteria. What I want to do now is create a text file with the name old.txt. (where old is the old .dwg file name) that says "file was...

I have the task of organizing a group of ~1700 autoCAD files. The first step I did was make an access database of all the files and where they are currently stored. What I want to do is after I've looked at a drawing and determined where it should go is press a button and move that file from...

How do I make a combo box so I can add more inputs over time from the same form. For example I have a form with a combo box that lists persons names. If I want to put a different persons name in than is on the list I just type it in. This doesn't end up adding her name to the list. Ist there...

faq705-2484 I'm having trouble trying to use this FAQ. What am I doing in this line of code? Dim cmdlgOpenFile As New clsCommonDialog I am using Access97 so I commented out the section talked about here but where is this CommonDialogConstants module stuff he is talking about. ' Values for...

Hi everyone, I'm fairly newat using access but I'm getting there. I am trying a project to import data into an access database. I have a group of 1700 files (AutoCAD drawings) in a number of sub directories that I'm trying to collect data from. I am mostly there. The database currently has...