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...
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...
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
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.