Search results

I assume that you have a unique fld (like an xxxxID Indexed No Duplicates). You will need some DAO code. 1. Create a RecordsetClone from the form. (rst1) 2. Use FindFirst to locate the record (on the xxxxID fld). 3. Call up the 2nd tbl (rst2), use rst2.AddNew etc then rst2.Update 4. use...

Use Date() instead of Now(). Now() incorporates time as well as date. At 12noon Date() => xxxxxx whereas Now() gives xxxxx.5. This causes trouble when you are trying to filter between dates, the last day will not appear with Now() but does with Date(). Basically, as I am lazy, I use...

There are some issues that I've discovered with split and unsplit dbs. eg In a single db if you open a recordset and rst.Recordcount, you get the right no of records. However the same code from the fe of a split db always returns 1 unless you rst.Movelast prior to the rst.Recordcount. So...

MSysDb is the last record in the system tbl "MSysObjects". Try the following: Create a blank db, go to Tools-> Options -> View and tick "System Objects". You will see 5 Sys tbls shown, but not "MSysObjects". Create a 1fld tbl and put 1 record in it. Unload and reload the db and...

I can't see how splitting the db would cause that problem. Does everything else work apart from that frm and qry. You can use more that 1 fe per be. Why don't you create a new fe with only the frm and qry(s) in it and link that to the be. I rarely use the db splitter. I create 2 new dbs (be...

The question of logos in dbs can create a massive increase in db size. Case 1: The logo was a .jpg file, 176Kb. When embedded in the db it blew the db out by an extra 35Mb - I couldn't believe it. If this was embedded many times in various frms/rpts the db would be massive. Case 2: I noticed...

Dates in Access are stored as numbers - the no of days from 12/31/1899 where this date is 0 (or 1). If you have a "start date" field and you add the "subscription length" as days (eg 1 yr = 365, 2 yrs = 730 etc) this will give you the "renewal date" (you'll be 1 day short across a leap year).

If by "this month entry " you mean the current month, try Month(Date()) And Year(Date()) in the qry criteria cell.

Seems like you might have Top Values set at 100 records. Get the qry up in QBE mode, rt click and go to Properties. This will give you the "Query Properties" box. Top Values should be All.

I think I get the gist of what your'e trying to do. 1. Create a qry to get records ordered as ABC, ABC etc, - pull flds into QBE grid and set fld 1 Ascending, fld2 Ascending. 2. You'll probably have to use VBA. Create a recordset from the qry in pt 1 and write a routine to do the calc and...

The above is pretty vague, but do you have 0 or "" as any defaults in the F3 fild.

If any qry has more than one join fld index set to Duplictes Yes (Allowed) then the qry is not updateable. To check, run the qry and if not updateable, the * on the Navigation Button is grayed out.

Yes, that's the way to do it. You will also need "UsersID" in the "Classes" tbl as well.

Can you post winzipped db with some dummy data in it.

No - a Primary key can only have one value per table ie no duplications. You now seem to have a problem. If the deeds are duplicated do the duplicates have diff data entered against each deed - if so is there any other fld in the deeds tbl that is unique.

Instead of Me.Undo try rst.Delete - the record seems to already exist. I understand Undo removes from memory before the record is committed. This is where the BeforeUpdate event needs to be used.

Are you saying that 1 person from the main tbl can have several affiliates and one affiliate can have several persons. eg like 1 doctor can have several patients and 1 patient can have several doctors. If so, you have a many to many relationship between the 2 tbls and you will need a 3rd tbl...

How many flds contain numbers you want to search. Set up a select qry and put <0 in the Criteria cell. If you have a no of fields put <0 one cell down for each fld. This creates an OR eg will look like: (without the -----) <0 ------<0 ----------------<0 If you put <0 more than once on...

Criteria: In Closed Date fld Date()-30

Use Date()-1 as Now() incorporates the time as well. I had a problem some time ago where some records from the last day filter in my qry were left out. eg Date() the number was 31 Now() the number was 31.5 because it was 12:00 noon.