Changing Records

Dec 21, 2004

Hi, I'm in the process of making a super simple database (3 - tables). I have run into a problem with two of the tables. The relationship between them is one -> many. Say, I have a record in the (one) table which contains a primary key that is also part of a compound primary key in the (many) table.

Ex:

tblEx1 - (1 side of relationship)
red(pk)
blue
yellow
etc...

tblEx2 - (many side of relationship)
red(pk)
purple(pk)
orange
etc...

If I create a record in tblEx1 and type in some BS for the "red(pk)" field, and I then go to tblEx2, fill in all the fields, and also type in the same BS for the
"red(pk)" field, and come back at a later date, and want to change the value of the "red(pk)" field in both those tables for a certain record, it will not allow me. It doesn't matter which one I go to first. Would I have to delete the relationship everytime to be able to change the value for the "red(pk)" field in either table?

On a related question. In the above example when your doing data entry I'm not sure if I'm doing this right. It seems odd to me that I would have to type in the field for "red(pk)" in both tables, isn't their a way it can automatically figure out to put the same value from the first table into the next one since thier in a relationship.

Sorry if the above is confusing, and stupid. I'm just asking cause I did a whole bunch of records and I have to modify the name of the field which is the primary key, and I don't want to have to delete all the records and re-enter them; that would be a big time waster. Any help is appreciated.

View Replies


ADVERTISEMENT

Changing Order Of Records

Feb 10, 2006

I am making a database that requires a list of all the crew people in our company. This list is not sorted by alphabetical order but by order of significance (or frequency of) crew person. This list is rather lengthy and if I add a crew person it can only be added to the bottom of the list. The only way I have been able to do this is by manually resorting and retyping the list. Is there any way to add a row in the middle of a table (like I can in Excel)??

Thanks, Joe

View 7 Replies View Related

Changing Records Through Queries

Aug 19, 2005

Whenever I have a form that is based on a query, I am not able to edit the data in the form. Is there any way to change that? I have all allowances set to yes and Data Entry also set to yes. The form contains data for a single record.

View 3 Replies View Related

Manually Changing The Order Of Records

Mar 20, 2005

I have records which represent tasks and the tasks need to be scheduled. They can be ordered to some degree by sorting the table on specific fields and then by sorting parts of the table by specific fields, however, the final ordering needs to be done manually as it cannot be done by a field sort. So, how can you move records around manually? It would be like a CUT and PASTE INSERT. Thanks.... Lester

View 3 Replies View Related

Cbo Keeping The Same Entries On All Records And Not Changing

Aug 2, 2005

Hi,
Can anyone help me please?

I have a combo box which displays the primary key. It then takes the other values from the cbo and then displays them in other text boxes in the form.
This is great.

I am trying to keep the values in record 1and then move on to record 2. reecord 2 has the same values as in record 1 (the values from the cbo!!!) I am trying to keep the values in record 1 and then go to record 2 and select different values in record 2 from the same cbo. Record 1 and record 2 as well as any other record contain the same values from the cbo.

I am stuck - I am not sure how to rectify this problem so that I can choose different values. The cbo is based on a query from other tables.

Please let me know how to do this as I am still finding this tiresome.
Many thanks.

View 2 Replies View Related

Cascading Combo Box Changing Records

Jul 13, 2006

I have attached a Microsoft inventory db that I have attempted to alter and apply to my needs.

I added cascading combo boxes to allow the users to make selections of products specific to categories. Once the category is selected in the CategoryID combobox the cascaded combo boxes ProductName & SerialNumber become populated with the products that belong to the category selected in CategoryID. This works as it should.

The problem comes after a record is selected and an attempt to switch categories is made. For example, say an inventory transaction for the product named "V1" which belongs to the "Special" category is entered. As soon as I switch back to the "Routine" category with the combobox, the product "V1" is now associated with the "Routine" category.

I know Access is just doing what it's supposed to but I need to find out how to prevent the category information for products from changing when a new category is selected in the first combobox. I've tried requeries, gotoRecords and various other commands without luck.

I have attached my db in hopes that a solution can be reached more efficiently.

Thanks in advance.

Shane

View 6 Replies View Related

Changing A Field Value For All Records In A Query

Mar 9, 2006

I have a query that pulls records from a main table based on a check box and I need a macro or code that will set the field value as if it were unchecked.

BTW I am self-taught and new at this so don't make fun of me if the question seems stupid.

Thanks!

View 8 Replies View Related

Forms :: Changing Multiple Records At Once

May 13, 2014

i have a splitview form that has a sub form which is a continuous form. On the continuous form there is a start and end date for each record. i would like to be able to change all the start dates on the continuous form by selecting a date once and hitting update or something like that.

so what i have going on is i have designers building scaffolds and adding articles to the scaffold (thus the continuous list) then a few months down the road the site planner will schedule the scaffold to be built and torn down. this will be done on this split form noted above. once that is done i need to have a date and an action applied to each article in the scaffold because i need to track usage of all the material per peice on a job site.

View 4 Replies View Related

