I am new at the whole Access thing, and recently got a new job. I am creating my first database. I did so in Access 2003. My problem is, I have 10 tables, and I created a tab form with 6 tabs on it. When I enter data on the form/subforms I go out of it and go back into, all my data in the forms are gone. They are in the table though. Can someone please help me. I am sooo new to all this.
It is saving to the table but not the subforms. It is also saving it to the main forms that I created the subforms from. HELP PLEASE!! thanks.
Apr 2 '07
18  8093 
No that shouldn't be a problem but check the number type. It needs to be an integer and not something with a decimal.
No that shouldn't be a problem but check the number type. It needs to be an integer and not something with a decimal.
I checked them all and they are all integers. hmmm wonder why it is giving me that error message then.
aah, nevermind, found that, They have to having matching Fieldsizes if one is an autonumber and the other is a number.
Thanks for all your help. Hopefully this will solve all my problems!!
Yes, the field size is where you set it to be long integer, short integer, single, double, etc. :)
Yes, the field size is where you set it to be long integer, short integer, single, double, etc. :)
Thank you so much!!!
Rabbit 12,516
Recognized Expert Moderator MVP
Glad to help for once! :)
Denburt 1,356
Recognized Expert Top Contributor
Impressive, nice job Melissa.
Denburt 1,356
Recognized Expert Top Contributor
Oh and WTG Mary glad you got it.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Corinne |
last post by:
I have a database that contains the details of pupils in a school.
What I would like to do may not be possible but I thought I would ask
anyway. Each year the pupils move to a different class, there are 8
classes in each year that are named with the year and the class
teachers initials e.g 5FS would be a year 5 class, teacher Fred Smith.
So every year I have to change the class the pupils are in, thereby
losing the classes they have been...
|
by: Michael Plant |
last post by:
Hi all.
I'm trying to write my first Access database and I'm getting on well. It's
for my own small business use and the scenario is this. I have 4 or 5
suppliers who all email their product pricing and databases daily. As they
all use different formats etc, I have linked all their data and import using
append queries into a single table in a format of my choice. I then
manipulate the data and use it to update my pricing according.
I...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the data in each record, which
includes the ID of the father and the mother (who also have records in the
table). One record per form.
I have a Tab Control in the form, and in one of the tabs I have a subform
(sfmSiblings) in which I wish to list...
|
by: filbennett |
last post by:
Hi Everyone,
I'm generally unfamiliar with Access form design, but have programmed
Cold Fusion applications for a couple of years.
I'd like to build a data entry form in Access that allows the
following.
First, the data schema: Three tables are involved. The first is a
PERSONS table which has two fields, SSNUMBER (primary key), and NAME.
|
by: fonzie |
last post by:
Is it possible to have a data entry form where the information is
stored in several different tables (5 or 6)? I have an inventory
database where Table1 stores all of the data common to all entries,
Table2 stores only the extra info relevant to items that are TYPEA,
Table3 stores only the extra info relevant to items that are TYPEB, and
so on. All relationships are setup (one-to-one) between the main table
(Table1) and all the other...
| | |
by: BD |
last post by:
Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed...
|
by: dac |
last post by:
I am quietly going insane on this project. I've never worked on a project like this one before. All my previous sticky forms were for data entry, not editing. I don't know how to display the form with data from the database, allow the user to update it, and then display the form again with POST data. I can get the data out of the database and get the user updates back into the database, but how do I get the filled-out form back to the user...
|
by: glamster7 |
last post by:
Hi Folks,
I have a form frm.viewbookings which shows in the header the labels Stylist1 through to Stylist 7 with the stylist names underneath them. In total for the set of data I have there are 14stylists. Ok behind all this we have 2 tables tmp_bookingsGrid & tmp_clientGrid.
Also in order to populate the form we run several queries in order to populate these tables with the required data & show the following in the detail section of...
|
by: Ian |
last post by:
I have a form with a sub form, on the continues sub for I want to
display some data along with a picture, on the On Current event I have
the code:
.Picture = Nz()
is the name of the picture control, is the name
of the text field that holds the path to the jpg.
What I want is each record in the sub form to show the associated
|
by: Lucas45 |
last post by:
Hi I am a newbe at this
I have created 3 tables one called computers the other software- and the third installed apps What I am trying to do via a form is to have on the one side a combo box showing the p/c names, and on the other side a combo box showing all the apps. What I am trying to do is to select a pc name from the p/c name combo and then selecting a few apps from the other combo box (installed aps) and this info is written to a table...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
