Recent content by ghayman73

Hi PHV, Thanks for the suggestion but ive tried all states and never get the right result back. Thanks Grant

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

thanks suicidED works a treat

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

Ive found it, Thanks for your time John. Grant

thanks john I am using 2002 version but cant see how i would update query to replace a value. When i tried it replaced the whole field to "+" is there a way of restricting the update to just the "space". 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

Thanks for all your replys RGB that seems to work great, "BUT" theres always a but isn't there. It only works on new records I insert is there a way of getting it to run on previously entered records. Does this mean that previously entered records dont have a truly null value or is...

still not getting any values in SID Is this part correct Private Sub SID_BeforeUpdate(Cancel As Integer) its a text field so the word Integer confuses me unless its saying if its a number cancel the action ?? 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...

sorted thanks for your time.

Its running now thanks spiralmind. BUT!! its asking for (Me!keyword) is that the correct syntax for current form. thanks again. Grant

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'...