I have a report, I need to update a textbox in the report and I'm using VBA and the on format event. However, it won't let me update the value..
How can I go about this? Thanks
Matt
The read only box isn't selected for the ODBC driver.. checked that first, and about 1,000,000 times since.
I can connect with toad and edit the database..
Here it is,
DoCmd.RunSQL ("INSERT INTO REPLICON_FTBE ( FTBE, DATERANGE ) VALUES (" & rs(0) & ", #" & dateStartDate & "#)")
I also get the same error if I try to edit the table itself.
I'm trying to update a linked oracle table via access.
I am getting ORA-01456 "May not perform inser/delete/update operation inside a READ ONLY transaction".
I use the same ODBC connection to connect with toad and I have no problems.
Any ideas?
In a report I'm working on, if a field has a textbox has a value above or below another textbox, I need it's color to change.. I guess its forecolor?
How would I go about doing that?
Thanks,
Matt
I'm working on an Access project that works off Oracle tables.
Everything runs fine I just have one question.
What is the least amount of software that must be on a machine for the access - oracle link? This needs to go on somebody's computer that has limited space.
The smallest install from...
Yes, Something similar.
I don't know access or VBA so I have no idea when I'm barking up the wrong tree..
Just a guess on where to look would be a huge help..
Thanks!
I have a nextrecord field in there.. I guess I could get X.
The table now has one row, the last cell contains the nextrecord field. Basically.. I need that row to repeat automatically.
I'm working on access mailmerge application.
Within word, I have a table that needs to be populated X amount of times.
How can I get this row to automatically repeat X amount of times with the mailmerge fields in the table.
I have a macro that will do it, but I don't know how to automate the...
I have a form, frm_EmpForm that contains a sub form, subfrm_SkillTable.
I am trying to requery subfrm_SkillTable from another form, frm_EditSkill.
I don't have many points and I'm new to access..
Any help would rock...
Thanks,
Matt
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.