I have a text box on 'Forma' & a textbox (named text3) on 'Formb'. I want to copy the contents of the textbox from 'Formb' to the textbox on 'Forma'. I have used the following code in the textbox on 'Forma'....
=Forms![Formb]![Text3].text
This doesn't seem to be working whether both Forms are open or only 'Forma'. Could somebody please advise as to what I am missing. Your assistance is very much appreciated.
Hi: There are two textboxs in my main form. One is bound and another is unbound. There is no entry in the unbound textbox as values come into automatically after entering some information in the subform. My question is how to i pass values from unbound textbox to bound textbox every time when the value change in unbound textbox i need to change the value in the bound textbox. When the form load there is already value in the bound textbox which i want to override based on the values from the unbound textbox.
I have a date textbox (Week_Ending) and number textbox (Staff_ID) in a form (frmHourEnter), when both have values I open another form (frmStaffReport) with textboxes (txtDateStart and cmbStaff).
How do I open the second form with the values of the first form pre-entered?
I have a database for billing. In my database, I have a form that consists of a main form "Order" and 2 subforms "OrderDetails" and "Customer" OrderDetails are to enter the products to be connected to the Order. All function super, but I want to have some information from one of the forms "copied" over to on of the others.
Here is what I would like
In the subform "OrderDetails" I have made a textbox that summarize all prices to a total, his tekstbox i called "Tekst31". I would like the amount in this textbox to appear in a field "Bel�b" in the main form "Order".
I have tried some different commands, but nothing has worked, also I have made a query which dose the same ting as the tekstboks, as the information in that tekstbox it not stored anywhere.
I have created a form using access 2000. So far, this form already has data and dates in a combox in this format: mm/dd/yyyy.
In the AfterUpdate of the date combobox, I did this:
If graduation_date = #2/1/2004# then Text_Graduation_date = "dated this first day of february two thousand four." End If End Sub
In addition, I have defined many other dates as well using the code above. It works well when I choose the date form the combobox, the other textbox populates, but there are so many more dates in the combo!
Is there a way to auto-populate the textbox with the appropriate text as I scroll through the form?
I currently have two froms, "add record" and "add record cont." The reason I have two seperate forms is because when clients create a new record information needs to be saved to two different tables and when creating one from with fields from both tables I ran into many problems. The two tables are named : tblMain, tblFileLoc Currently there is a textbox on both forms named "fileID" the FileID in the first form is from tblMain and is the primary key for that table, the FileID on the second form "Add Record Cont." is just a normal field. When clients enter in the new FileID in the first form "Add Record" and then move onto the next form "Add Record Cont." i need access to bring the entered FileID from the first form and Fill it in the FileID field in the second form. Currently I have tried making the control source for the textbox on the second form = the textbox on the first form but it brought up an error.
I didnt know whether to post this here on in the table forum, so sorry if its in the wrong place!!
http://x402.putfile.com/4/10309543998.jpg
http://x402.putfile.com/4/10309512643.jpg
Ok, so in the frist screenshot the green box is based off of the table labelled 3. The red box is comprised of the InvoiceID from table 1, ProductID from table 2 and name/price is drawn from table 3.
The green box is used to view products, the red is an invoice. How do I add the currently viewed product (in this case, a case) to the invoice? I need to copy the product ID from table 3 to table 2. How do I go about this?
I have an Access DB I have to put on numberous laptops. The DB is being transported via a CD. When i try to copy the DB from teh CD to a new folder on the laptop I get messages that the DB may have a virus and it cant be copied, or I need to install a microsoft service bulliten...xxxx ( I am not sure what the number is). The DB does contain VBA code and I am certain it is virus free. Is there some setting in access which enables this file to be copied on laptops which do contain virus or firewall protection or must I disable virus protection on these machines before instlaling the program or is it another issue altogether. Thanks.
I'm new at all this so i'm sorry if it's a silly question, but i've split my db into a front and back end on a server but need to copy them and put a copy onto a laptop for my boss to take somewhere. How do i copy them so that they dont look for the other one in the server folder but on the hard drvie.
im creating a fault logging databse, i have a form that shows all the "machines" details, (including its previous faults in a subform) i have another form for inputting new faults. what i want to be able to do is when you click on the "log new fault" the form will open up with some of the same details as the machine i was just looking at. e.g. it will auto copy over the "machine number" and "machine serial" thanks
I have a db (sadly Access '97) for annual software renewals. Against each year there is a set of licences (can be up to sixty records), can anyone please tell me how from a form I can copy the licences from the previous year to the current year with the click of a button
I am a beginner and I am having difficulty doing the following.
I have created a form from a query, (by agent)
The form took a little while to design, and I know how to copy the form, but how do you change the agent that is being referenced without having to go create the whole form layout again.
I have a form containing two text boxes (1Average, Average1) that the first one is containing formula typed in form and the result of that is in decimal data type. I want to copy the result in [1Average] to the [Average1] text box for this i used the following VBA code:
Code: Private Sub Text151_AfterUpdate() [Average1] = Me.[1Average] End Sub
But this code copy the value with full rounding the decimal part and doesn't copy the real decimal number for this i need to edit this code to copy the decimal value without any change and rounding.
I have created a form with various textboxes. In one unbound textbox called Graduation_date, I input information and this is reflected in another bound textbox called text762.
However, as I scroll through the form, the information that is to be reflected in textbox 762 disappears.
Any ideas on how to apply the information entered in Graduation_date textbox to all?
I have nearly 100 queries in an Access database which links to a SQL Server database. The queries are working just fine.
I have created a new Access database, linking to a different SQL Server database which has the same table layouts as the first. Is there a way to automatically copy the queries from the first Access database to the second?
Hello, Excuse my inexperience, this is not my field. I am a network administrator and have never dealt with this problem before. I have been assigned the task of transferring a database (used by a security company to manage a gated community) to another system. I had to do this because the home owners association is changing security companies and they old security company is taking their computers with them. Now, I copied over all the files i could find and now that I am trying to set it up, I get the infamous error 3033, "you do not have the necessary permissions". I noticed that there is also a secured.mdw file. All i need to know is how to set up this database on a standalone system so that the new security company can access what they need. Thanks in advance for your help -Nima Shariatmadari Euclid Management
I have two tables, one is called Table A and the other is called Table B:
Table A contains these data: I II III
Table B contains no data
in the form of Microsoft Access, I want to be able with a push of a button and DEPENDING on the selected item, I want that selected item to be copied into table B. For example, in table A I am selecting item II, when I push the button copy, I want that item to be copied into table B.
I have experienced a problem copying a database from a CDR to the C Drive of a networked machine at work. What happens is that the Database attributes are changed to "Read Only" after being copied. I can change this easily enough but i dont want other users to have the same hassle.
This problem does not occur when i copy the same CDR to my desktop or laptop at home.
I need a little help with a new function in our CRM db (Ac2000).
I've made a system for handling sale-prospects. When a sale is done, I want to transfer the costumer info to the costumer table. All this is well, no problems with this.
BUT, each prospect (And costumer) has contacts. There can be several contacts to each prospect, connected with a prospect number.
The challange is to transfer the contacts as well. And assigning the new costumernumber..
Dont bother going techincal right away, but a point in the right direction would be great!
Hi, Does anyone have any ideas on how I might prevent a database from being copied. I have an application that I have set up with a number a tools to prevent exporting to an empty Access container, and from accessing the database design via the ShiftBypass feature, but the database can still be copied in its entirety. In some situations I would like to be able to add a feature to prevent this. Any suggestions? FrankC
I wonder wether it is possible to copy elements from one database to another. I have two copies of the same database. One for development and one for user access. If i for instance would like to copy a form from the development database to the other, how can this be done?
I am creating a database where I want to have a table that has references to another table.
I have an ID field in both that are linked. I want to be able to on creation of a new record in this new table have it grab the ID field from the other table.
I am trying to help a new employee with an MS Access 2000 problem. The db was created years ago, and the main table (permits) needed some major changes. She created a new db with a table that has all the same fields as the old db, but many new ones as well. We want to now import the data from the old db's "Permit" table to the new db's "Permit" table. All the field names are correct, but we keep getting errors trying to import and export. There are approximately 940 records.
I am trying to copy the data from one table into another table. I then wanted to update the table where it is copied from. This data i then wanted copied into that table in another row.