Recent content by smudger70uk

  1. S

    Displaying a field from an unbound table on my form

    Hi, I have a number of tables that hold datasets that are created either daily or weekly to provide data for employees to perform equipment checks and record the status of these. These datasets are created individually via a central form (form button for each runs append queries to create the...
  2. S

    Copying attachments from one table to another.

    Hi Cyberman, I stumbled across your demo database as part of my search to try and find a quicker way to move 800 records with 1+ attachments from one web access database to another. I've taken a copy and given it a go but without success, now it might be that I'm just being stupid but...
  3. S

    Web Access Form not allowing negative entries in a currency field

    Hi, hoping someone can explain this one for. I have developed and published a Web Access Database to SharePoint and it has been in use for 2 or 3 months without any issues until today when someone needed to enter a negative value in an invoice currency field to reflect a credit note and it...
  4. S

    Using multiple RunSQL statements

    I have a number of fields related to interview questions that are all populated through option boxes (1=Yes,2=No,3=Unknown). The boxes all start with a null value and as questions are answered through the option boxes they update accordingly. However, the questions are categorised so if there is...
  5. S

    Using multiple RunSQL statements

    Should have made that clearer, not looking for an Else If as I believe that will again stop as soon as it finds a box that fits the first SQL update query. I need something that says: If [field] is null then update to [No] then go to look at the next field and do the same BUT at the moment if...
  6. S

    Using multiple RunSQL statements

    I have a number of option boxes on a screen, if there are boxes that no option has been selected I want them to be auto populated to a No rather than having to manually tick all the No options. Currently the code works if all of the boxes that I'm referencing in my code are null but as soon as...
  7. S

    Using multiple RunSQL statements

    Hi, I'm trying to run multiple sql statements behind a form button to update a number of fields at once as I didn't want to have to create individual queries and stick them in a macro. The code runs fine as long as the fileds currently contain a null value but the sequence stops as soon as it...
See more
Top Bottom