Hi,
I am running a few delete queries which r getting executed without any error. But the data in tables are not getting deleted. It is as if the queries were not run. I ran them through debugging but they are executing. Any ideas what is wrong?
thanks
atksamy
Last Activity: Jan 14 '11, 08:54 AM
Joined: Oct 27 '08
Location:
-
Ms Access Delete queries exceuting but records not deleted
-
Your attachment doesnt seem to work. I suspect its because of the access version... -
I am running a set of 30 to 40 queries to filter out some required data. At the end i delete the temporary tables i create....Leave a comment:
-
yes i copied the line exactly
i copied it into a module and then am running it. what exactly do you mean by executing it from 'open form'
Currently i am trying using Access 2007...Leave a comment:
-
When i execute this statement its asking me to choose certificate (digital signature)...Leave a comment:
-
Thanks for replying
I am looking into a automatic way through vba code. The problem i face is I get a message that this cant be done in vba or when database is open. If i close the database then I wont be able to run the remainder of the code from the module...Leave a comment:
-
How can I compact a current database using VBA
HI,
I am running a few modules of VBA code. In the middle of running the code crashes as Access reaches its max size of 2GB; but, if I compress the database at that point it is only 200MB.
How can i compact the database regularly in the interval
regards
atks -
How to resize a web browser in access forms?
Hello,
I have inserted a web browser in a form in access. I am trying to put a gif file on it. But however i try to resize I am getting a white border on the top and left side of the web browser which the gif file is not covering. Is there any other way to do it
thanks. -
Resizing the web browser
hello,
The web browser method for using gif files is a cool one. But i am facing a small problem in this. My gif file is black in color. I am getting a white border on the top and left sides. Even after trying to re size the browser i am not able to get the white border in the left and top to go away. Is there any other way to do this.
thanksLeave a comment:
-
atksamy replied to How to write a sql to compare two strings and get the result as a percentage match?in Accesswell i have managed to find a function. The algorithm is based on Levenshtein distance where the number of changes required for the two strings to be equal is calculated. i am trying somehow to use the like function with this function to try to get the comparisonLeave a comment:
-
atksamy started a topic How to write a sql to compare two strings and get the result as a percentage match?in AccessHow to write a sql to compare two strings and get the result as a percentage match?
HI,
I am trying to compare a series of strings like the following
rodeo rodas
carrot crate
GLX GLX 1.1
GLX glxs
the comparision need not be case sensitive
i am trying to write a sql where i am updating the first string with the second string if they match approximately. Here except the second string all the other... -
Thanks Neopa I ll try to get something going through this and get back in case i get stuckLeave a comment:
-
Is it possible to do some kind of paralle computing in VBA to reduce the time frame.Leave a comment:
-
i think we are talking about the sql in post no 10.
When i try it the query runs for more than 8 to 10 hours and then crashesLeave a comment:
-
Yes, But i doubt sql in access will be able tohandle it. the query will pick out 18000*18000 records and i find that it crashes at some point.Leave a comment:
-
1. The potential strings could represent anything strings or numerals.
2. Yes it is possible. As the field property of rs2 is text so "897" could be in text format.
3. At this point i dont think it has to be case sensitive,
so NeoPa = NEOpa evaluates to TRUE is correct.Leave a comment:
-
also would checking using ascii values workLeave a comment:
-
Thanks for replying.
Sorry for this confusing thread.
Anyway as Neopa had said i would want to compare the alphabetic strings in the field as well, to check if they are the same.Leave a comment:
-
Thanks for the replies.
I have a hitch . One of the fields is not numeric. Field 4 is numeric as well as alphabetic. is there any way to overcome this
thanksLeave a comment:
-
Could the number of records be the reason as each recordset has around 18000 recordsLeave a comment:
No activity results to display
Leave a comment: