Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mkatz13
  • Content: Threads
  • Order by date
  1. mkatz13

    Workstations can't find Access Application after compact

    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...
  2. mkatz13

    User Defined Fuction In Excel

    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...
  3. mkatz13

    How to Create Shared Spreadsheet Using Output to

    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...
  4. mkatz13

    Obtain Data from serial port

    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...
  5. mkatz13

    Create a row in excel from an access record

    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...
  6. mkatz13

    Compact and Repair Causes Problem

    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...
  7. mkatz13

    Update Text field from text file

    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...
  8. mkatz13

    Serial Port Device

    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...

Part and Inventory Search

Back
Top