Search results for query: *

I wrote a system like this several years ago, and it worked well, but there were very specific rules. The program worked in real time, and was up 24 hrs/day, using 24 hour clock. Rules: Can't check in if you haven't checked out. (would not accept the transaction). Can't check out if you...

Access does some complicated things automatically, but is frustratingly stupid about some things I think are trivial. Just like our two non-Presidents, irritating. Will help you if I can, but remember, although I am an experienced programmer, Access makes me feel really stupid sometimes. At...

conner; Let's call the table with the autonumber key AA. The foreign key in field two is a key to table BB. Table BB better be the table that contains the data you want in fields 3, 4, and 5 of table AA. But, you don't want to load these fields into table AA permanently, because not only are...

Use the Trim function. Ltrim to trim leading spaces, Rtrim to trim trailing spaces, and Trim for both. alley

In design view, goto 'other' tab in the properties window. The tab stop numbers go from 0 to number of fields - 1. Change these numbers to give you the sequence you desire. alley

all participants, It is delightful to see a storm of activity, opinions and experience explode when one stirs up the pot with an opinion stick. Planning and communication is necessary for any project. Written specs agreed to by all can be dust in a Kansas wind when the user sees what he/she...

CCTC1, It may seem easier at first, and I used to do it that way, but I got sick of chasing those fields thru all the other forms and reports, fixing each one. Although it may look more complicated with the function, you only have to function with it once. Its a matter of personal taste, I...

laura, Use the StrCvt function, triggered by an event like Lost Focus, or Before Update. Private Sub Form_BeforeUpdate(Cancel As Integer) Me![strFieldname] = StrConv(Me![strFieldname], vbUpperCase) End Sub You can also use this same function to capitalize each word in fields with names...

ahdkaw, 'Manual Split' procedure works beautifully. Results perfectly normal as before split. Really Thanks. You might want to make this an FAQ. alley

Thanks Kathryn and cmmrfrds, Two good answers! My lucky day. Thanks.

Kathryn, I am aware of the cascading property of relationships, but I hesitate to set that up, because years (too many) of experience has taught me that the users will not read the warning messages, and delete too much because they entered the wrong date, crying all the way about recovery (they...

I was looking for access 97 and windows 98 and found many office 97 on yahoo auctions, even one enterprise edition (with developer tools) ranging from $20 to $150. There seems to be a lot available. alley

Both methods returned the same number. My rst is small (0-8), but don't see that as making a difference alley

Richey, Use the Find Duplicates Query, and use the results to delete them with a delete query. Do the dupes query first, and look at the table vue to verify the selected records. Then do a delete query, calling the dupes query as the source. alley

I have 3 tables-- jobs, empjobs, taskjobs. Referential integrity is forced, so I must delete from the 'many' tables before I delete from the 'one' side (jobs). My question is, how do I pass the parameter (jobs dated before X date) to all three, so I don't have to rely on the user to put the...

It is my understanding that Access already knows the record count in a rst, in recsetname.RecordCount. alley

Halifax and ahdkaw, Thanks for your responses. The error occurs during the Split operation. The errors it gives are in my first note. There are NO arrays in the data. FOR loops are not entered if the To variable is zero. All variables are declared, but Option Explicit is a good idea, just...

By 'live', I mean I can't take my MDB and load it on their system. It would replace the real tables with all my test data. Which is the reason to split in the first place, separating tables from the forms, queries, reports and code. Anyway, thanks for your response. alley

I have been trying to split an MDB and I get 'subscript out of range' and 'invalid procedure call or argument'. True to form, there is no clue as to where these errors are, or if they are ACCESS errors, not mine. I have searched the code, but can't find either error. This is a live...

DougP, Besides EBay and Yahoo Auctions, there is a place on the web for classifieds, where there are a bunch of system integrators that have leftover software legal and registerable. The URL is: http://www.computer-classifieds.com/sect090.shtml alley