Started 8 months, 3 weeks ago (2009-03-27 13:14:00)
by trek46
I have recently started doing this and I found that if I put in a refresh command in the fields being filled in works like a charm. I put this in the first name field on the after update event. It's worked so far.
Quote: Originally Posted by cferriby hello i just
migrated an access backend to MySQL for performance and size reasons. I have a form that will ...
Started 1 week ago (2009-12-09 11:16:00)
by dykebert
This is doable in
VBA, but unless the 7 days are all in the same week (i.e. no Friday to Monday comparisons), I don't know of a way to do it in just SQL.
Is VBA OK?
Started 1 week ago (2009-12-09 11:53:00)
by dykebert
In the future, including the actual query would be helpful.
Basically you are mixing
apples and oranges.
The .Parameter property refers to the Parameters that are defined in your query.
So the statement:
qryTemp.Parameter(StartDate) = Date
Means that your query has a Parameter this is named the date "12/01/07"
Correct use of this property would be either
...
Started 1 week, 4 days ago (2009-12-05 18:37:00)
by AlanSidman
Look at this tutorial. I think it will answer your first question
http://www.datapigtechnologies.com/flashfiles/bu ildcustomfilter.html
Started 2 weeks ago (2009-12-02 10:40:00)
by dykebert
ummmm OK I think I got it, but I want to make sure.
It looks like the code you provided takes the values that are in fields on a form and puts them into an e-mail.
1. Is this correct?
2. What version of Access are you using?
3. When you say datafields do you mean fields (columns) in
a single record or multiple records (rows). Do you have a single record (row) and ...
Started 2 weeks, 2 days ago (2009-11-30 13:22:00)
by mmh38
We tried doing something
along these lines in our Access database to handle part number creation and we never really got it working to our satisfaction. What we found was that this was more trouble than it was worth. We ended up going with a third-party part numbering system from part-numbering.com. It's not a free service, but it's very cheap relative to the amount of effort we were ...
Started 2 weeks, 2 days ago (2009-11-30 10:29:00)
by dykebert
OK I've got a couple of questions:
1. Are the Primary and secondary
satellites ALWAYS identified the same way? (i.e. for a TCA event between satellites A & B is A always Primary and B always Secondary?)
2. This would be very in easy if VBA, but while doable in SQL it will probably take a couple of different queries, so is a VBA solution acceptable?
3. Can multiple TCA ...
Size: 996 bytes
