Search results

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...

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...

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...

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...

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...