Search results

  1. M

    SQL, ODBC and Win7

    - See solution at the bottom Hi all, We have an Access based system that connects to SQL Server 2000 through ODBC. Most of the client PCs use XP, and this all works fine. We recently, however, bought a couple of Win7 PCs and I'm having more than a little trouble setting up the DSN for the...
  2. M

    'Merge with MS Word' button

    Hi all, I have a system, which stores customer address/contact information, which I would like to use to bulk email customers. The only issue I'm having at the moment, is that in order to export the information to word for merging I have to right click on the table and select: Export > Merge it...
  3. M

    SQL UPDATE DD/MM/YYYY query

    Hey again, I'm having issue with an unbound textbox, which sits in an unbound form. Upon clicking the 'Save & Exit' button it is supposed to update the date field in a table (tEvents) with the SQL UPDATE query: stSQL1 = "UPDATE tEvents SET tEvents.Username = " & "'" & Me.txtUsername & "'" & "...
  4. M

    SQL Upsize affecting date fields

    Hi all, Not sure this is in the correct area, as the issue covers a multitude of areas, but here goes: I have an issue that has started occurring after I upsized my system to run on an SQL backend. I have a form (fMainMenu) which has a textbox (txtDate). The forms also contains seven...
  5. M

    Dynamically calculating a check digit.

    Hi all. I'm looking for some help automating the process of converting ISBN10s* to ISBN13s in a book database that I'm currently working on. ISBN13s are pretty much the same as an ISBN10, but are prefaced with 978 and, here's the rub, the last digit is a check digit that is dynamically...
  6. M

    Referencing the field ID in a multi-selection list box

    Hi all. I'm having a little issue with a multi-selection list box in a form which references a table (tCustomers) and determines what values are to be copied to a temporary table upon the clicking of a button. I have all the code up and running, and all seems good. However a little testing...
  7. M

    Clearing a list selection and value stored against it

    Hi all (again), I have another small issue that, hopefully, should be as simple to resolve as the last one. I have a form which contains a list box (list20), and two buttons. The first button (add/edit), when clicked, opens a form which either displays the data for the item selected in the...
  8. M

    Checking that a record exists in a different table

    Hi, I hope you might be able to help me with a little issue I’m having with an order processing system I’m trying to put together Firstly a little info about what I’m trying to achieve: I have a form which lists products within an order, and I’m currently trying to write some code that...
Back
Top Bottom