Search results

This answer was quite helpful in developing a form I was working on. My follow up question to this is what if you want to be able to "add" competencies using the same form? In other words is it feasible/recommended to be able to add employees and competencies using the same form? If so advice on...

Many thanks to posting your database. I'm not an VBA expert, but I was able to take your database and then copy the code to make it fit what I was doing (updating one box based on another in a continuous form). You saved me a ton of time.

Alright, so I did some reading and came up with a new game plan (better layout I think). The way to get a primary key/secondary key combination to appear is to have a secondary combo box based upon the primary key selection. The secondary spend category combo box will have an "update after...

I hear you on the names. I need to go back and clean it up more. To answer your question yes a primary category can have more than one secondary category. I would just build a table that has this for one column "Home - General" but the issue with that is it is more difficult to isolate "home"...

Alright, I must admit that I could not fully grasp on how to implement the suggestions. Also it is possible to have more than one secondary category assigned to a primary category. Such as Home - General, and Entertainment - General. I came up with an idea to query the many to many table...

First, why do you have two instances of the Account_Type table linked to [Account].[Account Type]? - I noticed that as well. I think it is happening because I used the lookup wizard to get values and I'm assuming that process puts its own join in there (to show where the values are coming...

I'm about to walk away because my brain is going in circles, but here is the next shot at me trying to solve my problem. The issue is the transaction table needs to have a primary and secondary category, but the combination needs to be unique. For example if I select "Home" then I only want the...

I'm developing my own personal finance database and the part stumping me on the design is how to setup the categories per transaction. For example a primary category would be "home" and the secondary category would be "furnishings". How do I set this up? I'm getting stuck on how to tie it into...

O.k. the first two links are helpful when I attempt to write this on my own. I would like to see how the wizard does it in order to see it first, and then try and mimic it on my own. My 2nd question is when I use the command button wizard and add it to the subform why is it not visible? I can...

What is the easiest way to access another form based on the information in a subform? I prefer not to write code since I'm a beginner. I have table "Employees" and a table "Projects" with a Many to Many relationship. I have a form designed that allows users to enter project information and...