Search results

howdy all, i have kinda a general rule of thumb question. is it generally a good design approach to limit the number of many-to-many relationships in an application. i'm finding that making entry forms that are easy for users to fill out is much more complicated when using many-to-many...

hi john, thanks for the reply. i've thought about going the MDE route, but i haven't really messed around with it. i think you right about making the FE a MDE. it seems like the simplest and best solution. thanks

hi everyone, i distributed an application a little while back and got a call saying it wasn't working. apparently, someone got into the code and tried to tweek it to do something different then it was originally designed to do. it wasn't that big of deal, but i was wondering if there are any...

awesome. thanks pat. i'll give it a try tomorrow. thanks again

hi pat, thanks for the response. could you please explain a little more how to set up the update query. i'm not quite sure how to populate the new FK using the new PK. thanks

hi folks, I have a table that uses a text field for the PK that i'd like to switch to an autonumber field. it has a 1-to-many relationship with one other table and a bunch of lookup tables attached to other fields in the same table. is there a way i can switch the PK from text to autonumber...

great. thanks pat.

thanks pat. i think you're right that a piece of equipment will never be associated to the same requirement more than once, but will indexing increase the speed of queries based on this table? thanks

whoops. i spoke too soon. the junction table turns out to be a parent in a 1-to-many relationship, so it looks like i do need an autonumber PK. pat could you explain what you meant about using a unique index for the two FK's in the junction table? thanks pat

hi pat and neileg, thanks for the responses. pat your exactly correct that the business rules require a compound key to make a unique record. one piece of equipment can have many requirements but one requirement can also have many pieces of equipment associated with it. so by changing the...

thanks ghudson.

hi everyone, i've stumbled across a little problem with one of my forms i was hoping someone could help me with. i have a form based on a many-to-many relationship with the following tables: 1. tblEquipment (FK) 2. tblRequirement (FK) and a third table tblCRequirement that brings the two...

hi folks, i was looking for some ideas for an audit trail and came across this great code ghudson developed. i have one question associated with this code. can i use this for multiple forms (unrelated) using the same AuditTrail field? for example i have 3 tables that i want to use this code...

wow. thanks calvin. those were great explainations. i especially appreciate your description of where each application resides. one of things i was confused about was do you distribute an ADP project the same way you distribute a file-server jet application. this client/server stuff fries my...

hi everyone, after reading the bazillion posts on database splitting i still have a couple of questions i was hoping someone could help me with. is the main advantage of .MDB database splitting data stability/integrity? does the amount data you save from going across the network (forms...

thanks jon.

hi jon, thanks for the reply. just after responding to this thread i found all those setting up email threads your're talking about. so thanks for info. so if i add the DoCmd.Quit in place of the code to send emails, what will happen the next time the user tries to open the dbase after the...

hi guys, i was just browsing through and stumbled upon this thread. this is a very interesting thread. i wondering if the logging code specified below can be used to make the dbase non-functional. so after the expiration date has come the user will not be able to open the dbase anymore...

thanks for the help pat.

hi pat. thanks for the response. so in order to really protect your application you have to do user/workgroup security. i've never really done user/workgroup security, but will this require someone to basically act as a DBA assigning new folks priviledges to the dbase? can the user/workgroup...