Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. R

    Rounding issue

    Hi all, doing some work for the Finance team for their general ledger accounting. I have the following scenario:Salary of £1315.33 needs to be split across 3 account codes, each of which has a different percentage: 60% = 789.20 29% = 381.45 11% = 144.69 So, I've built a query to do this...
  7. R

    Returning query field names in a combo box

    Hi all, I'm not even sure this is possible. I have Combo Box 1 which selects from a list of queries in the database Is it possible, in the next Combo box, to return a list of the field names in the query selected in Combo Box 1? Cheers for any help on this. Paul
  8. R

    sql statement in VBA - help!

    HI all, I'm trying to assign a sequence number to certain rows in a table - only those where the Migrate? field a mapping table is marked as True. Can't get it to work. I get 'Invalid use of property' on the strsql at the start of the sql statement: sub testit() 'Now add the sequence number...
  9. R

    docmd.runsql problem

    Hi all, first post so be kind :-) I am looping through a series of tables deleting the data in them. That's the easy part and works fine. Now the bit I'm struggling with. Each and every table has a field called ID. If the value in this field is 1, I don't want those rows to be deleted...
Top Bottom