Search results

I'm going to use [EnteredOn] and [ReferralId] as the primary key. An AutoNumber field is the current PK, but two staff members will be using notebook computers with a copy of the front end and backend. I'll be using an append query to append the new records to the back end on our server when...

I created an [EnteredOn] field to give a time stamp of when the record was added, and I plan on converting this field to the primary key. The problem is that I added this field after over 700 records were entered. For the existing records, I want to run an update query that fills in the...

i can look into ODBC, but for the time being the append query might be the easiest. the autonumbering should be okay because the only people entering information into that specific table will be the people with the notebooks. wait, nevermind - there are two notebook computers, so i guess the...

I have a stripped down version of our DB (front-end and back-end) on a notebook computer so that certain people out of the office can enter info. I did have the VPN set up with the tables linked to our back-end, but the notebooks connect via analog dial-up. it works, but it's just way too...

the mmi database repair utility didn't work because i think it tries to open the file before it attempts to repair it. thanks for your help. we found a company that successfully extracted the data for $148.

thanks, but that was one of the first things I tried - didn't work.

I can't open my database. I get the error message: The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time. The compact and repair utility doesn't work. Jetcomp.exe doesn't work. I have checked for an .ldb...

Thank you. Thank you. Thank you, RV and Pat. The nested queries is exactly what I needed. The people in this forum are incredibly helpful. Thanks again.

RV, changing "=" to "IN" didn't change anything. If the Max(DateOfAction) is the same for three records that all have the same ReferralID, I'll still get all three records. I think I need to somehow involve the indexed primary key [AutoID]. How would I put the following into the existing...

it was a consideration, but I need other fields that aren't part of an aggregate function. this thought just occurred to me: nest another query within the existing subquery that will do the same thing as the existing subquery except use Max(AutoID). [AutoID] is the primary field for...

The SQL fragment below is the criteria for tblPlacement.DateOfAction. It filters records by ReferralID then returns only the Max(DateOfAction). WHERE (([tblPlacement].DateOfAction)=(Select Max([DateOfAction]) FROM [tblPlacement] AS t_1 Where t_1.ReferralID = [tblPlacement].ReferralID)) This...

I'm trying to run an action query using CurrentDb.Execute "qryAction" I get an error message stating that I have too few parameters and that 2 are expected. What other parameter do I need to make this work? Thanks

thanks. I got the update query to do what I needed, but I also tried the code to see if that would work as well and got this error message concerning the first line of code: Object doesn't support this property or method (Error 438) an answer isn't necessary since the update query worked, but...

i'm trying to get all the records in a subform to equal [FosterID] on the main form. the following is in the onclick property of a command button: [Forms]![frmFPRecruits]![frmIndRecruit]![FosterID] = Me.FosterID when i click the button, the only record on the subform that gets its [FosterID]...

thanks. i guess i'll go that route since i really don't need the extra tables. i'm still going to set it up the way i originally intended strictly for knowledge and experience. i'm sure i'll have to use pieces of it somehow in the future. i figured everything out except for one last part...

even if a foster parent is flagged inactive, they are still a foster parent. there will be two categories of recruits that have nothing to do with active/inactive foster parents. with the lookup/navigation system already set up based on inactive/active, i think it will be a lot easier for me...

ok. I'll explain a little better. i already have a form set up with lots of information about foster parents. a lot of the code is based on whether they are inactive or active (0 or -1), and all the subsequent tables are based on the [ID] field. we now have a need for a section that is only...

I have a form based on the table [tblFoster] with a subform based on [tblIndFoster]. The unique ID for [tblFoster] is tblFoster.Identification. The unique ID for [tblIndFoster] is tblIndFoster.FosterID. I need to append the current record to [tblFoster] and the associated records of the...

Okay, got it. I guess I just needed to know it was possible to get what I wanted with DSum. For anyone who may need to refer to a calculated (or any) field on a form using domain aggregate functions, here's what I used for the "1stHalf" field. Note that [AutoNumber] and [IndFosterID] are the...

I have a subform, "subfrmTraining," which has an unbound text box in the footer, "txtTotalHrs" with the data source "=Sum([Hrs])" to give me the total hours. The form, "frmFosterInfo", has a text box, "Text35," with the data source "=[subfrmTraining].Form!txtHrsTotal" which gives me the Sum of...