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!

  • Congratulations Mike Lewis 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: *

  1. 4N6Mstr

    Expression does not use variable full value

    at this point, i'm inclined to move to Talend or ETL Tools. Testing both, but there is a learning curve there, as I've been using SSIS for some time. I just can't understand why SQL (SSIS) / Office guys at Microsoft can't get together and address problems that have been around for so many...
  2. 4N6Mstr

    Expression does not use variable full value

    There will always be at least one valid, but I will not know beforehand how many valid (or invalid) ones in total in each Excel book. Any help is always apreciated! Thx, 4N6MSTR ______________________________________________ If you don't know where you are going It does not matter how fast...
  3. 4N6Mstr

    Expression does not use variable full value

    Hello, folks. I have to import a number of excel spreadsheets. I'm using the classic Foreach Loop inside another Foreach loop approach. The outside loop (Foreach File Enumerator) cycles through the Excel files, while the inside loop (Foreach ADO.NET Schema Rowset Enumerator - ExcelSchema -...
  4. 4N6Mstr

    SSIS Script task to avoid an Excel Sheet that is empty or with different name convention

    Hello all, I have to import a number of excel spreadsheets. I'm using the classic Foreach Loop inside another Foreach loop approach. The outside loop (Foreach File Enumerator) cycles through the Excel files, while the inside loop (Foreach ADO.NET Schema Rowset Enumerator - ExcelSchema - Tables)...
  5. 4N6Mstr

    PivotTable woes: Part deux...

    Hello and a great Friday to you all. I was asked (ordered, really), to create a Main form with two subforms. SubForm A opens as a pivottable that shows PartNo v. Stores (on the cross point, Sales $ for each store where that PartNo was sold). SubForm B should show the details (all other fields)...
  6. 4N6Mstr

    Pivot Form: do they fire events?

    I was looking in the wrong places. There are specific events for that, such as On Data Chnage and On Selection Change. Part of the problems is solved. Any help is always apreciated! Thx, 4N6MSTR ______________________________________________ If you don't know where you are going It does not...
  7. 4N6Mstr

    Pivot Form: do they fire events?

    Hello all, I looked and looked around and did not find an answer to this (simple?) question: Do Pivot forms have events that can be used while navigating the records? I mean, current, enter / got focus / lost focus / Dbl Click, etc. If not (it seems that is the case), any workaround? I was...
  8. 4N6Mstr

    Struggling to update linked tables location in Access 2007 using ADO

    I found the solution for my quest: http://support.microsoft.com/kb/291264. It works really well for what I need (runtime installation, front-end installed in a "user-chosen" folder, back-end inside a subfolder), although it is not a "for-any-situation" type of solution. Any help is always...
  9. 4N6Mstr

    Problem with conditional formattingand Tab Ctrl

    Joel009, I agree with MajP about a somewhat strage design (and having been helped by MajP manytimes myself, I would tell you to heed his advice). It seems to me that the flickering has a great chance of beeing the result of cross-refreshing your forms, like a circular reference on an Excel...
  10. 4N6Mstr

    Strange Cursor Behavior While In Module

    randy700, I am not sure if that is the case with you, but there is an old bug in Windows that causes the "selection flag" to be "locked on" when you start moving from application to application (or window to window inside the same application). I was never able to identify what causes the...
  11. 4N6Mstr

    Tabular form

    Konar30, Are you trying to use the button to delete the record straignt from your "display only" form? You might have the edit / delete / add records properties set to NO, which would avoid changes to you recordset, thus the error generated when you try to delete the record. You'd have to flip...
  12. 4N6Mstr

    Struggling to update linked tables location in Access 2007 using ADO

    Hello all, I have a single user db in MS Access - split – front end and back end both 2007 accdb - installation using the Access packaging runtime, back end (and the subfolder where it "sits") added as a "extra" file during packaging, as per Microsoft instructions. I will be sending this to...
  13. 4N6Mstr

    ComboBox: NotInList event "firing" twice...

    Lameid, Thank you for your post. I did find my errors: 1) I was trying to move the focus away from the combo box before the Notinlist event was complete. Even though I was setting the correct Response (acDayaErrAdded) The combo box "records" wete not updayed at that point, which generated...
  14. 4N6Mstr

    ComboBox: NotInList event "firing" twice...

    Hello, all! On an Access 2007 db (accdb) I have a split form (popup = no, modal = yes) that shows only the header and the datasheet portion (detail.visible = no). On the header portion, I have an unbound combobox, a textbox and two buttons 1) Tag and 2) Cancel. The intended functionality is...
  15. 4N6Mstr

    Underlaying recordset does not update: What am I doing wrong?

    Great! I knew it was something silly. The old "use the correct wildcard" trick. Thx a bunch, PHV! Any help is always apreciated! Thx, 4N6MSTR ______________________________________________ If you don't know where you are going It does not matter how fast you are You will never get there
  16. 4N6Mstr

    Underlaying recordset does not update: What am I doing wrong?

    Hello all! The code presented below intends to split a table containing charges and payments (Imports Table). Charge records should be copied to the Charges Table and payment records to the Payments Table. A natural primary key does not exist, so its being created based on the concatenation of...
  17. 4N6Mstr

    Open form and show blank fields but not using NewRecord.

    Interesting. I'll check it out. Thx, again, MajP. Any help is always apreciated! Thx, 4N6MSTR ______________________________________________ If you don't know where you are going It does not matter how fast you are You will never get there
  18. 4N6Mstr

    Open form and show blank fields but not using NewRecord.

    MajP, All valid points. However, this is a database that I'm just refining the user interface and doing some fine tuning on the audit function it already has. The "lost" primary keys were getting in the way. There are certainly better ways to audit, but that problem will have to wait for the...
  19. 4N6Mstr

    Open form and show blank fields but not using NewRecord.

    Joe, The false-new-record does not leave a trace, thus the missing primary-key non-existance is not documented. A deletd record can me made to leave a trace (who, when, why). In critical databases, that need to be audit and scrutinized for unexpected ocurrences, that can be a fundamental...
  20. 4N6Mstr

    Combo Box Requery

    Ellie, That is exactly what the logic that I proposed does. When the combo box is made available for the user, the list of awards (by type) is updated, thus only available awards are listed. When the user selects the award, in the after update event code, you have to query the awards lists...

Part and Inventory Search

Back
Top