Search results

Not working. Me.FileName = tFileName

The dialog form can be called from different forms.

How do I populate a text field on a dialog form to the value of a filed on the calling form?

I'm open to better design ideas. Surprised this hasn't come up before. Please just focus on this aspect of it and ignore the multiple checklist part. For the different input types, my idea is to add a field to tblChecklistTasks, let's call it InputType, long integer; e.g., 1=date, 2=Y-N...

Got it working. That spelling was fine, though I corrected something inside quotes. Not sure how that or whatever else I did fixed it, but I won't complain. Thanks

P.S. I don't normally pre-define table relationships. I let that happen through the form/subform and query design.

Without revealing too much, we manage remote payments for different companies. There are a number of different products. The payments can come via different sources, with each source being a different type of product. Different industries can have different products. Within each product, there...

See attached

Yes, intellisense does show ChecklistID

I have a set of checklists using the standard vertical format: tblList, tblData, tblMaster (see thread http://www.access-programmers.co.uk/forums/showthread.php?t=283525) The twist is that not all of the tasks are the same type of field (in this case, I'm using a date field; click and it...

I'm getting this compile error, on the code below, on .ChecklistID even though ChecklistID does exist on the form. stSQL = "INSERT INTO tblChecklistData SELECT " & Me.ChecklistID & " As ChecklistID, TaskID FROM tblChecklistTasks WHERE tblChecklistTasks.ListID=" & Me.cmbListType It compiles...

I would let them use the main form. They would enter both the client's name and the proj type. The Smiths might have multiple projects of the same or different type, either simultaneously or over time. The Jones, Glenns, etc., will have projects too. The SQL to insert the tasks into tblData...

Yes and no. You helped me improve how I do checklists. However, the original question was how do I manage multiple checklists. The different checklists are not as part of the same big project as in your video examples, but different, unconnected ones. Suppose you are a security company...

Yes they are all in one database. Doesn't seem to be a compelling reason not to.

When you have a chance, I'd appreciate it. Briefly: The group I work with has created checklists for different types of projects. Each type of project (e.g., adding a new client, adding a new product/service for an existing client, POS name change) has a different checklist/set of tasks...

Giz, I've watched the multiple list videos. Other than adding the Group field, that's not what I'm doing. Each project will only have a single list. Depending on the type of project, it might use the ceremony, or honeymoon, or apparel list. How would I do that? I think I would still use...

Thanks. The idea for a single list makes sense, meaning I get the logic with tbls Master, List, Data, and the code of how to make them work. I'll start there - baby steps. Maybe I'll celebrate NYE watching the multiple list videos after the kids are in bed. I know the time zones. 26 years...

I'll track the discussion, but I won't get back to the project until next Tue. Until then, Happy New Year to you Giz in 5 hours, and you Paul 1 hour after me.

I've started watching the videos. It'll take some time for me to absorb the vertical structure. It's always good to learn new techniques that I can use over and over again. However, I don't see how it addresses the problem of different types of checklists. It's not adding an item to a...

They are actually date fields, but function like Y/N. Why is that a problem? There are also comment fields associated with each step.