Search results

There is an event procedure in the other combo boxes in order to filter the information. They are all bond to the table, but its arranged weird so IDK if its a problem of the other comboboxes or an common error for misstyping the Dlookup function. What do you mean by dataentry?

I need some help to make a combo box. For some reason when I try to make the combo box and grab the information, it erases all the information on the fields of the other boxes and doesn't work! anyone willing to give me a hand with that?

Hello guys!!!! I have not posted in some time, but work has been busy!! I am looking for a couple of people who want to help out a bit with some things that I do not know how to do in my Access Database. This is some of the things that I need to do: -Add some relations between a couple of new...

Hey Gregory; I am using right now ACCESS 2016. I would like to create a software that work with my database, and also I need to edit and create more stuffs for my database...

Hey guys. I have a database that needs to be finished from Access, and I need to add some relations + some tables that I am missing so I can start the database running. I will add some account levels in SQL, but I am looking to pay money for the time. I will get you everything you need to...

Dougers1; When you create a new table in design mode, it gives you which colums of information you want to put. an Autonumber is what makes each table to be unique, so for example, Ward 1, Ward 2, Ward 3, will have autonumbers that will be collected for each. I do recommend you to get a small...

aNY IDEA???

so normalization in this sense should not be done? what about if a customer sells his company? then I need to change the information in multiple tables? So truckT and TableT should reside in the same table??? and what about If I want to do a query with every single Driver? should that be...

Alright; I want to be able to use the search combo boxes with the tables instead of creating another filter for the Navigation Form to work. I also need the subform to let me add Multiple trucks for each company since its a One to Many relationship. Does that work?

Table Relationship is: *CompanyT One to One CustomerT *CompanyT One to Many TruckT *CompanyT One to Many DriverT *TruckT One to One DriverT

Here are my Master & Child props for my subform: Source Object: TruckF LinkMasterField: TruckID LinkChildField: CustomerID Table Relationship is: *CustomerT One to One CompanyT *CompanyT One to Many TruckT *CompanyT One to Many DriverT *TruckT One to One DriverT

I have a problem with my tables. To use a search combo box, I had to create a relationship between 2 tables ( CompanyT and CustomerT ) and I had to to a Query in order for the combo box to work property. The problem is that when I add them to a Form, and add a different subform, I have...

Well CompanyT Should be the mother and TruckT and DriverT should be the childs. This is a One to Many Relationships that I want to build. The thing is that every time I add More then 1 truck x company using the subform in the Truck Tab in NavigationF, gives me an error.

Please check the last post :)

Ok here it is. I hope this can work. Please let me know if you need more info, but as soon as you play with it, since is a small database you get it checked out in a couple of minutes ok?

Bump: Anyone who can help me with this please?

BTW, The trucks are located in a different form, so its a Form, from another Subform.

Yeah, here: http://www.megafileupload.com/inxN/4...chDatabase.rar The problem I have is that my Navigation Form is working directly from a query, instead of the tables, and I did that because if I did that directly from the tables, the 3 search boxes that I have do not work propertly... Also I...

Hey JHB, are you knowledgeable in Relationships and subforms?? I have major problems with my database and I need some extra help to fix them up. I been researching without success.

I'm having major problems with relationships and subforms... are you acknowledge in those areas???