Re: Using an unbound form for displaying and updating data
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Tue, 22 Apr 2021 03:02:03 -0400
Hum, take a look at:
http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html .
Also, even if the dates for each inspections schedule doesn't exist, this
doesn't prohibit you to create a simple query; as you can put a lot of stuff
in a query. However, I don't really understand the distinction or the
relation between the table tblInspection and the Inspections Schedule; so I
cannot tell you anything more on this.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"AkAlan via AccessMonster.com" <u18147@uwe> wrote in message
news:8305916c20d20@xxxxxx
Sylvain, The dates for each inspections schedule doesn't exist so I can't
make a simple query. I have stored the inspection, frequency and day due
from
there I could run code to determine the due date based on the month the
user
wanted to see. I want to populate a form by using that code then allow
the
user to enter a date completed field which would then update the date
completed table. I went ahead and took the advice posted here and
populated a
table with each inspections due date manually but thought that if I could
do
this in code on the fly I would never have to calculate the date due
again.
Thanks for your reply.
Alan
Sylvain Lafontaine wrote:
Any reason why you wan to use an unbound form? Also, it's not clear what
you mean by "entering data into a recordset". Do you mean by that that
you
will create a disconnected local recordset and populate it with the data?
The best way would be probably to use a simple query that will retrieve
all
the required data in a single step. I don't understand why you would want
to use a temp table or a local disconnected recordset here; excerpt maybe
for this unbound form thing.
I have an Acces 2007 project using SQL Server 2000 as a backend.[quoted text clipped - 36 lines]
Thanks.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200804/1
.
- References:
- Using an unbound form for displaying and updating data
- From: AkAlan via AccessMonster.com
- Re: Using an unbound form for displaying and updating data
- From: Sylvain Lafontaine
- Re: Using an unbound form for displaying and updating data
- From: AkAlan via AccessMonster.com
- Using an unbound form for displaying and updating data
- Prev by Date: Re: Using an unbound form for displaying and updating data
- Next by Date: MSSQL Restore Error: The system database cannot be moved by RESTORE
- Previous by thread: Re: Using an unbound form for displaying and updating data
- Next by thread: Best method to connect Java Application to SQL Server 2005
- Index(es):
Relevant Pages
|
