Search results for query: *

I have a table that I would like to append to an existing excel spreadsheet and I am using the TransferSpreadsheet method with the following syntax: DoCmd.TransferSpreadsheet acExport, 8, "Table-5", "C:\Stuff\MySpreadSheet.xlsx", True This exports table-5 into C:\Stuff\MySpreadSheet.xlsx but...

I have a multi line item order that I need to read into a form with a query where a couple of line items fields need to be contained on one line for each quantity ordered. Quantities ordered will vary from sales order to sales order and it is assumed that each order will contain a line item...

Not sure if I am asking this correctly or not but here goes.... There are a lot of examples of DoCmdTransferSpreadsheet acimport out there but haven't found one that answers my question. What I would like to do is have the user click a button on a form and then have this command import a...

I have been away from Access for awhile so I apologize in advance if I sound like a newbie or posted this in the wrong area and I am counting on you to set me straight if I am wrong... I am trying to pull some data from a couple of Oracle tables and the Oracle admin has set up an account...

Is there a way to create and also read an "ini file" with TCL? Thanks

I have a TCL script in which I would like to set up some pauses that are resumed by a key pressed by the user on a keyboard (space bar or whatever) much like the Getch command in C. Is there a way to do this in TCL and if so, how? Thanks

I am new to TCL and have a question about arrays... I have the following arrays but would like to make this one array of 64 numbers. set ch0_31 [list 8 25 13 21 127 10 18 19 44 29 27 120 35 124 126 41] set ch31_63 [list 6 12 11 16 15 42 22 26 30 20 85 34 39 121 43 40] set ch63_95 [list 47 61...

I have a query where I am trying to filter out parts that have a description starting with "OBL" and "ALPHA" but for some reason I am not able to keep items like this from being displayed in the results of my query. Here is the SQL for my query: SELECT BOM.BCHLD AS Item, Typ.IDESC AS...

I have a form called search_frm which contains three fields: a Documentation Type field (qDocType), a Documentation Ref field (qDocRef), and a Documentation Desc field (qDocDesc). I have a search button that launches a query to Search for any text that is typed into these form fields from...

I have a database table which contains information about documentation that is stored on our network file server. I am able to search for a specific doc and display the specific information in a report but I would also like to display the hyperlink to the file so that a user can click on it to...

I have a query which searches a table and displays records that contain text that is specified in text boxes on a search form. This works fine for finding the first characters of the fields but how can I change my query (below) to display all records that contains the string specified in any...

I have two Combo box questions: 1. Is there a way to center the text in each column of a Combo box? Setting the text align to center for the properties of the Combo box don't seem to work in my access 2007 as seen in the picture below where all text fields in the combo box are left...

I keep getting a Run-Time Error '3061' when I attempt to open a recordset with the following code: Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbs = CurrentDb strSQL = "SELECT M_tbl.ID, M_tbl.Asm, M_tbl.Desc FROM M_tbl WHERE M_tbl.ID =forms!MACaddr_frm!Device" Set rst =...

I have a list box (Device) that is populated by a table (M_tbl) and I would like to have the User click a button to select the record of the table that is shown in the list box so that a field of that record can be modified. My list box row source looks like this: SELECT D.Assembly...

Is there an easy way to convert a decimal number into a hexadecimal value? I tried the following but I think it is a hexadecimal to decimal conversion because when my number = 10, it is converted to 16: num = CInt("&H" & num) Any ideas on this are appreciated... thanks

I am attempting to add a new record to a table and I am able to access the table OK and move to the last record with .MoveLast But then I add a new record with .AddNew and the record appears in the table but when I attempt to edit that record, I find that I am not indexing the new record but...

How do I grab the largest number in a table? I have a query that does this but I would like to grab this number and assign it to a variable that I can increment and embed it into a string of characters from inside of an event procedure... There must be an easy way to do this... thanks SELECT...

I have a form (MAC_addr_frm) with a combo box (DVcode) which is populated by the table Device_Code_tbl.ID I am trying to populate the following 3 text boxes on this form from what device code is selected by the DVcode combo box: 1). pNum - to be populated from Device_Code_tbl.Asm_Num 2)...

I have created a report in Access and I was wondering if instead of printing or displaying the report with ACpreview, whether this report could be output into an Excel spreadsheet instead with all of its text field's formats intact. Any ideas if this can be done and how ? thanks

I have some code that creates records in a table based upon a part number that is manually typed into a form (newpn). I have a large list of numbers that I need to be placed into this table by performing the same calculation on them instead of typing one number at a time into the form...