Search results

Hi guys, I have a table of transactions (close to 1m records) from which I want to query totals by currency and direction (ins and outs) and then also show the proportion of the overall total for each currency. All amounts are absolute (i.e. ins and outs both represented by positive numbers)...

What is rsImage? Your naming convention suggests it might be a recordset yet you try to set it to a single value (the value of the [Images] field in the current record of the rsQuery recordset)? How have you declared it? And how is it meant to have a field called [FileData] when it has been set...

I understand that jdraw - which is why I'm puzzled - the records (or Excel rows) in question had identical values for all fields (or cells), including the one date (or datetime) field / cell I can't post the actual sample as it contains sensitive information. And little point in me posting a...

Thanks CJ 3rd Party not gonna work for me unfortunately - I'm lucky the company allows me to develop my own stuff, let alone use somebody else's! But I'll see if a manual resize is possible (you are correct; I do have code for positioning and resizing that may well require tweaking - I'm...

jdraw, Apologies for any lack of clarity - but you seem to have it pretty much nailed! You are correct in that technically there is no reason to purge the staging table and then recreate it each time. However, I have multiple import processes from multiple sources which utilise some modular...

Hey burrina, Sorry to resurrect an old thread but I've tried using the above to no avail? The event fires but the value for KeyCode which is passed when I hit the Alt key is 18 vbKeyReturn enumerates to 13 So resetting the KeyCode never occurs and the subform still scrolls back to the...

Hi guys, I'm in the middle of deploying a database for our department. Most of the users use a single widescreen monitor but a (small number) opt to use a dual 'standard' monitor setup. I've already incorporated some functionality to resize the form windows and apply / remove scrollbars...

I'm only recreating the staging table - not the main table. I create a linked file to a spreadsheet and SELECT INTO a temporary staging table. I then run a couple of additional queries between the staging table and some static tables so that I can keep the data normalised. Then, I run a...

No the entire table gets dropped completely and is created anew with each file

Hmmm, I could... But the staging table is temporary and gets dumped after each import has been completed. I use a simple SELECT INTO statement to generate the table from scratch. Might have difficulties applying a composite index to the table after records (which may or may not comply with the...

D'uhhh - sorry, yes, I meant double! Or rather, I meant the 'double' value was effectively an integer. Not getting into the semantics - we both know what we mean! :rolleyes: Yeah I don't think the DISTINCT would have a problem with the OR either? Which is why I found it odd in the first place...

Thanks namliam! I see where you're going - but that's not it... Between files, there is a separate duplication removal process. Any records which are already present in the main table are removed from the staging table up front. So the staging table only ever contains "brand new" records for...

Hi guys, I have a database with an import process which normalises incoming data and appends to various tables. No issues with that. I also have a function within that process which counts the number of new entries for a summary popup when the process has completed. This works by querying...

Yeah it's fun alright! Best o' luck!

I presume that Do While loop is within a With / End With block? With Sess0.Screen Do While .GetDisplayText(24, 7, 1) <> "E" ... Loop End With If so, try .Area instead? .Area takes 4 arguments, namely 2 sets of X and Y co-ordinates on the screen defining the area of the...

Hello there - no problem! I believe it was as I originally suspected, that being the conflict between the 32-bit application running in a 64-bit O/S, and subsequent issues with the registry keys The way I got around it was to use Attachmate Reflection rather than Attachmate EXTRA! - I...

Have a look at this - by no means a finished article but something to get you started Have added a table called tblDistributions - just two fields : NCR and Employee Have also added a listbox at the bottom of your form which shows the names and e-mail addresses for the distribution list...

Have you tried adding multiple addresses to the textbox separated by semi-colons?... It's not elegant but it should 'work'? If you want to go the more efficient route - how would I identify which e-mail addresses to be included from the Employees table?

You have a textbox ("E-mail Address") which is bound to a field ([E-mail Address]) in a table ("INPUT TABLE2") (NB Would strongly advise against using the same names for form controls and field names, as well as the previously mentioned use of non-alphanumeric characters (";", "/", ","...) and...

You've missed out on the object between xlApp (the Excel Application) and the worksheet - namely, the workbook : Dim xlApp As Object ' Excel Application Dim xlWbk As Object ' Excel Workbook Dim xlSht As Object ' Excel Worksheet Set xlApp = CreateObject("Excel.Application") With...