Search:

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

Search: Search took 0.00 seconds.

  1. Excel VBA to prevent Excel file before closing & saving

    Hi,

    I am trying to prevent the excel file to have specific cells filled prior closing & saving it. Since I am new to VBA can someone suggest me or write a VBA for me in this case ?
  2. Replies
    11
    Views
    492

    Thanks will look into it. Please do suggest is...

    Thanks will look into it. Please do suggest is there any cloud server available for my requirement ?
  3. Replies
    11
    Views
    492

    Nope I do not want to measure individual...

    Nope I do not want to measure individual Bandwidth Usage or consumption.

    All I want is a setup to limit the user with his share. We are a bunch of 20 users limited to download 200 GB per month,...
  4. Replies
    30
    Views
    1,826

    Thanks Patt. I fixed the above. Now I require...

    Thanks Patt.

    I fixed the above. Now I require help on the 2 things as below.

    1. In case of modifying the old data which are stored in rows having record id, I am trying to import the data to...
  5. Replies
    11
    Views
    492

    Solution for Sharing Internet Connection

    Hi,

    I myself and my friends are currently sharing an Internet connection with 15 Laptops and 5 desktops having no bandwidth restriction, hence the Bandwidth of 200 GB gets exhausted in 20 days...
  6. Replies
    30
    Views
    1,826

    I have managed prepare the search form. I...

    I have managed prepare the search form.

    I have splitted the Tables to BE, while the Dashboard form which is at FE retriving the data from couple of Linked excel files in the network drives. Now I...
  7. Replies
    30
    Views
    1,826

    Hi Patt. It didn't work still. Please could you...

    Hi Patt. It didn't work still. Please could you help/advise me on my form ?
  8. Replies
    30
    Views
    1,826

    Hi WendellB , I m still trying this on my...

    Hi WendellB ,

    I m still trying this on my own. I m not able to understand Allen Browne's sample. It goes over my head
    Attached is the form I am working on... my requirement is to search using...
  9. Replies
    30
    Views
    1,826

    Thanks to all. I have managed to Capture Username...

    Thanks to all. I have managed to Capture Username and Time of Import through Update SQL.

    Now I require help on the below:

    1. I am designing a Search form from Union SQL of all 4 tables (3...
  10. Replies
    30
    Views
    1,826

    Hi, Point 1 & 2. I want the Usernames to be an...

    Hi,

    Point 1 & 2. I want the Usernames to be an Auto calculated field in a Table where Iimport. We import 28 fields from excel, while Access has 30 Fields. 2 excess fields are Username of the...
  11. Replies
    30
    Views
    1,826

    Need ideas on below; 1. I tried capturing the...

    Need ideas on below;
    1. I tried capturing the Username for each Import, So I tried calling the User-defined Function through table design, but User-defined functions do not appear. Pls suggest.......
  12. Replies
    30
    Views
    1,826

    Thanks Patt. Not tried it yet... No I am not...

    Thanks Patt. Not tried it yet...

    No I am not using the ODBC reference... Its just the normal Queries & forms accessing the both the FE & BE.

    Need ideas on below;
    1. Any suggestions on...
  13. Replies
    30
    Views
    1,826

    Thanks again. I have built a basic search form...

    Thanks again.

    I have built a basic search form using a Query and Button to run it for FE table. I am still having 2 issues as below

    1. I am still facing issues while importing the data from...
  14. Replies
    30
    Views
    1,826

    Hi Wendell, Thanks for the valuable inputs and...

    Hi Wendell,

    Thanks for the valuable inputs and these are already in the plans in the future.

    I tried to adapt couple of Sample forms to my DB, but unable to adjust its VBA to my requirement. My...
  15. Replies
    30
    Views
    1,826

    RG, These FE Tables will be retained and will...

    RG,

    These FE Tables will be retained and will be empty post splitting the records to the Back end tables.... Excel cannot handle more than 1Mn records where my current data is already 3Mn. I want...
  16. Replies
    30
    Views
    1,826

    As informed earlier, this Access database is set...

    As informed earlier, this Access database is set to have 3 Million Check records issued for payment of Loan. This will include both Dated and Undated checks captured with other 20+ fields, with...
  17. Replies
    30
    Views
    1,826

    Hi RG, I m not clear with your above Update...

    Hi RG,

    I m not clear with your above Update Query. If you are referring to making Excel as Linked Table, Its not possible as there are 3 Mn records...
  18. Replies
    30
    Views
    1,826

    Hi, I have set the Database with 27 Fields while...

    Hi,
    I have set the Database with 27 Fields while the Excel which I import has only 24 Fields, where the additional 3 fields in Database are calculated fields in Table. I tried the regular...
  19. Replies
    6
    Views
    804

    As mentioned earlier, I need Specific records in...

    As mentioned earlier, I need Specific records in a Column to be changed to DMY through text to colums.... Cell Formatting didn't work.
    Example: 2-Nov-14 has to be changed to 11-Feb-14
  20. Replies
    6
    Views
    804

    Need macro to convert date formats

    Hi,

    I wanted to change the date format for a specific column from MDY to DMY using Text to Columns in excel for 4 files. This is specific records in that column and not for the entire column. How...
  21. Replies
    0
    Views
    190

    Excel to Infopath

    Hi,

    I currently store data in excel, which I wanted to convert as an infopath form, so that it can be used to collect data in access. I am aware of the Linking Excel file as Tables in access which...
  22. Replies
    30
    Views
    1,826

    Thanks Patt for the revert on this. Required...

    Thanks Patt for the revert on this.

    Required help on the below:
    1. I am planning to create a 2 backend tables for Dated & Undated checks, but not sure whether the limitation of Access applies for...
  23. Replies
    30
    Views
    1,826

    Check Database in MS Access 2010

    Hi,
    I am from India and developing an Access database set to have 3 Million Check records issued for payment of Loan. This will include both Dated and Undated checks captured with other 10 fields of...
  24. Re: Mail Merge - Memo options (MS-Office 2003)

    Hi Hans,

    Thanks for the prompt response.

    But I don't have enough knowledge in writing VB code for Outlook or Word. Is there anyway can I learn this apart trying download....

    Thanks+Regards...
  25. Mail Merge - Memo options (MS-Office 2003)

    Hi,

    I am currently using a contact list created in excel and using mail merge in word to send mail to them from a standard document template.

    My Requirements:

    1) I need a particular field...
Results 1 to 25 of 25