Problems With Relationships Showing Up In A Form

Nov 27, 2006

I'm designing a relatively simple access database with four linked tables:

- users
- computers
- licenses
- license_users

Each user as a computer_id linking to the computers table; they also have a set of rows in license_users, linked via their userid, that join them to the licenses table. The relationships are enforced with referential integrity. Everything works fine when I enter data manually in the table datasheet view.

I've designed a nice form to make it easier to enter data for all the tables at once, but when I try to enter the data it all goes wrong. I'm unable to enter any data into the users table fields until I have complete the computer and license data. If I enter that first, then start entering data into the users fields, the computer data suddenly disappears. If I inspect the table then the computers and license_users has been entered, but nothing is entered for the user and I can't get the rows to relate to the users!

It's a while since I designed any Access databases, and I'm stuck, so suggestions would be appreciated.

View Replies


ADVERTISEMENT

Help Please! Form And Relationships Not Working

May 8, 2005

Hi- I am trying to create a Registration form for Events and I'm having endless trouble getting it to work.
Basically, I have four tables: Contacts, Registration, Payments, and Events.

I either cannot delete registrations when I need to-I delete a record in the form, but when I reopen it it is there again; or the pmts table is adding blank records.
So when I try to create a query to get a list of registrants, I will get two fields with the same name and Reg Id, and one with a pmt and one without.
I want one record per person registering and Im not getting that in my database.

Most, but not all, people are paying for events. Some people are staff or scholarships.
I want to be able to see just one record for every person who has registered, whether they have paid or not.
Im either seeing two records with the same reg number, or missing people that have not paid.

I have tried all kinds of configurations as far as relationships and Reg form and Im pretty stumped at this point. Any help would be greatly appreciated!

View 1 Replies View Related

Form Not Showing

Mar 1, 2005

Hi,

I have copied a form and changed the table it is linked to. however, now it just shows a blank screen, not any fields.

I have spent hours on this, please can somebody show me what I have not changed. i have attached the database.

thanks in advance

lee

View 3 Replies View Related

Form Min / Max Not Showing

Mar 6, 2012

i need to size a form so that it does not fill all the window, i have tried enabeling the min and max buttons but they will not display for some reason, i changed the borderstyle to sizable and the controlbox to yes the min and max buttons are enabled , but still not showing the min and max buttons, the close button shoes and thats it? i am running 2010.

View 3 Replies View Related

Form Showing Entry

Nov 1, 2007

I have got a db when I enter a new client in the client form it saves it in the table but when I return to the form the client I have just entered is still there so I cant enter a new client it does'nt clear the text in the text box can anyone help

Thanks

View 2 Replies View Related

Second Form Showing Same Record As First?

Mar 22, 2005

Hi,

I have a main form that displays records with a couple of sub forms and it also has a button to open another form which is based on the same table main table but different sub forms.

All I am trying to do is open the second main form by clicking the command button and to automatically display the same main record as shown on the first form before clicking the button.

Sounds simple but I can't find how to do it.

Any ideas appreciated........Stuart

View 1 Replies View Related

Form Not Showing Records

Sep 15, 2005

Hey Gang,

Thanks for all your help on my previous problem but I now have another one that just seemed to start out of the blue. When I open my form the record selectors don't allow me to browse through all the previously entered records. This is a huge problem because if changes need to be made I can't call up the record to do so. I plan on adding a search funtion to the database soon but for now I need to be able to search through the records on my main form. Is there something I should look for or do you have any suggestions?

Any help would be greatly appreciated.

Cheers,

axsnub (access newbie)

View 5 Replies View Related

ID Showing On Form, NOT Number

Sep 21, 2005

Hello,

I am building a relatively small database, but it is made up of a number of different tables which are fed by other tables.

My three main tables are:

EmployeeDetails
Occupational Risk Profile
Health Surveillance Requirements

The employee details table has fields fed by small tables such as Department, Location, Business Unit, Occupational Group etc. These are all made up of an autonumber primary key column and a variable column as described above.

I have been going round in circles with a lot of this as I am still learning.


My problem is that on my forms these fields are showing as numbers and not the text values. For example, I have one form made up for each of the main tables above but I can't get them to display the relevant text.

I did a search on here and somebody said to create query to link the tables and bind this query to a form.

How do I set up the query just to return the text part and not the number?
How do I bind this query to the form if I already have the record source on a my form as a table? (can you have more than one source in the record source?)
Do I create one large query with all of these fields and use this as the basis for the form?

