Search results

Hi, Here's a slimmed-down version of the DB. I think I copied over all pertinent data/forms/tables etc. When working with a contact, I open the contact details form, and add categories to the contact through this subform. I use access '07, and it wouldn't let me save into an earlier version...

Hi, So I've been trying to play around with this and can't seem to get it to work. I used the code from http://allenbrowne.com/func-concat.html and pasted it into a module, as the site says. Public Function ConcatRelated(strField As String, _ strTable As String, _ Optional strWhere As...

It worked! That was too easy! Thanks

Hi, I have two queries, 'LocationOfTreeWork' and 'FundingExtended.' I'd like to create a form which displays all locations, and any corresponding funding associated with that location. I tried to create a query which pulled all info from both of these tables, with TreeworkID from query...

Hi, I have a contact table and a category table. One contact can be assigned several categories. I want to be able to have a datasheet in a form show me all vital contact info (name, address, etc) across one row as well as show in one cell of the row a string of however many of the categories...

I have a form 'Location' that has tabs. Two of these tabs are 'Tree Work' and 'Funding.' A location can have multiple records for tree work, and each tree work record needs to be assigned a funding source. But the funding source may be different for each tree work record, so each needs an...

Here ya go.

Hi, In my subform in the 'Budget' tab of my Location Details form, I tried to set the code Forms![Location Detail]![LocationID] into the lookup query for TreeWorkID, which was the control that was showing ALL possible IDs that I wanted to only show those relevant to the open record. In the...

How do I get the query to reference the ID# of the parent form only, so that it limits the options in my query to only those that apply to the ID of the record that I have open? Basically, what is the Code to call this? Do I put something into the source of the datasheet? Does it go into the...

Hi, My DB contains a Table 'TreeWork' and a table 'Funding'. I have a datasheet subform within a Funding tab on my form 'TreeWorkDetails' which has the Link Master Fields and Link Child Fields matched so that only Funding for that tree work is shown. I have a lookup set to the 'TreeWorkIDFK'...

Hi, Yes, the contacts would be receiving mailings more than once, such as newsletters or occasional postcard reminders, depending on other criteria which would be sorted out based on a parameter query. I went ahead and setup a 'Mailings' table which would store the ContactID and the...

Hi, I've got a DB in which we will want to pull contacts out based on a parameter query, create mailing labels for those contacts (either in Access or can export to Word for better editing ability), and then mark in that contact's information that they've received that mailing. Any...

Hi, I've got DB which tracks Events and Contacts; i.e. contacts and the events they attended, and events and the contacts who attended them. I based this form off of the Students DB Template Microsoft provides. I have 2 data forms, 'Contact Details' and 'Event Details', which the user can...

Hello Everyone, I was able to find it after checking behind all the events (which was tedious); the DB template I'd started with had a 'Filters' table, form, and macro to aid the user to search, and I'd deleted these because I wasn't going to use them. But, on one of the forms I'd formatted, it...

Hello Everyone, I was able to find it after checking behind all the events (which was tedious); the DB template I'd started with had a 'Filters' table, form, and macro to aid the user to search, and I'd deleted these because I wasn't going to use them. But, on one of the forms I'd formatted, it...

Hi, My DB is a 'Frankenstein' db of the Access templates for Students and Contacts. I have in it a form, 'Location List,' which displays all of my records just as the original templates had a 'Students' list, and a similar form, 'Contacts List'. In my forms, I have a text box (or column, on...

Thanks! Looks like I'll be busy for a while.

Hello, I'm working on a DB that I think needs to be setup in some way as a many-to-many relationship. Now, from what I understand, Access doesn't necessarily create 'many-to-many' but, you instead create multiple one-to-many relationships. What I'm stuck on is this; I have in my DB a table...

Hi, Right now, the DB uses a query to populate a datasheet list of all the records. When the user enters a new record in a separate form, the information does go into the appropriate columns in tables A, B, and C. However, they do not show up in the query, and table A is not storing the...

Hello, I'm working on a DB setup by a different department and trying to make it work correctly for them, as they've hit a wall. To keep things simple for now, this DB tracks in 3 tables A, B, and C. Table A has columns to store the ID# of B and C in it, as well as other data. There's a...