Search results

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

Hi all. If you have a date cast as a long (43112 for example) and you would like to get the day of the week out (Monday, Tuesday, etc), is there a function for that or do I need to write my own modulus function? Thanks all. PB

Well, yes. This retrieves a parm query in code. This is great code, but unfortunately, it does not answer my question. The data is sent to a record set. i would like to see the data... open it.... show the table,....how should I say? ..open up a window with a grid in it that has the data in...

Hi all I've got a parameter query. I would like to call it in code, feed it the parameters in code, and show the result set (datasheet). I understand that this is different from retrieving it in a record set (which I can already do). Example code? Link? Anything's appreciated. Thanks...

Hi all. I've got a subform that I would like to populate in the Form load event. I have a parameter query already written that I would like to use to fill this subForm. The parameter is a date [#Enter Date#] I'd like it to default to now() The form prompts me for the date in the parameter...

Hi all. I don't use the reports module much. How do you add a footer that counts the record in a report? I looked in the 'View' 'Sorting and Grouping' and 'Field List'. Sorry to throw out such a simple one. PB