Basic Form/subform Problem

Mar 16, 2005

This is probably really basic stuff to most of you, but here goes.

(In the past, I have always had tables with zillions of fields, rather than having linked tables, so I have never had to mess with this stuff before...)

I have a db with 2 tables. A Main table with, say, contact names and addresses and a Lesser table with specialised info that I only want for some of those contacts.

The Primary Key in the Main table is fldContNum (autonumber), the primary key in the Lesser tables is fldNum. The two tables are linked 0ne-to-one on those fields.

There is not a record in the Lesser table for every record in the Main table.

I have a form showing records from the main table and a sub-form showing records from the Lesser. They are linked Child fld Num / Master fldContNum.

At the moment, I can go to a Contact from the main table and I can enter info for him in the sub-form, thus creating a record in the lesser table. That works ok.

However, if I move the main form to another contact and then go back, that info that I just entered does not show in the subform. In other words the subform is in "add new record" mode, whilst I want it to go automatically to the existing "Lesser" record with that number.

I can make it do this with VBA and searching recordsets and suchlike easily enough, but I feel that there must be a much more basic way of linking the two form and tables.

Also I want to make sure that if there is already a "Lesser" record with that number, I want to make it so that the sub form cannot even try to make a new record (because then I obviously get primary key violations).

I hope that I have made myself relatively clear here...

Thanks

George

View Replies


ADVERTISEMENT

Basic Form Help

Jan 12, 2006

Hi

Im an absolute noob when it comes to Access so please bear with me

For work I want to make a database to keep track of ordering, so thus far i have made 2 tables: suppliers and products

in my form to add products, i want it to display a drop down with the supplierName in it, but store the supplierID in the products table.

I figure this should be pretty simple, and could easily do it if this were php....

Can anyone help?

View 4 Replies View Related

Basic Form Help

May 19, 2006

Hello,

Help appreciated,

trying to create a form so that when I type in a value it will bring back held in a table it will display two fields held in the same row. i.e.

Table 1
no
first name
surname

I want to type the no field and it displays the appropriate first name & surname fields for the row.

View 1 Replies View Related

Basic Form Information

Jun 27, 2005

I have forms in a database that I am looking at. How can I tell which table the forms are connected to?

Easiest thing, I know. Help much appreciated.

-Mike

View 1 Replies View Related

Help With Basic Invoice Number On Form

Sep 20, 2005

I am trying to incorporate a field in my customer order form for "Invoice Number". Not every customer order form will have an invoice number.

The Invoice Number field will default as null, or blank. I want to make it so the Invoice Number gets automatically populated ONLY IF another field on the same form is populated with "X".

