Replies

Charlotte,

WOW! So how do I know what the default sort of the recordset is? I need to go through the records in a specific order, which coincidently is the order of one of the two indices.

How would I open the query, using the following example?

Set rst = dbs.OpenRecordset(“tblRates”, dbOpenDynaset)

Thanks tons for your help.

Ken

Charlotte,

WOW! So how do I know what the default sort of the recordset is? I need to go through the records in a specific order, which coincidently is the order of one of the two indices.

How would I open the query, using the following example?

Set rst = dbs.OpenRecordset(“tblRates”, dbOpenDynaset)

Thanks tons for your help.

Ken

Charlotte,

You are awesome. Will the dbOpenDynaset also work on local tables, or does it require the dbOpenTable always on local tables?

Thanks again for your help.

Ken

Charlotte,

You are awesome. Will the dbOpenDynaset also work on local tables, or does it require the dbOpenTable always on local tables?

Thanks again for your help.

Ken

uh oh. I have been using the following to calculate age. It seemed to work ok, but now, based on these kewl funtions presented here, I am concerned it may be incorrect.

‘Age in years is Current date (dtmToday) less Birth date (dtmBdate)
Int((dtmToday-dtmBdate)/365.25)

In a query it looks like:
Age: Int((dtmToday-dtmBdate)/365.25)

Is this oversimplified?

Thanks,

Ken

uh oh. I have been using the following to calculate age. It seemed to work ok, but now, based on these kewl funtions presented here, I am concerned it may be incorrect.

‘Age in years is Current date (dtmToday) less Birth date (dtmBdate)
Int((dtmToday-dtmBdate)/365.25)

In a query it looks like:
Age: Int((dtmToday-dtmBdate)/365.25)

Is this oversimplified?

Thanks,

Ken

Charlotte and Hans,

THANKS! ! !
I tried it both ways and it worked! You guys are awesome.

Charlotte,
RE: “However, if the form you are popping up is already open”
No. The form can only be opened from the double click event, and when open is modal forcing user to close to notes form before going anywhere else. There may be caveats to that approach, but I don’t want the user to have the ability to have a bunch of forms, report previews, etc. open at one time.

THANKS for sharing your brilliance.

Ken

Hans,
I’m sorry about the lack of clarity.
frmNotes “knows” which record to display based on the query that feeds the form:
SELECT tblRehire.pkey, tblRehire.memRemarks
FROM tblRehire
WHERE (((tblRehire.pkey)=[Forms]![sfrmMain]![txtpkey]));

In other words, when they double click on the control on the record displayed in the subform I use the txtpkey to relate to the appropriate record in tblRehire. Does that make sense?

Again, I apologize for the lack of information.

Thanks,
Ken

Thanks Hans. The following is the code I used in the Event of the control.

Private Sub txtTermDate_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = “frmNotes”
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

Record source for form frmMain is tblPerson, which includes an Employee ID field that is used as the parent.
Record source for subform sfrmMain is tblRehire, which includes an Employee ID field that is used as the child.
Record source for frmNotes is tblRehire, which includes a primary key that acts as the link to sfrmRehire.

sfrmMain contains three visible controls (txtTermDate, txtReason, chkRehire) and on hidden control (pkey).
frmNotes contains two controls, memNotes (visible) and pkey (hidden)
tblRehire contains the following fields:
pkey
fk_EmployeeID
dtmHireDate
dtmTermDate
strReason
logRehire
memRemarks

Does this help?

Thaniks,
Ken

I used Apple Newtons for long time, and put off switching to the WindowsCE machines. Main reason was that for amount of money I spent on the thing, I expect THE PC to learn my handwriting, not ME relearn how to write in computereze/Grafiti. However, the Newton got too big, and not supported by the original manufacturer. (another story for another time)

I have had my IPAQ for nearly a year now. I travel a LOT! Two programs I find most useful are products by Ilium. eWallet is an awesome tool for keeping my personal information like frequent traveler/hotel numbers, software serial numbers, credit card numbers, and other information. The security seems very solid to me, so I don’t have a problem storing that type of sensitive information electronically. Heck, before I had the program, I was carrying a wallet full of cards with all the information anyway.

The other program I use is ListPro. Every possible list imaginable is available online, plus you can create your own custom lists. The one I use the most that saves me a ton of money and time is AT&T local dialup numbers when on the road without broadband connection.

I also love the ability to reconcile my work calendar with my personal calendar via Outlook by simply connecting the handheld to either the work pc, or the home pc.

Hope this helps.

Hans,

Thanks for the queries. I will work on them this weekend and hopefully let you know that they work, and what a brilliant person you are.

Have a great day!

Ken

Steve,

Thanks for the shot in the dark.
1. Yes, I am using a main form/sub-form
2. Code posted attached (which is probably where the problem resides)
3. No, I am trying to filter on field(s) on the main form.

Thanks for you help. Believe it or not, I am learning a lot from you guys.

Kwvh

Charlotte,

Thanks for the followup. Running Service Release 1. The tables don’t have lookup fields, but the form has four combo boxes with lookups, and there is one subform with 15 fields.

Subdatasheets is turned off and AutoCorrect is turned off. It looks like I will have to go through the code behind the form (oh no!). I will let you know the findings if you are interested, and assuming I find the problem. LOL

Thanks again.

Kwvh

John,

I get an error even in the mde, which would not open VB editor (I think). It occurs when the only object open is the one form. The form is called from another form, which closes when the offending form is opened.

Thanks for your help.

Thanks Dave