thisisntwally
Last Activity: Mar 14 '08, 01:48 PM
Joined: Jun 27 '07
Location:
-
I've been having the same problem since june (also inherited from those who came before me) and have yet to find a solution. With Access 03, and acrobat readers 7 and 8. Thought i might check in to see if anyone had a fix yet. -
got this one. my controls were still unbound. oops.Leave a comment:
-
I figured much of my problems out, partially a bound form thing, partially through a different approach.
Form1 opens an existing blank record, which it edits, "saves", and opens in a new form. It then closes and generates a new blank for when it opens next.
heres the problem: Values inputed on Form1 fail to save, automatically or even when instructed. my code follows...
from...Leave a comment:
-
this:gives me a 'syntax error'Code:Dim stDocName As String Dim stLinkCriteria As String stDocName = "Update" stLinkCriteria = "![keyID]=" & Me!txtkey DoCmd.openForm stDocName, , , stLinkCriteria
this:prompts me for...Code:DoCmd.openForm "Update", acNormal, , "!keyID='" & Me![txtkey] & "'", acFormEdit, acWindowNormal
Leave a comment:
-
Ok so form two was indeed unbound, a problem which has been addressed.
this didnt work:
which leads to "syntax error (missing operator) in query expression '[txtkey]='...Code:Dim stDocName As String Dim stLinkCriteria As String stDocName = "Update" stLinkCriteria = "[txtkey]=" & Me!txtkey DoCmd.openForm stDocName, , , stLinkCriteriaLeave a comment:
-
I just found a seldom used 'ammendment number' that will soon become manditory now that i can identify the records without the autonumber/dmax (procurement request + amendment number => PR + Mod # =yay!). I'm hoping with that it will be easier to reopen a record in a new form now that i wont be referencing calculated fields.... now if i could only find those postings on linking with multiple criteria....I'l l be back just as soon as im in deep...Leave a comment:
-
ok those are definately unbound. im pretty sure that the problem is that my editrecordButto n on Form2 is copied pretty directly from the original addrecordButton on Form1 - i just changed .addnew to .edit...Code:Private Private Sub comRecord_Click() Dim temp As Variant On Error GoTo Err_comRecord_Click temp = SysCmd(acSysCmdSetStatus, "Filling table...")Leave a comment:
-
*very embaressed
I don't(edit:do) think that the control source properties are set to fields in [tbl Modifications] (actually "txtkey" might be if what im doing in VB is setting control sources which as i type this begins to seem more likely)
Code:'in form1 !key = DMax("[key]", "[tbl Modifications]") + 1...Code:'in form2 !key = DMax("[key]", "[tbl Modifications]"Leave a comment:
-
you could also build your own (if you wanted to avoid autonumber) with =dmax("PKfield" ,[table])+1Leave a comment:
-
hoookay, Got some of this worked out, i just changed the update spec to Dmax and voila! (well at first i forgot to change the control source...and maybe there was something else...)
that being said, the second form still insists on updating the first record. It is of course friendly enough to change the key value to corrispond with the first form - thus creating duplicates and leading me to believe the problem is either still here:...Leave a comment:
-
speaking of, i went ahead and changed the control source for "txtkey" on the all-inclusive tabbed form to =DMAX("key",[tbl Modifications]) + 1, and now have the same problem. (as it used to be autonumber and there was no need to reference the key on the combined form, this was never an issue).
that being said, it seems to me as though there is a problem with my Dmax syntax......Leave a comment:
-
Both tables are indeed bound to [tbl Modifications]. There has been some who question my logic (i don't believe its all that ab-normal hehheh) but for user simplicity's sake im rather stubborn about having two forms. I do have a functioning tabbed form which combines the two, so I could get to work on some other functions in the database, but I hate the d@mn thing....Leave a comment:
-
heres the sub ATM. im still getting the same error. I added the save command, and have changed my PK from an Autonumber to number, and its control source to =DMAX("key",[tbl Modifications]) + 1.
not that it produced any results per se.
...Code:Private Sub Command85_Click() On Error GoTo Err_Command85_Click With CurrentDb.OpenRecordset("tbl Modifications", dbOpenTable) .AddNewLeave a comment:
-
Well while i am quite sure its rather convoluted at this point, its an attempt at opening a newly added record in a new form. it started out as you have above - but checking that again im getting a .(dot) or !operator or invalid parenthesis error......Leave a comment:
-
Thats the most helpful thing i've gotten yet! You rock.
...Code:Now why does it insist on only applying changes to the First record? Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "Me.LastModified!key = & Forms![Input Form].txtkey" stDocName = "Update" DoCmd.openForm stDocName, , , stLinkCriteriaLeave a comment:
-
When you say retrieve value from recordset, is that to say i can reference a value not explicitly included in form1, provided its a field on the table? And if so can I reference a key which is autofilled on completion of Form1?...Leave a comment:
-
sorry! i was just hoping it might be a .dll problem! thanks for pointing me in the right direction!...Leave a comment:
-
Update Record in one Form and Open in another form?
I've created a button in formA which updates the table in question, but i'd like to have an option to update and open the same record in form2
(different datafields are being entered so i don't think theapproach will work).Code:DoCmd.openForm "form2", , , "[field]=" & Me.[field]
Is there anyway i can use the .bookmark property to open the new form?
The primary key is autogenerated...Last edited by thisisntwally; Jun 29 '07, 02:30 PM. Reason: forgot a word....title still looks dull though... -
OLE Bound Object Error in Access
I've seen this question asked a few times around the forums, but it never seems to get a satisfactory answer.
In an Access database with bound objects (pdf's in specific here) after I open the embedded file (no problem yet) when i close the document I get the error:
the operation on the Acrobat Document object failed
The OLE server may not be registered
To register the OLE server reinstall it
...
No activity results to display
Leave a comment: