Recent content by mugen_rsx

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...

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...

Thanks Doc_Man! I am now working on a secondary BE file to store those rarely use data. My VBA knowledge is very limited, but I think is time to learn some more to handle what I am doing now. So basically, we should have pull data directly from table, rather than going through any queries. Use...

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...

thanks everyone!! ALL info are really helpful for me. I am just a beginner on Access and I really appericate your help Compacting does help a lot in my case, it actually reduce to less than 10mb :D . I am still talking my time to observe what causes all the slack space. With my current...

:p never mind! I changed the field from number to string after I deleted all records. Thanks anyway

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...

Yes, I did. It helps a bit, but I just worry in the long run. I am completely satisfy with access right now, and I really don't want to change. Am I inputing too much data for access?

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...

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

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...

I am working on something very similar to this example. Mine is calculating on salary. Main Form is Staff infomation, Sub Form is worker done in this month and how much they earn of each tasks. So on this form, I calucate how much they earn in this month. Is it possible to save the total Money...

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...

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

Thank you for your help with such a detail answer!!