Search results

  1. L

    Import data from Outlook to table

    Hello again. I've been looking for an easy to use helpdesk DB and I found one on the Office templates site. (I've uploaded it here) It's pretty simple but it suits my needs. I was wondering if someone can help with my question. How can I setup the DB that each time I open it, it transfers data...
  2. L

    Declare a variable auto incremental and write/read txt files

    Hello. I want to know if someone can help me with this: I'm starting to write some code to run an office (not professionally). When I write the Client Class, how do I make it that the number of the client be a primary key (unique and auto incremental)? Also, I want that all the Client and...
  3. L

    Null Value from View to Stored Procedure

    Hello. I've been hitting my head all day with this and maybe anyone can help me. I have this piece of code on a view: Select HA_Id, HA_Seg_Id, HA_Data from dbo.Hist_Analysis where (HA_Data BETWEEN CONVERT(DATETIME,'2001-01-01 00:00:00', 102) AND CONVERT(DATETIME,'2009-01-01 00:00:00', 102)...
  4. L

    Importing from Word

    Hello, I have a file in word that is like this: Name 1 Address 1 Phone 1 Postal Code 1 Comments 1 Name 2 Address 2 Phone 2 Postal Code 2 Comments 2 And so on, intil 300 and something. How can I import that into records to an Access table strtured more or less with the above mentioned fields...
  5. L

    Back To Basics Question

    Hello guys. Just starting a very simple (one should think) DB for keeping track of medical doctors. How should I approach this? Doctors_Table should contain : - Id - name - address - state - phone - medical area - addicional comments Medical_Area_table - Id - Medical_area State_Table - Id -...
  6. L

    Meetings

    Hello. I'm having trouble with this small db I've started to maintain records of meetings. I have 2 tables (Participants and Meetings). On Participants, I have: Id_participant - auto number Participant_Name - text On Meetings, I have: Id_Meeting - auto number Meeting_Subject - text...
  7. L

    Keeping a history of records

    Another doubt I have is: I have a form to register applicants data. In it, there are the fields: Candidate_Id Candidate_Name Candidate Address … and with the Candidate_Id filled in, it opens other tables concerning Professional Experiences, Literary Abilities and other Abilities. What I need...
  8. L

    Displaying results of search on dropdown boxes at a form

    Hello. I wonder if you can help me with something. I have created a Form where there are 4 drop down boxes that collect data from 3 tables. How can I use that form to search for all the records matching one or more criteria chosen from those drop down boxes and display other fields on a report...
  9. L

    Buttons on Switchboard

    One quick question Hello. Just wanted to know if there is limitation of buttons on a main switchboard, because I can't seem to get an 8th button to become visible. Thanks. Cheers
Back
Top Bottom