Setting Up A Table

Nov 9, 2007

Hi

I feel really stupid for asking this, but I am so stressed at the moment, I can't concentrate!

I have a database that stores land locations and information relating to it. In the database, I need a form that asks 13 questions and answers are given in drop down boxes (about 3 answers to each question). Each of these answers relate to a score, which I want to be able to show automatically.

What I would like to know is how to set the table for it. This table has to use the ID from the land locations table (which is sorted by the way).

Please see the attachment for a simple design of what my 'boss' wants it to look like. The form for this table will be a subform on the main form for land locations.

Please can someone help me? I would really apreciate it :)

View Replies


ADVERTISEMENT

Setting Field Value To Table Value

Apr 4, 2008

I have tblDefaults that has only one record, containing default values. Next I have tblWebpages that has a Memo field that holds my html data. Lastly I have a Form called frmCreate with a field called Webpage. This Form is based on a tblCreate table.

Whenever I click a command button on my Form, I want to populate the Webpage field on my frmCreate Form with a template from tblWebpages. The template to chose will be based upon the WhichTemplate field in tblDefaults.

In brief, tblDefaults tells me which is the current webpage template and so the field should be populated with that html data.

Phew!

Thanks,

Jon

View 2 Replies View Related

Setting Feild Value To Table Value

Nov 28, 2004

I have a form and subform which have the total value of subscriptions made for the month on them.

The subform has the individual values, and the mainform has the total value for that month.

how can i then assign the value of a feild on the mainform, to a value in one of my tables?

whats the best way to go about it?

thanks
BB

View 4 Replies View Related

Setting Up My Table Structure.

May 30, 2005

Hi,
I have a contact list about 20 people strong. These contacts are related to a certain CostCenter. Each costcenter will have multiple contacts. I want a combo box on a form where I can select a contact from the combo box' list and send them an e-mail. I also want a list box on the form that shows each costcenter and the contacts related to it. I also need to be able to add or remove contacts and have the new info shown in both the list box and the combo box. I'm stuck with setting up my table structure. Anyone wanna give this a go?
Thanks,
Israel

View 11 Replies View Related

Setting Property To Yes/no Using Alter Table

Dec 4, 2004

I want to add a column to an existing table using the sql statement Alter table. The new column needs to be a yes/no type. The following code almost works but it only sets the column to a general logical type not specifically the yes/no check box .

DoCmd.RunSQL "Alter Table TblIssues Add [" & Issue & "] logical;"

Any ideas?

View 4 Replies View Related

Setting Up A Table For Sales Figures

May 6, 2005

Dear All,
My boss wants me to create a budget report as follows:

Rep Cust ActM$ BudgetM$ VarM$ ActMProfit BudgetMProfit VarMProfit

ActYTD$ BudgetYTD$ VarYTD$ ActYTDProfit BudgetYTDProfit VarYTDProfit


I have a table with the following headings:

Date State Product Prod Code Customer Cust Code Category Jan Feb Mar etc

State has the domain Vic, NSW, Qld
Category has the domain Sales GP

Question 1:

To the field Category, should I either

A: add to the domain actual sales and actual profit? I can past these into the table at the end of each month.

OR

B: set up a separate table for the actual sales and actual profit for the month?

I think A.

Question 2:

Instead of having a separate column for each month, should I either:

A: just have a heading Month and put the figures in that column

OR

B: Have the sales figures in separate columns for each month?

I think A

Question 3:

When I have set up my table correctly, and assuming the answers to my questions above are all "A", I am now unsure how to create a query which will give me the data for the report my boss wants.


Can someone please give me some help?

Thanks
Bon

View 4 Replies View Related

Setting Field Size In A New Table

Nov 15, 2011

how to set the Field Size in a new Table. I need the user to be able to type in 17 characters (as in a vehicle VIN). I don't want the user to have the ability to type in anything less than 17 characters or anything more than 17 characters.

View 2 Replies View Related

Setting Table Field To True When Exporting To Csv

Sep 21, 2006

Hi,

I export a query as csv to upload to another database on a web site. When that csv file has been exported I'd like the query to be emptied, so that the next time I export I don't export duplicates. What's the easiest way to do that?

I've been thinking of having a field in the table with a check box that is checked when the file is exported. The query then selects only those records where that box is not checked.

But how can I check those boxes on Export rather than when I run the query? The reason being that I may want to preview by running the query, without having that affecting the check box.

View 1 Replies View Related

Make Table Query Setting A Primary Key

Feb 26, 2007

I am trying to create a new Table using a MakeTable Query

using the following sql:

Code:SELECT qCPPlannedStopsOnTargetTotals.WeekNumber, qCPPlannedStopsOnTargetTotals.Line, qCPPlannedStopsOnTargetTotals.Description AS Above, qCPPlannedStopsOnTargetTotals.[%] INTO mkCPPlannedStopsAboveFROM qCPPlannedStopsOnTargetTotalsWHERE (((qCPPlannedStopsOnTargetTotals.Description)="Above"))ORDER BY qCPPlannedStopsOnTargetTotals.WeekNumber DESC;

