Search:

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

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    433

    Query Design in MS Access 2013

    Why when I right click and select Design View for a query is it opening in the SQL View rather than the Design View?
    I can then right click the query name tab, select Design View and it will display...
  2. Replies
    2
    Views
    483

    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,...
  3. Replies
    2
    Views
    483

    Pass-Through Query in Access

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

    That seems to be working. THANK YOU!

    That seems to be working.

    THANK YOU!
  5. Replies
    2
    Views
    1,652

    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...
  6. Thread: Converting DOB

    by Aheron
    Replies
    3
    Views
    823

    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))
  7. Replies
    1
    Views
    467

    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...
  8. Replies
    3
    Views
    2,442

    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
  9. Replies
    6
    Views
    1,384

    Shareing the workbook so far is working...

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

    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...
  11. Replies
    3
    Views
    881

    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...
  12. Replies
    3
    Views
    881

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

    I will try this and see how it goes.

    Thanks Wendell.
  13. Replies
    3
    Views
    881

    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. ...
  14. Replies
    15
    Views
    22,461

    This is GREAT. Thank for your help.

    This is GREAT. Thank for your help.
  15. Replies
    15
    Views
    22,461

    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...
  16. Replies
    9
    Views
    23,203

    Thanks to all for your help

    Thanks to all for your help
  17. Replies
    9
    Views
    23,203

    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.
  18. Replies
    9
    Views
    23,203

    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...
  19. Thread: .net

    by Aheron
    Replies
    3
    Views
    1,927

    Exactly what I was looking for. THANK YOU

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

    by Aheron
    Replies
    3
    Views
    1,927

    .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.
    ...
  21. 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...
    ...
  22. Replies
    1
    Views
    1,325

    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,...
  23. Thread: Parse Field SQL

    by Aheron
    Replies
    2
    Views
    1,262

    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.
  24. Replies
    15
    Views
    2,772

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

    Can you post the results of the Debug.Print statement?
  25. Replies
    15
    Views
    2,772

    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....
Results 1 to 25 of 386
Page 1 of 16 1 2 3 4