Search results

  1. M

    how to boot windows with orginial setting?

    At my school, all computer with the same setting (software installed and specific files at the same place). It allow user to install any programs. During restart, it allow user to choose regular restart or restore to orginial setting. Once selected orginial setting, all pervious installed...
  2. M

    Server Computer = Home PC ??

    Working in my current SME company, lots of data need to be save, so I made them a data base using MS Access with my limited knowledge. However, now having more and more data, I think we need a server computer. Looking at dell computer, look up in the server selection, seem pretty expensive...
  3. M

    Append Query but duplicate records

    I spend a lot of time seaching here, but not sure what to look for, please help!! I have two linked tables One has Order_Number Client (and other info) The Other one has Order_ID Order_Number (link with first table) Finish (user choose it is "processing" or "done") (and other info) I am...
  4. M

    Import / Link Excel File

    look for the best method. I have another software to work with my access. End of each month, ProgramA will generate an excel file with the monthly data. I want to import/link it with my access. I first try to import it everytime I generate the new excel file. However, there are one line at the...
  5. M

    Help with Large Database!

    I have split FE and BE, but the performance gets really slow. I hold my BE in win xp pro. But after I made some changes in the registry, things get a lot better. It used to take almost one minute to open, now only a few seconds. here is a link http://www.winguides.com/registry/ sorry, i forgot...
  6. M

    Case Sensitive in Primary Key

    I am trying to make "ABc123" is different than "abC123", can anyone help? I also found that in my table, it does not allow me to add these two together! I thought activitated the unicode mean case sensitive as well
  7. M

    problem with relationship

    I have attached a image here, hope it will help!! My problem is on the bottom right, where the table called "size"-->"model". This is actually a very simple Material Used database. From left to right, user have to input material name, then their color, then Usage of it. (I also add the...
  8. M

    This Month Date Range Button

    Is it possible that I create a button and after I click it, it will show only "This Month" or "Last Month" Database? If today is Dec 14th, I click on "this month" button and it will show Dec 1-14th data. Is it better to work this on Query? Sorry I am a newbie, still couldn't know when to use...
  9. M

    How to hide the pre-new record row?

    Not sure how to call that row. On my sub-form, there is always a blank row for you to add new record. How can I hide it. I want to use a button to add a new row (record) instead of having a row ready for me to type in. THank you
  10. M

    Newbie question : Calculation on Queries

    I have very simple calculation. I believe that I couldn't done it on table, so I calculation them on query (is it right?) . Example: "TotalAmount: [Quantity]/[QuantityPerPcs]" on the "Feild". I manage to done this part, but the "TotalAmount" on table doesn't have the number that I calculate on...
  11. M

    Procedure Form and Subform

    I am creating a form here the Main form need to fill in (or may already fill in in another form) some headings like date, name, memo details, ect. On the subform, there is a procedure list out all the steps and need to fill out who have done this step, and date, etc My main problem is on the...
Top Bottom