However i want the new table to have a Primary Key, (Week Number) can i set this as the table is made?

Please help

Andy

View 1 Replies View Related

Forms :: Booking Table - Setting Value In DatePicker

Dec 26, 2014

Access 2007 - Win7

I have two textboxes in my form bounded respectively to check-in and check-out dates of my Hotel_Bookings table

When a user enters the check-in date, I'd like the date-picker of the check-out date to display the same month of the check-in date instead of the current month.

I know that the built-in date picker cannot be manipulated. I cannot work on check-out default value because it will not be updated on the current record.

The only way that I've found until now is to set the check out value to check in + [some days] but I do not like it because it could generate data entry mistakes

How can I solve? If there is no way to get the job done with the built-in date picker, what kind of ActiveX control could I use instead? And where to find it?

View 4 Replies View Related

Setting A Filter On Dynamically Created Table?

Apr 23, 2015

I am currently working on a Database to automatize some process.

The User can import a CSV (Text) File via a DialogBox, which gets imported into a Table. After this, the content has to be filtered, setting conditions on 4 different rows. The new Table gets exported into a new CSV (It has to be CSV, since it later gets imported into SAP)

How can I set a Filter on a dynamically created Table (using VBA)?

Best case would be to save the filter into my Import spec, but Access doesn't seem to have this option (?)

View 3 Replies View Related

Setting Text Box Input To Variable Before Writing To Table

Jan 5, 2005

This is the first time that I have done any major work with forms. After I thought I had finished a problem came up. There are several forms that are use to input information into a table. When the form is opened it grabs an automated number for tracking. The problem is, that if the form is opened and then closed it creates a line of data with all null values.

What I would like to do is have the form open, the user fills out the information, and upon pressing the "save" button, the data will save to the table. I think I need to have each text box write to a variable and then save on the click event. Or I could be completely wrong and need to do something else.

i'm guessing this is something I would learn in Forms 101 if i had ever taken that type of course

Thanks

View 7 Replies View Related

Tables :: Setting Up History Table For Contacts And Companies

May 15, 2013

I need setting up a history table for contacts and the companies that they are associated with. I am sure this will be obvious to some of you database veterans but I am fairly new to Access and I can't seem to figure out the best way to accomplish what I am trying to do.

Here is what I need to do:

When a contact's employment status changes, I need to change the contact's current company association but somehow maintain his or her association with the previous company so that s/he can still be associated with past projects.

So, in my contacts table (TBLContacts), I have a foreign key field "CompanyFK" that links to my companies table (TBLCompaniesPK). There is a one to many relationship between TBLCompanies and TBLContacts.

I want the CompanyFK field to be the current company but somehow link the person with past companies too so that the project directories and subforms will continue to show the contact's association with the parent company.

Maybe I don't need a history table but something else?

I have a similar problem with companies that change name, too. How to deal with takeovers, name changes, mergers, etc.

View 5 Replies View Related

Tables :: Setting Relationship Between Contacts And Locality Table

Sep 24, 2012

I have a contacts database and I am trying to set the relationship between the contacts table and the locality table. The contacts table has a LocalityID field that is a long integer and the Locality table has an autonumber as the PK. When I drag the LocalityID on one table to the other LocalityID I get the Can't create this relationship. When I look at the Edit Relationship dialog box the primary table is the Locality table not the Contacts table. I want set up a lookup on the contacts form that relates to locality.

View 4 Replies View Related

Table Design - Setting 3 Decimals Rounds Down To First Decimal Then All 0s

Feb 20, 2014

I'm setting up a table that has several percentage fields, for which I want to display 3 decimal places in datasheet view (and later in forms and reports). I've tried to set up the fields in a variety of ways, but either I don't get a percent format, or I get 3 decimals with 2 zeros at the end. For example, 73.913% shows up as 73.900%. This, of course, causes problems in calculations, so that for a total percent field I'm getting things like 99.900% instead of 100.000%. I've tried various combinations of formatting properties for these fields (Field Size, Format, Decimal Places, and Scale) but I have yet to hit on the right one to simply display the correct value in the format of a percent.

View 8 Replies View Related

Tables :: Setting Primary Keys To More Than One Field In Table / But They Cannot Have Null Values

Nov 30, 2012

Access 2010..One organization that we work with provides us with a block of numbers for each of the two types of contract products we order from them; we do order non-contract stuff from them also.The block of numbers are the same (i.e. 20000 to 30000 this year) for each of the two products. This means that each product can have the number 20000, for example. We call this the Tracking Number. If it is one of these products, we need to select the Contract Number.

