Recent content by Newie

Hi jdraw, Is that it/all !!!!!! I was having so much trouble that I expected the answer to be a very long winded/complex one ....? Your reply is very much appreciated........thank you ! Steve

Hi, Hope some-one can help as this is driving me crazy ! I have a Table with a Field set to Number, Single, Fixed, 2 Decimal points in which I enter Hours (ie 11.25) then at some point I want to extract those new entries to create a Text file transfer. I have a Macro which extracts those new...

Hi both, Thanks for your responses, I'm not good at VBA (in fact I'm useless having been self-taught using only Queries) so have created a Macro with a series of of Update queries geared to each column, long-winded I know but once set up, does the job very quickly, just wondered whether there...

Hi Megatronixs, Not sure exactly what you are trying to do ? If I haven't got it wrong?....... it seems you could: Run an Update query to update the Checkbox to True/Yes where it is False/No and where the monetary field <>0. But here you will have trouble distinguishing between those you've...

Hi, Is there a clever person who knows whether I can "uncross" the data on a Crosstab ? I import an Excel sheet into Access as a Table but the data appears in a Crosstab format, as I want to append this data to another Table it obviously needs to be in single line format. Does anyone know if...

Morning ! 'Fraid I couldn't open your File (didn't like the accdb extension) but let's give it another bash! What you want sounds like it should be reasonably easy but as explained before, what I'm having trouble with is understanding exactly what date you want to show because you mention...

I'm obviously missing something here. If you set the Default Value of the "Date File Run" field to Date(), that will automatically enter the date that you generate each file on (whether importing directly to your main Table or appending the new data from your Temporary Table to your Main Table)...

I'm new(ish) to Access too, so this may seem long-winded but the only way I can think of the answer is to set up a Command button to a Macro which imports your data (or Copy data, Run Command, Paste Append) then a second step in the Macro to run an Update Query setting "Update to" to [Enter...

Hi Rain, That's great ! There's enough for me to see how it works in the Query formula, that was the initial stage which I just couldn't get past...... but you've cracked it! I've just been spending the past couple of hours expanding data, tweaking and re-naming Fields to suit my data (not...

Hi Rain, Thanks for the tips within your Naming Conventions attachment. Very informative & very useful......I shall be following it's recommendations in future ! Best, Newie

Hi Rain ! Thanks for your speedy reply although not sure I can resolve this as I have Access 2002 (will attempt to attach sample anyway). I had already come across that link example before I posted and tried to edit the formula & Fields with no luck. Also realised after I logged out that I...

Hi, I had a quick look to see if this was covered but failed, don't know if anyone can help? I'd like to know if it's possible to find the number of days difference between the events in the following Query example ie: between 03/09/2012 and 07/10/2012...

Thanks for the tips Trevor, haven't tried them yet but good to know I still have some options to try and I will keep trying if these don't succeed !? Much appreciated........... Newie

WOW !!!...that response was quick (another applications forum usually takes days !!!) Thank you Trevor, I have version 2002 which I assumed is separate from the Office Home & Student ? I don't actually have an Office Button but I've checked the "All Programs" option and although Microsoft...

Hello...... Before I upgraded to Windows 7, I was able to download Access db samples from a website, I found them very useful. Since upgrading to W7, I get a message along the lines of "Access cannot open this file - This file is located outside your Intranet or an Untrusted Site - Microsoft...