Autopopulating A Form With Duplicate Info

Oct 27, 2005

I have a form with two fields, work_email and home_email. If after entering work_email, I would like to click on a check box if the home_email field is going to be the same information and have it copy what I entered in work_email into home_email.


Please help!
:confused:

View Replies


ADVERTISEMENT

Forms :: Duplicate Form Opens But Area With All Info Is Blank

Jul 2, 2013

I just copied a form from one database to another and for some reason the copied form in the new database does not display. the form opens but the area with all the info is blank... When I choosed design mode it all shows up correctly but in form mode it is just blank.

View 3 Replies View Related

Autopopulating A Form

Jul 9, 2005

I am using the following code to update my form, open a new form with a new record and then populate certain fields of that new record with data from the previous record:
-------------------------------
Dim strFrm as String

strFrm = "frm_Auto_Accidents"
'save pending edits
Me.Refresh
'open the "other" form
DoCmd.OpenForm strFrm
'create the new record in the newly opened form
DoCmd.GoToRecord acDataForm, strFrm, acNewRec
'reference the newly opened form inside the With block
With Forms(strFrm)
'and set the values of any of its controls
.ClientID = Me.ClientID
.CaseID = Me.CaseID
End With
-------------------------------------------
This code works perfectly. Here is my problem. I also need to pull data from one field which is not on the 1st form(Its in a different table) into a unbound textbox. Is there a few lines of code I can add that will pull the data from the table. The link is not a problem because my tables are linked on client id. I know I can use a query but the whole point of this code was to eliminate the need for a combobox.
Can anyone help?

View 14 Replies View Related

Duplicate Info In Table

Dec 14, 2004

I've got a huge table with one column that shows a lot of duplicate
info in it. How can I let it identify the unique names and "hide" all the
duplicate info that falls under it e.g.

Columns:
Col.1:Fruit Col.2 Col.3
Apples A 1
Pears B 2
Peach C 3
Apples D 4
Apples
Apples
Pears
Pears
Pears

I would like the table only to show the say Fruit column with Apple, Pears,Peach
and list when you click on it all the related data to it. Along with this I would like to
associate all this info in the form. If I select Fruit in the form the related data should appear
below in maybe a subtable or something which I should be able to select from which info I need.

View 4 Replies View Related

I Want To Duplicate Info Automatically

Jan 14, 2005

Having a problem where information from staff worksheets has some constant data and other info is static.

I have added file for your viewing. The Propagation form 1 is the original form I was using to input the data, this was time consuming. I am trying to upgrade the form so that constant data can be entered in once and static data entered onto a sub table within the for.

Problem is that when I view the table to make sure everything is working the constant data is only recorded for one record not the balance(pls go to last record to see problem). ie date is not repeating in propagation table

Can ANYBODY help with this as this problem occurs in other forms as well.

View 1 Replies View Related

Forms :: Stop Duplicate Info From Table A To B

Apr 3, 2013

I have a database that lists all the books I have read. The Table "Books" holds "AuthorId' "Title" etc. I have another table that is called "Whats Next To Read" which I store the next book that I will read from that author. It also uses "AuthorId" and "Title" etc. In the form, how can I look to see if the title put in for that author in "Whats Next" does not have the same title already in "Books" table. I can use Dcount to find the title but it could be same title different author. I need same title with same author.

This is what I have so far.

