Search results

Cool. Thank you both. I'll see about putting some brain bytes into the links you've both provided and see if I can't figure this out. It's been about 6 months since I've designed a DB and I just can't help but keep beating my head against a wall on this. It's as if I know I need to bust...

Awesome. I may just incorporate that into the db. Really not a bad idea at all. Thanks!

Try this db as a sample.

Create the form that has the recordsource to include the table that you want to update the data to. Then create your comboboxs on the form and set the row source to include the options that you want the user to have based on whatever table you have the options saved in. Then on that same...

I took a look, and decided that I want to try and keep as much of this project query based if at all possible. I'm trying to begin creating these databases so that another user down the line would have an easier time tweaking and editing the databases I create. I've got the following query...

No that's the kicker. I anticipate at the most, there will be 5000k records at any given time. I'll be incorporating an "auto-purge" feature that deletes records after a certain amount of time. It just seemed like overkill to create a feature that would use a default, only to then create a...

Thanks Ken. I really couldn't think of a simple solution that would circumvent the need to duplicate these entries for each member, I just wanted to make sure I wasn't missing something obvious. Thanks for the help!

I've got a db I'm working on that will generate training reports for individuals. I've got a table that has a basic template consisting of a paragraph of text for each section of the report. Would I be violating the rules of a relational db if I took and copied that paragraph to a record for...

Good Morning, I need to figure out how to take a list of awards that are to be presented to an individual and take the description of each award they are being presented and copy that or append it to a memo field for that individual. How would I create a query that would basically loop...

Alright, I've run into a hitch. Currently I'm using the following SQL statement to display all of the awards applicable to the person: The SQL I've got for the Exclude Query isn't generating what I want by using the MemberID and is below: Any ideas?

I've given it a go, but I can't figure out how to actually filter the query based on the MemberID. I decided to go with 2 listboxes. One will have the results from the tblMembersAwards and the other will hopefully use the Exclude Query you mentioned and will look at what awards are not...

How do you take multiple selections in a listbox and save the Primary Keys associated with those listbox selections in one field on a table? Basically, I've got a form that has a MemberID that populates the remaining data for that individual. I've got a Listbox that displays all of the awards...

Good Afternoon All, I'm working on a database in A2003 that involved me allowing users to insert "Variables" or something similiar to Smarty tags in a Memo field that will be updated in a report with information in the database. For example, the memo field would look like below: %%FIRSTNAME%%...

All - I have a Report Selector form that's laid out with a Drop-Down Combo Box that selects that name of a report and is populated by a table called tblReports. I have two listbox's on the same page and two text fields that are used to filter by date. The two listbox's rowsource is based on...

Got it. I did basically the same thing. I cleaned it up and I got the following that seems to work: I've got to get my head away from code for a little bit, so I'm going to head out to lunch, but I truly do appreciate the help! 'define data for slide Set rs =...

The x is actually a variable for the slide index number. I have that initizlized a little further up in the code: 'create new powerpoint presentation Set ppPres = ppObj.Presentations.Add x = 1 This way each time a slide is added, it add's one to the variable allowing me to create...

I'm struggling. I can't for the life of me figure this out. I've got the code posted and I can't figure out how to tie in your code to make it work for me. ' Setup the set of slides With ppPres 'define data for slide Set rs = CurrentDb.OpenRecordset("SELECT *...

I am currently using the following to format the cells in a table generated by Access in Powerpoint. With .Slides(index).Shapes(3) For i = 1 To .Table.Columns.Count For j = 1 To .Table.Rows.Count '.Table.Cell(j...

I would just typically use the DoCmd.OpenReport and set the Where portion to find what I want ... but the form will be remaining open.

I'm actually looking to move to and find the record that I just created on the modal form instead of looking for if that record exists. I want to move to the record on the main form. Any ideas on that?