Search results

Best if you zip up the file with all extra data deleted. This way someone can look and see if you have set something wrong or it is in your copy of Access. Sam

You should not have used an option box. This is used for 'options' which you do not have on the form. You should have used a rectangle. I have attached a repaired db for you to look at. Sam

I know this is not the answer but it would seem to me that you would take the total pieces to be made and divide it by the number of machines available and then store this result in a table. Might need more explanation from yourself. Sam

The actual syntax is: fullname: trim([last]) & ", " & trim([first]) & " " & trim([middle]) Hope this helps Sam

Me :) (Just kidding).. I have never found a 'good' access book. They are either too simple or too complicated. Sam

This came right out of the MS Access help file: Control how an Access file looks and behaves when it opens You can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file...

Here is a dummy db that I created to do what you wish (I think) Let me know if this helps. Sam

I made up a dummy db showing how I would handle the tables. Let me know if this works for you. Sam

In any case I changed the sample I sent to you and it now hides the 'Client Requests" on a button toggle. Sam

Just a quick question. Are these dates in 2 different tables?

Ok, why does it have to 'go away'?..

My addrss is sonofbc@gmail.com

Yes, zip it up for me and I will do up an extra form with the data the way I see it in my minds eye. Sam

Ok, I created a form and subform to show how I would do this. The Form is called 'Test Client' and it uses the subform 'Client subform'. I also added a name to the client list just to show something other than ClientID. I also changed a few tables to use 'ClientID consistently as you hade one...

Just copy the database and then zip it. If there are too many records you could delete most of them. Sam

I suggest you do it this way: PersonnelID (autonumber) Last_Name First_name PositionID (tied to Position table) DistrictID Intials Address etc PositionID (autonumber) Position etc DistrictID District etc

From the form I see in the pic you sent there does not appear to be any subforms. You could put the hire subform beside the bike info and every time you went to a new bike record it would show all the historical hires for that bike. You could then record a new hire for that bike right in the...

You need to use subforms to tie everything together. Read about them in help. This is the way to go. I have used them many times in the past and they are slick. Sam

Ok, it looks like you have a handle on the relationship thing. And it looks like you have done it correctly. Create a main form BikeID and any other info you would like from that table. Make the BikeID field a drop down and connect it to a subfrom tbHires with this BikeID field. You will then be...

Ok, I did remove the relationship that was causing the problem with ClientIR and it will now save the 'Requests' but since you do not tell it to what 'client' it belongs to it defaults to clintID 0. Do not know what you had in mind exactly. Sam