Recent content by clive2002

  1. C

    Pop Up Box

    You can have a form on a timer, if you just want to splash a message up which then closes
  2. C

    Design of KPI

    Sorry is this an excel question or are you after general advice on setting or measuring a KPI.
  3. C

    Importing Complicated Excel file to access table

    i would suggest you just tidy the data before importing into Access. You can use formulas to build the broken description back up into one cell, eg =F1&F2&F3 then filter out the duplicate records. Or if its going to be a repeated task, just create a template you can past the output into that...
  4. C

    Setting cell format with VBA

    I don't think it will be possible to do this on the fly, eg replace a mr with Mr as its typed by the user, certainly not using validation. Choices would be. 1 - Add mr to validation then either live with have both mr and Mr or loop through after entry and replace mr with Mr or triger an on...
  5. C

    Enter record if doesn't exist

    I Presume the form being used for entry is not bound to either table. If you need to do unbound then: I would suggest you create a temp table and use an append query to add to the detail table if the record does not already exist, then run an update query to update the visits table with the...
  6. C

    Test if Port Number is open in VBA

    Hi, I have an application that requires a port number to be open to function. How do i test in VBA if a user has opened the the required port number before i run the main piece of code in my application. eg Is port number 1234 open? If true then, else exit. Thanks Clive
  7. C

    copy recordset to table

    I'm running a stored procedure on a remote sql server to populate an ADO recordset in access VBA, how do copy that recordset to a table without looping through the recordset. In excel i could just use copyfromrecordset to paste into a worksheet, but i can't work out how to do something this...
  8. C

    Multiple Langauge in a table including chinese?

    Hi, Hope someone has tried this before. I want to set up a serious of forms to ask the user questions and record answers using buttons in forms. I have a table of questions, each question will be read from the table and the answer recorded next to it. My issue is that i will be using several...
  9. C

    backend and links questions

    Hi Guys, Hope someone can help with the below. I have a split database, with the backend saved on a network. 1) How can i retrieve the name and location of the backend in VBA? 2) Is it possible to change the linked location for each table via VBA, say for example if i wanted to switch the...
  10. C

    Store a variable once form is closed

    Thanks, I'll try both suggestions and see which works best for me.
  11. C

    Store a variable once form is closed

    I'm trying to set a variable in a form and store the value for use in other forms even after the initial form is closed. I don't wont to write to a table and i think this can be achieved using a static declaration in a class module, but am unsure how to do this? Any help greatfully recieved.
  12. C

    Lookup between Values no VBA

    Hi, Hope someone can assist with this problem, which i need to solve without using VBA. I have the below table of events, From - to dates and event description. From To Event 07/01/2012 09/01/2012 Contract1 11/01/2012 14/01/2012 Contract2 I also have a straight...
  13. C

    Problem with IF and

    Are you sure you want .caption can give the value of the ncount variable and Me.userlookup.Caption
  14. C

    SumProduct Expert Needed

    thanks for this guys, sorry for delay in response, been away.
  15. C

    SumProduct Expert Needed

    I am trying to use a SumProduct Formula with one criteria being an array and it is working in part, but when i try and expand the criteria array it only works on the basic formula not the more complicated one. Data is Structured as below Column B Numbers from 1 to 10 repeated many times Column...
See more
Top Bottom