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 TouchToneTommy 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: sathandle
  • Content: Threads
  • Order by date
  1. sathandle

    Duplicate Order Details and Increment

    I have an order fulfillment application that is trying to generate multiple copies of the same order so the order document can be placed on each individual box. How can I create a data source that duplicates all of the orders a given number of times. Therefore, if I need 7 copies of Order...
  2. sathandle

    Print Multiple Copies of Same Report

    I have an order fulfillment application that is trying to print multiple copies of the same order so the entire order document can be placed on each individual box. How can I have Reporting Services print the order X times with a number on each print? Therefore, if I need 7 copies of Order...
  3. sathandle

    Change Linkage on tables to Access From SQL Server

    I have a db that has several linked tables. They are currently linked to SQL server (MSDE Client). I want to change the properties of the links to link the tables to an Access db. When I run code that will automatically link the tables that includes the following Dim oCat as Catalog Dim...
  4. sathandle

    BIOS not adding failed drive to drive table

    I have an older IDE hard disk that has a confirmed failure that is being recognized by the BIOS, but the BIOS fails to assign the failed drive a drive letter/allow the machine to recognize the drive/add the drive to the drive table so I can run my data recovery software. I am running Award BIOS...
  5. sathandle

    Code Running when Form Opened in Design View??

    I have a form that is running code when it is being opened for editing in design view. The steps I am doing is as follows: 1. Open database using shift key bypass. 2. Highlighting form. 3. Click on Design so I can make changes to the form 4. I am now prompted for my territory (i.e...
  6. sathandle

    Disappear - ing - Control Properties

    I have a combobox control on a Form that has been "losing" it's properties. The font is re-setting itself to 25856 and the list rows has been re-set to 25088. The width has been re-set to 0" from 2.44". The original name of the control was cboModelName and there was an...
  7. sathandle

    Form_Current on First Record when Form Opened

    In the Access 2000 Developer's Handbook (Getz, Litwin, Gilbert) it states the following (pg. 26): "When you open a form, the following events occur: Open --> Load --> Resize --> Activate --> GotFocus --> Current --> 1st control (in tab order) Enter -->..." Does the Form_Current...
  8. sathandle

    Current Hardware Profile Registry Key

    How can I pull the current hardware profile on the machine running my Access database? I have users that may be using the database on laptops in the field with dial-up access only. I want to prevent them from synchronization over dial-up and force them to only synchronize over the LAN...
  9. sathandle

    No Read Permission Error - Reading MSysErrors - Replication

    I am receiving a "No Read Permission Error" (Error # 3112) which states: Run-time error '3112': Record(s) can't be read; no read permission on 'tablename' OS: NT 4.0 Access ver. 97 Workgroup Information File: Default (no changes to security model) Any ideas? I am trying to read...
  10. sathandle

    Determine Windows Version using VBA

    How do I determine which version of Windows a person is using via VBA? Thanks! definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."
  11. sathandle

    Determine Access Version using VBA

    How can I determine the version of Access a person is running using VBA? definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."
  12. sathandle

    Shift Key ByPass & MDE

    Does an MDE disable the Shift Key ByPass? What happens when you Shift with an MDE? Thanks, SAThandle definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."
  13. sathandle

    Access 97 to 2000; convert; DAO

    I am programming a database in Access 97 and know it will be used by a lot of users running Access 2000 who will have "no clue" [thumbsup2] how to modify their add-ins to use the DAO 3.6 add-in unless it is automated in the program. Is there a way to do this in my Access 97 code if I...
  14. sathandle

    Tab Control & Pages - "Disable" Inactive Pages

    Is there a way in Access 97 to show pages in a tab control that do not have the focus as enabled = false? I have tried the following: 1. disable the entire tab control & change the on click event of the "active" tab to change that page's property of enabled to active. No click...
  15. sathandle

    Outlook File Size

    What is the maximum file size for a pst file on Microsoft Exchange Server? The client machine is having problems processing the network based pst file which is around 140MB. Is this normal (not the file size, the inability to process the file)? Other than dumping the year's worth of e-mail...
  16. sathandle

    Is Failure of JET SQL/Access Possible?

    Access 97 Is is possible for the JET SQL to become corrupt (i.e. too many design time changes?) and thus not run queries properly? The query was working flawlessly the other day (likely story)... I have made no changes to the module used by the query, the query itself or the table underlying...
  17. sathandle

    Security-partial access to data

    Is is possible to limit a users access to part of a table? I want to have a consolidated organization wide listing of customers, but I want to limit each division to just changing their own data. The users need to be able to view other organizations data but they cannot change it. I would...

Part and Inventory Search

Back
Top