Search results for query: *

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 -...

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)...

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)...

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...

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...

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...

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...

Hello all and Happy Holidays! This is more a pet peeve of mine than a problem that does not have a workaround (or many). The standard situation is this: main form – tab control with sub forms scenario. No creation of records / no deletion, just fields’ update available. After the user opens up...

Hello Everybody. I think is still in time to wish Happy New Year to you all. Here is my quest. In an old database, I have four tables for which I have to create a report (Crystal Reports). The table structure is not the same but the common point is each table has more than 250 fields, most of...

Hello all! Happy Holidays! This is the situation: In an access database, Managers (high-level users) select products and subparts of that product during the "configuration" phase. This is done for each different project. In other words, the final selection of Products and subparts is different...

Hello, all. A long story short, to try to keep it making sense. I have a situation in a form that I could not find a solution (or actually understand why is not working). Due to reasons that would take too long to explain, I have a kind of different Main Form – Subforms structure (one of the...

Hello all, In MS Access, I can use OR inside a SELECT clause to show if one or more values in a serie of boolean fields is true. Something like SELECT Table_I.Field_A, Table_I.Field_B, [Table_I.Field_C] OR [Table_I.Field_D] OR [Table_I.Field_E] AS MyBooleanResult FROM Table_I What would be...

Hello all, I have (what i hope to be) a simple question. I received two tables from the same system that were used in different areas. These systems were not connected so, along the time, the tables definitions were independently changed. In simple words, Table_I has fields A, B, C, D and E...

Hello all, I'm looking for functions / explanations / details for each one of the components of a Word document, which (as far as i know) are: 1. Data 2. 1Table 3. CompObj 4. WordDocument 5. SummaryInformation 6. DocumentSummaryInformation

Hello all! Any of you know of an application that would give me a hash (MD5 / SHA) of a floppy disk? It’s easy to get hash for individual files but how do you get the hash for the entire floppy? Thank you in advance for your help. Thx! BTW, if this is not the correct forum for this...