If DCount("Title", "Books", "Title = '" & forms!Whatsnexttoread!Title & "' > 0 Then
Msgbox "Title is already in books.", vbInformation
End If

I need it to only look at the same author.

View 3 Replies View Related

Autopopulating Fields/Relationships?

Jun 19, 2006

Autopopulating fields/Relationships?

These are similar things right? :confused: I am trying to do some autopopulating of some fields to other forms. Say I type in someones number, name, and address and then I go to my other forms and enter thier number so that it gives me thier name and address automatically. :mad:

I have had no success thus far...:eek:
Do I do this in relationships?:confused:

Please help me get on the right track and accomplish this autopopulate...:cool:

Thanks!:D

View 4 Replies View Related

Update Order Info Based On Quote Info

Nov 7, 2006

I need help on this, from what the best concept is, to what I need to look into using:

I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.

As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?

Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...

Thank you.

View 2 Replies View Related

Subform Opens New Form That Gets Its Info From Main Form

Dec 20, 2011

I'm working on a project that has two tables. "Calls" and "Customers". The Customers form has a subform, "Calls Subform" in it. When you click on the (New) Hyperlink a new form opens, "Call Details". I would like to pull information off of the "Customers" Form and insert it into the newly opened "Call Details" form.

Problem #1) Home Phone (named "Phone" and Text223 (named "CID"): are both bound controls so I have to do this in an OpenArgs type process.

Further details:

On "Customers" the following is true:
"25" is the "ID" for that customer on the "customers" table
"Home Phone" is the home phone number on the "Customers" table

On Call Details the following is true:

Home Phone is Bound to a table "Calls" and needs to pull it's data from Customers Form..Text223 is CID and bound to the table "Calls" and needs to pull it's data from "Customers" form.

View 14 Replies View Related

Form Getting Info From Two Tables...

Jun 7, 2006

************** edit: Fixed!!!! *************


The database I'm working on is coming on nicely, thanks to some valuable help from this forum. But I've got a couple of new problems that I just can't seem to get my head around. Really hope someone out there can help!

So...

I have two tables (well, there are more.. but there are two main ones with the important data on them). The first is a list of Customers (you know, the usual Name, contact, telephone etc...). The second is a list of jobs for each customer.

After starting from scratch, I created a nice looking form wth control tabs that on one page shows you the customer information and on the second; the job history for that customer. I then have a third tab which lets you add new jobs. So I'm all chuffed because that is the basics of what I wanted it to do.

However, I need a hard copy of the job report to print out and give to an engineer to fill in or to print in future should a customer wish to see it.

Try as I might, the reports function didn't look as if it was something that could be "designed" the way I wanted it to look. So, I figured another form was in order.

I started by building a query which included all the fields from the two tables mentioned above in it; I.e. So it would pull up a Job Printout by a workorderID number. That way it would show all the company info PLUS the detail of that one particular job.

Problem is this: I can see from the query in table view that the Jobs are listed; but alongside them is a straight listing for all the companies in the database. Basically, the Company who received the job in question is not being shown by the query.... if you follow me. (Apologies if I'm explaining this like a fool).

Question 1 then... is how do I fix this? Is this something to do with these arcane relationships things?

Question 2: How do I create a button to print that one "form" by workorder ID.

Question 3: Did I do the right thing by using a "form" or is there a better way to create a "report" for printing that can be formatted the way I want (with logos and stuff)

Thanks again peeps!

View 3 Replies View Related

Reusing Info On A Form

Apr 1, 2005

Hi, I have a from which is based on a simple query.

It prompt users to enter a booking number and then shows all info they have previously entered themselves.

I did this in order to give them te opportunity to alter the info they've entered earlier.

Now what I would like to have as an option is

to give them the same form, for which they enter a bookingno. and having the possibility to reuse the information attached to the booking.

My question is:
How do I create something like this?

Cause if they change the bookingno on the current form, it will not create a new record with a different bookingno but it changes the bookingno in the current record.
So what I want is to change the bookingno to create a new record with mostly the same info.

Can you guys help me out?

Thx,

Lion85heart

View 1 Replies View Related

Info From Form On Table

Mar 27, 2008

I know there should be a simple solution to this problem but i have not worked on access for some time and the cobwebs is too thick.

I have 2 tables one being Stock codes with related fields: Stock code id; Stock code;length;width;height.

Second table is Order Details with related fields: ID; Order id; Stock code;quantity;length;width;;height.

Did a query running the stock codes with length width and height.

Did a form with all details, calling up the stock codewith the query. The info on length width and height to the related stock code is on the form but how do i relate it back to the table Order details.

In the order details table the stock code is showing but none of the other related info.

As i said it is something small but i cant get round it.

View 3 Replies View Related

Copy Some Info From One Form To Another

Apr 16, 2008

I have 2 different sets of tables,forms and queries, one for quotes and the other for orders.

All is basically simalar but the reason why i did not combine the two in one set of tables and queries is because after a certain time i want to delete some quotes and would also have too many fields in one table to manage.

Both have a main form (own table)with customer detail and then the subform (own table) contains various fields with data relating to products.

My problem now is because one in 5 quotes get accepted i want to just copy one field from main quote form to main order form and then 6 fields from quote sub form to order sub form, the rest of the info will have to be put in manaully in the orders form and sub form.

I thought of running a macro to open order form but not sure how to populate the relative fields.

Any suggestions, prob simple way of solving this but i am self taught and therefore dont know it all.

View 3 Replies View Related

Display / Add New Info On A Form?

Jan 22, 2012

My current database is in need of an upgrade. Currently (view image), as you can see (its the only form), each student entered into the database can only have one course. However, I would like to add the ability for students to have multiple courses. my problem isn't so much how does the database user enter in the new course for the student. This can be achieved with another form. However, I am struggling on how I would display these multiple course, in a user friendly way, on a form. What controls do i use? I'm thinking a table control would be suitable (much like an excel spreadsheet) as it would allow show all the courses/ edit a specifc field if required. However i do no believe access 2010 has this control.

View 1 Replies View Related

How To Save Info From A Form

Oct 24, 2012

How do I type info into a form and then save it to the database.

View 4 Replies View Related

Specific Table Info To A Form

Apr 27, 2007

This may be a bit detailed, so stick with me. Is there a way to have a form which you can pull tabel information into, but look at a specific line? I am trying to create a database that will pull up the first line of a specific tabel's information, then when a command button is pressed, it will pull up a seperate form with the information from line 2 of that SAME tabel. I don't want this to be done by clicking the arrows at the bottom of the form. I actually want this to populate seperately.

Lets say I have a Loc_ID box that is pulling the Loc_ID from a tabel.
The tabel I am trying to pull from has an autonumber format and is sorted in that manor from a-z. Is there a certain type of logic that I should use however? As of now, each time I have a form come up, it starts at the first record, which is not what I want it to do. I want it to come up with the first record, then click a few buttons, then the next time a new form comes up with the same info on it, I want it to show the second record's information.

Any information anyone might have will be MOST helpfull! :D

View 3 Replies View Related

Open Second Form Based On Info In First.

Feb 2, 2005

I have a Form1 that is based on a select query with a criteria [Enter PIN number]. When we enter the PIN it returns the correct result. I want to have a button that opens a second form based on the same PIN number entered to open the first (in fact there will be numerous forms I want opened based on this PIN).

Example:

Sidewalk - button
Curb X button
Tree - button
Hydrant X button


In the example above, only CURB and HYDRANT returned an entry. Therefore when I click on the button next to CURB I'd like the frmCurb to open showing the data based on the PIN numbered entered to open the From1, and when I click on the button next to HYDRANT it would open frmHydrant showing the data for HYDRANT based on the same PIN number entered to open the Form1.


Thanks,
SKK

View 12 Replies View Related

How Do I Capture User Info In A Form

Jan 22, 2006

:) Hi Guys,
I have a small problem, hope you can help me out. I have created a a form in Access for data entry. But I would like the form to capture the data and time and the user who's entering the data into the form.
How do I do that. Been trying to figure it out:rolleyes: . Hope you can help. Attached is the screenshot of the form I created. Thanks a bunch

http://img21.imageshack.us/img21/5612/screenshot4ic.th.jpg (http://img21.imageshack.us/my.php?image=screenshot4ic.jpg)

http://img21.imageshack.us/my.php?image=screenshot4ic.jpg

View 3 Replies View Related

How To Clear Info After Entering On Form

Apr 27, 2006

After informations is entered and a button is clicked to submit the information I can use the back/up arrows and page up to see what was entered even though the form is cleared. Is there something in the properties of the button that is clicked to submit that will make it impossible to see the prior users data.

It is personal information that people do not want others to see but is a public sign in computer.

Thanks

Tricia

View 3 Replies View Related

Info Generated On A Form Then Being Sent To A Table

May 9, 2006

Hi I have a field on my form called cost of order
I also have a field called deposit on the form that is generated by dividing the cost by 2.
is there a simple way (most probably) to the send this data to my payment table, I already have a deposit filed set up in the payment table I just want to post the data in from the form?

View 5 Replies View Related

Not Saving Info Until I Close The Form

Oct 9, 2006

I have a form and one of the fields is a drop down box with autofill. If I enter an information that it is new, it doesn't show in the drop down box even after I click on the Save button I created on the form. In order to show up, I need to close the form, then reopen it again.
I am running this particular drop down box from a query in order to facilitate the autofill and because it also automatically fill other fields when the information has been already entered.
I also tried linking the drop down box directly to the table instead of the query, but it did not worked.
So basically my main problem is that in order for the new information to appear in the drop down box I need to close the form and reopen it.
Any ideas what can I do here?
Thanks

View 3 Replies View Related

Passing Info From Between Subform And Form

Nov 21, 2006

Hello all.

I am in no way shape or form familiar with access beyond the very basics. I am however the house programmer and some of the employees here like to create access forms (no programming knowledge though). So from time to time I am asked to help out with the more difficult tasks.

The issue I have run into is that we built a form(that has no connection to a table or query) that has a subform on it (that is connected to a table). Basically the subform information is used to help fill out the form which is then printed.

Problem is that when the form is printed all of the records of the subform are also printed. I am struggling with finding a solution.

Is there a way to just have the subform print the current record shown?

I tried having the form grab the current record from the subform to print the info out on the main form but I can't seem to get the two to talk. How do I use subform info on the form? I have tried something like Me.mysubform.control.text or [Forms]![Me]![mysubform].whatever but nothing seems to work.

One work around I am currently trying to implement is to have the subform visibility set to false which allows me to just print the main form. Problem is that I need the info off the subform also. I try to say something like myformlabel.caption = mysubformtextbox.text but nothing seems to work.

Any help or direction would be greatly appreciated.

View 1 Replies View Related

Forms :: No Info When Creating Form

Jan 24, 2014

I'm quite new to using Access 2007 and I'm trying to create a form from different tables which have relationships. I've used the form wizard and added all the fields I need from the different tables, however, when I click form view it only shows the title and nothing else. When I'm in design view everything is showing..

View 1 Replies View Related

Forms :: Copy Info Into New Form

Apr 9, 2013

I have a [New Job Number] form in my database. In this [New Job Number] form, I have a [Purchase Orders] subform showing all open Purchase Orders. I have a button in the [New Job Number] form to open another form called [New Purchase Order]. How can I transfer all of that information from [New Job Number] into the [New Purchase Order] form through a macro? I don't know how to use VBA. Also I do know how to use basic Macros, though.

The fields I would like to transfer from [New Job Number] into [New Purchase Order] are JobName, JobNumber, and CustomerAccountNumber.

View 7 Replies View Related

Storing Info From A Formula In A Form To A Table

Nov 17, 2006

Hi,

I am an Access newbie and I have a form running about 5 seperate formulas and I would like to store the info in the table that it is associated with so that I can use it later in a query to create another formula. Any help would be greatly appreciated.

View 6 Replies View Related

Linking Info From 2 Tables To Same Form By A Field

Jan 25, 2007

I have two Tables, Contacts and FlowMeters.

On the Flow Meter Form Info is listed specifically for each Flow Meter.

I would like to bring some of the information from the Contacts table on this form.

For Instance if I am on Meter 1T-02 I would like for it to associate that meter number with the name of the customer thats already on the form, then look up that customer's name in the contact table and bring over that customer's contact information.

I built this database over a year ago and it has been a long time since I have worked with the design of it, therefore I am a bit rusty.

Please help if you can.

Thank You

View 1 Replies View Related







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