Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    29
    Views
    1,322

    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...
  2. Replies
    29
    Views
    1,322

    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 ?
  3. Replies
    29
    Views
    1,322

    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...
  4. Replies
    29
    Views
    1,322

    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...
  5. Replies
    29
    Views
    1,322

    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...
  6. Replies
    29
    Views
    1,322

    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.......
  7. Replies
    29
    Views
    1,322

    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...
  8. Replies
    29
    Views
    1,322

    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...
  9. Replies
    29
    Views
    1,322

    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...
  10. Replies
    29
    Views
    1,322

    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...
  11. Replies
    29
    Views
    1,322

    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...
  12. Replies
    29
    Views
    1,322

    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...
  13. Replies
    29
    Views
    1,322

    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...
  14. Replies
    6
    Views
    610

    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
  15. Replies
    6
    Views
    610

    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...
  16. Replies
    0
    Views
    126

    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...
  17. Replies
    29
    Views
    1,322

    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...
  18. Replies
    29
    Views
    1,322

    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...
  19. 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...
  20. 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 20 of 20