473,320 Members | 1,951 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Q: Use a temp table for a single field or ?

I have a form that prints a report for a weekly staff meeting. On the
form is an unbound field to enter the staff meeting date, which is
subsequently used as a parameter in the report's query data source.

I'd like to have this date stored/recalled so that when the user opens
the form to print the report for the staff meeting each week, the form
"recalls" the previously entered date. That way the user doesn't have
to look at the calendar or guess.

Will I need to create a table just to store this date, or is there a
better way?
Nov 12 '05 #1
3 1453
You could make a table for this -type- of thing, and use different columns
or different rows to handle the different cases. Actually, though, I think
I would go for the table. If you have one setting you want to save today,
you may have more later, and it will be convenient if you have a table with
columns with the same names/types as you want to store.

Another option is to use the XML library to create and manage a settings
document in the same directory as the MDB. The advantage of this is that,
if you deploy a new copy of the database front-end, you don't erase the
user's preferences - they're still in the xml file.

On 21 Oct 2003 23:47:58 -0700, so*********@hotmail.com (John) wrote:
I have a form that prints a report for a weekly staff meeting. On the
form is an unbound field to enter the staff meeting date, which is
subsequently used as a parameter in the report's query data source.

I'd like to have this date stored/recalled so that when the user opens
the form to print the report for the staff meeting each week, the form
"recalls" the previously entered date. That way the user doesn't have
to look at the calendar or guess.

Will I need to create a table just to store this date, or is there a
better way?


Nov 12 '05 #2
There are a number of ways you can store this information, but the easiest
is in a table.

Personally I create a generic "Control" table for these bits of unrelated
data that are needed for the application to run.

Terry

"John" <so*********@hotmail.com> wrote in message
news:90**************************@posting.google.c om...
I have a form that prints a report for a weekly staff meeting. On the
form is an unbound field to enter the staff meeting date, which is
subsequently used as a parameter in the report's query data source.

I'd like to have this date stored/recalled so that when the user opens
the form to print the report for the staff meeting each week, the form
"recalls" the previously entered date. That way the user doesn't have
to look at the calendar or guess.

Will I need to create a table just to store this date, or is there a
better way?

Nov 12 '05 #3
Just create a table, and bind the form to the table with the one record. It
will automaticially remember the value, and it takes no code!

So, use a bound form! Assuming you have a standard split database, this
table can go in the front end, and thus you get a nice form that remembers
EACH USERS setting without having to write special code.
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: dev | last post by:
how create a temp table as a copy of a existing table and then update1 field and insert the hole temp table back in the existing table? please any help? if i have 10 fields in 1 record and...
5
by: Billy Cormic | last post by:
Hello, I am interested in dynamically creating temp tables using a variable in MS SQL Server 2000. For example: DECLARE @l_personsUID int select @l_personsUID = 9842
1
by: Robert McEuen | last post by:
Using Access 97 on WinXP I have data in a DB2 table that I'm trying to get into an identical table in my backend db. Based on volume of data and frequency of download, I'm trying to avoid...
4
by: Onion | last post by:
This has to be simple, but I'm forced to admit that I'm a novice who can't figure it out. I have a listbox in a form that allows multiple selections. That works fine. The problem: I can't...
9
by: BillCo | last post by:
I have a function which clears out a temporary table and then fills it with values from a recordset. One of the table fields is indexed with no duplicates. Very rarely - almost enough to ignore it...
1
by: John Dalberg | last post by:
I am getting "Input string was not in a correct format" error in a line like this: Int32.Parse(((DataRowView)e.Item.DataItem).Row.ItemArray.ToString()) Field #8 comes from a SQL Server stored...
2
by: Burbletrack | last post by:
Hi All, Hope someone can help me... Im trying to highlight the advantages of using table variables as apposed to temp tables within single scope. My manager seems to believe that table...
4
by: nerurmon | last post by:
Hai, I want to make a temp table in vs 2005. i have few field in one form and a datagridview. i want to make a temp table where i can store my different data in the controls(textbox, combo box) data...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.