Search results

Hi theDBguy: Thanks very much for the well wishes and especially for all your help! You folks are outstanding!! Cheers, Big D

Hi Isladogs: Yeah, I think so. What I have seems to be working correctly and the forms are editable so I'm going to run with it for now and see how it works out. Thank you again for all your help. There's no way I would've advanced the ball this far with that database without the help you...

Hi Isladogs: Now I understand what you mean by form not being editable. I just tried to change info in a manually entered field and I can't. Unfortunately, Revision 3 won't work for me as the form fields need to be editable. Cheers, Big D

Hi Isladogs, Yeah, I guess I'm somewhat confused because I just opened Revision 3 and if I place the cursor in a field and left click the mouse, a menu opens allowing me to edit the form, please see attached screenshot. Thanks very much for your help. Cheers, Bruce

Good Morning Isladogs / theDBguy / Pat Hartman, I'd like to thank you all for all the help and support you have provided me to help me get through this problem. I can't thank you folks enough for all that you do! Based on the latest information it sounds like I should be putting Revision 3...

Isladogs, I just figured out how to set the ID to primary key in the task table. Any idea how I can get rid of the duplicate repords?:confused:

Hi Isladogs & theDBguy, Thanks very much for following up with me so quickly. Isladog's proposed solution looks like it might be the easier one to implement. So I'll try that first and if that results in no joy, I'll try theDBguy's proposed approach. Isladog, I do have a question. I was able...

Greetings: Has anyone experienced forms duplicating resulting in multiple records? Attached is a zipped copy of my database. The first button shown on the switchboard is titled "Enter Project Details." scrolling through the records on at time, you'll be able to see the records that were...

Hi theDBguy, Got it changed. Thank so much for your patience and all your help!!!:) Hope some day I can return the favor. Thanks again!! Cheers, Big D

Hi theDBguy, Yes, this will work fine. I see that when the "Priority" drop-down menu item is selected "Standard" work the "Billing Rates" field is populated with $70. This is the correct amount. But when "Emergent" work is selected from the "Priority" field, the "Billing Rates" field gets...

Hi theDBguy, Outstanding!!!! This day started out very rocky but looks like it's going to result in a great ending! Thanks a bunch for all your help!!! Cheers, Big D

Hi theDBguy, Absolutely, users should select the "new record" to enter a new task. I tried out the modified version that you provided and it works perfectly! No more error message popping up! I can't thank you enough for your help! :o All the fields in the form are working except for the...

Hi mike60smart & theDBguy: First of all, many thanks to you both for looking into my database problem. To answer your question concerning how the problem surfaces. Please follow these steps: 1. Select the "Task Details" button on the switchboard. 2. Select the LAST RECORD...all fields will...

Hi Bob, that might be the case. The first button on the Switchboard to "Enter Project Details" does have a link to "Add Task" into a subform but for some unknown reason shortly after launching the database, it started to duplicate the tasks and caused a huge amount of confusion. So I asked...

Greetings: Has anyone ran into the following error: The error: "The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value and then make the entry with the desired join...

Anyone here know anything about developing a database with Office 365 PowerApps and SharePoint? I've seen some references to Microsoft no longer supporting Access Web Apps and suggestions to using Office 365 PowerApps and SharePoint but the literature currently out there is very high level...

Thanks very much arnelgp; I good.... Cheers, Big D

Micron, I am not familiar with junction tables having a PK, Person FK, and Task FK. What is that exactly and how will it solve my problem of being able to assign two or more people to a task? Do you have an example of this that you can share? Thanks very much... Cheers, Big D

Thanks very much for your feedback. Greatly appreciated. Do you know if it's possible to select two or more names in the AssignedTo field and have this reflected in the reports? This would solve the problem of not being able to assign more than one person to a task. I actually attempted to do...

I want to copy all fields except for the AssignedTo field. Once the last entered record's fields are copied to the new record, the cursor should be sitting the the AssignedTo field and the user has only to select a name from the AssignedTo drop-down menu. All the other fields will already have...