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...
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...
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)...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.