For all other one off orders we have with them, we assign our own Tracking Number starting with 00001. This Tracking Number cannot duplicate unless it is one of the aforementioned two products.Both the Tracking Number and Contract Number are in the same table. The user selects the Contract Number from a form (connected to the Contract Number table that has all the details on the contract) and the Contract Number is populated in the same table that has the Tracking Number.Each order must have a Tracking Number (no null)..Not all orders need a Contract Number (null okay).The Tracking Number and Contract Number combination cannot duplicate.I tried setting the primary keys to more than one field in the table, but they cannot have null values.

If not... I have been working on Plan B.... an AfterUpdate on the form (either the form or a field... don't know yet) that looks at a query that only has results if there are duplicate values.

View 1 Replies View Related

General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File

Oct 5, 2014

I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.

One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.

Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?

View 4 Replies View Related

Setting Data Import To Overwrite Data On An Existing Table

Aug 1, 2007

I have a database that I import data from an excel spreadsheet into multiple times daily. The table that this data is imported into has several key fields that if the data already exisits in the table, and I attempt to import data that is the same except for one or more of the key fields is different. At this time the database it creates a different record. I am trying to get the database to overwrite the data in the database.

View 1 Replies View Related

Tables :: Numeric Field In A Table - Setting Field Property?

Nov 16, 2013

I have a numeric field (long integer) in a table. I've set the format to fixed. No matter what I set the decimal places to, auto, 0 or 2, when I enter a value of 0.71, it displays as 1.00

In my form, I've also set the field property to fixed, but it displays the value as 1.

View 2 Replies View Related

Setting Up A New Db

Feb 15, 2007

Hi Guys,

ok I work a lot on databases but have recently been asked to set up an access database for my team. We are a marketing team within a large insurance company and need a small access database for MI and project management.

I have made a start on this and going well so far but there are some things I need it to do that I dont know how :P

Ive never messed about with Acess before so bare with me :P ok so this is what im looking for, any help would be greatly appreciated.

I have set up various tables for look up wizards for some of the menus on another table I designed for the raw data entry.

I need two tables, two forms - one table for very basic generic data such as

- Job Number
- Description
- Business Unit
- Owner
- Due Date
- Completion date

I then need to drill down into this to add more information, so its basically two tables on top of each other with co-dependencies.

So for example one of my team enter a new project at the very basic lvl, they have a job number, they know what business unit it is for and they know the date its due, as time goes by and work is done on the project I want them to be able to click on a button that takes them to another form where they can enter information that is linked to the original information.

So they search for job number 00000 and come up with the above data on the first form, I want them to then click on 'Project Information' button and be taken to another form that has a lot more stuff on there, like a description, complications, notes, links to documents etc etc. I tried to do this linking two tables together but it doesnt work as the two forms/tables are not co dependend and are irrespective of each other.

Does this make any sense ? and does anyone know how I might make this work ? Please let me know if I am not clear and I will try to explain as best I can

I would also like to change the form 'theme' aswell and have my companies logo transparent behind the data fields etc, anyone know how to do that as I only have the option to use the standard themes.

Any help would be greatly appreciated

Sleek

View 1 Replies View Related

F11 Setting

May 29, 2007

hi there,

Hiow can i make my access database to open the database window on pressing F11?

Thanks
Danny

View 14 Replies View Related

Setting References

Jun 22, 2005

Is it possible to set which VBA reference boxes are ticked each time a database is loaded?

A problem is created when a person amending the database to the person using it has different setups and so some of the references show as "missing" and so compile errors show on loading.

We are using Microsoft Access 97.

Any help most appreciated.

Dalien51

View 1 Replies View Related

Setting Out A Report

Apr 10, 2006

Hi

I have 6123 records in a database.

I need a report that prints the Customer ID and the Postcode

I have managed to do this but it comes to 196 pages!

Is there n e way i can format the report so instead of it being like this:-

Customer ID Postcode
2334 LS89 8UJ
2333 BD67 990

It displays multiple lines on each page .eg

Customer ID Postcode Customer ID Postcode
2334 LS89 8U 2354 LS69 8YH
2333 BD67 990 7899 BH78 6NQ

Can anyone help??

View 5 Replies View Related

Setting A Value To An Option Box

Apr 25, 2006

I made on option box on a form called Status. The 2 radio buttons are marked Open = 1 and Closed = 2. Is it possible to open a query based on what the user selects. In the query I want open to stand for Is Null and closed would be Is Not Null. I know this sounds unusual but it works in the query they way I want it to. Is this possible? Thanks...

View 2 Replies View Related

Setting AutoNumber

Jul 18, 2006

How do I change an AutoNumber that will output 1, 2, 3 to output 0001, 0002, 0003??


Thanks
Jessie

View 11 Replies View Related

Odd Problem...is It A Setting?

Feb 14, 2007

I tried various searched and came up empty handed.

I have a user that is using a database that is on a network. When she enters records using her computer and exists the database, they don't save. If she goes back in, they aren't there. However, if she uses another computer, they save.

I can assume that it's not user error because it's the same user on two different computers.

Any ideas?

View 7 Replies View Related







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