Search results for query: *

My db has two relevant tables, tblGrantee and tblGrantSum. TblGrantSum is a child of tblGrantee with DLCDGrant# as the primary and foreign key in the tables. Both tables have a "StreetAddress" field in them because the same street address is not always used by a Grantee. My form simply lists...

I have created the following code to open the appropriate linked record in a related table or to create a new record if a record does not exist. Dim ProgType As String ProgType = [Forms]![frmtest].[ProgramType] If ProgType = "Competitive" Then If IsNull(DLookup("[Grant#]", "tblCT"...

I am struggling moving from macros to VB. Here is the setup. I have three linked tables. tblGrantSum has info about all grants. Tables tblCTrack and tblFTrack have tracking information about some of the grants. Their is a one-to-one relatinship between tblGrantSum and the two tracking...

Based on what I believe was good advice, I created my database with something I don't fully understand and it is now coming back to haunt me. I have two tables: tblGrantSum and tblCTrack. The primary key of each is an autogenerated number. Each table also has a Grant# field, which is the link...

I need some help with writing a macro or code to either open or create a new record in the following situation. My Grants application has three tables: grantsum contains information on all grants; FTrack is for tracking the fairly simply process of awarding formula grants; CTrack is for...

Let me start with an etiquette question - I posted a message similar to this one a week ago that got only one response. I have searched the site to no avail. Is there a "correct" way to ask for more input? My question is: How do I get the records selected through a "Filter by Form" query to...

I am trying to understand two issues regarding relationships. I have created a grants database with a number of tables; GrantSum as the "one" table and Grantee, Payments, Products, etc. as the "many". Each table has an autogenerated ID# as the primary key and an indexed field called Grant#...

I am trying to preview a report based on a Filter by Form. The thread Thread703-796248 provided the coding below, which works great when the form is based on a single table. If Me.FilterOn Then DoCmd.OpenReport stDocName, acViewPreview, , Me.Filter Else DoCmd.OpenReport...

I have created a "one line per record" form based on a query. The query also includes a sort order. I would like users to be able to use the buttons on the standard toolbar to either select or sort records from this form, but not have those sort/select actions saved with the form when it is...