Search results

I would make each of your examples a table. So you would have "Hire of Equipment" one table, "Sale of Goods" and "Attendance on a training course" each their own table. You would then link them as needed. For example, "sale of goods" would have a relationship to your customer table, attendance...

I am working on an E-R Diagram and I am not quite sure on a certain relationship. Here is what I have. I am showing a relationship between Service and Subproperty. Management wants to have the service they provide tracked by the subproperty, not the property itself. So I am showing a...

Can Access be used as a stand alone database? In other words, can I build a complete application and have it installed on another computer wheather that person has access installed or not? I have seen some database programs that sure look like Access but they install and run as a program in...

Can anyone help with this one please. Thank you.

I cannot seem to figure this out. I do not know why this is such a hard concept to figure out. I am trying to make a gun inventory. Here are my tables. Table1 Sold_Price Sale_Date Tax_Amount Who_Sold Table2 Purchase_Price Received_Date Who_Bought Table3 Maunfacturer Model_ID Type_weapon...

Excellent, thank you. I will try this.

Excellent, it worked Excellent, thank you for the help. It worked great.

Where do I put this code? Thank you for the code. I went to my splash screen form and inputted the code in a new module. I am new at this. Was that what I was suppose to do? It asks me to save it and name it. I need to have a reference somewhere to let it know to run the code correct? I am a...

I am building a gun inventory database for a friend. He needs to have information such as , gun price, sale price, manuf, caliber, serial number, model, so forth. My question is; would it be better to have severa different tables? I. E. Table 1 Manufacturers Table 2 Models Table 3 SalePrice...

I was not clear about the tool bar Excellent instuctions for making a toolbar, thank you. But I was not completely clear. I want only the custom bars I make to show when a user opens my database. I am doing a gun inventory. I saw one program that does gun inventory and when you open it, it has...

If I wanted to build a database in Access can I make my own file bar. Let's say that I wanted to build a gun inventory but wanted the tool bar at the top to have the specific files I want people to click on. How is this done? Is it done with another program used as a developer with Access...

It worked, thank you Excellent. Worked perfectly.

Close form upon clicking a command button I have a startup splash screen with a "OK" button, similar to Nortwind database. The OK button works as far as opening my switchboard page. But how do I get the Splash screen to close after I click the OK button? So I can see my switchboard page.

Makes sense now Thank you, it makes sense now.

I have a VBA module called modAuto_Fill_New_Record. It auto fills several different fields for me. My problem is I need to use it on 5 different forms. How do I do this. When I write a new form it does not work. So I create another modAuto_Fill_New_Record and it says that I already have one. Do...

How to sum with multiple files Ok that makes sense. But how do I do that when there are five records for this balance and different people use it? I just cannot seem to figure that out right now. Do I use VBA, which I am real new at? Or what? Thank you.

OK, I figured out how to make a calculation. My big problem now is to have a global field, which would be "beginning balance" and "ending balance". I have 5 employees that share the budget. The budget starts at $1280.00. One employee may buy somthing one day and then another day while another...

Figured it out I fixed the problem by using a subform.

I have a form that tracks the budget. It is a small budget. But my problem deals with req. dates and req. amounts. You will see from the example I gave you that I can input one req. date and one req.amount and my calculations shows the ending balance. But how do I make fields where the same...

Fixed Thank you that fixed it.