Search results

I am creating a log of edited records. So let's say I have two fields: NAME, AGE Say my present Record is NAME- Liv Manto AGE- 28 If a user say, User 8 change the record to: NAME - Olivia Gonzales AGE - 32 I will a add a record to a log table EDIT: User08;Name-Liv Manto:Olivia...

Let [Forms]![frmFindPart]![Size] be X So your formula is like this: iif (isnull(X) or X =""), "* ", X) The second ) should be deleted.

Ask HELP for this topics: Open or CLose Toolbox Create a subform and add it to an existing form [This message has been edited by Liv Manto (edited 09-28-2001).]

Since you have different recordcounts for Field 1, Field 3, does this mean you have two tables linked by Field 1? [This message has been edited by Liv Manto (edited 09-28-2001).]

Ask the HELP for this topic: Display only the highest or lowest values in the query's results If your criteria is not one of list then go to the SQL view and change the value in there. If you are doing this through a code, you can set the SQL with a variable. [This message has been edited...

Would it help if you have table appended to everytime you run the query?

I find Access Power Programming by F. Scott Barker useful for form designs.

You can create a table using vba code. You could set the field type, size etc.

put this on the On Open event property of your form: DoCmd.GoToRecord , , acNewRec docmd.Maximize

You could create a crosstab query - GROUP BY so you could grouped your field's data thereby supressing duplicates OR you could create a delete query. Sample of which I am sending you a copy now. [This message has been edited by Liv Manto (edited 09-17-2001).]

Use instr() Ex: 1234567 ABCD_FG x= ABCD_FG Pretend the _ is space. Space is on the fifth of the term (x). Instr(x, "_") will give you 5. Add 1 to 5 and you got the beginning of the second word "FG" So now you can use MId(x, (instr(x,"_")+1)) Just replace "_" with " "

I need to move my msgbox at the lower left hand corner of the screen. How do you set a msgbox's top and left position?

Try True or -1 [table1]![checkbox field]=True

tblScaleData.Ticket, tblScaleData.PROD If ticket is actually field, you are using it as a table - tblScaleData.Ticket means Field "tblScaleData" is from table "Ticket"

Just thinking, I haven't done this myself. So if you have Mainform, Subform1, Subform2: Create Subform1 with a subform in it, Subform2. Then put that Subform1 on the Mainform. Try it with simple records.

all the records in Aug-01 Between 8/1/2001 and 8/31/2001 (if there is a 31)

Do they have something else in common, like from the same department, or all terminated employees or name starts with S ?

Between #startdate# and #enddate#

Use the crosstab query. COntractor___ Open___Missing ___Closed GroupBy________Count__Count _____Count

How is your table set up? Can't you base your report on a query?