Search results for query: *

Thanks , but I fixed it a different way. Seems on compact the new file produced takes on the attribute of the user's temp file. Setting the temp file to shared solces it. Mike

zeven tried writing batch files moving mdb to desktop and then back to mydocuments folder. Still cant open from client except after I drag icon outof my documents onto desktop and then dra it back. Otherwise get message cant find file from any owrkstation nexcept machine app is placed on ...

After I run compact/repair on a mbd file the workstations cant find the file, they say path not found. I'm on an ethernet with 3 machines. If I move the mdb file out of the "my documents" folder and then move it back eveything is fine again. Its access 2000. Any ideas would be appreciated as I...

Got it thanks to all who responded

Thanks , just what I was looking for Mike Katz

I have a workbbok with 13 sheets, one for each month and a summary page. I have used the macro recorder to create a macro that copies cells from the summary page and pastes the values into the cell where the cursor is when I hit the hot key for the macro. The recorder produced this code...

I create an excel spreadsheet from access usnig the DoCmd.Output to method. However, the spreasheet is created in exclusive mode only. Since it is linked to other spreadsheets, I need it to be in shared mode. Presently, I need to open it and using the sharing menu save it as shared. I would...

Thanks, I had seen this product's ads and it does seem to do the job. I just thought that perhaps I could keep it all within the app if I could pull the data fairly easily. Like the Active X I believe called MS Comm?? Because I'm not in the programming business and do need to get this going, I...

We currently enter data using hyperterminal into a text file from a measuring device connected to a serial port. I then use low level file functions to put the data into a record. My question is, can I also use low level file functions in place of hyperterminal to "read" the serial...

I need to fill the next row in an excel workbook after a certain event occurs in access using the data from the access record on the corresponding page of the excel workbook. What I am doing is that the excel is an account receivable ledger and an entry needs to be created when certain events...

Hi. I have a 3 machine windows network connected by hub. Two machines run Xp and one is 2000 professional. I run access 2000 on all machines and the mdb resides on a shared folder on one xp machine. All is fine until I run compact and repair. After I run this, the 2 machines on the network...

I thank you Steve for that rapid response. The only thing is that I am only trying to update the present record's memo field with the contents of the entire text file and then want to zap the text file. If I import, then it breaks my data into fields and attempts to create a table, and that is...

I need to put the contents of a text file into a memo field text box control on a form. I could cut and paste , but would like to do it thru automation. I assume that I would do some sort of DDE on maybe the on current property, but I definitely need help. The text file changes as it is...

OK went to the computer store and realized that the connector is not a mini DIN. The only thing that looks close is a 5 pin DIN , so I purchased this and a 9 pin D to put on the other end ( crimp). I'm not due back to work until tuesday, so I need to wait until then to see if the DIN fits. Is...

Thanks piperent. I had visited that site initially and cant seem to get much more than the output is RS232. I've done some looking around and I believe that I may be dealing with an 8 pin mini DIN connector. I have noticed that other foreign makes ( and macs?) use this connector or did use this...

Thanks for answering. It is a Topcon Auto Kerato Refractometer Model # KR 7000 Serial # KB 0301 Mike Katz

My first post. First of all, thanks for all the great info this site offers. I am an optometrist and have a totally electronic record keeping system , all home made using access and now a 4 machine network. I have some computer experience in programming, but the slow transition from a flat...