I Need To Change The Enabled Property After Changing Records

Nov 23, 2005

Hi Guys,

i have a problem i hope some one can help me with.

i have a form with a sub form on it, and i want to disable everything until the user clicks a 'edit' button to allow the information to be changed.

i am just testing it at the moment, so i set one text box's enabled property to false. then i added a button with an on click event with the following code:

Me!userid.Enabled = True

when i start the form, the userid box is disabled and when i click on the edit button, it enables it fine.

however, when i change to the next record, the userid box remains enabled. i cant find where to put the code to set it back to false everytime i change the record.

i should also let you know i am a beginner, so please be gentle!

View 2 Replies View Related

Changing The Order Records Are Displayed In A Subform

Feb 27, 2006

Hi everyone. I need help on this one

I have a form with a subform. The subform is basically the sale history of the item on the main form (The main form shows a record and then the subform reports its history). This all works fantastic, except that on the subform, every time a new record is entered, it goes to the bottom of the previous one, so after a while, if I want to enter more history into the subform, I have to scroll down through all the older ones to get to the more recent ones.

How can I do it so that in the subform the most recent entry is always at the top and each time a new record is entered, the older ones move down one. This way the most recent records are always on display and older ones move down as they become less important. Likewise, the empty record used to enter data is also at the top!

Thanks!!

View 14 Replies View Related

Changing A Command Button According To The Number Of Records

Nov 13, 2007

I have a subform where you can add multiple records. i have a command button labelled NEXT (which obviously navigates to the next record) but I only want this to be enabled when there is more than one record.

I am OK on the enabling bit but how do you specify if the record number >1?

Does someone have time to start me off on some code?

View 1 Replies View Related

Tables :: Changing Multiple Records Using MS Access?

Aug 28, 2013

I am connecting to a table in our accounting software using MS Access ODBC Connection. I would like to change the value in a table for every record in the table 7,000+. In the latest version of the software a new field was added to the Vendor Table that by default is unchecked. I would like to have this field checked for each vendor. Is there a way that I can change all the records at once instead of going row by row to make the changes?

View 1 Replies View Related

Forms :: Changing Y / N Field On All Records In A Table

Aug 12, 2014

I am creating a database where I will select recipes from one table and then create a shopping list through related ingredients from another table. I want to be able to clear all selected recipes before I start a new class.

For example, I have 100 recipes and am using 10 this week, but next week i am using a different 10. To create a new grocery list I want to clear all of this week's selected recipes before selecting the new bunch of recipes.

Is there a way (I am assuming a macro would be used) to insert a command button that would change all y/n values of the recipes table to no?

View 1 Replies View Related

Queries :: Update Query Not Changing All Records?

Apr 24, 2013

i have an update query that looks for a product number, updates the cost, and re-calculates the price in two columns based on the salesman's margins. the problem i am having is that it seems to be hit and miss on the first run. if you run it again, it runs the calculations on all the fields. (it has to check / recalculate 16,000 rows.) should this query have vba to make it loop thru the table.

here is the basic layout of the query:

