Search results

Thank you jdraw. I was not aware that a text box does not save an instance of a single entry, as you wrote. Let me go back and try what you are saying. Thanks again, PW

Thank you Gasman for replying. I had trouble logging back in earlier to Access World. I get the same problem, when I use code to select just a folder. The folder path stays in the text box for a minute, then it disappears, say as soon as I close the form. Of all my Access misadventures...

Hello all, Even as a novice programmer, I thought I could get this Access VBA code to work, but can't. I would like to set a folder's value in a form text box, for later use to direct the user's exporting to Excel. I am assuming I can set just the folder path....and that I do not need to...

The amounts successfully imported by Access, look fine. The various Access numerical formats I've used, which accommodate 2 decimals, remove the SAP trailing minus sign. So Access will either put the negative sign in front of the number, or it will bracket negative numbers, depending on the...

Dave, thanks for the reply. "WTGBTR" is the SAP object, which defines the column that holds the dollar amount values. "Gridview" is the SAP object for the table of data, if you will, that was generated by an SAP query, a few lines of code previously. So WTGBTR is the column within the table...

I tried various error loops, but the code still does not work. My hunch is there is something wrong in this code. GetCellValue works great for text, not dollar amounts. I will try to convert dollars into strings...maybe that will help. Thanks all for your nice responses...

DBguy, great idea. Let me try that solution. It very well could be the null values causing the problem, thanks.

Yes, I tried text too for the Dollars field. And that does not work either. I get a different error message.

Sorry, "Hello DB Guy"....please excuse spelling error!

Hell DB Guy, For the Dollars field in the Access table, I have tried all conceivable types for the field that receives dollars. Both Number and Currency. Field size/format/decimal places are Double/Standard/Auto. Probably tried about 10 different variations of Number or Currency. Nothing...

Hello forum, I am writing an Access VBA code module, which imports SAP actual data into an Access table. I believe all the proper libraries have been tagged under VBA references. I am using SAP GUI scripting code as well, to navigate thru the SAP screens. The code works good for pulling...

Hello Access forum, I am a CPA, working on management reporting within organizations, which often utilizes Access. I have about 15 years of Access experience, but I must say I am not a programmer or developer. So forums like this are extremely helpful to me. Access 2010 is currently the...