Search results

That's a lot to consider Doc Man! For what we are doing, I don't think we need the level of complexity you used. This is only going to be a project management tool. The risks we are tracking are only related to impacts to the schedule and costs of the project for the owner...

I'm starting a similar task. This one is to be used for heavy construction projects (roads, bridges, freeways, transit, utilities, etc.) I have been given a spreed sheet from another project to base is on. I've attached that.

Thank Mark. That did the trick!

The error seems to be related to the Where statement, base on the message.

Still something isn't right "SELECT '" & NewArea & "' As Area, Job, item " Error 3075 Syntax error (missing operator) in the query expression 'Area=ADA West AND Job = '04SF-190"

Thanks Mark. That was revieling but how can I translate that into VBZ? DBGuy, Still getting an error. Changed the code a little to better match what I am trying to accomplish. I want to add the Job and Item with the NewArea for the Area value. strSql = "INSERT INTO...

Data type is short text. Changed the insert order. "INSERT INTO [tblDurationAnalysis] ( Area, Job, item ) " & _ "SELECT " & NewArea & " As Area, Job, item " & _ Got the same error. Error 3075 Syntax error (missing operator) in the query expression 'text entered in...

I am trying to duplicate a record on a form and change one field based on a user input. I have based the code on this from Allen Browne: http://allenbrowne.com/ser-57.html I am having trouble with the where clause in the SQL. I am not very familiar with SQL. I get a Error Syntax error...

I set a reminder for 2/8/2018. Thanks!

Thank! works like a charm. Would appreciate any other feed back. Access is kinda a hobby for me - and I know there is a lot I could do better. Been playing around with it for 20 years, mostly learning on my own through the web.

OK. Thanks for bearing with me, and more importantly, your interest! The data base is used for assigning items for various people to do; i. e. a to do list, or Responsibility tracker. I am using it as a project management tool. The "To Do List Entry" tab is the one to focus on. This is...

Sure. The user would enter a contract, the who (person), and the what on the form. Then when closing the form (or moving to a new record), a record in tblToDoListLog would be created with the name of the person in the Who Field, today's date in the DateAction field, the ID of the todo item...

Here you go. The form I am working with is frmToDoListEntry

I get an error message saying "You cannot add or change a record because a related record is required in table "tblToDoList"" This record would be created in the form - so after updating, I guess.

Sounds like a good plan, but I'm not clear on how to check that in the BeforeUpdate event.

I would like to enter a record in a table if a value of a control changes on a form. I would also like to enter record in the same table if the record is new with a differing value in one of the fields. I can code the first part, but have not been able to figure out a way to get the 2nd...

Sorry it took so long to get back to you. needed to learn about the Immediate window 1st! :) Anyway, here are the heights: 15 1855 2212 15 1855 1943 15 15 1515 1408 15 6876

Really appreciate this info. I'm dealing with some other issue today, but tomorrow, I will dive back in and see if I can answer your questions. Have a great Monday! (no, I have no idea where the 6500000 came from)

Isladogs, I put the debug code in the on print event for the form and the error message disappeared. E-mail was generated. Thanks! Can you easily explain to me what the code did? Thanks again and have a fantastic weekend.

isladogs, The height various with the number of records. The number of pages in the report is 14, and yes there are page numbers. Where do I place the debug code?