Please forgive me if this has already been explained...but I've searched and searched and haven't found anything like it...
I have a form which contains a command button to open another form which is attached to a subdatasheet in Microsoft Access 2002. When I click on the button to open the sub form, I would like for it to automatically copy the contents of a text box on the original form to a text box on the sub form.
I'm trying to create a system where if I enter data into one field it will automatically appear in the corresponding field in another table. For instance if I enter the values 10,12,15 into a field called QID in table A I would like this to appear automatically in a field called QID in table B. Both tables are related and I have enforced referential integrity and 'cascade' options but this still doesn't seem to allow one table to automatically update another. My ultimate aim would be to have a form that you filled in data for the field QID once that then propagated to both Table A and Table B.
I have created an MS Access 2007 for a user. When the user uses the database, it automatically saves a copy of the database. Why is this happening? I did create for the database to compact/repair each time to user closes the database. ... However, when I open/close the database, there are not new copies of the database.
I would like to print a table including subdatasheets in Access. However, in Access 2002 it collapses them, and closes the table when I click on Print Preview. (In Access 2000 it works.) Any ideas?
I have a table for Inventory Items which lists the Item #, Description, Vendor, Pricing, Etc. I also have a table for Inventory Control which lists the quantites in inventory, what was sold and bought, etc. I want to create a subdata sheet in the Inventory Control table, so when you expand it only the information on that item comes up, but when I create the subdatasheet it brings up all the items. How do I create the subdata sheet so only the information I want is shown and not the whole table?
I have a form, which in it's turn has a subform (datasheettype). Each work with different tables and are related to eachother. Unique key of motherform's table has several occurences in the subform's table.
Enfin, what I now want to do is have a textbox inside my main form displaying the total amount of values of one of the subform's columns. Please advice!
I want to apply a parameter query to a subdatasheet.
I have a primary query that has a list of all the machines we service, this same query will count the number of service calls within a given date range that the user inputs. (For the date criteria- Between [Enter Period Start Date] and [Enter Period End Date])
The resulting query datasheet is linked to a subdatasheet from another query that searches all the service calls and links it to the Machine ID. So when I expand the subdatasheet it shows all the service calls for that machine, beyond the date range.
How can I make it so that the date range from the primary query applies to the subquery?
(without having to re-enter the date range everytime I expand the subdatasheet)
What I am doing, is I have various products with 5 basic fields. I then wanted to add an array of text fields to 2 of those original 5 basic fields. I attempted to do this with a subdatasheet, however, a subdatasheet is not record specific, is not directed to a specific field, and really does not do anything that I want.
Say that the basic field is ProductDescription. I want one column of fields to correlate to it, like below. ProductDescription Is blue Is large Is heavy Is strong
Each product will have a different amount of varying descriptor fields. Once understand how to incorporate this with my project, I then will need to understand how to add the subdatasheet to a report easily. Thanks for any help, -SethTherrien
Linked field is shown both in Master and child tables, but not in the default subdatasheets made by when a relationship is made between a Master and Child Table.
I am using Excel/VBA as a frontend and Access backend. The sheet2 stores the queue name and Queue number. We have to update the sheet1 from column L to column O by looking for the values from the Access table for the date selected from the comboboxes. Now In sheet 2 , it says Queue number and in actual in access table it is the combination of Type & Type1 & Type2. So we have to look for Type & Type1 & Type2 in the table and find out total Batches ,Total Envelopes,Total documents and total pages and then store the values in the ExcelSheet1 from column L to column O.
The following formulas will be used in the select statment:
Total Batches = count(BatchNo) for date selected Total Envelopes=sum(Envelopes) for date selected Total Documents=sum(Cases) for date selected Total Pages=sum(Pages) for date selected
i would like in a form for a combo box to be able to select an item from a table and input relating information automatically into other boxes in the form..
I have 3 tables: Table 1 has product code and product description. Table 2 has invoice number company details, address etc. Table 3 has product code and product description qty and invoice number.. Table 3 relates to table 2 by the invoice number and table 3 product code looks up the product codes available in table 1 and also table 3 looks up the list of products descriptions in table 1 using the combo wizard. This means the wrong code can be put with wrong description. What i would like to know is how i select a product description and the product code in the form fills out automatically?? i hope this makes sense please helppppp!!
We just upgraded to Office 2007 and are experiencing very slow access performance. This microsoft article addresses the problem:
http://support.microsoft.com/kb/275085
It won't let me change Subdatasheet Name property to [NONE].
Even if I am able to change it, will this affect my table links. I have a lot of them.
I am just the part-time Access "programmer" here and am somewhat lost trying to figure this out. Does anyone have a simple explanation and solution? I would appreciate any help so much!!
I have a form which has a subdatasheet attached to it. there could be 1000 records in the main form but only 10O records in the Subdatasheet that match the records in the main form , these are linked by a "product number" .
Is it possible for the row in the main form to be "red" where there is data in the Subdatasheet that is matched by the "product number".
We recently switched over to A2003. As far as my db everything went ok except for one thing.
I have a continuous form that we enter data into. When you open a new record the form only displays one empty row. Because we enter tons of rows that come from an AS400 system I made a button on the top of the form that switches from continuous form view to datasheet view.
Private Sub Label59_Click() Me.[Part #].SetFocus DoCmd.RunCommand acCmdSubformDatasheet End Sub
Within datasheet view I am able to paste many rows at once. However, after the change to A2003 it still "appears" to work. Many rows are pasted in but if you exit the db and come back to the record all of the data is lost and you are back to one blank row in continuous form view.
When a record is added to the continuous form each record is assigned an autonumber primary key. I think that this is where it is failing. Within Access help is the following under "Cutting And Copying Data", "Copy or move records or data from multiple fields to a datasheet": To paste the data as new records at the end of the datasheet, click Paste Append on the Edit menu.
I think this is what I need to do but I don't allow my users access to any menus so I create command buttons or auto running code in place of menu items that they need.
Can anyone think of some code to run a Paste Append of these records or of any other method in which I might restore the multiple paste funtionality I had with A2K?
i have 3 tables inventory and sales and order and i made 3 forms for each table
in inventory form the user will only read the data
in sales and order the user will enter and delete the data
so my problem is i want to know how when the user enter the data in order form all the data will be copy in inventory table so what ever added in order table it will be copy or updated to inventory table
I have read some of the posted threads. But I still couldn’t understand on how to solve my problem.
The scenario
I have 2 forms which linked to 2 different tables with the same attributes.
Example: Form 1 links to table 1.Collumns (index,name,address) Form 2 links to table 2. Columns (index,name,address)
The problem
How do I replicate the same data from Form 1 to Form 2 with Single button / command?
The Objective
What I’m trying to do is to create an auto fill function so that user do not have to type in the data into form 2 / table 2 by referring to form 1 / table 1.
Hi: Can any one please help me when user select 2 dates from DDLDate1 10/09/2006 and DDLDate2 10/12/06 and the name and it close the form. I need to create multiple records in the another table on the basis of two dates like that.
Data in continous form table1 ----------------------------- Data entered in continous form 10/09/2006 10/12/2006 John 10/12/2006 10/13/2006 Petty 11/11/2006 11/11/2006 Stiffny
Required data into table table2 10/09/2006 10/09/06 John 10/10/06 10/10/06 John 10/11/06 10/11/06 John 10/12/06 10/12/06 John 10/13/06 10/13/06 John 10/12/2006 10/12/2006 Petty 10/13/2006 10/13/2006 Petty 11/11/2006 11/11/2006 Stiffny
I am currently using a continuous form where there are two drop downs one for AppDate and other for EndDate. I need a script here once use close the form, Script check the data and create multiple records on the basis of date selection into table2. I am using two tables. One for the continous form and the other for the reports (Both have same fields). Continous form table i empty it every time once it close. So i need the result into another table assume form table name is table1 and table where i need multiple records name is table2.
I have been tweaking my friend's database for him. I included some sample data in the main table (ficticious names and addresses etc.) and in a linked table.
I want to leave the sample data in so my friend understands how the database works. However, once he has tested it, he will want to blank those tables (not all tables, though), and reset the primary keys to start from 1 again.
Can I have a button on a form that will do this? Obviously with an OK/cancel message box. If so, how?
I am trying to create a form which involves 3 tables. The 2nd table (CaseRef_Case_Control) is the junction because I needed many-to-many relationship between “CaseReference” and “Cases” tables.
All I want to do is automatically fill in the fields in the “CaseRef_Case_Control” table when I add data to “CaseReference” and “Cases” table. Check the relationship diagram attached to make more sense. Can someone please help me with this?
Hi I need to copy some data from last record to next(New record), when a user clicks a button on a form. I don't want to copy all the data.
An example would be booking in items from an invoice: Company would be the same Invoice number would be the same Product code would be different quantity would be different
Hope this makes some sence, and i'm not being stupid:rolleyes:
I have a field called Shipdate. I have created a new field that is called invoicedate. What I want to do is copy all of the shipdates and paste them in the invoicedate field for my old records. From here on out they would be distinct fields but for old records and reporting purposes I need those dates.
I have a problem.... How can I copy data from one column in a table to another colunm, with WHERE and UPDATE? And how can I find the data, which is the closest, for example using LIKE '%' UPDATE tag_info,tag_info_kilde SET tag_info.TAG_DESCRIPTION = [tag_info_kilde].[TAG_DESCRIPTION_KILDE] WHERE [tag_info].[TAG_NAME]=[tag_info_kilde].[TAG_NAME_KILDE];
I have a form which is bound to a table. I want some of the Data to go to another table which is not the control source. I am trying this code, but no luck. What am I doing wrong?
