problem with database

[mike leach]

Hi Ultra Excellers database is not working now!! not sending data to database. Also can anyone help with setting up a chart to store information of earlier amber and lates for each run. A sheet after database. Put a screenshot of the marco's, if that is correct.

Also the image below shows what I am trying to get for earlys & on time = green.
amber (15 mins cushioning time after the on time ) = amber colour.
Then after the 15 mins is up it is a class as a late = red colour.

I am so close to completing this loading sheet for work tonight please if anyone has a bit of time help me that would much appreciated....

 

[Chihiro]

Well, you've got no table in your workbook named table_database. That's your main issue.

 

[mike leach]

Well, you've got no table in your workbook named table_database. That's your main issue.
View attachment 48718

cool thanks for the reply how do solve the problem?

 

[Chihiro]

... rename the table or change code to match actual table name.

I haven't gone through entire code. So there may be other issues.

 

[mike leach]

... rename the table or change code to match actual table name.

I haven't gone through entire code. So there may be other issues.

cool maybe send an image of where I change it, a bit lost how to do it.

 

[Chihiro]

It's highlighted in your image.

 

[mike leach]

It's highlighted in your image.

what bit do I rename in the high llighted bit?

 

[Chihiro]

The table name. Refer to link for table reference convention.
http://www.informit.com/articles/article.aspx?p=2455213&seqNum=16

 

[mike leach]

The table name. Refer to link for table reference convention.
http://www.informit.com/articles/article.aspx?p=2455213&seqNum=16

you can see how much I have done just please need a bit of help to finish it.

thanks

 

[NARAYANK991]

Hi ,

See the attached file , where I have done only the renaming ; I have changed all references in the code from table_database to table_database4 , since the latter is the name of your table.

Narayan

 

[mike leach]

thanks for doing that, sorry I didn't reply but I was at work. Cheers. Slight problem though on database not adding info correctly not adding to but going over it. as seen in screen shot. uploaded your test again to. But nearly there with it. Also I don't know when you are inputting times some are 24:00 and some are 00:00? but the formula is the same.

Thanks again. Much appreciated. You don't pressure I am under to get this up and going, and I said I would do it as favour to the team.

Hi ,

See the attached file , where I have done only the renaming ; I have changed all references in the code from table_database to table_database4 , since the latter is the name of your table.

Narayan[/quote

 

[mike leach]

Cheers. for helping me so far, Slight problem though on database not adding info correctly not adding to but going over it. as seen in screen shot. uploaded your test again to. But nearly there with it. Also I don't know when you are inputting times some are 24:00 and some are 00:00? but the formula is the same. Also lastly why does bright red show up when I do the information into the database, I have looked everywhere, but I really don't how it started being their, the command button for the date doesn't work. thanks again for all your help!!!!!!

Thanks again. Much appreciated. You don't pressure I am under to get this up and going, and I said I would do it as favour to the team.