Thanks

View 5 Replies View Related

Fields Not Showing On Form

Aug 15, 2006

I have created a form off a query. I made the form for adding new records only. When i bring up the form it is blank, the labels and fields don't even show. Anyone know why this is?

Thanks in advance for your help.

View 2 Replies View Related

Records Not Showing On Form

Sep 7, 2006

I have created forms to add data. What i do is click the add new record command button and add the details. But when i open the form again, it does not show the record which i have just added. However the record is present in the tables.

got any ideas? please help:(

View 1 Replies View Related

Form Design Strategy On Schema With Many M-M Relationships

Nov 4, 2005

Hello,

I have a couple of elementar level questions on Form creation process and standards invloving a schema with several M-M relationships. I have a highly normalized design (thereby producing several junction tables). I have attached a picture of my schema to give an ideal of the schema I am talking about.

1. What is typcially the process of creating Forms on such a schema for the purpose of data-entry. Meaning, should there be several Forms (on the order of # of tables) or should there be a few that enables simulataneous data entry to many tables through one Form. What is typically the practise?

2. If there are 3 tables (A, B, C) so that A and C have a M-M relationship and B is a junction table that makes A &B and A & C have a 1 - M relationship, then how does one enter data for A, B, and C so that all the three get populated?

3. Can someone provide a copy or link to a sample database that has a similar normalized schema and Forms built into it that takes care of the data entry to the various tables?

Thank you very much for some light on this path.

View 3 Replies View Related

Showing Records With A Null Value On Form

Apr 26, 2006

Ok this null value thing is killing me. I have a parameter query that works great. I know if I use Is Null in the criteria field it will show me this. The problem is I made a search form which the users type the value in and it opens a form based on the parameter query, the parameter on the query is [Forms]![Search_frm]![txtClosed]. If they type a date in here it opens the form and shows the user all the closed records. The problem is they want to see all the records that have no value or Null. I've tried eveything to make this work. I'm ready to jump!! Just kidding. Is there a way to do this with out creating another query. Thanks a bunch!!!

View 2 Replies View Related

Form Values Showing As 1, 2 3 Etc In Reports

Jun 15, 2005

Hi Guys,

I`ve searched the forums, but not knowing the terminology, i cant find what I`m looking for.

I have a table which is use for a drop down list in my forms.
This is saved into a table, but shows up as a numerical instead of the name value.

Also In reports, I get a numerical value, instead of the text value.

Is there something I`m over looking ?
Or am I doing something totally wrong.
My relationships are correct. and the field data is right, I just cant over come the number issue.

Thanks in advance.

View 6 Replies View Related

Showing A Value If The Data In A Form Field = Something

Aug 18, 2005

I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text?

for example:
txtDate is 1/1/1000
if txtDate = 1/1/1000 then display = "*"

but the query still runs on 1/1/1000

I am asking this because I am trying to run a between statement for a date range and the only way I can do the entire range of dates on my table is to use the highest and lowest date possible (1/1/1000 and 1/1/3000) but I only want the users to see "*" so they are not confused.

View 1 Replies View Related

Change Record Showing In Form

Dec 14, 2005

Hello,

I have another question about ACCESS forms. With VBA, I want to change the record showing when I open a form.
I see there is a member "CurrentRecord" so I tried in the class module

Me.CurrentRecord = 2

I compiles but gives runtime error that is write-protected and cannot be changed. In the ACCESS help I read you could do it but HOW?

What should I do ( I am using ACCESS 97 ) ?!

Thanks in advance

Victor


PS : Is it true that VBA in newer versions of ACCESS has more features/functions etc?

View 7 Replies View Related

Open Form Showing New Record Only

Mar 28, 2006

Hi all,

Is it possible to open a form so that it shows the new record fields only? I want to create a form that only allows the user to enter data and not view any of the records in the table the form is linked to.

Cheers,

Matt

View 1 Replies View Related

Showing Query In A Form And Using Filter

May 26, 2006

so I have been working on this form for a while and I'm really a newb at this
maybe it easy maybe its not but i just couldn't figure this out
I'm so frustratated that I'm willing to pay(beer money for help)


well anyways I have this form
http://i27.photobucket.com/albums/c176/rlan214/WorkAssignForm1.jpg
at the side you can see that there are 3 filters
1st has check box (check box is always checked) for the date
2nd check box for Target Location
3rd check box for ForkliftID1

I also don't know how to change the date format in my date
its in yyyymmdd format right now and I want it mmddyyyy

In the middle theres a blank, and thats where I wanted my
query to show

here's my query
http://i27.photobucket.com/albums/c176/rlan214/WorkAssignQry1.jpg

View 1 Replies View Related

How To Load A Form Into Memory Without Showing It?

Jun 26, 2006

How can I Load a Form into Memory without showing it?

I have a DB with some Forms. None of them are open. I want to check some properties of each form without actually opening them. How can I do this. Probably by loading it.
Can anybody tell me how to use the LOAD command to load the Form?:o

View 4 Replies View Related

Showing Photos In An MS Access Form

Aug 5, 2004

Access 2003, Win XP Pro

I have tried to find information on how to do this but everything I try fails.

I have a form on which I want to display JPG photos which are stored in a folder called FCP. The path to each photo is stored in the database table. Each record will have one photo only and the path looks something like this:

C:Documents and SettingsBKALProjectLRFCP4.jpg

Can someone tell me exactly how to design a form picture field that will display the relevant photo?

Thanks!

View 3 Replies View Related

Forms :: Total Sum Not Showing Up In Form

Aug 27, 2014

I have a query that has a total sum , my problem is when i create form all the fields in the query is visible in the form but my total sum doesnt show up, but when i view it in query it works properly.

I don't really know what the symbol really is called i just called it total sum, the E icon in query ....

View 7 Replies View Related

Cleaning Up Access UI And Showing Only Form

Oct 27, 2014

I want to release an Access file which has eveything locked down and cleaned up so that my Form is showing full screen (and nothing else) for an optimal user experience.

View 2 Replies View Related

Continuous Form - How To Display Info From Tables With One To Many Relationships

Apr 25, 2006

Hi everyone,
I've tried several different things to get around this problem and have found out a lot about what won't work!

Basically I am building a HR database. The main table is M_CandidateDetails and the primary key is CandidateID. This is a foreign key in all of the other tables: MCandidateEducation, MCandidateEquipExp, MCandidateSector. (I've attached a screenshot of the relationships.)

Goal:
What I want to do is create a continuous form with one record for each candidate. A record will show all of the info pertaining to a candidate. The form is to be used to for searching and filtering candidates.

Attempts..
First I tried creating a query to combine all of the information. (I've attached a screenshot of the query). The only problem with that was if joe bloggs had worked in 3 different industry sectors there would be 3 records for him. (I did have problems with the query not being updatable - solved that though by using the Dynaset property of the form)

Next I tried basing the form only on the M_Candidates table and using listboxes to display the information from the many-side of the various tables. But that didn't work as you cannot use an unbound control on a continuous form.

Then I tried putting in subforms instead of listboxes but you can't use subforms on a continuous form.

I'm out of ideas now- can anyone give any tips?

View 5 Replies View Related

#Deleted Showing On Form And Error 2455

Mar 1, 2005

Hi,

Sometime when I delete a record on a form using the wizard delete button and I move between records, #Deleted record shows up.

Can anyone help me in getting rid of it? or why is it ocurring?

Also, I am getting error "2455 : You entered an expression that has an invalid reference to the property |"

thankyou.

View 5 Replies View Related

Disable Showing New(empty) Record In A Form??

Apr 29, 2005

Hi,

I am currently working on a database and I'm using a form to view the records. A standard Access behavior is to show an empty record (new record) as the last one. is there a way to disable this "feature". I would like my form to display only the records, which are really filled with data and not show the blank one at the end??

Thanx in advance
Luke

View 3 Replies View Related

Form Showing Info Pulled From A Query...

Jun 20, 2005

Actually, I don't think i've done this right, but here's the goal I wish to achieve.

I have 2 tables, one containing contract info and another containing client info. I have the 2 related using the client name field. I have a form which is based on the contract table which contains a drop down field of client names. When I select a client, I want it to update a read only client address field within the form, just for display purposes.

Is this easy to do and can anyone point me towards some examples on how to achieve this???

Many thanks.

View 1 Replies View Related

Missing Record - 325 In The Table, 324 Showing On The Form???

Sep 19, 2005

I have a database which has one main form linked to a table which has 325 records in it. The problem is when you open the form it says there are only 324 records :confused:
I have gone through the table comparing the records with the form records, I found what I thought was the 'missing' record. But when I did a find on the form I managed to retrieve the record.
Can anyone help as I'm a bit baffled.

Thanks
S

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved