Thank you for replying!I do have the primary key set to an aoutonumber field, so that dosen't seem to be the problem. I am only getting that error on one computer. On other computers it runs fine. I used to wizard to build the duplicate key, and it does what I want it to, but not on one...
I have a duplicate record button on a form so that users will not have to re-type header information. When you click on the button it generates a Paste Errors Table. Is this because the form has drop-down boxes, or is it something else? Thanks in advance for any suggestions you may have.
Justin
Thank you again! It is still not printing. I am not sure why. I erased the line me.command1.visible = False. Should I replace it with something?
Thank you,
Justin
Thank you!Is that all I use? I tried it and it didn't print? This is what I have now:
Private Sub Command1_Click()
Dim doc As String
Me.Command1.Visible = False
doc = "Index Performance Appraisal 1"
DoCmd.SelectObject acForm, doc, True
DoCmd.PrintOut
doc = "Index Performance...
I would like to print three froms using a button at the end of the third form. How do I do this? Here is what I have:
Private Sub Print_Click()
On Error GoTo Err_Print_Click
Dim stDocName As String
Dim MyForm As Form
stDocName = "Index Performance Appraisal 1"...
I have three forms that I need to print using 1 button on the last form instead of a button on each form. What do I need to change in the code and/or where do I put the names of the other forms so that they print? Here is what I have so far:
Private Sub Print_Click()
On Error GoTo...
Thank you for your help. I may have to do it that way.
Maybe a better description of what I am doing will help. I am creating a form that was once a temoplate in MS Word. There is a slider bar to designnate a "Score" of 1 to 5. To my knowledge you cannot build a slider bar in Access...
I am building a form with over 400 fields. As you know a table is limited to 255 fields. I divided the fields into 5 tables. I would like to use all the fields in one form. So far I have been unable to do this using the form wizard or anything else I can think of. Is there a way to get all the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.