Recent content by rincewind_wizzard

  1. R

    vba sql update statement - can't get the format() syntax right

    Wonderful. Works fine. I thought I'd tried the extra quotes, must be imagining it. Thanks
  2. R

    vba sql update statement - can't get the format() syntax right

    Hi all, I'm trying to run the following in a module, but it doesn't like the 0000000 (I get expected: end of statement). The employee number field is text and I need to pad it with leading zeros. 'Tidy up the pay number in the tax and NI table - format to 7 places strsql = "UPDATE...
  3. R

    Displaying a signature on a report

    Hi I have an OLEObject (Bound Object Frame) on the report with it's record source set to the OLEObject field in the data source which contains a jpg of the signature, which I want to show on the report. Unfortunately, it only seems to want to display the icon with the file name in it. I have...
  4. R

    Access 2013 and Azure/Sharepoint

    Hi all, I have an Access 2003 database that has been used by a client for some years now, and they have asked me to update it to a newer version of Access. they are now using MS Azure for cloud hosting of the majority of their files, and have asked me if it's possible to move the database to...
  5. R

    Costing file issue - running out of time

    Well, my thanks to all on here who contributed to my thought processes - went to bed last night mulling over the suggestions, which was probably not a good thing as I laid awake. Anyways, I got there eventually using two Sum queries, one for credits and one for debits, then finding the...
  6. R

    Costing file issue - running out of time

    isladogs that sounds like a really good start, I'll work on that tomorrow first thing. The data comes from the payroll system and it's a one off issue (thankfully). The Personnel Number is a text field because many of them start with a zero, so I made it a text field. It wasn't until I...
  7. R

    Costing file issue - running out of time

    Hi both, it's an access table but I put it in excel so I could highlight the correct entries. there's over 3,800 rows in this data, so manual isn't really possible. It's the matching pairs that need deleting - they are the adjustments for the previous month. Trouble is, in many cases the...
  8. R

    Costing file issue - running out of time

    Hi all, I have an payroll general ledger file which has employee numbers and credits and debits. Due to system issues, there have been a lot (thousands) of extra rows written to the file which Finance do not want to load in to their systems. I'm trying to think of a way of deleting the unwanted...
  9. R

    Checking to see that all fields on a form have a value

    Thanks CJ_London - that's exactly what I had in mind. I'm currently near Liverpool St Station btw - in London too.
  10. R

    Checking to see that all fields on a form have a value

    Hi, I need users to enter values in about 8 unbound fields, then they click a button to run a routine. I know I can check that there are values in the unbound fields by going down the if is null xx or if is null yy etc. etc. route but I know there is a way of cycling through all the unbound...
  11. R

    Rounding issue

    I realised it was only a fix when I totalled up the split amounts and compared to the original total. I've now mapped out a way of doing it using queries. Sum the total of the split values, compare that to the original total, find the difference and use the difference to update one of the...
  12. R

    Rounding issue

    CJ London The round function seems to have done the trick - thank you
  13. R

    Rounding issue

    I can see your thinking, but that won't work in a query (will it?)
Top Bottom