Search results

It doesn't seem to be working correctly. I'm not sure if it is becuase of multiple participants, but here are some actual values from the table. PK fkosParticipant ActionType EffectiveDate 181314 105999 Other 6/1/2003 164655 105999 Annual 4/1/2003 153307 105999 New 11/1/2002 210000...

Perfect! Thanks a ton that saved me a lot of trouble. Thank you, Roeland Kim

Hi all, I'm in a bit of a bind trying to figure out how to accomplish this query, any help would be appreciated. I have a table called ApprovedCertification. This table contains the following fields: PK, ParticipantPK, CertificationDate, CertificationType I want to be able to compare the...

Yes, there is a primary key for the table, so by sorting on the PK I can determine the order of the records. Thanks, Roeland

I have a form, called main form, which has on subform on it. The subform is in continious form view. Basically it tracks an Out Date and an In Date. I want to make text box visible/not visible based on whether there is a value in the In date field, in the last record in the recordset. I can get...

Attached is your database with some changes made to it. Take a look and let me know if you have any questions. Basically the form frmAssetList has an unbound control on it which is a listbox. The listbox runs off a query of tblAssets. There is an "on Dbl Click" event which opens your main form...

You could also try putting the following in the criteria: Like "*" & [enteparameterhere] & "*" This will bring up anything with the criteria you specify.

Do you have security setup on the database?

Here is what I have setup in VB to send an email with a specific report attached. DoCmd.SendObject acReport, "InsertReportNameHere", "SnapshotFormat(*.snp)", "", "", "", "InsertEmailSubjectLine", "", True, ""

Thanks, I'll give it a try.

I have a question on preventing users from adding a new record to a continous subform if a certain condition on the current record they are working on is not met. Let me explain… I created a database (with the tons of insight from these forums)for tracking incoming phone calls to my department...

Hopefully someone can help me out. At my office we send out people to do inspections on a regular basis. An inspector will visit around 20 locations a day. I want to be able to take a list of address' and parse them out into seperate fields. For example: 10 Main Street 24-32 5th Avenue 534...

Since the field attainment is a calculated field, meaning it is dependend on outside variables to get a result, there is no reason to store it. Just calculate it in the query. You can than bind your form the the query and show the results, whenever the base variables are changed, the calculation...

Try this in your query. Right([fieldname],IIf(InStr([fieldname]," ")>0,InStr([fieldname]," ")-1,4))

I assume you are using toggle buttons which in turn are bound to a field in one of your tables. If this is the case, see the attached example on how to undo/reset toggle buttons. Hope this helps. Roeland Kim

See the attached file for what you want. Basically in the footer of the subform total the fields you want, in this case cost. Than on the main form refer to the control in the footer. Once you look at the example it should make some sense...

Great, works like a charm. Thanks for the help.

I have a table as follows Othersource____PAsource____Wagesource 5_____________8__________0 8_____________0__________2 5_____________5__________9 I am trying to do 2 things, first get the maximum value for the 3 sources, which I have been able to do using a zmax() function posted on another...