Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Fattire
  • Content: Threads
  • Order by date
  1. Fattire

    Updating Records from RS Not Working

    I don't see what I'm doing wrong with this update, no error occurs, but no update either. Both rec2 and rec5 are ADO. rec2 comes from Oracle, rec5 from Access. Do While Not rec2.EOF With rec5 .MoveFirst .Find "[po] = " & rec2!PO_NUMBER, , adSearchForward...
  2. Fattire

    Summing List Box from in Text Box WIth Data Type Error

    I use this code to sum up column 9 into a list box whenever its requeried but if there isn't at least a $0.00 in the column it says I have a data type problem. It's hung up on the NULL's. The data type in the table the value is held is set to currency. I've tried NZ, I've tried Format...
  3. Fattire

    Allow Blank CBO to pull All Values to ListBox Not Working

    My users have 3 values from a combo box to chose from which is used to isolate the data they need to a listbox. I'd like them to have the ability to retrieve all data if the combo box is blank. How can i accomplish this? I've tried using the 'Switch', 'IIF', and 'NZ' funtions in the crieria...
  4. Fattire

    Link Subform to ListBox On Same Page Index/Tab

    I'm trying to link a listbox on page index 1 (second tab from left) to a subform on that same page. Seems like it would be easy but it's not taking anything I give it. Subform would keep notes to each record in the listbox I select with the mouse. Tab Control: TAB_CTRL_PAGES Page...
  5. Fattire

    Export 03 Access Query to Excel 07

    I find it hard to believe that this doesn't work in A03, is it true a03 will not do a transfer spreadsheet to excel 07? I usally can't find the little secrets around this site so I'm asking here. Option Compare Database Private Sub cmd_XFER_2007_Click() Call XFERExcel2007 End Sub...
  6. Fattire

    Reverse Pivot multiple Rows into Single Field

    I have 3 items I need to consilate, but I can't lose part of the detail. Right now 3 lines look like: INVOICE DESC AMT 123 TAX 5.00 123 FREIGHT 7.00 123 PAPER 9.00 Need it to 1 line and look like: INVOICE DESC AMT...
  7. Fattire

    Difficult Row Number Needed

    I need a function or something that can give me a bucket that increments by 1 at each change in data that is not unique (but it is sorted correctly)... See below, I need to produce the GROUP_ID at every change in invoice date then line_number (notice invoice date is not unique, niether is line...
  8. Fattire

    Intercept Error Msg

    I have a form that enables the user to select an excel file they can import into the database. Problem is that some of these excel files get saved on accident after someone has changed the columns. The user gets "Run-time error '3274': External table is not the expected format." Is there a...
  9. Fattire

    DoCmd.TransferSpreadsheet Still Won't Work. Run-time Error 2391

    There have been a lot of posts on Run-time error 2391 but I have never seen an answer to it: Private Sub CMD_IMPORT_NEW_DATA_Click() Dim varDate As String Dim varSpecification As String Dim varTable As String Dim strInputFileName As String varTable = "TBL_AR_AGING"...
  10. Fattire

    Zip Multiple MDB's Into 1 Zip

    Using WinZip I can zip one file with the following code, but I'm having problems getting more then one file into this winzip file. Private Sub Form_Load() Dim ZipPath As String Dim ZipFile As String Dim ZipApp As Shell Dim strpath As String Dim today As String Dim fol...
  11. Fattire

    Toggle Breakpoint Won't Go Away

    The other day I was making a change to a cmd button on someone's front end and put in a couple breakpoints to get it fixed. Well now everytime the cmd button is pressed the DB stops where I put my breakpoint - I hit debug on the error msg and sure enough its where I put my breakpoint but its...
  12. Fattire

    Reverse Pivot a Result Set into One Column

    I would like to take: INVOICE|QTY 12345 |500,400,700,600 And turn it into: INVOICE|QTY 12345 |500 12345 |400 12345 |700 12345 |600 Any sites or previous links you know of? I couldn't find anything.
  13. Fattire

    Data Type Issue

    I have a little form where you type a vendor number and it goes to that record in the database, the vendor number is a text field in the table and the text box on the form has no formatting to it, but it says I have a data type mismatch, not sure why. Private Sub cmd_GoToVendor_Click()...
  14. Fattire

    Right Justify a Column In a ListBox?

    My dollar amounts look rediculous in this list box - is there a way to right-justify a specific column in a list box?
  15. Fattire

    Keep ODBC Con Open so it Logs In Once for All Forms

    How do I keep an ODBC connection open so that any form can use it to extract data from an external at any time rather then having the Access DB log in the the external DB on every form? The DBA's are upset that my db's are loging in 200-300 times a day from my users into the Oracle DB and want...
  16. Fattire

    Insert Null column(0) on combo box via Code

    I'm trying to give the user the ability to update a combo box to null if they no longer want a value from the combo box on the main table. varSalespersonID = IIf(IsNull(Me.cboSalesPerson.Column(0)) = True, "", Me.cboSalesPerson.Column(0)) It's the INSERT statement that doesn't like the two...
  17. Fattire

    Bypass 'Linked Table Manager' with Code?

    We have several users that have mapped their drives to the same place with different drive letters due to face that other departments cannot change their drive letter because of their access DB's, and we have to hit their databases. Is there a way of bypassing the linked table manager settings...
  18. Fattire

    Select Field Names from Table

    I keep searching but can't find this question ever being asked. How do I extract the field names, data type, and field description from an Access table via SQL or a Query? I don't see any table column name data in the Msys tables.
  19. Fattire

    Split Database Principle Question

    We have a shared windows network here and several access databases on it. They are all split, but very slow once more then one person uses them. I noticed recently that everyone has shortcuts to the front end and not the actual front end sitting on their desktop. The front end and the backend...
  20. Fattire

    Create new recordset after 1000 rows retrieved

    I need to compare 4000 records in Access to another database (Oracle) using SQL via the IN function. It's limited to 1000 expressions, which means I need to split it up 4 times and run the SQL 4 times or create 4 IN statements in the SQL, which I would rather do so that I only run this query...

Part and Inventory Search

Back
Top