Search results for query: *

Hi all, I have imported a table from oracle to crystal reports, when i add my date field to my report the date is displayed in the format 01/01-4713, however when i browse to field data on the field, the correct data is displayed!! So I'm assuming perhaps i need a formula to format the date...

I can't believe i missed that! Thanks very much Bob! Maggie "Work is the curse of the drinking classes

Hi all, I have a piece of code which i know works where by I insert a record into a new table. I want to now insert a group of records (whicch are displayed in a list box - all are selected by default) into the table but i am getting a Debug Error - Object required when I try to do this. This...

Hi Sean, I have tried that and unfortunately no joy. The code works on another machine, its just when i have copied down to my machine - it is not working, so maybe i am missing a reference or something?? Any help would be greatly appreciated!! Maggi "Work is the curse of the drinking classes

Hi all, I am currently trying to step through code for a Batch Job which moves files from one folder to another. I am getting the error "Object Variable or With Block Variable not set" on the following line: Set oTagAttributes = oNodeBirthDetails.Attributes If anyone has experienced this...

bjd4dc and Tom, Thanks for all your help, the code now works perfectly, Thanks again, Maggie "Work is the curse of the drinking classes

Hi all, BJD - I have used you Instr code and it is working fine except for one small thing, in my program, if a file contains the strtoMatch it is copied to another folder and deleted from the original folder. The file is copied with no problems, however when i try to delete the file from the...

Hi bjd4dc and m milan, thanks for responding, bjd4dc - thanks for your solution - it looks like it will definitely do the trick - i will let you know how i get on, again thanks for your time, Maggie "Work is the curse of the drinking classes

Hi all, I want to search through about 100 files for a specific string - "Country code is invalid" which is contained in the text of the file, these are xml files. I am familiar and have been using the FSO to move and copy files but i just cannot find the property/object to search for a string...

Hi all, I have a query where by the user can enter in a description to bring back a number of records, when they enter in a single letter (which brings back about 14000) records my database crashes. This is my search query: SELECT tblProducts.[Product No], tblProducts.Updated...

Thank you Harold, I will try this. "Work is the curse of the drinking classes

Hi all, I have a form based on a table which has the Product No (autonumber) as the PK. i ahve an update query which will update fields in my table as follows: Update tblproducts set primary_material_no = '" & Combo59.Value & "' , secondary_material_no = '" & Cbo_subcategory.Value & "'...

Hi all, I have a simple form which was created based on a table. On my form I have an updated yes/no field which is filled when the record is updated. I want make a no of fields invisible if the record has not been updated. I need to check if the record has been updated each time i change a...

Hello all, thank you all for your help and suggestions. Crowley 16's suggestion of declaring an array, and having a for loop, which adds the item being updated to that array did the trick for me, thanks a million Maggie "Work is the curse of the drinking classes

Thank you so much Crowley 16, That worked perfectly! Maggie "Work is the curse of the drinking classes

Hi all, I have created an array which holds unique product nos of records i have updated in my db. i now want to select records from my db based on the data (product nos)in the array. I have: List42.RowSource = "Select * from tblProducts where Product No in '" & myarray & "'" but it is...

Crowley 16 or anyone else who knows arrays! I have created an array which holds all the product nos of records i have updated. i now want to select from my db based on the data in the array. I have: List42.RowSource = "Select * from tblProducts where Product No in '" & myarray & "'" but it...

hmmm well my problem is i use an initial search query(select stmt) based on an a word entered in a text box to allow the user to select a number of record to update (based on the text box value) From the values returned to the list box the user selects the records he wishes to update. So using...

Hi all, I want to run a select statement which will bring me back all the records i have updated in my last update statement (to be displayed in a list box) how would i create a select statement to do this?? Or what would be the best approach to doing this?? Many thanks, Maggie "Work is the...

Having reduced the box - the scrollbar now appears, thanks a million, Maggie