Recent content by pdbowling

Good day, All. I searched the forums but didn't seem to have the right keywords to dig this up. I am also new at XmlMapping so may be I am going about it all wrong. I am starting with a normal spreadsheet without an XmlMap. I want to (if this is possible), create an XmlMap and output the...

Thank you Very precise.

Hi all, My help files are not working for some reason so until I get them reinstalled... Would someone please let me know what the return values are for the instr() function are. IE. If the search string is not found, what does the function return. If it is found, what does it return from...

Hi all, I have a table... Amount........Wholesale...........Commission Lots of other columns but they don't come in to play. When an Amount is entered, can Wholesale and Commission auto populate with Amount*.9 and Amount *.1 using default values in the table definition? I couldn't quite get...

Good day, all. I would like to loop through the files in a folder and do some basic processing. I've done it before but seem to have misplaced the code. Any suggestions? Using Access 2003 SP1. Thanks PB

Hi all, I was wondering if someone could tell me what criteria to put in at design view for queries on a number field when you want to mine out numbers with more than 2 decimal places. Thanks everyone. PB

Nice Wow. Fantastic, what References do I need to include to use the Workspace and Database object types? Thanks for your help. PB

Hello all. I am curious if one could create a new and seperate Access database in code. Can this be done? Thanks PB

Thank you. PB

Hello everyone. I need to run a query to do this: Table structure: row..Field1(txt).....Field2(txt).....Field3(num) 1.....x..................y..................1 2.....xx................yy.................2 3.....xxx...............yyy...............5...

Hi all I have a small table with a list of items that I would like to delete from a larger table. All column names and settings are the same. I tried to set up a query to do this but have been unsuccessful. I tried "Delete * from table1 where table1.field1 = table2.field1 and table1.field2...

I'm not in control of the data I have to work with. I've got several sources that are independent of myself and each other that would like to report off of both sets of data. 3 companies, 2 sets of data. Thanks for the append query idea, I'll give it a go. PB

Hi all. I have a table like this Truck...Repair.....Date......Cost F001....Brakes.....3/1/03.....0 F001....Axle.......3/1/03.....0 F001....Bearings...3/1/03.....0 F002....Tire.......3/1/03.....0 F002....Stear......3/1/03....0 I have data that needs to go in like this Truck....Month....Cost...

OK, call me stupid. I've used format to format(myDate,"mm/dd/yyyy") What's the syntax for 'Day of the Week'? PB

Thanks, but I know how to cast dates to anything except Monday, Tuesday, Wednesday, Thursday, etc. The 'regular' function.. I don't know what that is. Got a hint for me? PB