Search results

Still struggling. This works albeit with the Write Conflict warning if I refresh or save. Private Sub cboOne_AfterUpdate() Me.cboTwo.Requery Me.cboThree.Requery Me.cboFour.Requery DoCmd.OpenQuery "Level1CauseUpdateQ" End Sub This breaks the cascading combo boxes Private Sub...

Beautiful. I added the suggested code in each Change() sub before the DoCmd.OpenQuery line. Thank you. Edit* Whoops, I thought it worked, but it only works once. If I go back and try to repeat, it wipes away the cascading options. I guess I don't understand what you are suggesting. *Edit

I have a set of 3 cascading combo boxes in a form that are intended to let users update values in a table as they need to. There is no need to maintain the old values when the data is updated, so I am doing two things. When a combo box is updated, I run queries on the other two to refresh the...

The_Doc_Man, Thanks for the advice. I'll think about how to apply this to my situation. jdraw, I have a basic working knowledge. I've built a couple databases for different purposes here at work. For what its worth, I've also worked through an online course that included the basics as well...

The process is early. All the meeting amounted to was basically "These are the documents we want to keep track of." I'm familiar with most of them and how they function in our workplace. The use of the word "generally" was a poor choice. Lets take for example standard operating procedures. All...

I just left the first design meeting for a database my superiors want me to create, to track documents used in the office. Many of these documents have due dates. The QA manager spoke up about one document that could have an extension to the due date. Due dates will generally be set by an...

I built a sandbox for testing functionality of the idea, and it looks just like that. The ProjectOwner and TaskOwner tables are just renamed aliases of the Owner Table. I was able to construct a report from this query that groups by ProjectName, that looks just as I had hoped. Thanks again. By...

This is a revelation! I didn't know this was possible. This solves the problem. I now have a query that aligns tasks with their related projects, and tasks and projects with their owners. Thank you so much. I also learned how to change the alias for the tables, so the names make more sense than...

I have figured out that I can work around this by having two Owner tables 1. Project Owners 2. Task Owners Is there no way to use a single table? In the real world of my little database, many of the names on these two tables will be the same, though there will be some task owners that won't...

1. A Project may have many associated tasks 2. A Project will have one owner 3. A Task will have one owner 4. A Task may or may not have the same owner as its associated Project

What I have 3 tables Projects Tasks Owners Tasks are linked to Projects via FK (Project PK) Both Tasks and Projects have FKs, that are the Owners PK. I am trying to create a query to be used to build a report where Tasks are grouped by Project, and each Project and Task Owner is also shown...

Thanks for replying. I hadn't considered the sub form idea. I made a quick demo and it appears to work like a charm. I can use this same basic format making the sub form a continuous form for the existing projects and related existing tasks too. Thank you.

Here is the scenario: Form 1 - Data entry for a new project Form 2 - Data entry for a task associated with the project in the Form 1 Button on form 1 that opens Form 2. What I am trying to do: Use a combobox on Form Two to choose the Project entered into Form 1, so I can capture the Form1...

Thanks. I don't know why it never occurred to me to post on his blog.

I am using Scott Gem's tutorial to set up an audit trail. http://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/ I am having a bit of trouble with one part of it. The DB I am putting together has a login form with a combo box for the user name, and a textbox for password...

Printer is set to "Normal" quality, whatever that means.

Printing to pdf does make a difference, but check boxes still aren't as "black" as black text on the same page. Sort of that default gray that is so common with Access. I tried changing the Shape Outline, and a few other things, but none of those things appear to have any effect on this...

The printer issue occurred to me, and I figured that by amping up the print quality I could get a better looking box, but that I couldn't expect everyone who might print one of these would know to do that. The check box looked fine on a monitor, and I never tried to print a pdf. I've already...

That is brilliant. I keep running across tutorials by Allen Browne, and he seems to come up with a work around for almost anything. Thank you very much. That said, why wouldn't MS make this a simple thing? Seems like my particular application requirement wouldn't be that rare in the real world...

I have a form with a Yes/No checkbox. Sometimes a data entry person will use this, sometimes an associated report is printed and a technician in the field will be required to fill check the box by hand and return the report for data entry. Makes sense right? Here's the problem, no matter what I...