Search results for query: *

i have a text file with chinese characters and english characters that i need to insert into a row of a table. I need to get the whole text file so i can do some text manipulation later. However when i try and open the file using VB Dim FSO As New FileSystemObject Dim colFiles As Files Dim...

I am trying to anchor to text which is on a page inside a table there is nothing special (ie no tags) about the text. i was wondering is it possible to anchor to text of my choosing. Thanks Grant

i am using the iif function in a query Expr2: iif([search_term]="",[search1],[search_term]) it doesnt show [search1] if there is no value in [search_term] but it will show [search_term] if there is a value. any sugestions why this shouldnt work. Grant

I have a field in a table that has 2 and 3 words in, is there a way of changing the spaces into "+". Thanks Grant

I thought this would be easy but I Just dont get whats wrong. I have a form wich has three text boxes keyword SID searchphrase all i want to do is when i load the form i want to check if there is a value is searchphrase ifnot then the value will be same as keyword. Ive tried this and a few...

I have a CSV file that i want to import into access but it comes with information on the first 6 lines that i do not want, is there a way of skiping the first few record so that it starts reading on line 7. I have seen this done in excel you but dont seem to be able to save the import structure...

hi i am trying to copy current record "which has only one field" to another table. I am trying this but keep getting an error Dim strSQL As String strSQL = "INSERT INTO [ignore_list] ([keyword]) VALUES (Me!keyword);" CurrentDb.Execute strSQL error: Run Time Error '3061'...

I want to be able to clear a table but leave the structure. I have done this before but cant remeber how, I know i used a Macro but I cant see anything there to use now. any help Grant

is it possible to run a qry that will pull out all words that have more than 25 charaters. i have tried this in the criteria of the qry. Len([keyword])>25 but with no luck. any ides how to solve this i have used this before but on a form and it worked fine. thanks Grant

Is it possible to compare 2 tables to show all records that are in "TABLE A" that are NOT in "Table B". I have around 11000 records in TABLE B and 8000 in Table B and would like to see whats missing. I've looked at table relationships but they seem to show the opposite of...

is it possible to change the name of a textfile via access as i am transfering a table to a text file to incriment by 1 each time. eg textfile01 next textfile02 etc. or can it be changed with acces once it has been created. thanks in advance Grant

i am trying to insert string into a text box i think?? i would like a text box to say something like this Hello "keyword" welcome to this form. where the keyword is say someones name which is in another field. Is this possible. thanks for your time grant p.s. it doesnt have to...

i am trying to open a form and have certain tick boxes enabled or not depending on a value in a text box using this code Private Sub Form_Open(Cancel As Integer) If Forms![USA_form]![how_many].Value > 14 Then Forms![USA_form]![Dirt_cheap_keyword].Enabled = False Else...

is there a way of controling 5 tick boxes so that only 1 can be ticked at a time e.g. if one is true then all the rest are false. is there something in access that can do this or do i have to write an IF , THEN statement. thanks in advance grant

i have a form with 5 tick boxes on it. I am trying to make the visable property false if the number in another text box is more than a certain figure. I am just trying it on one tick box at the moment but having no joy this is what i have so far: Private Sub Dirt_Cheap____Enter() If...

I am trying to display how many characters are in a text field like so name=grant how many=5. however i also need it to count the blank spaces. name=grant hayman how many=12 (not 11) is this possible and how do i display it as a numerical value. all help is appreciated. Grant

how can i grab the keyword from the url. I have an url like this http://www.adomain.com/page2.html?keyword=akeyword is it possible to grab the "keyword" from the url and use it in text in html. I would also like to insert it into a link. the set up is that i would like to show my...

I am trying to send a value to a page using this script: #!/usr/bin/perl read(STDIN,$temp,$ENV{'CONTENT_LENGTH'}); @pairs=split(/&/,$temp); foreach $item(@pairs) { ($key,$content)=split(/=/,$item,2); $content=~tr/+/ /; $content=~s/%(..)/pack("c",hex($1))/ge...

Hi im using this script for a page loading message, It works ok but it doesnt always wait for the complete images to load, i think it is only set up for one image and the problem is i have two. To further complicate this the images are variable so i cant just check to see if a certain imagename...

Has anyone heard of a virus that can corrupt the fat32. I have a small network only 6 pc with no server which i split up about a month ago since then four have had problems. Two have had corrupt fat32 (they will not let me format them when checking the integraty it fails)One of the others has...