Search results for query: *

All, I hate to keep posting things, but I have another SAP question. I am trying to pull longtext from SAP tables and can do it one part number and one operation at a time with the following code. Public Sub ReadText() Set objFileSystemObject =...

I am just wondering if anyone has any experience with RFC calls into SAP from access. Here is my current code I have that works well. Dim LogonControl Dim conn Dim funcControl Dim TableFactoryCtrl Dim RFC_READ_TABLE Dim eQUERY_TAB Dim tblOptions Dim tblData Dim tblFields Dim retcd Dim...

I have a VBA code I run to select a sheet, copy that sheet, and save it as a .txt file. It pastes several strings of text and one just one of them it always adds quotes at the front and back. These quotes do not show up in the cell in which the text is contained. The sheet that is copied has...

I am adding some things my boss requested to the database I am building to keep track of warehouse orders. I have a form that displays all of the current pending orders the warehouse needs to fill. I have a button that they can click to indicate that they have totally filled the order and it...

I am building a database to keep track of orders requested from our warehouse. I have most of it built, but am having trouble building the query below: Private Sub cmdDisplay1_Click() Dim strSQL As String strSQL = "SELECT * FROM tblPending WHERE PartNumber = '&lblPN1.Caption&' INSERT INTO...

I am trying to create an on-screen keypad in Access. I have a form with the numbers 0-9 on it and a text box that displays the numbers pressed. I just need to know how to code the keypad so that it can be used with any form in the database. I have several forms with textboxes that I want to...