Access Continues Form With Form.open Event (1 Viewer)

H

haxan786

Registered User.

Local time

Today, 12:37

Joined

Jul 27, 2019

Messages

13

• Jul 28, 2019

• #1

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

I’m here to help

Staff member

Local time

Today, 01:37

Joined

Oct 29, 2018

Messages

21,467

• Jul 28, 2019

• #2

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

I’m here to help

Staff member

Local time

Today, 01:37

Joined

Oct 29, 2018

Messages

21,467

• Jul 28, 2019

• #3

Cross posted here.

 

H

haxan786

Registered User.

Local time

Today, 12:37

Joined

Jul 27, 2019

Messages

13

• Jul 28, 2019

• #4

theDBguy said:

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?

Click to expand...

sorry for the cross post.

please see my tables and guide me to design form

 

Attachments

• TEL-Test.accdb

  812 KB · Views: 85

mike60smart

Registered User.

Local time

Today, 09:37

Joined

Aug 6, 2017

Messages

1,904

• Jul 28, 2019

• #5

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

 

H

haxan786

Registered User.

Local time

Today, 12:37

Joined

Jul 27, 2019

Messages

13

• Jul 28, 2019

• #6

mike60smart said:

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

View attachment 75713

Click to expand...

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.

 

Attachments

• Daily Declaration.pdf

  96.2 KB · Views: 113
• Downward.pdf

  99.9 KB · Views: 94
• upward.pdf

  99.5 KB · Views: 95
• temp.pdf

  98.3 KB · Views: 96

H

haxan786

Registered User.

Local time

Today, 12:37

Joined

Jul 27, 2019

Messages

13

• Jul 28, 2019

• #7

mike60smart said:

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

View attachment 75713

Click to expand...

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

Ignore List Poster Boy

Local time

Today, 04:37

Joined

Apr 27, 2015

Messages

6,331

• Jul 28, 2019

• #8

haxan786 said:

sorry for the cross post.

Click to expand...

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

 

H

haxan786

Registered User.

Local time

Today, 12:37

Joined

Jul 27, 2019

Messages

13

• Jul 29, 2019

• #9

theDBguy said:

.

Click to expand...

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