Recent content by BanditLV

Sorry Ma5... Still the same thing - removed the drivers and restarted - came right back as if nothing happened... I did this for both channels... Roy aka BanditLV Las Vegas, NV RLMBandit@aol.com

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

If I'm not mistaken, it seems that you're capturing the lookup values via a query... Select the query to be Distinct Values... This will make the lookup specific... Roy aka BanditLV Las Vegas, NV

Hi Will! Try doing this: Format(blahfield,"Standard") I believe Standard format gives the thousands separator... Either that or "Fixed"... One or the other... Roy aka BanditLV Las Vegas, NV RLMBandit@aol.com

This sounds familiar - I believe I came across this same issue. First, the best way to move between tabs automatically, if you're looking for that as well, is to send control to a field inside the tab. If it's within a subform, make sure you reference the subform in addition to the field name...

I concur... If you're writing a query, you need to use the following expression in the criteria: Between #01/01/02# and #05/16/02# - or - > #01/01/02# - or - Between [BegDate] and [EndDate]

I've done this so many times, I can do it in the dark (as long as my fingers are on the homerow keyboard keys - hehehehe)... Dim Dbs as Database Dim Rst as Recordset Set Dbs = CurrentDb Set Rst = dbs.OpenRecordset("NameOfTable",dbOpenDynaset) '*** NOTE - when opening a...

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

Well, in all actuality, the databases I'm converting are in Alpha, which uses the same theories as FoxPro and Paradox when it comes to database management. I'll look into the documentation in regards to the size of the Memo fields and if they're kept in a different file. Thanks for the...

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

By request, this is one of the queries (SQL-based) that deletes the archived records... The appends work fine, of course... DELETE Client.Status, Client.* FROM Client WHERE (((Client.Status)=83)); Roy aka BanditLV Las Vegas, NV

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

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

This is the code I use to access Recordsets and I haven't had any problems using either Access 97 or Access 2000: Dim Dbs as Database, Rst as Recordset Dim Ctr,Ttl as Long Ctr = 0 Set Dbs = CurrentDb Set Rst = Dbs.OpenRecordset("Name of Table/Query",dbOpenDynaset) DoCmd.OpenForm...

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