Search results

Paul, Thanks a lot. That's exactly what I needed. Tenney

Uncle Gizmo, That's exactly what I needed! Thanks a million!

Hi, I have a table which is basically deposit information something like this Category Transaction Category 1 $100 Category 1 $50 Category 2 $100 Category 1 -$100 Gategory 1 -$75 Category 2...

Uncle Gizmo, Thanks for the reply. I tried something like that. However, I need to do more than find out if the field is null. I need to find out if there is a detail record associated with the header record in the database. If a record has already been commited for detail then it's ok if the...

Hi All, I hope I can explain this in a way that makes it clear what I am trying to do.:confused: I have a form with a subform on it. The main form us used to capture "header" information about deposits and the subform is used to capture individual items (checks, cash, etc). The two forms insert...

The command button has an openform macro that is used. I have resize set to no and I have tried it without the code but I haven't tried setting autocenter yet. I'll try that.

Hi all, I'm having kind of a weird problem and I'm not able resolve it. Here's what's happening: I have a main for that has a button on it to open a pop up form. However, sometimes when I ope the form it doesn't open. I can open it three or four times sometimes without a problem then out of the...

Subform of a Subform disappears on record change Hi All, I have a tabbed form that that has a subform on it which has a sub form nested on it. So in other words my set up is TabForm -> SubformA -> SubformA_a. SubformA and SubformA_a both have combo boxes on them. The two subforms are linked by...

Thank you both for your help. I have decided to use the normalized way. This handles my data better.

So this sounds like I would have one form that would enter data into two separate tables? I'm not sure how to make one for enter data into two different tables. I'm assuming I would have to use a sub form solution, right?

Hmmm, you've both given me something to think about. if I were to use the normalized version of this solution wouldn't that require a separate record for each portion of a donation? In other words multiple records for one check? If that is the case what would I use as a unique key? My first...

Ken, I think your right. I reworked the way my forms handle this and your suggestion seems the best way to do it. Thanks Tenney

Ken, So you think I should have a table with 4 fields; Tithes, Offering, Other, Total and total the first three columns in the fourth column? The issuee is I need a record not only of the the first three columns but I also need a record of the total.

Hi, I am trying to figure out the best way to design a table. The table is going to contain data concerning checks that have been given to a church. Each check could be broken down into 3 different categories; Tithes, Offering, Other. In other words one check for $100 dollars might be Tithes...

I found my own answer. This is what I used (in case anyone else runs into this). Public Sub form_load() Me.Command10.Caption = DLookup("LetterName", "Letters", "LetterID = 1") End Sub

Hi, I am kind of new to VBA so any help would be greatly appreciated. I am trying to set the captions of buttons on my form by running a query. Here's what I have so far. Dim LSQL As String 'Display all customers LSQL = "select LetterName from Letters where LetterID = 1"...

Hi, I am trying to email the results of a query on a click command but I don't know how to add the results of the query to the body of the email. The query is: SELECT Count(*)AS Expr1 FROM assets WHERE Assets.AssetCategoryID = 1 AND assets.StatusID = 1 My email code is: Public Sub...

Hi I am a noob and I'm having problems performing a particuler form. I need a form that will auto-increment records as they are ented from 1 to 20 but once I have receached 20 I need it to start over at 1. So no record will have a higher number than 20 in this particular field. Any help would...