Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Take Info From Form1 And Input It Into Form2 + 3 Based On A Number?

I need to make a query work so that when someone enters info into a master form, it will pull the data for that job onto other forms when the job # is entered. Thanks for any help.

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Bring Value From Form1 To Form2.
Hi all,
(Refer to Figure1 pls) How can i bring the value from form1 to form2 after i click the save button?


View Replies !   View Related
Copy Text Between Form1 And Form2
I have 2 forms which are based on separate tables. When I open Form2 from a command button on Form1, I would like the common boxes on the Form2 (name, ID #, ets.) to automatically copy the info from the boxes on Form1 with the same names. How can I do this? TIA

View Replies !   View Related
Opening Form2 With Data Related To Form1?

I've searched but cant find the answer,

I have an Account form (Form1) and it displays account information along with their many addresses for the account (in a datagrid embedded form). I hit "update or add address" button to launch form2 (Address Form). From this point I want to query the Address and AddressAccountLink table with a passed in Global Variable (AccountID) from Form 1 so that just the Addresses pertaining to that Account show up, instead of all the Addresses for all accounts.

How do I do this? I've tried a String Query in the Private Sub Form_Load() but it gives me errors, here that is:
sSQLQueryAddr = "SELECT tblLinkAccAdd.AccountID, tblLinkAccAdd.AddressID, tblAddress.* FROM tblAddress INNER JOIN tblLinkAccAdd ON tblAddress.AddressID = tblLinkAccAdd.AddressID WHERE (((tblLinkAccAdd.AccountID)=" & v_accountid & "))" (it's on one line in the code)
followed by:

DoCmd.SetWarnings False
DoCmd.RunSQL sSQLQueryAddr
DoCmd.SetWarnings True

Any ideas? Am I on the right track? Do I move this query elsewhere? The address form is made from a query -- querying the Address and address/account link table.

Oh, the v_accountid does have the correct value passed to it...

Please help , I'm going nuts here!! :confused:


View Replies !   View Related
Populate Form2 With Form1's Subform Data
I have a form where a different form opens up when a user clicks a certain button. What I’m trying to do is assign a field value from form1's subform to a field on form2 and it’s telling me "Run-time error ‘-2147352567 (80020009)’, You can’t assign a value to this object." I'm new to VBA, but think I'm on the right track. Could someone please tell me what I’m doing wrong.

The code I'm using is: Me.txtStoreNo = [Forms]![frmCDRData4REF]![sfrmCDRData4REF].Form!txtStoreNo

View Replies !   View Related
Requery Listbox On Form1 When Form2 Is Closed
What line of code do I need to requery a listbox on Form1 when I close Form2?

I'm pretty sure I need to put it in the OnClose Event of Form2, but I don't know how to reference the Listbox on Form1.


View Replies !   View Related
Update Order Info Based On Quote Info
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 Replies !   View Related
Input Info Into Word Documents Using Access Information
Hi. I have been asked to find out if it is possible to automatically insert info from a access database into some word documents that require the same info i.e. a title or reference number so that, for example, if the title is changed in the database it will automatically change in the associated word documents.

Is this even possible as I have no idea or can something similar be done?

Thanks for any ideas!

View Replies !   View Related
Return Info Based On Other Fields
Hi All

I have 2 formulas that work for me in excel. I hope to be able to replicate the result in Access.

I have the following in a field called PROBLEM STORE NAME:

I want these to be grouped as WOWPOS or ISS460 (if not WOWPOS), so return in field STORE TYPE as:
PROBLEM STORE NAME.............................STORE TYPE
SALE (DAY 1 - HD)............................................... ..ISS
Mt DRUITT (WOWPOS) (E)......................................WOWPOS
THE MALL (WOWPOS).......................................... ...WOWPOS
TOWN HALL (RF).............................................. ......ISS
LIVINGSTON........................................ ..................ISS
I use the following formula in Excel to achieve this when I export query results from Access:

I have a field VENDOR ID that may or may not contain ANY detail. If the cell is empty I need it to return N/A. If populated I need to return VENDOR CALL. The following formula achieves that for me in Excel:

Any suggestions would be greatly appreciated



View Replies !   View Related
Open Second Form Based On Info In First.
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).


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.


View Replies !   View Related
Append Query Based On Existing Info
Wow, seems like this is my favorite place in the world now.

My problem is that I need to append data from one table to another, on the condition that any of the fields in the record have changed since the last time the query ran.

For example,

tblEmployee has the fields 'EmployeeID', 'Name', 'Position', and 'Office'. We are appending to tblEmployeeHistory with the same fields in addition to a field for a date. When executed, the query should append the records where something has changed and attach today's date to them. This enables us to later use another query to call up old information based on the date.

Once again, this is a hypothetical situation and not my actual database. Any solution or comments are welcome.

View Replies !   View Related
Need Help With Updating Number In Tables (read Post For More Info)
I am new to Access, so bear with me.

I am using Access 2007.

I have 4 tables created, and they are breaking out information for recording files that are being created from a PBX.
The tables are created as thus:

Key:ext_id | extension

Key:loc_id | location

Key:f-type_id | filetype

Key: mass_id | filename | date | loc_id | ext_id | f-type_id

Now I have created the relationships between the tables for the various ID's. My issue is the following:

I will be automating this process, so when the data is imported to the various tables, I need the relevant keys from tbl_1 tbl_2 and tbl_3 to be added to tbl_4 when the new data is brought into the tables.

As to the process of importing the data, I was looking at using PHP to facilitate this. Any ideas, help or direction would be greatly appreciated. I have looked around the net for an idea of how to solve this, but, being so new, I am not exactly sure how to word the question.


View Replies !   View Related
Auto Insert Field Info Based Upon Combo Box
Someone once posted an database on how to do this but I was not able to see how they were able to automatically input the data into a text field.

I know how to do a combo box to query and input those results into a combo box but I am confused how they got the information from the combo box selection to automatically put the other variables into the testbox. They did this without using the dlookup command. In fact it was done without any code.

They showed how to do this automatically without code and with two other methods (one being dlookup). Can someone please help me if it is clearcut as I don't have too much time to search the forums for empty answers (believe me I have already wasted too much time) Thank You

View Replies !   View Related
Report/letter Based On Info On Current Form
I have a booking form comprising of a main form which holds the person details, and a sub form which holds the details

of each course they book. I want to be able to produce a report/ letter from the current form (ie once a person has made a booking)

confirming that the booking has been made and giving a print of the details.

How I can produce a report based on just the current booking information just entered in the form?

Can anyone please give me some advice on this one, I know how to produce general reports but cannot see how to link one to a current form's data?



View Replies !   View Related
Phone Number Input Help
Greetings... I am setting up a text box to accept a phone number with an input mask of 000-000-0000;0;_ but it isnt doing quite what I want it to do, I would like it to start at the begining when clicked to prevent the error of a user typing in the number a space too far to the right. (right now it places the cursor where ever the user clicks, which becomes a major pain when you want to just be able to click the field anywhere and type from left to right for sake of speed)

thanks for any solutions you might have to offer

View Replies !   View Related
Help With Input Box Based Querying
I have two linked tables as follows:

Table 1

Main Service ID (primary key)
Main Service

Table 2

Sub Service ID (primary key)
Sub Service
Main Service ID (foreign key)

one-to-many relationship

I would like to query the tables, so you search on the Sub Service and it returns all of the Main Services it come under. I would like this query to run off an Input Box that will allow me to type in the Sub Service or a word.

I have managed to get the Input Box, by putting the following code into the criteria :InputBox («prompt», «title», «default», «xpos», «ypos»). But when I type something in the search fails. I have chopped and changed the fields I search on, but can't get it quite right.

Can anyone help me on what fields to choose and what I need to set in the criteria to get the search running properly from the input box?

Also is there any way to program Access or VB to return the results in a message box e.g. **** is a Sub Service of ***** - listing all main services it appears under?

Any help is most appreciated,



View Replies !   View Related
Phone Number Input Mask
Ok I have an excel spreadsheet with over 6000 phone numbers that I need to import into a table. I have set up my field with an input mask to display a phone number as (xxx) xxx-xxxx. I have also set up my excel spreadsheet to have the numbers set up like 1234567890 to make it easy to throw in and let the input mask take over. My question is: I have some numbers that have an extension and are set up as 1234567890 x 102. I can take out the "x" and have all of the numbers run together, but what is the input mask syntax to have it display as say "(xxx) xxx-xxxx"?


View Replies !   View Related
Input Value Based On Textbox Entry
basically i have a textbox called


when my user types t1 in that textbox, and tabs to the next field, i want the value LHR - T1 to be placed inside 'mytext'

how can i do this?

View Replies !   View Related
Numbers Only Input Mask, If Checking For Number
I have a control called GoToId which afterupdate moves the user to a specified record where ID=GotoID. I want the control to only take numbers as input. I used input mask: 999999;;" " but with it the user can still press a letter on a keyboard and even though the letter doesn't get typed in, I think an empty string gets passed as value.
If I can't do it with masks, what's the simplest if statement in vba that will check if the value is a number and positive? (IF the value is Null, "", or anything else I want the if expression to be false)
I know how to do it with several if statements checking if is null, or if "", but there must be a clean way of asking it in a single expression.

View Replies !   View Related
Query Decisioning Based On Form Input
I have a database that has several tables, each table has account numbers in
them. I also have queries set for each table to bring in desired
information. Is it possible to set up a form so the user can input an
account number and depending on which table the account number is in, that
query will run?

View Replies !   View Related
Query Criteria Based On An Input Date
I have a database with the following information:

FTA # Date Attended Last name First name assigned person......

Each week I need to generate a report that shows the people that attended for that week, grouped by the assigned person. I only want to show the data for a specific "date attended" (i.e. that days date). I figured I first need to generate a query that only returns the data for that specific date in the "date attended" column. I did that but it is manuel by using the criteria field.

Is there an easy way to type in the date that I want the query to use as the criteria?


View Replies !   View Related
Query Runs When A Policy Number Is Input In A Form
I have a form set up and would like to have field update to a table when a policy number is input into the form. The fields are extracted from a linked table and are not viewed on the form but need to be written to a table to create a report. I'm confused on the sets to take to handle this. I think i need to use the "onchange" property and set up a macro that runs a query but how does the query write to the table?

View Replies !   View Related
Show Records In Query Based Off User Input In Form
Ok this might be basic stuff i'm a bit dumb

I have a query showing lots of records of equipment that is in different rooms. I would like to have a form where the user can bash in a room number and all the records from the query that have that room number in it pop up.

Please help the dumb

View Replies !   View Related
Export Part Of The Table Based On User Input Via Form
hi everybody, im have a database with table called "project". there are many column in this table. my user want to export this table to Excel, but only some of column, with particular order ( depend on him) to analyze in Excel.
he asked me to build a form with a list box, drop box,somthing like this, so he can choose what column to export in what order.
i try to make a query like this: " Select Forms!UserInput.combobox1.value , Forms!UserInput.combobox2.value,etc, From Project" but it wont work.
Dou you have any idea.
thanks in advance

View Replies !   View Related

Copyright © 2005-08, All rights reserved