AccessHelp32
Last Activity: Feb 2 '07, 11:06 PM
Joined: Dec 22 '06
Location:
-
I think this is exactly what I needed. Thanks for the direction. -
Customized Letters Using Reports
Hi All!,
I've searched the fourms but I can't find anything specific to this. I'm trying to create customized letters using a data table containing names, addresses, order numbers etc.
I want a standard letter, but I want the name, address and order number to change for each letter (e.g. Dear Mr. Jones, Dear Mr.Smith, etc). I also want to print each letter and as the letter is printing, make the changes to each letter.... -
Nico, Neopa,
Thanks for the input, both of you. I just figured out both solutions! I plan to use both solutions in various parts of my DB just to gain experience with the code.
Neopa, I'm glad to see that my syntax wasn't too far off in my original post =)....Leave a comment:
-
So I have the Form [Programs] bound to table [Program]. Both the Form and the Table contain 3 fields: Program ID, Program and Program Desc. I'm trying to filter the field Program using the txtFilter I just added to the Form. The control source of the Form [Program] field says Program. Does this sound right?
Once I'm given the idea, I can generally make things work, as you have successfully given me an idea before (Thanks, by the...Leave a comment:
-
Any Good Reference Materials/Books?
Hi All,
As many trying to help me have guessed, I'm new at programming Access. Can anyone recommend a good book or books to get me going faster? -
I think this is the solution! However, my [fieldname to search] is a textbox (bound to a table). When I use the code above, I get no results and I suspect it's because the form is fitering an empty textbox. Do I need to point the code to the table holding all the records of [fieldname to search]?, so the code searches the table for "Like [fieldname to search]" and loads the Form with the complete Record of "Like [fieldname to s...Leave a comment:
-
I like the idea, but I'm concerned because I may not have a limited number of ID's. If all goes well, this will be a temporary fix until the new Computer System goes live. However, as with all new systems, I expect delays, problems etc. - in which case this will be more than a temporary fix indefinitely. Is there another option to get this to work....Leave a comment:
-
Use InputBox to Open Form/Locate and open Record
Hi All,
I have a command button that opens an InputBox. I would like users to enter a string and have the InputBox open a Form and go to the record that matches the users string most closely. I'm using the following code with no luck:
...Code:Private Sub Command3_Click() Dim Search As String, Message As String Search = "Find Program" Message = InputBox(Prompt, "Search") -
I think so. But just to be clear, Subform B has the OrderID to link to Main Form C - not sure if this makes a difference. Also, not sure what you mean by "SubformB's OnCurrent event." I can't find the OnCurrent event.
I test this out most of tonight post a reply tomorrow....Leave a comment:
-
Forgive me in advance if I complicate this. It's a good idea, but because I didn't disclose more details, it may not work. My apologies.
Forms are set up so that Form A also has Subform A1 attached (linked through an ID field). Subfrom A1 then becomes Main Form B on the next form. Main Form B has Subform B1 attached (linked through ID field). Subform B1 then becomes Main Form C on the next form. And so on.
As I...Leave a comment:
-
Record Look Up
Hi All,
I have forms A, B, C and D all linked through various ID fields - A linked to B, B linked to C, C linked to D. I also have a command button on each form that closes the current form and opens the next.
How can I set up the forms so that when form B closes and form C opens, form C opens displaying the same ID record I was working with in from B? -
Reports huh? That's my weak spot. I'm great at queries, just learned Forms but I've never created a Report before. Sorry. I'll be posting some Report questions soon, because I need to generate a few myself....Leave a comment:
-
Hi All,
I just figured out the code and posted my solution in a similar discussion that had more details/examples etc. The discussion thread is: Getting the sum from a subform. Hope this helps!Leave a comment:
-
I just figured out the code! I typed:into the Control Source of the Text Box and it worked! Instead of referring to the [Source Code subform], I referred to the table "Source Code".Code:=DSum("[Circulation]","Source Code","[Camp Sched Proj ID] = Forms![Campaign Schedule]![Camp Sched Proj ID]")
Thanks for the example Aplnz, it really helped....Leave a comment:
-
Great Thanks!
[*] [Circulation] is a field in a subform called [Source Code subform]
[*] [Source Code subform] is derived from a Table called [Source Code], so yes "Source Code subform" is a Table.
[*] [Camp Sched Proj ID] is a field in the [Source Code subform]/Table.
[*] [Campaign Schedule] is not a subform. It is a Main Form, and [Camp Sched Proj ID] is a field in [Campaign Schedule].
In short,...Leave a comment:
-
I'm sorry to be a pest about this, but it doesn't work. I get a syntax error "Expected:= "
In any event, the exact code I'm using is:
.Code:DSum("[Circulation]","Source Code subform","[Camp Sched Proj ID] =" & Forms![Campaign Schedule]![Camp Sched Proj ID])
Is there something wrong with the code? The spaces in my form names? The fact I'm using a Subform? I've wrecked my...Leave a comment:
-
Unfortunately, I need to edit the subform.
I'm trying the following code:
I've added the additional "=" because Access requests for one....Code:DSum("[Source Code subform].[Form]![Circulation]", "[Source Code subform]", "[Source Code subform].[Form]![Camp Sched Proj ID] = Forms![Campaign Schedule]![Camp Sched Proj ID] = [Source Code subform].[Form]!Camp Sched Proj ID")Leave a comment:
-
So [Quantity] and [MasterItemID] are fields in Table that stores various Inventory Values?
My ultimate question is: I have a subform attached to a main form in which both forms are linked through a Project ID field. When I change the Project ID field on the main form, only the records associated with the Project ID are shown on the subform.
I would like to sum a field in the subform and display that sum on the main form...Leave a comment:
-
Sum a Subform
Hi All,
I have a subform attached to a main form in which both forms are linked through a Project ID field. When I change the Project ID field on the main form, only the records associated with the Project ID are shown on the subform.
I would like to sum a field in the subform and display that sum on the main form (perhaps in the footer). However, I want the sum of the subform fields to be only for the Project ID... -
ADezii,
I had the same problem. I don't understand your code above. What is "tblLocSubLocQt y"?...Leave a comment:
No activity results to display
Leave a comment: