Access Continues Form With Form.open Event

[haxan786]

Hello

I am designing a continues form but also want to load 24 hour time slot from my Table "tblTimeSlot". When form opens it import 24 entries from table for Time and all other entries can be added manual. Is there any solution ?


Example on Form OPEN

Hour-------------Temperature-----------Load
00-01--------------manual entry------manual entry
01-02
02-03
....
23-24

 

[theDBguy]

Hi. This should not be a problem. But again, designing a form before the table is typically considered a backwards approach. Can you show us your table structure please?

 

[theDBguy]

Cross posted here.

 

[haxan786]

Hi. This should not be a problem. But again, designing a form before the table is typically considered a backwards approach. Can you show us your table structure please?

sorry for the cross post.

please see my tables and guide me to design form

 

[mike60smart]

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

 

[haxan786]

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

View attachment 75713

Find attached docs to see how my form should be working. Each form will have 24 hour readings but I am confused. If I go for separate reading for every hour this will make my database an excel spreadsheet.

 

[haxan786]

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

View attachment 75713

I have also designed the database but now I want to start new database with data normalization. I am sharing the download link if my database where tables look like spreadsheet. I need help in database normalization

I cant upload database due to size limit and link due to 10 post count.

 

[NauticalGent]

sorry for the cross post.

Cross posting isn’t a cardinal sin, but there is a way to go about it.

Give this a read:
https://www.excelguru.ca/content.php?184

 

[haxan786]

.

Can you check the attached forms and guide me to design table structure.