Hi,
I'm developing an accesss front-end using odbc to a backend database. I've just started getting this error:
Run-time error '2001': You canceled the previous operation
when I click a button which replaces one subform with another.
The line of code it breaks on is...
thanks! course it does duh! now i've thought about it, don't know what I thought it could be different. I guess maybe I though search engines might miss asp pages altogether or something...earlier nights might help!
hi,
i'm using javascript instead of vbscript for asp scripting, because i'm much more familiar with java. its ok most of the time, but i do get stuck sometimes :-) and all the asp sites on the internet seem to be about vbscript.
I was wondering if anyone knew of any good resouces for asp using...
Hi,
don;t really understand how search engines work with indexing .asp pages. if I had metatags in the .asp page with values set using ASP e.g. from a database, would these get picked up by search engines?
Thanks!
I don't think I explained what I want to do very well!
I'm using Access as the front end to a postgreSQL database. Direct data-binding works fine for getting the data to display in an access form. However, when access runs an update (e.g. when I edit a record and then move to the mext record)...
Thanks for the idea
I tried:
RunCommand adCmdUndo
but it has the same effect as Me.Undo
Basically I want to make Access think the record is clean without undoing the changes on the form.
Cheers,
Tamsin
Hi,
Don't if this is quite what you want, but maybe you can modify it to get the results you need. I put this in the On Click Event of a button on a form, and it puts up messages showing the tablename and fields which make up the primary key. Not sure what you'd do if your form was based on a...
Hi,
On a bound form, I'm trapping the before update event, and using ADO to send an update query to the database (just using access as the front end here).
To stop Access trying to do the update itself, I've got
Cancel = True
at the end of the beforeupdate sub. But this means that Access still...
Thanks for the idea. You're right, it does seem a lot of work. But the queries that access generates don't seem ideal. e.g. for updates it does something like:
update tablename set field1 = "value1", field2 = "value2" , ...
where field1 = "oldvalue1" and field2...
Is it possible to have an entity reference with a quote in it? I'm using xsl to transform xml to html, but I'd like to put some html in entity references, for easy of changing certain things throughout the site.
e.g I'd like an entity reference that puts:
<img src="pic.gif"...
Hi,
I'm using access as the front-end to a postgreSQL database using odbc, and I'm looking for the best way to talk to the database. I don't want to use directly linked tables because the sql that gets generated isn't really optimised for postgreSQL, so I'm looking at ADO, pass-through queries...
Hi,
Not sure what the best approach to this would be. I have a button which opens a form in dialog mode, which I want to pass three integers to, to use to set up the contents of some combos etc. But because its in dialog mode, the code after DoCmd.OpenForm .. doesn't run til its closed. And...
I guess this is a fairly common problem - about 50% of the time, when I try to shutdown my computer, it reboots instead. VERY annoying!
Its windows 98 SE, and I've followed the advice in other posts, and found that if I shutdown mcafee active shield first (or disable it from starting up at all...
I want to install apache-ssl using rpms, which I've found.
I'm running Redhat with Apache & openssl already installed (via rpm). Anyone point me to some notes on how to do this? - all the instructions I can find refer to tars etc & I'm not sure what I should actually need to do after...
Image buttons don't pass their value, they pass the coordinates where the mouse was clicked (in the form buttonname.x=3&buttonname.y=4 - I'm not sure the exact syntax & I think it only works server side. So checking if buttonname.x != "undefined" might work.
Alternatively, keep the...
Thanks for the help - that nearly worked!!
The example above works fine, but unfortunately, I need to put input boxes in more than one cell. When I move the form tag outside the td (i've tried putting it outside the table, and between the table and the tr) the gap comes back in Netscape...
I am trying to put an image above a table without a gap between them. I'm using margin-top in css to make sure there isn't a gap. But if the table contains a form, the gap seems to be much bigger. (And of course, its different again in Netscape cf IE). Has anyone come across this?
Thanks
Tamsin
quick comment - if you just use meta tags, this will only stop the browser from caching the page, but won't stop intermediate caches on the internet from caching it, so you still might not get an up-to-date copy of the page. To stop intermediate caching, you have to set the http headers which...
Hi,
I know that an input type=image passes the x & y coordinates rather than the name & value, but I can't work out how to get these values. I've written the following (much simplified from what I really want to do!) which I call from an onSubmit trigger on the form:
function...
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.