Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.29 seconds.

  1. Call Eval(strAction) Thanks to theDBguy & ...

    Call Eval(strAction)

    Thanks to theDBguy &

    HansV Eileen's Lounge
  2. Some further Information: Has anyone moved...

    Some further Information:

    Has anyone moved prior versions of Access custom menus to Access 2013?

    Discontinued features and modified functionality in Access 2013
    ...
  3. How to Call a Function From a Variable?

    I have the following in Form and it works OK

    Call RunForm("frmProviderLookup", "", "Edit", "", "", "Normal", "Normal")

    I want to build a combo box with several different RunForm variations as...
  4. You may also want to check out Windows Virtual...

    You may also want to check out Windows Virtual PC, Windows XP Mode

    When you configure and start Windows XP Mode it turns you session into am XP desktop where you can install and run you XP apps...
  5. Wow, what a needle in the haystack, thank you both

    Wow, what a needle in the haystack, thank you both
  6. How to Close a Batch file StartBP15.bat

    Running Windows 7

    I have the following batch file that I run from the desktop and it works OK

    The problem I'm having is that is leaving two tasks open at the bottom of the screen, 1 for the...
  7. Custom Menu Bar won't Display in Access 2013

    I have a program.mdb with a customized menu bar

    When I open program.mdb in 2007 & 2010 the ribbon is disabled and the custom bar is displayed as it should be and all is OK

    When I open the same...
  8. Is Access 2007 Program.mdb compatible with Access 2010?

    I have a Program.mdb file that is compiled and opened and used with Access 2007

    Can I open this same 2007 Program.mdb file in Access 2010 without it recompiling for 2010?

    Can I open this same...
  9. Thanks for all your help

    Thanks for all your help
  10. Thanks for that t = 470641 Home Does t(0)...

    Thanks for that

    t = 470641 Home

    Does t(0) take the 1st value up to the space?

    Cells(Row, 1) = t(0) '470641

    Does t(1) take the remaining value?
  11. Maud, Thanks for the wonderful clinic Could...

    Maud, Thanks for the wonderful clinic

    Could you verify my contents of the spllits?

    Split (text_string, delimiter, limit, compare)

    'Input to split: Tab id: 470641, Home

    s = Split(.[a1], ":...
  12. Denormalize a variable number of sheets with variable number of rows into a Summary sheet

    Need some Excel 2007 code for the following

    I have the attached Excel WorkBook with a variable number of Sheets, each Sheet has a variable number of rows

    I want to denormalize a variable number...
  13. Thanks again for the tutorial

    Thanks again for the tutorial
  14. Wow! very nice, could you translate this, 2nd...

    Wow! very nice, could you translate this, 2nd grade version?

    LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

    When I started with Access there was Rogers Access Library, Allen Brown &...
  15. Need Help Looping through Sheet with Concatenation

    Need Help Looping through Sheet with Concatenation

    Excel 2007

    I have a 1000 item Contact List that contains name, email, cell, etc

    I need a macro that loops through the sheet and will take...
  16. Thanks zeddy, going to use j-walk til I get time...

    Thanks zeddy, going to use j-walk til I get time to do custom form

    Thanks RG for your Summary code, are there any sample Excel VBA databases/websites/tutorial you can recommend that demonstrate...
  17. Thanks zeddy, that was the form I was talking...

    Thanks zeddy, that was the form I was talking about initially

    RG, Sorry, I was clicking the Form (Standard/Default) button zeddy is refrencing which list all the fields, do I understand correctly...
  18. Here you go

    Here you go
  19. Can you get sample excel spreadshhet from your...

    Can you get sample excel spreadshhet from your solution above?

    Attached Files 2013-09-10 11:07

    File Type: xlsm support4john LYC_Member_Data_Summary-1_MS_20130909_Test.xlsm (33.9 KB, 2...
  20. Wow, thanks for this, worked great, just had to...

    Wow, thanks for this, worked great, just had to change the following:

    Cells(lCurRow, 3).Value = shtCur.[K3].Value 'FirstName

    I like the way you parsed the csz, normalizing to lowest level...
  21. I understand it is an abortion Can this be...

    I understand it is an abortion

    Can this be imported into a new Excel sheet, so I can have one row/record per member so he can stille work on it in a list format and I will work on bringing the...
  22. This is not my design/approach I inherited this...

    This is not my design/approach I inherited this from my club secretary

    The real file has about 200 records

    one direction, e.g. Detail to Summary that could be done with formulas would be great...
  23. Customer Sheets and Customer List In Same Spreadsheet

    I'm new to Excel 2007 so I need the 2nd grade explanation

    I have 20 customers.

    This is what I have:

    I have a sheet for each customer with contact and demographic information in a vertical...
  24. 1. With the report on the screen, you right click...

    1. With the report on the screen, you right click on the document

    2. Click Export

    3. Click Word RTF File

    I'm looking for the equivlent DoCmd.RunCommand ????????? to put the on screen report...
  25. Thanks for the references I have a customiezed...

    Thanks for the references

    I have a customiezed Menu Bar that has most of the functions in the standard File, Edit, Insert, Tools, Windows and Help Menu Bar

    And I have a mod_Tool_Bar_Menu module...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4