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...
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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.