Search:

Type: Posts; User: jex57; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    662

    Re: Derive relationships based on data

    This works if you are looking for table relationships. I am looking for a way to determine relationships from the date.

    For example

    SystemTable_data
    SystemA
    SystemB
    SystemC
    ...
  2. Replies
    2
    Views
    662

    Derive relationships based on data

    Hi all,

    I have a database - about databases - so what it does is stores all information about the various databases that we run, table names, columns that are linked column sizes, descriptions...
  3. Replies
    4
    Views
    864

    Re: MS access - generate query visually

    Reason for try in to see if I can emulate it is because I need to create something but in a format that can be better deployed. Db is SQL, so looking to prototype something similar to the ms access...
  4. Replies
    4
    Views
    864

    MS access - generate query visually

    Hi all,
    Has anyone, or does anyone know of a access db, whereby the users through the guid can select the tables that they want, and a query can be built accordingly. I am trying to create an...
  5. Replies
    3
    Views
    170

    Re: While Wend Statement

    Thanks - variable names are correct - just the way I coded it because of number of counts that I need (column referring to what I am counting and not ROW Column in excel

    Have tried brackets and...
  6. Replies
    3
    Views
    170

    While Wend Statement

    Hi,
    Can one use AND in a while wend statement:



    When I use this statement, it does not read the AND statement, so even though there is data in my last column it exits the loops.
    Not too...
  7. Copy only certain values from 1 sheet to another

    Hi all,
    I have written some VBA to get the correct data values that I need from a sheet called DATA
    I now want to do the following:

    1 - Write the values (table name, comment, column) to a new...
  8. Re: Find multiple values across multiple worksheets

    So I have got some code, but now my loops are incorrect. Any ideas on how to fix this?

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden;...
  9. Re: Find multiple values across multiple worksheets

    Hi,
    Thank you for your response. Do you perhaps know how I can do it in vba?
  10. Find multiple values across multiple worksheets

    <tbody>
    Test1

    Test2

    Test3

    Test4

    Test4
  11. Replies
    6
    Views
    370

    Re: Code does not create PDF

    Hi,
    Have tried but my permissions do not allow me to upload attachments.
  12. Replies
    6
    Views
    370

    Re: Code does not create PDF

    Hi,
    FNAME = C:\Users\Documents\STATEMENT_Visser_E_040418.pdf

    All the code executes, the save as dialog appears, the file looks like it is being created, but when you go to the folder there is...
  13. Replies
    6
    Views
    370

    Code does not create PDF

    Hi all,

    I have the following function code (which as it is works):


    Function RDB_Create_PDF(Optional Source As Object, Optional FixedFilePathName As String, _
    ...
  14. referencing a control on a subform list in a navigation form

    hi All,
    I have a navigation for 01 Main

    On the navigation form, I have a subform FrmSocialGraph

    On the FrmSocialGraph I have a Subform FrmSGUsgage - which has a list box on it. From the...
  15. Replies
    3
    Views
    286

    Re: Dlookup returning incorrect results

    Hi
    What I am supposed to be doing is doing the dlookup on the OLD value and not the new value.

    I dont want the new value.
    I have a number of business terms for example
    A Title
    B Title Code
    C...
  16. Replies
    3
    Views
    286

    Dlookup returning incorrect results

    Hi all,
    I have a form that before updating, I want to store the old value of one particular field. The original field is an integer, and I want to store the text description.

    My code looks like...
  17. Re: Error you tried to execute a query that does not include the specified expression

    Hi,

    I managed to come right - what I did was:


    newSQL1 = "UPDATE TblTempStats " _
    & "SET TblTempStats.EmptyFields =" _
    & "DSum( " _
    & " 'IIf([fieldname] Is...
  18. Error you tried to execute a query that does not include the specified expression

    Hi,
    Keep on getting error

    "you tried to execute a query that does not include the specified expression"

    My SQL looks as follows:

    UPDATE TblField LEFT JOIN TblTempStats ON...
  19. Thread: Queries in VBA

    by jex57
    Replies
    2
    Views
    239

    Queries in VBA

    Hi all,

    In desperate need of assistance.

    I am currently building a statistical view of data - % data missing, % complete etc.

    I am the writing these values into a stats table so that one...
  20. Replies
    3
    Views
    146

    Re: micorosoft Object library 14 / 15

    Thanks for the help
  21. Replies
    3
    Views
    146

    microsoft Object library 14 / 15

    Hi all,
    Please can someone assist.
    I have two word / excel applications (word calls excel), one of the apps works, the other does not.

    I traced it down to the object references

    One has...
  22. Re: IF, sumif, and sumifs - how to calculate based on column criteria

    Thank you - works.....
  23. Re: IF, sumif, and sumifs - how to calculate based on column criteria

    http://s000.tinyupload.com/index.php?file_id=00113861428911117061
    Table looks something like this:
    There are a number of tests that a child will write
    In the second row:
    This is the total that...
  24. Re: IF, sumif, and sumifs - how to calculate based on column criteria

    Problem is that is going down and not row totals and no x. I don't know how to do a screen shot to show but if you put the figures I posted in the message it might make more sense. Will try post a...
  25. IF, sumif, and sumifs - how to calculate based on column criteria

    Hi All,

    Am wondering if someone can help me with a formula.

    My data is more in columns than rows, so for example

    Count1 Count 2 Count 3 ...
Results 1 to 25 of 50
Page 1 of 2 1 2