Search results

Ahh, wise. thank you.

Sorry for the delayed response. Thank you, I appreciate your input. I will take a look at this.

Thank you. That worked. If I first want to check to see if there is already a "linked Proposal" should I use "DLookup"? I feel like I've read things where you want to stay away from DLookup, but I'm sure it has it's uses. Private Sub OpenProjectForm_Click() Dim projectID As Variant...

Any chance you can take mercy on my soul and point me in the right direction here... (This should probably be a separate post, so feel free to reject and tell me that as well.) After the user creates a proposal, if it is accepted, they will want to "open a project". I'd like this button to open...

I understand your point. So when creating my combo for the company would I use "store for later use"? And then can I use this to filter the contacts? Not exactly sure how to do that, but I give it some effort.

So to provide clarification: While my markups point to the company and company contact, I really am asking about the "referral company" and "Referral contact". Which might be blank for any given job. The user might select a referral company and contact by mistake. This will put a companyid and...

After a quick search, it seems like a hanging indent really isn't possible. Is that true? Below is an example of a long text field with rich text enabled. I could make each of the "services" a unique record in a different table and then create a continuous form, but then I think the indented...

Thanks Pat. I do like the sound of this, but given my lake of access skill and not having that many different "types" I will give the one table approach a shot. However, I would like to understand what you mean about the last part. Are you just saying that each "type" table should have an FK...

I have cascading combo boxes. The first is for Company and the second one which is dependent or "child" of the company is "client". Client combo box is based on a query so I can select a client of the selected company. If select a company and client, then save the record, then delete the...

Appreciate the feedback. I'm going to give single table a try.

A few responses: Typos not in Database (at least I don't think they are) Yes proposal table has PK called ProposalID. All tables have a PK and they all have ProposalID as a FK. I apologize for leaving all these off the table lists. "Is ProposalTypeID a coded link to the specific record in a...

Thank you both for the responses. @June7 - Would you create a separate form for each "type" i.e. 7 different forms for entry. Or just create tabs like you said earlier? I'm torn on this decision. On one hand I really like the idea of having separate tables because it keeps things "cleaner" in...

Also clarification on "locking" the control... What triggers the locking? I noticed that as long as I don't change records the control remains unlocked. I can save it, refresh it, input text in other fields, none of that seems to impact that lock. I take back the question, since it is in the...

So backing up for a minute and going back to what June7 mentioned in post #4... Here are my tables, Main proposal table, and then 7 sub-tables. Does it seem better just to jam it all in one table or keep them separate? Also attached is the database. I know it's in pretty rough shape. Don't...

Huh, yeah, I see what you are saying. Well said. I will share the database as all the data is fake at this point, but it's a bit messy. Let me try to clean it up a little and also add a couple more tables/forms so you get a better feel for number of proposal types and fields. Thanks again for...

I wouldn't be surprised if I'm doing something wrong. My intent is that the main form has general proposal information common to all proposals. I then have different subforms which are specific to different types of proposals. I want to populate a subform located on the "proposal page of the...

I'm trying to use a combobox to set the value of a subform control. A blank form is shown for a new record. However, after the user selects which subform should be displayed, I want a warning with a yes/no option displayed if they try to change it. I can't seem to get this to work correctly...

Thank you this is what I had in mind. Just to be clear the proposal table and projects table would not duplicate any information. The proposal table has information about how much it costs, type of work, etc. Project table has information on who is working on it, projected end date, etc...

Thanks for the responses. @DHookom - Thanks for confirming, this is essentially what I was discovering. It just seemed like maybe there was a better way to do it. @Mark_ - Client table has a one to many relationship with Proposals table. The workflow is typically to start with the proposals...

I have a "proposal form" that has a bunch of information such as project name, client name, price, and some other subforms with other information. I want to create a button that opens a "projects form" that links to the proposal table and client table. I have fields for proposalID and clientID...