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

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

Hello all. I am curious if one could create a new and seperate Access database in code. Can this be done? Thanks 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...

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

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

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

Hi all. I've got a form... I choose a selection from a combo box. The selected record determines what needs to go in a text box and another combo. I keep getting this error when I try to set focus on the textbox. How do I correct this? "You must save the field before you execute the...

Hi all. I wrote a query and saved it. It counts records. When I click on the query I get 3074 as the result. I wrote a function that calls the query, but the function returns 0. Here is the code. It is a carbon copy of another function that does exactly the same thing and works perfectly...

Hey all. I've got a parameter query that feeds a report. I'd like to call the report in code and feed it the parameter. I thought the following code would do it, but I still get the parameter prompt [Enter Vendor Number]. Any suggestions? PB Text0.SetFocus myVendorNum =...

Hello all. The help files in Access seem to be leading me down the wrong path. I am trying to set up User Level Security. I want a SuperUser that can log in and do whatever and a read-only set of users. The help files keep setting up a universal password that asks for the admin password on...

I am trying to import a spreadsheet to a table. On my computer, it works fine. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Data", myFileName, True True being the "HasFieldNames" parameter I copy this file onto another machine and it no longer assigns field names. It imports...

Hello all, I have 2 tables. PO and Repair_Tag PO table PO(txt)....Vendor(num).......UserCode(txt)......etc Repair_Tag table Repair_Tag(txt)......UserCode(txt)..........Vendor(num).......PO(txt)........etc My question is: Is it possible to make the field PO in Repair_Tag a lookup value that...

I am trying to import a spreadsheet to a table. On my computer, it works fine. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Data", myFileName, True True being the "HasFieldNames" parameter I copy this file onto another machine and it no longer assigns field names. It imports...