Search results

Thanks for your reply. I hope I didn't seem ungrateful for your help. Quite the contrary. Reading your post I think my problem is understanding how to put the restrictions on the data to limit to one letter per reference per job. Would the restriction be based off modifying the relationships...

jdraw this is great! I really appreciate how much you've helped. I was looking at the sample you provided and I noticed something. The MAIN forms' subform shows every letter by the selected references. This is very close but I think someone would only submit one reference letter from any one...

ok.: My main form's (frmJob) recordsource is tblJob. My subform is based on the many to many relationship between tblJob and tblReference. So i created a query that includes both tblJunction and tblReference. In the query i include JobID and RefID from tblJunction and then FirstName, LastName...

jdraw I've attached a jpg of my relationships. Thanks,

Good afternoon~ Access 2007, windows vista I'm trying to understand how i can get nested subforms to work. I have a main form with a subform that is based on a many to many relationship. This subform is working. I would now like to nest another subform that would be based on a one to many...

Hello~ I have a design problem i can't seem to figure out and am looking for some advice... I have a DB used for tracking pollution complaints. The structure for this is fairly well set. My question involves hyperlinking to folders of pictures related to each of these complaints. My...

I have a bound listbox that is generated through a query on a form. My goal is when a new record is added and the form moves to the 'new blank form' to move the display of the listbox to the first record. Not necessarily select the first record, just move to the top of the list. Right now...

noboffinme~ I'm new to the spatial database world. I was curious if you are storing data in your database, then pushing that data out to GIS map in an ESRI product? Or are you doing something different? Sorry for my confusion, but am interested in this idea.

Any ideas on missing headers?

I've done a little searching and 'googling' but didn't find what i'm looking for. I've set up my reports with a report header and page header. They are both set to display always. Yet when i print my report out they aren't showing. I have some other grouping set up with some header options on...

You have it nailed. The only change i made was to sum the projected, actual, and balance fields. It is what i've been seeking for so long now. I can't express how much Linds and I appreciate this. It's a functional monthly budget tracker that we can use. I'll develop some reports for the...

This is very close to what i'm looking for. I would like to add the field items to the mix. Attached is a spreadsheet of what i'm hoping to accomplish with the query. also is a newer version of the db... I think i mentioned before that i want every category listed even if no entries exist for...

Mr. B What I ended up doing was creating a many-to-many relationship. My tblCategoryItemCombined is my junction table. I then populated a list box with the combination of the category and items 'pairings.' The selection in the listbox would then populate the tblLedger.CategoryItemID field...

The more i get into MS Access the more I learn i don't really know what's going on. I think i get the basics. I'm fairly comfortable in table design and form design but my next biggest challenge is learning how to use querries and get the data out of the DB. I've learned that getting the DB to...

Mr. B~ I have been playing with the db and noticed that when i enter new data on the form using the cascading list boxes it fails to give the tblLedger.CategoryItemID field a value. I wasn't sure if i had messed something up, so i went back to your version that you provided and i don't get...

I'm sorry for the confusion. I've gone back to my latest working version of the database on my desktop, verified that the information is correct, re-zipped, and posted this-see attached. Hopefully this works. there should be 6 querries included: 1) qryActualCostsEveryEntry...

I just saved my uploaded file and opened it. I see both of the querries but the first one: qry ProjectedExpensesGrouped is spelled qryProjectedExpenseGrouped (missing the second 's'). I assume this is the problem. If you still can't see it i can re-upload the zip file if you would like.

So I think I have reached the point where I am happy with my data entry. But now i'm trying to get the data out. My goal is to create a query that will give me a balance from my projected expenses and my actual costs. I was able to create three queries of interest here: 1)...

I have a date field in my table. I have not formatted the field in the table, allowing the 'general' format to be applied to the values. However, when working with these values i'm only interested in the month and a year. For instance, grouping values by the month of the year. Having two...

Mr. B Thanks so much for your help. Your ability to just jump into a db project, synthesize what the goal is and provide a relevant solution is awesome! What you were able to provide as a solution is exactly what i was hoping for. Looking through the record source queries i understand them and...