Also, I would like the Invoice Number to equal the Previous Record that has an invoice number + 1. For example, if the previous 5 client records did not have an invoice number (blank because the client's form did not have a certain field populated with "X"), but the previous 6th record had an invoice number of 1001, then the current invoice number would be 1002.

So far, I just have the Form for the underlying table created. I don't have the invoice field in the table created yet. Not too sure where to start.

Thanks much appreciated in advance.

View 3 Replies View Related

Very Basic Question - Form Colours

Apr 3, 2005

Hey,

Got a simple question really...

Designing a form and I have boxes where the data is entered.

The form background is grey and i would like the data boxes to be grey
as well, unless the box is "active" meaning its selected.

ive done it for one form but i can't remember how on earth i would do it on another from i need to do.

Many Thanks

View 1 Replies View Related

Basic Search Form Inquiry

Dec 12, 2005

Greetings, I'm a bit new to the world of MS Access and have encountered a problem when making a search form for my database. The query is using a Like Condition with the '*' Wildcard for a single field like so:

Like "*" & [Forms]![frmPickUpReport]![txtAgentName].[Text] & "*"

While the query on its own runs correctly from the viewer of course prompting me to enter the data manually the actual data from the form is being ignored. Instead of taking the text value within my form's text box, when I press the report creation button the same data box is prompted to me asking for me to enter the data manually.

anybody has a solution?

I'm using MS Access 2000 and cannot use any other application such as visual studion

View 3 Replies View Related

Basic Query Form, Foreign Key Field

Oct 18, 2006

hello.. i have 2 tables

CUSTOMER TABLE
customerid
customername
customerphone


BOOKING TABLE
bookingid
bookingdate
customerid


At the moment i have 2 forms.. one customer form based on the customer table and one booking form based on the booking table.

at the moment, my user enters a customer record using the customer form.. they then save and close the customer form..

they then open the booking form.. and in the customer id field they enter the customers id.. this way, they successfully register that customer to that booking..


what i want to do is allow the user to enter the customer details and the booking details in one form..

i assume i would have to create a third form based on a query..

if i include all the fields from both tables in this query.. and then make a form based on this query, how can i make the following 2 things happen..?

1. when the third form is opened and customer details are entered... a new customer record will be added to the customer table (with a new customerid)..

2. this id will then need to be auto placed into the foreign key customer id field in the booking table.


do you get me?

View 3 Replies View Related

Setting Form Border Style Using Visual Basic

Mar 10, 2005

I have a form which I use for many different tasks, in order to save database size, reuse code and keep things at their simplest.
Sometimes, I'll click a button to open the form which will only show specific filtered data in "Form" view, using a default "Dialog" border style.
Sometimes, I click another button which opens the same form, filters different data and displays the form in "DataSheet" view, but this time, I want the borderstyle to be "Sizable".

What I need is a line of VB code which will force the form to open-up with "Sizable" borderstyle, regardless of the form's Design view settings.

Something that would look like this (which obviously doesn't work):

Forms!frmFormName.Borderstyle = sizable

Does anyone have suggestions?

View 1 Replies View Related

Problem With Calling A Visual Basic Function From A Form Field

May 30, 2005

Dear All.

I have a visual basic function, placed in a module.
I need to call it from a form field, and pass a value to it and the function has to return a value.

I tried it but it doesn't work
the value I get on the field is " #Name? "

any help will be very appreciated.

Thanks!
CS.

View 8 Replies View Related

Basic "Add Record" Form?

Jun 11, 2006

Hey all,
I was wondering if anyone could point me in the direction of creating a basic "Add Record" form? I want everything to be button controlled, so once I've entered data, I click "add" or "save" or something. Similarly, create a remove button.

I'm trying to create a basic app for organizing my music collection, and I'd like to create a simple interface, with a few buttons ("add cd" "remove cd" "search for cd"). I just don't really know how to setup such a standalone app. Any help with any of this would be greatly appreciated. thanks guys!

View 2 Replies View Related

Requery Subform From Another Subform Both Connected To Main Form

Aug 8, 2014

I have a main form that has two subforms, subform1 and subform2, both connected to the main form. When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.

I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.

Me.[subform2].Form.Requery

Does not work. It errors and says it cannot recognize subform2 as a field. I have tried a field name on subform2 but I still got the same error.

View 1 Replies View Related

Forms :: Moving A Subform Within A Subform Of A Form?

Aug 19, 2015

I often move sub forms up and down within a form using something like.

Code:

forms!MyMainForm!MySubform.form.top = 500

However, I am having trouble moving a subform within a subform of a form.

Code:

Forms!MyMainForm!!MySubform!MySubformSubForm.form.top = 500

View 1 Replies View Related

Some Basic Help Please

Feb 21, 2007

Please can you guys give me some basic help, im pulling my hair out over this one!

Attached is a test database which im writing at work, what I would like to happen is that when a new machine ID is selected from the drop down box (combo box) all the relevant fields update with all the information in them.

Please could somebody download my test database have a quick look, see if they can sort it for me then upload it back and explain how they did it.

Thanks in advance

Andrew.

View 6 Replies View Related

Help With Basic Structuring

Oct 3, 2005

I will try and be as concise as I can...

I am trying to create a database for our organization that will keep track of our "Gift Fund". I have a table with all of our personnel that includes all of their basic info with a customer ID field as the PK. I then have a table that is for all of the transactions. Deposits, withdrawls, description, date, customer ID to relate the two tables and transaction ID as the PK.

So we have a table with our personnel and a table to record transactions. Transactions occur anytime we put money in or take money out as well as when one of our personnel becomes a member of this fund by paying their "dues".

I have created a form to update our personnel table. It works fine. I also have a form to enter basic transactions. It also works fine. My problem lies where I try to make a form that will add a member to this fund (which in the personnel table is a yes/no checkbox) at the same time entering this as a transaction. Ideally the form would have the user pick personnel from a drop down list, click the yes/no checkbox making them a member and then entering their "dues" as a transaction.

Ultimately I would like to be able present this info in several dif reports showing all the silly statistics that boss' love to see.

Any help would be appreciated and if I have left out any key info, let me knw and I will be more specific.

View 2 Replies View Related

Basic Principles...

Mar 1, 2006

Hi there,

Having read many posts here regarding normalization, table designs with a view to avoiding duplication of data, avoiding storing of calculated contols into a field in a table (duplication as well as danger of keeping data updated, etc) - I would like to clarify something...

I've designed 2 databases, one sticking to the rules and one breaking them...

I hear the 'don't store' - calculate on demand principle - and this works well in the case of closing a new record where you 'store' a value by passing a subtotal from a subform to a field in the main form. All that passing of values works but there are time delays. Look at the time delay of summing a range of values in a form footer...bout half a second in general...So in this case, storing values fails...(incidentally is there an 'event' for this time delay a calculated control takes to show it's value in a form? - OnErrorCausedByDelayOfCalculatedControlToDisplayIt 'sValue?? Oops ignore the apostrophe ;-).....).

On the other hand you may want to work through many thousands of records, summarising all your data into reports, charts, etc...It just seems that if you stored each records 'total' (say an invoice total) it would be quicker for to work through thousands of 'ready stored numbers' rather than thousands of 'calculations to get those numbers'...or maybe I'm missing something!?

Sorry for all the fuss, but I'm self taught and I wish I wasn't LOL. I shoulda definitely done college instead of getting hooked on databases in my 30's)

And I'm also sorry if this question has been asked before, even under different wording...

Best regards

dazza61

View 1 Replies View Related

Tell Me What I Need - Basic Question

Mar 22, 2006

A family is to enter basic income and expenses data comprising of date, description, catagory and price. The family don't work on a budget that is lost at the end of the month if it is not used, but rather it accumulates in each allocated catagory. example: Money not spent on a 'holiday' this month will build up each month in the 'holiday' catagory until it is spent.

They need to enter data. Query, add, modify, and delete records. Also, to print simple reports.

1. Is this a big project for a novice?
2. What exactly is required to be done? i.e What do you suggest I need?
3. Would it be better to buy SimplyAccounting Basic if it did the job?

View 1 Replies View Related

Very Basic Query

Sep 20, 2005

I have written a basic query that looks at the date field, department field and cost the cost field on a table. What I would like is a form that you can chose a date (19/09/2005) and a it looks at the table and calculates the total sum of money for each department for this date. Ie.

Date: 19/09/2005

Dept 1 = £123.00
Dept 2 = £1234.00
Dept 3 = £123.00
Dept 4 = £1234.00
Dept 5 = £123.00
Dept 6 = £1234.00

I can get the query to work but only 1 department at a time. Any ideas?

I have attached the DB

Thanks
D

View 6 Replies View Related

Basic Sql Query

May 22, 2006

Hello all This is a pretty basic query I guess but I am having trouble solving this.. Can anyone help plsssssssss.
I have two tables
Table1
Code Serial_No Amount1 Amount2
1 ABC 100 200
1 ABC 720 220
4 ABC 150 112
9 PQR 11 25
9 ZZZ 122 44
9 ZZZ 1250 42

Table2
Code Serial_No Amount1 Amount2
1 ABC 24 20
1 PPP 72 22
4 ABC 15 12
9 PQR 11 54
9 ZZZ 22 44
9 ZZZ 150 99
and total of the amount as 844 and 440

I have write a query to select only the Code common to both the tables and add total of amounts for these codes. For eg. I want rows
Outpput
1 ABC 100 200
1 ABC 720 220

1 ABC 24 20

Thanks in advance

View 4 Replies View Related

Really Basic Question

Jul 23, 2007

I have forgotten everything about Access!

I have two tables: A & B, and I want to join the two by a common field, and only add one field from B to the A table (based on the common field).
How do I accomplish this?

Thanks!
:confused:

View 11 Replies View Related

Really Basic Sql Question

Dec 4, 2007

Hey. This is a really basic question but i've looked through a few tutorials and couldn't find an answer

If i have this statement

SELECT * FROM timesheet
WHERE Weekending='07/12/07' FNAME='James.90';


How do i filter it with 2 parameters

such as the Weekending and the FNAME. When i run it, it gives me the following error

Syntax Error (missing operator) in query expression Weekending="07/12/07" FNAME="James.90".

Thanks

View 4 Replies View Related

A Basic Question

Mar 28, 2008

Hi,

I'm trying to understand queries a little better -

If I have a query linked to a Report does the query run first - then open the report?
It's just that If I make a new entry to a table the query seems not to be showing the new entry.

Secondly there are different types of query - what are they for?
EG
Updat
Append etc

Cheers
Andy

View 4 Replies View Related

Visual Basic

Feb 16, 2005

Hi,
Many thanks to those who helped with my last couple of problems.

I've allmost completed my project now and am debugging.

I've found that in order to close one of my forms, which has combo boxes on it, I need to have no values selected in those combo boxes. Could someone give me the visual basic script (or any alternative meathod) for resetting the combo boxes to their default values; i.e. nothing selected in them!

Many thanks,

Robin :o

View 3 Replies View Related

Basic Chart?

Jul 6, 2005

I have a table with eight fields. I want to do a chart where I the piles are "tighten" togther two and two. I would like the chart to look something like this (Example):

|_______________________________
|___ _ __________________________
|___|x|______ _ ____ _ _____ _ ____
|___|x|_ ___ _| |___|x|_ ____|x|___
|___|x| |___|x| |___|x| |____|x|____
|___|x| |___|x| |___|x| |__ _|x|____
|___|x| |___|x| |___|x| |__| |x|____

View 5 Replies View Related

Vis Basic Coding Help??

Oct 31, 2005

Ok I’m coding a form, heres what I have done so far

Me.FN LN =DLookUp("[First Name] & ' ' & [Last Name]","tblStaffID", "Staff ID=" & Me.Staff ID")

I have a txt box to imput the Staff ID number in to and I want it to return the first and last name in to another txt box

Am I close??? What am I doing wrong here??

The table this is coming off is just three fields “Staff ID” “Last Name” “First Name”

Can anyone help??

View 9 Replies View Related

A Basic Question

Sep 14, 2004

If I am developing a form for data entry into a table, should the various controls in the form be bound to the fields in the table or not?

I have seen that if they are then any entry into the form control automatically fills up the fields in the table.

So, as an alternative, should the controls be unbound and the data entry be through an event procedure with an SQL string??
I will be glad to supply more specific information if needed...
Thanks in advance!

View 5 Replies View Related







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