Search results

Try putting this on the double click event for one of the fields in the popup form (or add a button with this on the click event) Dim stDocName As String Dim stFilter As String stDocName = "frm_ASI" stFilter = "ID = FORMS!frm_ASISearch!ID" DoCmd.OpenForm stDocName, acNormal, , stFilter...

Can you post the query?

In access 2003... Is there a way to format a text box in a continuous form depending on whether or not the value in the field is duplicated? I've tried using the DCount function on the "OnCurrent" Event of the form: If DCount("[FIELD]", "QUERY_NAME", "[FIELD] = Forms!form_name![FIELD]") >...

Ah, brilliant. Thanks everyone. Sorry for the slow reply. Scooterbug and namliam had the right idea. I ended up using: stLinkCriteria = "[UIC]=""" & Me![UIC] &"""" Works perfectly.

This is in Access 2003. In my form (continuous, if that matters), when the user clicks on the [UIC] field, I want to open a subform and display the record containing the same UIC (unit identification code). This is my current code on the click event: Private Sub UIC_Click() On Error GoTo...

Cheers! I never even thought of using Grouping/Max. And I even used the word "group" in my title. LOL Probably because I never needed it before. I love this forum!

This is hard to explain - so I can only hope that someone understands and knows a solution... I want to update a "JOB" field in table "PERSON" to a field from a source file "JOBS". The tables are linked via a unique id for each person, "SSN" The problem is that each PERSON may have...

Thanks for the reply... In my "ACTIONS" db - I have one table named "tblSTATUS" that contains all the possible status options for each action, Then a separate table named "tblACTIONS_StatTRACKING" in which the status history for each action is stored as a number value that corresponds to the...

Disregard - I spotted the problem. Changed the ending to: Hopefully this thread might at least help someone else. lol

I'm using the DLookup function as the control source for a text box on a subform and it is returning "#Error". But, if I open the subform on it's own - it returns the correct data. Here's the code: I don't think it's a problem with the code itself, because it works when I use it on the...

OK, I think I got it now. Thanks for the help guys.

OK. This is what I've come up with using the Nz and DMax functions: Me.CTL_NR_MONTH = DatePart("m", Date()) Me.CTL_NR_SQNC = Nz(DMax("[CTL_NR_SQNC]", "ACTIONS_MASTER", [CTL_NR_MONTH] = Me.CTL_NR_MONTH), 0) + 1 - but how do I compare the data from a field in the current record to the data...

Can you still use the database? Can you look at the design of all the objects? Do you have to enter a user id and password when you open the database? What exactly are you not able to do? Does the database need to be secure? Just try this and see if it works: Open up microsoft access (not...

You mean HE created the passwords before he left and now you can't get into the db - or you just want to change the passwords so he can't get in anymore? If you are still able to open the database and view all the objects and their design - you can just create a new (blank) database and import...

If anyone can point me towards one of those threads, I'd appreciate it. The search function isn't working for me right now.

That's pretty much what I'm doing. I already have an autonumber as the primary key and am concatenating 3 separate fields plus the date as the control number - but I want to store the complete control number as a separate field. If I can get this all to work, I'll make the control number my...

It's sequential, according to the month - it's not dependent on the action type or the employee. ie, the first action of this month would be RT0806001DO, the second would be CT0806002DO, etc. Next month would be RT0807001DO... I was trying to do this by SQL (in VBA) on the AfterUpdate event of...

Is there any way to force an autonumber field to reset itself (go back to "1") on the first day of each month? *** Or...can anyone recommend an easier way to do the following: I'm trying to automate a control number comprised of 4 different parts: first part = 2 letters representing a...

I just checked you previous thread, but I'll post this here since it's the most recent. You can get the same result if you use a union select query as the control source for the report...just requires a little knowledge of SQL. something like: Select TABLE.NAME, TABLE.OTHER_FIELD FROM...

Bump If you still didn't get it to work, try this: Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\POWERPNT.EXE"" C:\Training\Training.ppt", 1) That worked for me. I came here looking for an answer and ended up figuring it out on my own. You shouldn't need to mess with the...