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.
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.
Suppose I have a customer database. Is there a way if I click on a button, it will create a new record and copy some of the info from the previous record?
Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted.
I have spent the day using Access 2010 and attempting to move information from a parameterized query into specific cells in an excel template. It runs smoothly until I attempt to reference the query at which point I run into th error "Too few parameters. Expected 1." Currently my reference code looks like this:
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...
The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same.
-Is there someone that can help me with this problem, to make the copy-button in the Form run properly?
-Are there other options to achieve te same?
I have put in a attachment, to give you guys a visual example of what I mean.
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.
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)
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.
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.
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.
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
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.
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.
:) 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
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.
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?
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
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.
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..
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.
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.
I need help to figure out how to create a form that includes a place to enter date ranges (A start and an end date: the field name in the table is CrossClampDate), patient name, and case number as a search. I have just taken 3 levels of Access classes and saw an example of this, but we never went into it and from the Properties box for all parts of the form I still can't decipher how it was done.
Basically, I want to run the operations a query goes through by inputing this information in a form.
I have created an actual query that performs this operation, and it works. But I am prompted for each criteria separately in individual pop up boxes. I just need to streamline this operation for the users.
Actually, I don't think i've done this right, but here's the goal I wish to achieve.
I have 2 tables, one containing contract info and another containing client info. I have the 2 related using the client name field. I have a form which is based on the contract table which contains a drop down field of client names. When I select a client, I want it to update a read only client address field within the form, just for display purposes.
Is this easy to do and can anyone point me towards some examples on how to achieve this???
