Search results

  1. K

    Pop up update

    I have created a multiple items form. There are three fields in the form. Sr No-Textbox-Primary key Geometry-Combobox Factor-combobox I want to acheive the following. When the user selects one of the following geometries, Square Rectangle Triangle Circle. A pop-up dialog should open up...
  2. K

    Sharing access db

    I created an access database (.accdb). I used the database splitter to split the database into front and backend. I kept the backend in a shared folder in my computer which is a part of the company's windows network. I linked the frontend with the backend tables. The dasebase works fine on my...
  3. K

    Search for records in all fields.

    I have 6 fields. Allotment Number Date 1 Date 2 Date 3 Date 4 Date 5 I want to write a query which when run will give all the dates and their corresponding Allotment Number which are 1 week after today but not later than 2 weeks from today i.e. Suppose today is 11.03.2010. I would like the...
  4. K

    Checkbox check uncheck nased on field value

    Checkbox check uncheck based on field value I have a checkbox, which I use in a report. The controlsource of the checkbox is an expresssion field in a query. This expression field has value 1 or 0. I want the checkbox to be checked when this field's value is 1 and to be unchecked when it is...
  5. K

    Question Combobox dropdown list values from multiple fields

    I want my combobox dropdownlist to show records from two fields, one below the other. An example will make it clear. I have two fields each in a different table. Field 1:Desktop Records: HP 112,Dell 325,Hitachi 652 Field 2:Laptops Records: Dell Inspiron, HP Notebook, Lenova Pad I want the...
  6. K

    Access equivalent of Excel function today()

    I want to update my records to today's date. Whenever I open a the access db the table which contains the date field should update automatically to today's date. In excel this is done by today() I tried using date() but the stored value is static, (it stores the date when that record was...
  7. K

    Send Email Automatically.

    Hello, I have data of 15 of my department collegues in an access table. It includes their name, date of birth & Email Address. I need to accomplish the following. Say if tomorrow is Mr.X birthday. I want to send a reminder mail to all of the other fellow about the birthday except Mr.X...
  8. K

    Upload files to access 2007 throiugh web

    I have created a website as given here. http://www.utteraccess.com/forums/showflat.php?&Number=1024572 Now i would like the user accessing the site to upload images which will be saved in the back end. How to do this. Also I wud like to create a page for updation and deletion of records...
  9. K

    Print Access Form through search string in web

    I have an access database with a table and a form. I would like a webpage which will contain a textbox for searching the primary key of the table. When the user at the frontend hits the command button("Print") after entering the search query, I would like to print the form as it would have...
  10. K

    Contacts Database

    I have a database of my friends. The database contains a table containing the primary key(autonumber), Name, Telephone no,mobile no, home add, office add, photograph, Date of Birth and other details of my friends. i want to do the following: 1. i want a userform to insert other friends details...
  11. K

    Welder Qualification Database

    Hello, I am new to access. I know more than average about excel and I am new to VBA programming. I need help in the folllowing 1.I have a welder qualification database as an excel file. The database includes the following columns. A- Sr no: Serial number from 1,2,3 ... it is unbounded B- Welder...
Back
Top Bottom