table 1 is newproductq
table 2 is Products
Field: PriceIn
Table: newproductq
Update To: [Products].[Cost]
UNITS
newproductq
[PriceIn]/((100-[Margin])/100)
PIECES
newproductq
[PriceIn]/((100-[BrokenMargin]/100)

View 4 Replies View Related

General :: Changing Existing Database From Overall To Monthly Records

Nov 8, 2013

I'm altering a database to have certain fields be recorded monthly.For example: instead of a client's file having "Total X Purchased" it would now be "Total X Purchased - Jan", "Total X Purchaed - Feb".

I want to spin the monthlies out of the master clients table & in to ex. tbl_clientsJan, tbl_clientsFeb, etc. but still have them linked; & have a "Totals" table that aggregates data from all of the tables (adds them up).

I have an existing form, & I was thinking of just creating tabs for the months & subforms in each with their sources as the month tables, & removing the fields that don't change month-to-month (e.g. client name), with relationships between them. I would start by copying all of the master table data in to the month tables & allowing edits from there.

the company doesn't track when the transactions occurred; I'm unable to group them along those lines.I'm new to Access & don't want to make a mistake.

View 9 Replies View Related

Forms :: Updating Cost Without Changing Previous Records

Apr 11, 2014

I have this estimate database for a construction company. In this database I calculate how much will a project cost. It's pretty much complete the only problem that I have is trying to figure out how to update the cost of a trade without affecting older records

Example let's say we have a painter that makes $15/hr in project A,B,C,D,E we decide to give him a raise so project F would have a new amount for painter. The problem with that is that it will affect record A-E

I don't want that my department wants to go back and view a history of records. Also take a look at my database it's my first time creating one ...

View 7 Replies View Related

Forms :: Changing Data Entry Value To False To Edit Records

Mar 19, 2013

I have the main form open up where the Data entry is set to YES so it opens in New Field. I created a button to change the value of form's Data Entry to NO. It works. Changed the form so I can navigate through entered fields. I have created a drop down to filter a specific field "Claim#" and it will open that entry.

The drop down only works if I set the default form's Data Entry to NO. Dropdown works and I can select Claim#. But if I open the form with DataEntry set to Yes, and I click on the button to change the value to NO, the form changes but the drop down field does not pull up the proper information. The button code is.

Private Sub EditButton_Click()
Form_MainForm.Form.DataEntry = False
End Sub

The Claim drop down has this event after update

Private Sub ClaimSearch_AfterUpdate()
Me.Requery
End Sub

I'm missing something. Like I said, it works without having the button change the value.

Access 2010

View 1 Replies View Related

Changing Form?

Apr 20, 2006

I just recieved a call from a customer who is having trouble with a database that I did not create for her.

She says that she modified a form in design view and saved it. Now when the database is opened using he shift key, the changes show on the form in form view. She says if she opens the database normally (without the shift key) the changes do not show on the form.

This does not make sense to me. Can anyone give me a clue as to what might be going on?

View 5 Replies View Related

Changing Cursor

Nov 26, 2005

Is there any whay you can change the cursor as it moves over an object, similar to what it does with hyperlink.

I am trying to make the form more dynamic

Thanks

Dave

View 2 Replies View Related

Changing Times???

Jan 5, 2006

We use a device called a site master to test frequency levels across a system. This device stores plots onto graphs which are then downloaded onto an Access (95) database. When the plots are captured before they are put into the database they are time and date stamped among other things. When I open the Database in access I can go into the fields and physically change each of the dates. Yet when I use the site master software to open the database the Time and Date stamp appear at the bottom as the original values and not the changed values that I have assigned. Also when you right click the plots table and go to the properties. The created and modified dates have stayed as the originals. What I would like to be able to do is adjust this date. And what I would like to know is this possible??? Is it like a Windows File 'System' that is giving this date or is it a function in Access that can be changed?

View 4 Replies View Related

Changing Layout

Mar 16, 2006

Hello Everyone,

I'm pulling my hair off with this situation. I have an excel file that was given to us by the payroll department of our company, but my manager doesn't like the layout in which was given to us. I've attached a sample of the file, the file has two sheets the first one is how the original file looks like and the second sheet "final look" is how my manager want the file to look.The original file is pretty big, it's for 33 different employees and it contains 93,500 rows. I think it will take forever to do this manually, any ideas would be really appreciated.

Thanks,

Pablo

View 3 Replies View Related

Changing Icon For Mde!

Apr 24, 2006

hello guys,

firstly thanks to all the guys here without whose help, I would not have been able to finish my database. However, there remains one question to which I havent found a satisfactory answer. I have checked through all the threads here.

I have made an .mde for my application and I want to customize my application icon to my company icon. The DB by default shows the access icon which I would like to change.

The threads here deal with issues of changing the desktop shortcut icon or changing the icon for forms. These threads do not address the problem I am facing.

I want the icon to be changed from access icon to a customized icon.
I am using MS access 97.
Any help will be greatly appreciated. If there is a thread which I may have overlooked, plz point me out.
Thanks in advance
FXP.

View 5 Replies View Related

Changing A Password

Aug 1, 2007

I have set a password on my access document but now need to change it - does anyone know how to do this?

View 1 Replies View Related

Changing From One Mdb To Another One With A Hlep Of VB

Jan 9, 2008

I need a little help in the following topic:

There is an Access (2002) database used at our company covering its different tasks; different mdb files are used for different tasks (storage, invoicing etc.). All of them are linked to a central file that holds the tables.

Some of the users use more files; the same colleague uses for example the storage module and the service module.

I'd like to keep it this structured but I'd like to make it easier to change between the files so the user don't have to quit manually from the storage moduel and open a service module, giving his password for the tenth time per a day.

Could you help with an advice how I could do with VB that by clicking on a button the presently used file closes and another preprogrammed one opens.
(For closing I'm using DoCmd.Quit but no idea how to open something)

I really appreciate your help.

Peter

View 3 Replies View Related

Changing The Password

Apr 13, 2008

i am doing a computing project using access 2003 and vba.
i have designed 2 forms A and B, form A is where a user to logs in to my system (with four main items: username (combo box), password (textbox) and two buttons) and form B is where the user can change their password (with four items: username (username (combo box), new password (textbox) and password verify (textbox) and a button that checks everything and updates the password).
Form A has two buttons, one button can log the user into the system after typing in their correct username and password credentials, and the other button gives the option to change their password also after typing in their correct username and password credentials (and the opens up form B for the user to change their password)
My question is, when the user presses the button to open up form B, what code could i use (or methods in access) that would set the username field (in form B) the same as in form A automatically without the user having to select it again?
All help would be much appreciated

View 1 Replies View Related

Changing A Query....

Oct 9, 2005

in my assignment, I am told to change my prior query by continuing to display the sum, average, and pledge numbers. what is required, is for me to display these totals by the names of the pledges, not just a grand total. how can I sort the query by name?

View 1 Replies View Related







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