I am making a database that tracks the inventory of a tool room. This includes info about both shelf tools and tool box inventories. Each inventory has about 300 items in it, and there are about 9 kits. The info was already put into excel, and instead of re-typing the inventory for each one of the tool kits, I want to just import the info from excel. I've done this before with a database that I made about 3 years ago, but I can't remember how, and I can't find my access bible to look up the answer there. Help …

Member Avatar
+0 forum 0

I want to develop a new app. for Windows Mobile 2003 that based on Access DB do you know about a nice place where i can read about it and get some nice tips? If you know about some other app. that uses access DB or any other DB for Windows Mobile app. please let me know about them I want to learn as much as I can about it. thanks. Yoav

Member Avatar
+0 forum 0

A project a do at my job is a monthly report using Excel spreadsheets. I enter raw data and get calculated totals, averages, etc. Nothing very complicated. Each worksheet is a month, the workbook is a year. No yearly summary is done. Now my supervisor wants some new additional info included. Have template for new worksheet. What would be very nice would be to replace unused pages/worksheets with the new and keep them in one workbook. Can not figure out how to do that. My alternative is to create a new workbook and label each one appropriately.

Member Avatar
+0 forum 0

Can anybody help me understand difference between form_load and form_open event in MSAccess?Which event occurs first?

Member Avatar
+0 forum 0

Hi I Have Three Tables 1- Cutomers 2- Payments 3- Invoices I Need A Way To Build My Qyerry So That I Can Get A Detailed Report On The Customer Account Movement, As Such Date.........Description.............Cr. Amnt............Db. Amnt..........Balance And Also The Balance Should Be AddeTo A Previous Balance If It Is Not Zero. Thkx In Advance

Member Avatar
+0 forum 0

Can anyone tell me what is Microsoft Transaction Server?

Member Avatar
+0 forum 0

Hi guys and girls! I am currently doing a degree in Business Computing. For my dissertation I have decided to look at what Database Management System (DBMS) software people use and why! By using this forum I am hoping to contact people that use DBMS Software and get their views on the different types available at the moment. I would be really grateful if anyone using DBMS Software could fill in this short questionnaire online, it should only take a few minutes. The link is: [url]http://FreeOnlineSurveys.com/rendersurvey.asp?id=85758[/url] Thanks

Member Avatar
+0 forum 0

I change query parameters in my code. i want the query to change her Sql property to new sql with new parameters. Set QueryDef = CurrentDb.QueryDefs("q_QueryName") QueryDef.Parameters("[Param_1]") = stringvalue_1 QueryDef.Parameters("[Param_2]") = stringvalue_2 QueryDef.Parameters("[Param_3]") = stringvalue_3 QueryDef.Parameters("[Param_4]") = "#" & Format(timevalue_1, "HH:mm") & "#" QueryDef.Parameters("[Param_5]") = "#" & Format(timevalue_1, "HH:mm") & "#" QueryDef.Parameters.Refresh 'QueryDef.Sql DoCmd.OpenReport "r_ReportName", acViewPreview The report "r_ReportName" need to run with new Query and new parameters. But, actually the Query.Sql didn't change at all. and microsoft JET still ask me for enter parameters ??

Member Avatar
+0 forum 0

Hi all....im newbie here ;) ;) Actually im looking for software under Decision Support System like Expert System, Management Information System etc..any software as long as it relate to DSS..if u have the software or know where to download it..please let me know :lol: :lol: Tq very Much

Member Avatar
+0 forum 0

I am using the toggle field codes option to populate a report from a Word document. I have not been able to get this option to do multiple parts of a scenerio (ex. Does this condition exist? If yes, than do this. If no, do that.) If more information is needed please ask (document is attached with example). Thanks , D

Member Avatar
+0 forum 0

Hello, I'm new here, and new at using Access... grrrrrr... To start off, I want to create a database for all correspondence, i.e. invoices, quotations, etc. etc. 1. Is it a good idea to use Access for this? 2. Any tips pleaseeee? Best wishes!!!! :p

Member Avatar
+0 forum 0

The End.