Search:

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

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    175

    I continued to play with it and was able to get...

    I continued to play with it and was able to get this code to work.

    (CASE WHEN ((InStr(CBP,'~',2,2))-(InStr(CBP,'~',2)))>0
    THEN SUBSTR(CBP, (InStr(CBP, '~', 2))+1, ( (InStr(CBP,...
  2. Replies
    2
    Views
    175

    Pass-Through Query in Access

    I have an expression written in Access
    Mid([CBP], (InStr(5,[CBP],"~")+1),...
  3. Replies
    2
    Views
    394

    That seems to be working. THANK YOU!

    That seems to be working.

    THANK YOU!
  4. Replies
    2
    Views
    394

    Excel Hyperlink Using MS Access VBA Code

    What I am trying to do is create a Hyperlink on a sheet in a workbook that I am creating using MS Access and VBA code.

    I have the "Return to Contents" working on the individual tabs in the...
  5. Thread: Converting DOB

    by Aheron
    Replies
    3
    Views
    455

    Try this IIF(IS NULL([DOB], "", Mid([DOB],5,2)...

    Try this

    IIF(IS NULL([DOB], "", Mid([DOB],5,2) & "/" & Right([DOB],2) & "/" & Left([DOB],4))
  6. Replies
    1
    Views
    301

    Fields on a report

    I have a field on a report that when it growns is pushing a single line to the top of the next page. Is there a way to force it to put it all on the one page or force the entire content to go to the...
  7. Replies
    3
    Views
    1,472

    ODBC table-size limit

    Is there a limit to the size of a table when linking Access 2010 to Oracle using the Microsoft ODBC Driver for Oracle OR the Oracle 10G ODBC driver?


    Thanks
  8. Replies
    6
    Views
    1,033

    Shareing the workbook so far is working...

    Shareing the workbook so far is working graet.Thanks to all for your help.
  9. Replies
    6
    Views
    1,033

    Multi Users In a Workbook

    Is there a way for a single workbook to be open AND editable by multiple users?The workbook we have is on a network drive. When one user opens the workbook, any other user can open it, but gets the...
  10. Replies
    3
    Views
    712

    Named Range worked. For some reason Access...

    Named Range worked. For some reason Access converter the following from "'Region 33'" & "!A1:T900" to 'Region 33'$A1:T900. Of course Excel could not find that range.

    But named rangeds worked like...
  11. Replies
    3
    Views
    712

    I will try this and see how it goes. Thanks...

    I will try this and see how it goes.

    Thanks Wendell.
  12. Replies
    3
    Views
    712

    Import Excel Data

    I am having issues trying to find the correct syntax to import data from Excel. I have the TrasnferSpreadsheet down fine. What I would like to do is give the statement a data range in the workbook. ...
  13. Replies
    15
    Views
    13,621

    This is GREAT. Thank for your help.

    This is GREAT. Thank for your help.
  14. Replies
    15
    Views
    13,621

    How to find Access version in code

    Is there a way to use VBA code to query Access for the version?

    I would like to create an If statement that will do one thing for Access 2010 and a different thing for Acess 2003.


    Thank for...
  15. Replies
    9
    Views
    18,331

    Thanks to all for your help

    Thanks to all for your help
  16. Replies
    9
    Views
    18,331

    Can you help with the syntax for using the PDF. I...

    Can you help with the syntax for using the PDF. I had come to the conclusion that was the way to go, just having a hard time figuring out the correct syntax.


    Thanks for your help.
  17. Replies
    9
    Views
    18,331

    Using Snapshot format in Access 2010

    Is there a way in Access 2010 to use the Snapshot format in the following statement?

    DoCmd.SendObject acSendReport, stDocName, "Snapshot Format", ...

    I have found that in Access 2003 and Access...
  18. Thread: .net

    by Aheron
    Replies
    3
    Views
    1,628

    Exactly what I was looking for. THANK YOU

    Exactly what I was looking for. THANK YOU
  19. Thread: .net

    by Aheron
    Replies
    3
    Views
    1,628

    .net

    Is there a free version or maybe a student version of the .NET suite that I coould use to lean with. I have done some VB and VBA prgramming, but would like to do some learning and testing in .NET.
    ...
  20. If you have both version installed on the...

    If you have both version installed on the machine, you should be able to point your 2003 database back to the correct library. If you open the code window, look in the Tools menu for References...
    ...
  21. Replies
    1
    Views
    1,147

    Reading File Names Into a Table

    Is there a way to read files names from a given directory and all it's sub directories into a table using VBA code.

    I have some code that reads a single directory and dumps the files to a table,...
  22. Thread: Parse Field SQL

    by Aheron
    Replies
    2
    Views
    1,041

    Try something like mid([Description], instr(1,...

    Try something like mid([Description], instr(1, [Description], "(" ) +1, 10) This assumes the Invoice number is always ten characters.
  23. Replies
    15
    Views
    1,920

    Can you post the results of the Debug.Print...

    Can you post the results of the Debug.Print statement?
  24. Replies
    15
    Views
    1,920

    What you are looking for the Debug.Print...

    What you are looking for the Debug.Print statement to do is show you the full SQL statement before Access trys to produce the recordset. This will allow you to double check field and table names....
  25. Replies
    2
    Views
    1,909

    The compact and repair does run correctly in...

    The compact and repair does run correctly in 2003. The db ends up about 175 meg. I did run the compact on the db in 2010 and it took the database from 325 meg down to about 225 meg, so it seem to be...
Results 1 to 25 of 385
Page 1 of 16 1 2 3 4