Forms :: Transferring Data From One Form To Another

Dec 14, 2014

I have a form (frmJob) that has a combobox (cmbCompany). If a new company is not in the table the NotInList code opens another form (frmCompany) and a new company is added into the textbox (txtCoName).

The code below is the code that closes the frmCompany after entering new company.

The first part of the code (Add new company into table) works and adds the new company into table but the second part (Add new company into frmJob) does not, and the new company does not appear in the cmbCompany combobox. Note: frmJob remains open while data is entered into frmCompany.

How can I get the second portion of the code to work?

Code:
Public RemCompany As String
Private Sub cmdCloseCompany_Click()
"FIRST PORTION - Add new company into table
Dim dbCom As Database
Dim recCom As Recordset
Set dbCom = CurrentDb

[Code] .....

View Replies


ADVERTISEMENT

Forms :: Transferring Data From One Form To Another

Mar 3, 2014

I have one form that is serving as a popup while the parent form remains open... in my code for the popup I'm trying to transfer the value of a textbox to the actual textbox on the parent form... seems easy, but I get this message: "You can't reference a property or method for a control unless the control has the focus" with this code:

Private Sub btnExportData_Click()
[Form]![Worksheet]![txtBookedNotBanked] = Me.txtTotal1.Text
End Sub

... also is there a way to code this so the popup closes when the transfer is made?

View 5 Replies View Related

Transferring Data To A Second Form

Dec 15, 2011

I have created a database that deals with inventory control. My next step that I have been approaching is to click a command button that opens up a separate from but takes specific information from FORM 1 into the new FORM that I just created.

So if a specific Employee takes out 4 aprons from a total of 50 and there are now 46 left, I would like the submit button to transfer that data over accordingly to Inventory control form in the correct text boxes.

Specific Example: If employee John Doe takes 4 aprons from a total of 50 which now leaves 46 how can I transfer that data into the other form showing specific information like 'Product ID' taken, 'Date' it was taken, 'Product Description', 'Employee' who took it, 'Amount Taken' and, 'total' left. I need the extended information to show up in the text boxes on form 2.

Is there a certain code that does this? Here are screen shots so you can get a visual....

View 2 Replies View Related

Data Calculated On Forms Not Transferring Back To Tables

Nov 27, 2006

I understand that any data that is inputted into a form is always transferred back to the table in question.

In the form I created, I had

4 subheading scores added together to form another subheading named function =([1]+[2]+[3]+[4])/4 was the formula that I put into the control source. The calculation worked fine on the form giving me the correct name. However, this number did not transfer back to the table simple being labelled as zero. Can someone please advice!

View 14 Replies View Related

Transferring Data From Form To Form When Starting New Record

Sep 7, 2011

OK so my situation is a simple 1 to many relationship where the main form has the primary key and the secondary input form needs the foreign key to be passed to it to link the 2 tables.

Say for example 1 Site has many sections (Plants). The main menu form can therefore select the Site and filter to another combo box containing the plants that are attached to that site. The user can then either edit the plant or add a new plant record linked to the site.

I have figured out how to edit the plant attached to the site using a macro that opens the form Plants with the site ID passed from the main form however when I want to enter a new Plant I still need the site ID passed to the Plants form however using the following code

DoCmd.OpenForm "frmPlants", acNormal, , , acFormAdd

It simply opens the form as a new record and therefore will not transfer the SiteID

No doubt this is not the hardest thing to do I just can't work out how to do it

I have seen somewhere using code similar to this

