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

    Not Recognizing Secondary Slave

    About a couple of weeks ago, I installed IDE devices set up as such: Primary Master: 20 Gig Main Hard Drive Primary Slave: HP CD-RW Secondary Master: 4 Gig Hard Drive Secondary Slave: CD-Rom When I first set up this system, I burned a few CDs from the Secondary Slave to...
  2. BanditLV

    Scrolling Mouse

    Any way to disable the wheel on a wheel mouse so that some rambunctious mouse user doesn't roll their way into a fresh form? I've had some issues with my system because of it...
  3. BanditLV

    .DBF Memos

    I've been trying to import .DBF files into Access 2000 - I have no problems until I get to Memo fields. These Memo fields seem to longer than the importing capability. Some of the Memo's are extremely huge. The only way that I've been able to maintain integrity of the field is to export them...
  4. BanditLV

    Archiving Records between Linked Tables

    I have a front-end .MDE that is linked to several back-end databases (to minimize size and possibility of loss of data)... Everything revolves around the ClientID in Client... In general, I would have tables such as this: Client Client Expenses Client Creditors Client Notes The...
  5. BanditLV

    Loss of Data in Table

    I have two sets of users on a Network based system (I believe Linux (groan later, k? heheheh))... A user entered information via an MDE linked to the Data Tables - roughly six rows of information... When our user in Dallas opened up the same information at a later date (a couple of days to a...
  6. BanditLV

    Changing Printers

    I wish to change default printers in my module coding using Visual Basic... The issue: The database I'm working on needs to print either using a printer connected to the network or use a Fax Printer driver, depending on what the user chooses... What seems to be happening is the fact that...
  7. BanditLV

    Importing Text File Data

    I'm trying to import data from a Fixed-Width Text File however, I've come to find out that the length of each line in the text file is quite long... I tried to import it first to Excel but when I did that, it would cut off some of the needed data in each line because Excel only imports to...
  8. BanditLV

    Still having access problems with Access 2000

    Platform: Windows 2000 Software: MS Office 2000 Network: dual Gigahertz processors Users: 7 Terminal Server users, 40+ Standalone systems Layout: BE: Tables FE: Forms,Queries, Reports, Modules Circumstance: Two or more people accessing the same database but going into different...
  9. BanditLV

    Access 2000 Exclusive Access Error

    System = Windows 2000-based dual Gigahertz processor server Program = Access 2000 Situation: Two programmers working on the same database on a network server... Both programmers are getting the error "You do not have exclusive access to the database at this time" Anybody know about...
  10. BanditLV

    Shutting Down an External Application

    I have a system working on a network that is utilizing digital cameras for Internet interaction.... We are utilizing three different camera programs on three different servers to allow use of a camera program should one of the servers fail... When the end-user system is booted up, one of the...
  11. BanditLV

    Upgrade to Access 2000 necessary?

    We're running a database that is approximately 200+ Megabytes in size with some tables reaching 1 million or more records... Would it be more efficient to upgrade to Access 2000? If so, could I get some reasons? Thanks in advance, Roy (aka BanditLV) Las Vegas
  12. BanditLV

    Combining Reports

    We are looking to sending some reports out using a fax program (most of them are long-distance and we would like to see the reports faxed out once) However, some of the reports that we are sending, are multi-paged - I've utilized all four page possibilities (Page Header / Footer, Report Header...
  13. BanditLV

    Backup / Compact Database Remotely

    We want to write a database that will Repair/Compact/Copy another database every night at a given time... Has anyone done this before and can advise? Thanks in advance, Roy (aka BanditLV) Las Vegas
  14. BanditLV

    Different font characteristics in Report

    Does anybody know of any special coding that will allow me to change a Text Box of a report to show different characteristics within the same Text Box? ie: "Your payments must be deposited in your checking account before your due date. I would like the font to be a Times New Roman, 10 pt...
  15. BanditLV

    Inactivating Mouse

    I am setting up an automatic drop-down, however, throughout the whole database, there are places where I want to turn the mouse "off" (not accepting any mouse clicks or moving of the mouse pointer)... Anyone know how to do this in Access 97? Thanks in advance, Roy (BanditLV) Las...
  16. BanditLV

    Working with Reports

    I would like to make a report setup like a letterhead... However, I'm putting all my address information on the left-hand side... The problem comes to be if the report has more information than what is allotted... ie: I have a line on the left hand part of the form with a length of...
  17. BanditLV

    Reporting Options

    Looking to have the Page Header print, starting ONLY on the 2nd page... Anyone know how to do this?
  18. BanditLV

    See if an external file exists from within Access

    I have the following line in my Module: Call Shell("C:\WINDOWS\NOTEPAD.EXE c:\Progra~1\RPS\Create\Reject.fil", 1) However, there will be instances where this Call line will not find the file of "Reject.fil" and will ask the user if they would like to create a new...
  19. BanditLV

    Modify / Delete files via VBA

    Is there a way to delete / rename files through VBA? For instance, I have a file C:\Progra~1\RPS\harbour.dbf that I want to delete because I'm getting ready to overwrite it utilizing another program within Access - each time I use the program, it adds another file called harbour1.dbf or...
  20. BanditLV

    Remote location situation

    I have two locations - one in Las Vegas, one in Dallas... I tried both copies, one .MDE and one .MDB of the same database... Betatested on local machine (both copies) in Las Vegas produced no errors... Tested full version copies (both .MDE & .MDB produced errors)... Both sites are full...

Part and Inventory Search

Back
Top