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
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:
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
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...
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?
Is it possible to have website form with text inputs and a submit button to save the info into an Access database? I have IIS installed on my system and would like to setup something like this where people can submit there details from a webpage and i can work with the data from Access.
I have 2 formulas that work for me in excel. I hope to be able to replicate the result in Access.
1) I have the following in a field called PROBLEM STORE NAME: SALE (DAY 1 - HD) Mt DRUITT (WOWPOS) (E) THE MALL (WOWPOS) TOWN HALL (RF) LIVINGSTON
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: =IF(ISNUMBER(SEARCH("wowpos",K2)),"WOW","ISS460")
2) 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: =IF(ISBLANK(X2),"NO","VENDOR CALL")
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.
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.
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.
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.
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
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)
Sub Service ID (primary key) Sub Service Main Service ID (foreign key)
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?
I'm working a summer internship at a machine shop this summer, and one of my tasks is to build a database that allows the employees in the tool crib, and the employees in engineering to add tooling assemblies, new tools, new extensions, etc..
I chose to use a database even though i have never used access before because i know all that data would just get ugly and intimidating in excel
I have the basic database up and running, which allows users to add in new tools, holders, extensions etc.. through the use of forms. I also have a report set up that prints out ALL of the assemblies in the database (assemblies being compilations of one "holder," one "extension" and one "tool").
Now, the question is if i want to print out a report that only contains, say, assemblies 1, 5, and 10, but dont want to constantly create and format a report with the wizard each time i need to make a new assembly sheet for each part, can i make a form, enter which assemblies i need (you can assume there is a constant number of assemblies per part - in reality there isnt, but ill cross that bridge when i get there), maybe a part number and a few other random pieces of data and have access automatically generate a report for me?
keep in mind i'm only familiar with the very basics of access (i just dont know where to look to create this). I'm not opposed to using some VBA script as i can do some elementary basic code, but i dont know all the commands i would need to use.
from reading this over before i post it, this seems like it would be a pretty common request. If anyone knows of a guide that outlines how to do this that would be greatly appreciated as well.
Ok, years ago I wrote a Quoting database for work. Essentially it runs a ton of equations in the query but then runs a few Sum totals on the final quote report.
What would be the best method to go about saving some of these totals into a new table? Could someone at least point me in the right direction? The goal is to have the reports run and to save a few of the final totals to a table to not only show what numbers were given to the customer but to make use of them elsewhere without having the database run all the equations required to get those totals every time.
I know, maybe not the greatest design setup in the world but if I were able to do this, it would make several other tasks much simpler. I just appear to be drawing a blank on how to get this done although I'm pretty sure I've done something similar to it in the past.
I am tryimg to create a form that will chek records from two tables; tblEquipmentList and tblMaintenance. After the users selects an equipment type (description) from the tblEquipmentList they should then select the size range from the tblMantenance. After selecting the size, I want the records to change to that type and size equipment so they can be editted. I have attached a sample database. How far off am I?
I'm making a database to record inventory. I have two tables.
1) Data Table -- contains two text fields: one for Item Number and one for Bar Code.
2) Inventory Table -- a table to record new entries into stock by date and qty.
We are using a scanner to scan barcodes. I was making a form for the Inventory table. When the user scans a barcode, it shows in the barcode field. But the user needs to see the item number, since that is how s/he knows the product. Then the user will enter the qty and create the record.
How can I make the Item Number field in the entry form (for the Inventory table) automitically update to the number corresponding to the barcode from the Data Table?
Edited by: joncraver on Fri Mar 9 10:12:18 EST 2007.
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 ext.xxx"?
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.
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?
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?
Hello. I have this idea and am not sure how to go about it. What I am hoping to do is display certain fields on a form, and then have the ability to click on any of those fields, start typing, and have the records all sort based on that column. Here is how this will be used:
Our service department will get a call from someone inquiring about their service call. Sometimes they are given the Order Number, but most of the time they are given the Job Name, Customer Name, Phone Number, or other pieces of information and need to figure out the Order Number. I was thinking that instead of a search form, I could dump all the data in, and then do kind of a one-touch-locate. If they are given the Job Name, they could click on that field and start typing the Job Name. The Job Name column would sort alphabetically based on that input and then they could just look across the record to find the Order Number. If they were given the Zip Code, they could do the same thing. Is that possible?
I don't know if I'm explaining this very well. Hopefully you get the idea. Like I said, this is just an idea I'm thinking about, any suggestions would be appreciated. Thank you!
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?
I have created a standard input mask for my phone number (on the form, not in the table). I would like for the cursor to start on the right (enter right to left) so that if an area code is not needed the user doesn't have to skip over that part.
From reading the Help files, I thought that if you used ! that would work, but no matter where I put it in the mask, it works the same (left to right).
Hi all I have a data input form (Form1) In has various lookups based on input data, then the values are saved to a table. It has a print button to print data on form. It also has a return button (which runs a append and delete qry via a macro ) When the return button is pressed i need to print a different form (Form2) Do i need to lookup the table data with code or can Form2 ? Anyone point me in the right direction
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.
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
I am stumped. I need to specify an input mask for a textbox based on the value of a combo box on a form. The data type for both the combo box and the text box must be text. There are a number of variables to be included. I assume this can be done with VBA on the After Update Event of the Combo Box but I have no idea of how to specify the input mask via VBA. Here is what I am working with.
Combo Box Value / Text Box Rule
00010 / Value must be reported to the nearest tenth of a Degree. Whole numbers require
tenths digit. (Example: Enter 30 as 30.0)
00061 / Values less than 0.01 must be reported as 0.01. Values less than 10 and greater
than 0.1 must be reported to the nearest tenth. Values greater than 10 must be
reported to the nearest whole number.
00078 / Value must be reported to two significant figures.
00094 / Value must be reported to three significant figures when the value exceeds 100.
(Example: Enter 1014 as 1010)
00300 / Value must be reported to the nearest tenth. Whole numbers require tenths
digit. (Example: Enter 6 as 6.0)
00400 / Value must be reported to the nearest tenth. Whole numbers
require tenths digit. (Example: Enter 7 as 7.0)
00480 / Value must be reported to the nearest tenth when the reported value
is above 2.0. (Example: Enter 3 as 3.0)
01351 / Value must be reported as a whole number in the range of 1 to 6.
31616 / Value must be reported as a whole number with two significant figures and cannot be
reported as zero.
31699 / Value must be reported as a whole number with two significant figures and cannot be
reported as zero.
31701 / Value must be reported as a whole number with two significant figures and cannot be