Recent content by RandDUser

In a form, I have an unbound textbox (TEXT1) with an option button next to it (OPTION1). In a query, I have the field, LAST NAME. The criteria for LAST NAME is linked to TEXT1 in the form: [Forms]![frm_MAIN]![TEXT1] But, if the person highlights the option button, I want the criteria to...

I'll give that a shot, thanks PHV!

I have a query that has about 500 names in it. The query is sorted in ascending order based off of last name. I have a form based off of that query. The form is a continuous form. In the form header, I have 26 labels for each letter of the alphabet, so that if I click on 'F', I want it to...

That did the trick, thanks!

OK, I tried the above: DMax("[Year]", "tbl_MAIN", "Quantity = " & me.textbox1.Value) And I got a runtime error 2001. Not sure if I have the syntax right.

I have a DMAX function where I need 'XX' = me.textbox1.value: DMax("[Year]", "tbl_MAIN", "XX") I tried: DMax("[Year]", "tbl_MAIN", me.textbox1.value), but produces a run time error. I'm sure it's something simple, but I can't figure it out. Thank you!

The On Dirty property wouldnt work for me, but the Update Query worked perfectly. Thanks guys!

The records have already been created. I need to time stamp existing records. Let's say I have 10,000 records, and the DATE field is blank for every record. Then the query is run to pull back 300 records. Those 300 records need to have the 'time stamp' (Date Stamp in this case).

I have a form that has a date field in it. All the date fields are blank, and I want to time stamp them. I have the following code through a command button: Me.TEXTBOX_DATE.Value = Date However, this only inserts the time for the first record and not all of them. My guess is it needs a...

Sometimes it's too simple...but that's a good thing. Thank you Glenn.

Column A = employees last name Column B = a dollar amount The range A1:B11 is populated by employees and dollar amounts like so - Employee $$$ -------- ----- Smith 100 Johnson 200 Allen 2500 Smith 100 Smith 1000 Johnson 950 Allen 700 Allen...

Well I have columns on opposite sides that are populated, but do not need sorted, and I have 3 rows that are totals at the bottom that have to be excluded, so with that, I used: r = ActiveSheet.UsedRange.Rows.Count - 3 And that worked perfectly. Thank you both!

I have the following macro that will sort range C3:H298 by column D - Range("c3:h298").Select Selection.Sort Key1:=Range("D:D"),Order1:=xlDescending, header:=xlNo, _OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom However, if someone adds a row, I don't want to change the...

That was easy, thank you!

I have the following DCount statement in my VBA: DCount("[Quantity]", "tbl_Main") This obviously counts all of [Quantity], but I want to be able to count the quantity of only records where FieldX in the same table equals 'Team'. I can't figure out how to add in the WHERE statement in my...