Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: akasmia
  • Content: Threads
  • Order by date
  1. akasmia

    NotInlist event error

    Ok this is very simple BUT I am not making it work !. I am using a single table underlying the same form which contains the combobox cmbFindbyLastName. When I enter new data in the combobox the message generated by the msgbox function keep hounding me !. Keeps saying the same thing "smith"...
  2. akasmia

    Notinlist event on same form error

    Ok this is very simple BUT I am not making it work !. I am using a single table underlying the same form which contains the combobox cmbFindbyLastName. When I enter new data in the combobox the message generated by the msgbox function keep hounding me !. Keeps saying the same thing "smith"...
  3. akasmia

    NEW RECORDD NOT SET IN FOCUS

    I have a form called Physical_Exam based on a table also called Physical_Exam. On this form there is a combo box based on the same table. It works fine except when I add a new name (new record) using the NotInlist event. The record I add is not automatically in focus for the user to complete...
  4. akasmia

    ACCESS SETTINGS TO ANOTHER COMPUTER

    This may be a simple task. How can I copy exact settings of Microsoft Access frome one computer to another (no netwok). Examples: menubar customarization, macos and buttons associated with them, autocorrect and spelling...etc. Is there a settings file that one can simply move to the next...
  5. akasmia

    LOOPING THROUGH CONTROLS!

    This is a simple thing but I am a simple user! I have form with many check boxes, radio boxes and text boxes. I would like to loop through the controls to changes their values. example There are 40-50 check boxes to be reset to false all at once (i.e. cleared or reset). I have tried using...
  6. akasmia

    REMOVING BLANK SPACES FROM REPORT?

    MY DATA IS A SIMPLE SET OF SHORT SENTENCES CHOSEN BY THE USER ON A FORM. THE SHORT SENTENCES ARE STORED IN A TABLE THEN DISPLAYED IN SMALL TEXT BOXES ON THE REPORT. THE PROBLEM IS THAT WHEN A SENTENCE IS NOT CHOSEN ON THE FORM THEN IT BECOMES BLANK ON THE REPORT. EXAMPLE: POSSIBLE CHOICES...
  7. akasmia

    Report from form data

    This gotta be the simplest question!. I apologize ahead of time. I have a form with text boxes, check boxes, option buttons, toggle buttons, and command buttons. I am using this form to collect data from customers. This form is not based on a table or query. I would to generate a report from...
  8. akasmia

    HARD DRIVE ACTIVITY FOR UNKOWN CAUSE?

    AFTER WINDOWS 2000 PROFESSIONAL BOOTS I KEEP HEARING HARD DRIVE ACTIVITY FOR UP TO 30-40 MINUTES!. NO PROGRAM RUNNING, TASK MANAGER DOES NOT LIST ANY RUNNING PROGRAMS. ANY THOUGHTS.
  9. akasmia

    ARRAY of Dates in VBA

    My array of dates contains blanks or zeros, pending on the user. I have only 4 dates DATE1, DATE2, DATE3 and DATE4 to sort and obtain the smallest date. Example: DATE1: 12/3/02 DATE2: blank DATE3: 1/12/03 DATE4: 4/14/04 I WOULD LIKE TO SORT THE ARRAY AND PICK 12/3/02. I AM RUNNING INTO...
  10. akasmia

    FORGOT ACCESS DATABASE PASSWORD

    HELP...HELP... HAVE NOT BEEN ABLE TO OPEN MY ACCESS 2000 DATABASE. TRIED UPPERCASE LOWER CASE ..ETC AND NO LUCK!!!. ANY SOLUTION?
  11. akasmia

    Urgent! FORGOT ACCESS DATABASE PASWWORD

    I have opened my database as exclusive. Entered a password, now can's open my database !!. Any solution?.
  12. akasmia

    ARRAY OF DATES: Select ing the smallest/b

    This is very simple: I have 4 dates in Microsoft Access: DATE1 DATE2 DATE3 DATE4 in a table. I add nothing to DATE1, 2 years to DATE2, 2 years to DATE3 and 1 year to DATE4. I generate the following dates: DATE1_Plus, DATE2Plus2, DATE3pLUS2, DATE4pLUS1 and store them in...
  13. akasmia

    SELECT DATE:

    I think this one very is simple but I am getting and error: I have 4 dates in a table: DATE1 DATE2 DATE3 DATE4 I add nothing to DATE1, 2 years to DATE2 and DATE3 and 1 year to DATE4 then I select whichever date comes first. I have created a form and stored the modified dates (i.e...
  14. akasmia

    BLANK AND ZERO CELLS IN DATE CALCULATIONS

    I have a table with the following dates: Excel sheet: DATE1: DATE2: DATE3: DATE4: Iam tryin to use MIN(DATE1, DATE2, DATE3, DATE4) and put the result in a cell. Some dates can be zeros or blanks (missing). MIN function works correctly only if all dates are given(available). I want...
  15. akasmia

    Many to many relationships in MS Access

    I am new to this so please forgive my simplicity! I have the following tables: Patients Meds Hospitals Providers Diagnoses Visits I have edtablished many-to-many relationships as follows: Patients-Providers (Subform esablished) Patients-Meds (Subform esablished) Patients-Diagnoses (Subform...

Part and Inventory Search

Back
Top