stLinkCriteria = "[SiteID]=" & Me![SiteID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

But I can't seem to get it to work.

View 1 Replies View Related

Data Not Transferring

Apr 6, 2008

Hi, I'm running 2 append queries to my existing db to update fields in one table with data from 2 sources - basically plucking some fields from one and some from the other (using a client ID number as the common identifier - the data is fed into the parent table). However, it would appear that some of the data is not transferring into the parent table even though it is visible in the source file (.xls). I know that this seems like a broad request but I'm just wondering if there may be a potential simple error. Any ideas?

Cheers....

View 2 Replies View Related

Data Not Transferring

Apr 7, 2008

Hi, I'm running 2 append queries to my existing db to update fields in one table with data from 2 sources - basically plucking some fields from one and some from the other (using a client ID number as the common identifier - the data is fed into the parent table). However, it would appear that some of the data is not transferring into the parent table even though it is visible in the source file (.xls). I know that this seems like a broad request but I'm just wondering if there may be a potential simple error. Any ideas?

Cheers....

View 4 Replies View Related

Transferring Data To An Access DB

Jul 16, 2007

Does anyone know if it is possible to transfer data from an old MSDos database into an Access 2003 one?

If so any idea how you would go about doing this?

Thanks in advance.

View 14 Replies View Related

Transferring Data From One Table To Another

May 2, 2005

Hi all. Hopefully this will be a simple thing...What I have is one main table (RFA Main) and two related tables (S/R Disposition and Suppliers). RFA Main has a two check boxes (ScrapRewrk and SupActs) that I am using to trigger append queries that append the following SQL statement:
Suppliers table
INSERT INTO Suppliers ( LogNum, Originator, ReportDateOp, PartNum, PartNumDesc, ProbDesc, CustRtn, RmaNum )
SELECT [RFA Main].LogNum, [RFA Main].Originator, [RFA Main].ReportDateOp, [RFA Main].PartNum, [RFA Main].PartNumDesc, [RFA Main].ProbDesc, [RFA Main].CustRtn, [RFA Main].RmaNum
FROM [RFA Main]
WHERE ((([RFA Main].SupAct)=True));

S/R Disposition table
SQL the same except for the WHERE statement reads ((([RFA Main}.ScrapRewrk)=True));

First, what kind of statement would I use to trigger the append query when the boxes are checked? Currently, the users are doing these append queries manually by clicking command buttons.

Second, is there an easier way to do it?

Thanks in advance

Camille

View 14 Replies View Related

Transferring Query Data To Excel

Mar 28, 2008

Not sure how easy this one will be but here goes.

I currently have a database which collects details of event effecting our business and am using a simple query that displays events within a defined date range.

I have also set an excel sheet which on the main worksheet appears as a calender format for a particular month which is updated by data in the access query. At the moment I tranfer the query to excel and it appears as a new sheet which I then have to link to the master calender.

Is there any way when exporting to excel to tell access to send the data to a particular sheet and cell range and even more advanced tell it were to put certain dates information? i.e send 1st March info to cells A1 to A4, 2nd to A5 to A8 etc.

Hope someone has some ideas on this one - even being able to send all data a specific cell range would be useful

View 2 Replies View Related

Transferring Same Data To A Field In All Records?

Aug 10, 2006

I suppose thatīs easy, but I only accomplished one by one by selecting a specific record.


Ty

View 4 Replies View Related

Transferring Data From Word To Access?

Sep 6, 2011

Is there a way to transmit data from an MSWord Form to an Access table?

View 6 Replies View Related

General :: Transferring Data From Table To Another Under Conditions

Feb 22, 2013

I have 3 tables :

table 1 empno Employee Nomber
empname Employee name
salary basic Salary
bonus
deduction
iddate month nomber

table 2 is bonus table id
empno
bonus amount
iddate

table 3 is deduction tableid
empno
deduction amount
iddate

Now i need is to transfer the data from bonus table and from deduction table to the table 1 if the empno and iddate are equal on the both tables

What I mean for ex if i create query and when i enter the employee number directly it will give me his bonus if he has and his deduction also if he has, so how can i do it?

View 1 Replies View Related

Transferring Data From MS Excel To MS Access 2013

Mar 27, 2014

I am setting up a database using Access 2013, and am trying to test downloading files from Excel. For some reason it is not allowing me to have more then 4 columns in the excel file, it gives the error "Subscript out of range". I thought it was the type of variable at first, but when I tried deleting different columns on both files, the transfer always worked with 4 columns. How do I allow more columns to be transferred?Also, is there a way to not include the row numbers of the excel file as an ID column and only include the ID given in the first column?

View 4 Replies View Related

Transferring Data To Another Access Database (before Delete)

Aug 16, 2013

I have a database with a main database that has 2 related tables...my problem is that i only keep data that i really need, in the main table. My problem is that i sometimes need to go back to old data that i erased. so i have to keep old data too. but i can;t on the same database. so i need to move the old records from the main table and all the related data to another database that will keep all the erased data, so if i need to find something i will search on the "deleted records" database.

View 6 Replies View Related

Transferring A Field From A Form To A Report

Jan 15, 2006

Hi All,

I've attached a picture which shows the problem.

I need to know the expression required to transfer the name of a football team (selected on a form with a combo box) onto a report.

The teams all have ID numbers, and so far its the ID thats getting transferred, not the team name.

Any help is appreciated

Thanks

Colin

View 7 Replies View Related

Transferring Query Results From One Form To Another

Aug 27, 2004

I have one table of records that I would like to query and display the results.
I have created a form that asks the user for criteria for the query (search).
Then I want to display the results from that query in another form (results).
The problem is that I cannot figure out how to do it.

The results form is using the query as its source. I have tried running the
search and then opening the results form, but I get a message saying that
I tried to lock the table but it was in use.

Is there a way to link these forms so that i can bring up the search form,
perform the search, and have the results brought up in the results form?

Thanks for the help.

View 4 Replies View Related

Modules & VBA :: Transferring A Form To Password Protected DB

Feb 10, 2014

I have a mdb file that does not have database or user level security, but it does have a VBA password.I want to transfer (overwrite) a new form to this database from another Access database. The form I'm exporting has VBA code. When I try using docmd.TransferDatabase I get an error. The error is:

"The TransferDatabase action was canceled."The line is:

DoCmd.TransferDatabase acExport, "Microsoft Access", txtCheckInFile, acForm, "SubformLineSummaryContractor", "SubformLineSummaryContractor", False, False

where txtCheckInFile is the location and mdb file name I'm trying to send the export.It might be because the form already exists. So, if I go into the database and delete form, and repeat the export I get the message:

"Microsoft protect this Visual Basic for Applications Project with a password. You must supply the password in the Visual Basic Editor before you can perform this operation."My question is it possible to transfer a form to a MDB that has a passworded VBA? I know the VBA password.If not, perhaps it is possible to remove the VBA password in the database (using VBA), make my export, and then add the password back in?

View 2 Replies View Related

Access 2000 :Transferring Test From Form To Report

Dec 9, 2006

I have been trying unsuccessfully to transfer about 20 details describing the name, up to 14 different colours, prices etc and one image of beads from the details displayed on a form to a report. I have no problem displaying the details of one bead using a combo box but then I want to send these details to a report. After that I select another bead and then want to send these details to the report.

The report is divided into 12 rectangulars to represent 12 sections of a display box. This tells the shop owners which beads to put in which section as display is important for sales. as there wooden beads, glass beads, plastic beads animal beads, letter beads etc, etc.

I have gone into this details so you will understand what I am trying to do. I would be very grateful for help but I am sure will realise that I am technically inept and please when you try to explain things to me to remember you are dealing with an idiot.

View 1 Replies View Related

Form Record Navigation Transferring To Next Form

Apr 24, 2005

on main form i have 6 buttons to take me to different forms. these other forms display different details relating to the same record im looking at on main form.

SO, i hit the record navigation button and it flicks to show record 2's details, then i hit my button and it takes me to my new form BUT starts from record 1, i want it to show the current record in looking at on main form.

i feel ashamed asking this, must be simple thing to do.

thank you for any advice.

View 3 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Forms :: Display Data In Form As Select Record In Subform In Data Sheet View

Nov 11, 2013

i have a main form named(EMP) i have a subform named(SEMP)with EMPID i have an another form Named(SDetail) with EMPID i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field Subform SEMP in as datasheet view. i can open sdetail for selected records only

View 14 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

Forms :: Switching Form From Data Entry Only To Data Editing

Feb 18, 2015

My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.

My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....

As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.

View 5 Replies View Related

Forms :: Display Existing Data On Data Entry Form

Sep 28, 2014

My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.

i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.

What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.

View 7 Replies View Related

Help! Transferring To New Server

Oct 11, 2006

I've been asked to assist a local non-profit transfer an Access DB to a new server. The DB was set up a number of years ago and the designers are no longer available.

The old server is set up as a workgroup server, and the new server is set up as a domain server. (I am completely unfamiliar with how networks are set up...I've never dealt with this end before.)

The designers set up a .mdw file which (I believe) controls permissions etc. After much wrangling, we finally uncovered the admin password. However, even signed in on a workstation as the admin w/ full rights, I still can't copy a functional version of the DB to removable media in order to move it to the new server.

The server does not have MS Access loaded....only the .mdb and .mdw files.

I *think* I have to replace the 'secured' .mdw file with a generic, clean .mdw. Do I need to do this on the server, or the workstations, or both?

What am I doing wrong????

Thanks!

View 1 Replies View Related







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