Recent content by DavidDrotts

Hi Bob! Thank you...again! I am going to use your suggestion. I didn’t even think about using the DCount function in an If statement, but that is why I love building applications…there is always another way to do what needs to be done. Take Care, David

Hi PHV, Thanks for your reply! I fixed my problem; I did not put single quotes around my variable ("'" & [Forms]![AddKid]![last] & "'"). See below… strSQL1 = "SELECT idnumber, last, First FROM Kids WHERE idnumber In (SELECT idnumber FROM Kids As Tmp GROUP BY idnumber HAVING Count(*)>1 ) AND...

BSman, Thanks for your reply. In an effort to get a handle on this I am forcing myself to create/execute all of my queries in VBA. I am working on a project that requires the user to input data and assign a user ID so that they can retrieve the data at a later time. To make this even more...

Thank you all very much for your inputs. I think it’s interesting that they led me to the one area that I have cringed at learning…using SQL statements (besides the real basic stuff)in my code. When I do projects I find creative ways to avoid using SQL statements. I don’t have a good reason...

Crowley16, Thanks for the response! A temporary table wouldn’t work because I need to keep track of the tasks per week. I should have further explained in my post that the Admin form is bound to a table that keeps track of the weekly inputs. For example this shows just the DPC section, there...

Hello, I have built a database, Weekly Activity Report (WAR), that keeps track of the workflow in the following five work centers: DPC, DPE, DPF, DPM, and MOF. Updates to the progress of the tasks assigned to each work center must be updated weekly. In order to keep track of which work center...

Hello, I have built a database, Weekly Activity Report (WAR), that keeps track of the workflow in the following five work centers: DPC, DPE, DPF, DPM, and MOF. Updates to the progress of the tasks assigned to each work center must be updated weekly. In order to keep track of which work center...

Jvhazelbaker, I am trying to accomplish the same, and like you, I am having a hard time figuring out what to do. I have tried linking the task folder to my access database, but the only fields I get are the following: % Complete Team Task Start Date Due Date Date Completed Actual Work Total...

Hello! I am trying to build an access database to accomplish the same thing that MS Project accomplishes. My table has the following fields: ID, Task (memo), Start (short-date), Finish (short-date), and Duration (number). Tasks will be inputted by the user; when they input the duration...

ineedyourhelp, How did creating a custom shortcut menu help? I have the same exact problem you did. Please explain what you did to solve your problem. Thanks in advance! David

Hi Rick, You are right I need to straighten out my terminology. To clarify, “Address” is an unbound control on the sub-form “CPOStatus”, which is on the form “CPOOPRfrm”. The SQL Staement is, as you surmised, in the row source proerty. On db open the splash screen will have the hidden...

My apologizes, I didn’t expound upon the field enough and mistakenly called it a text box. In fact, it is a list box and the SQL statement that is firing comes from the row source of this field. This one statement cause three “Enter parameter value" prompts, and it looks like this… First...

When I open my form normally everything works fine. It is only when the form is opened via VBA do I get the “Enter parameter value" This is the query that it is firing on… SELECT DISTINCT CPOemail.[Supervisors Email], CPOOPR2qry.OPR, CPOemail.Last FROM CPOemail INNER JOIN CPOOPR2qry ON...

Hi Rick, I guess you can say I am struggling, but I am having a blast along the way. I came up with the following solution to passing the Form name to the docmd.formopen. It’s not very inventive and I am having problems with my stLinkCriteria statement, I keep getting “Enter parameter value"...

Hi Rick, Feeling a little stupid here… I have never played with the Dlookup function before ( I have only been building applications for 4 months and my knowledge comes from interlibrary loan books!) so I didn’t even think of going down that road. Thanks for pointing it out! BUT…I am still...