Recent content by morg59jeep

how do you turn on the dashed guidelines that help you line up things to another object? For example if I want to draw a line and I want the starting point to be at the intersection of a point on an object above and to the side of where the line needs to go. How do you turn on the feature that...

Is there any way to update a DateModified field in a table if a record is changed? I know this is possible when the data is changed in a form but what if someone changes the data directly on the table. Is there any way to record this?

I need it to be intergrated into my access system.

Yes they do calculate it every day... so I figure I could do something like transactiondate - lastpaymentdate = interestdays then do something like interestdays x dailyrate = interest then paymentamount - interest = principal then I deduct that from the current balance... problem is I...

I have to setup a system to track our loans. Need it to work like a bank would handle the loans. Here is what I have so far. Tables LotInfo LotID(primarykey) LotLoanRef LotID(primarykey) LoanID(primarykey) LoanInfo LoanID(primarykey) LoanType Bank LoanNumber Interest Rate...

Yes.. those in my understanding dont apply to my situation where I have multiple possiblities. In my situation every vendor has multiple cost codes and every cost code has multiple vendors. I cant figure out how to make your example apply. It does not have a table that has records that define...

Im bumping this per still not fixed.

Sorry for the lack of detail but I am just learning this more advanced stuff. Thanks for your patience lets try again. Ok here is what I have at this point in detail. I have a 4 Tables vendInfo ID (PK) vendName vendAddress vendPhone costBreakdowns costCode...

the example that traingamer posted looks like it will only work if (in my situation) each costcode could only be assigned to each vendor. Im my situation though we use more than one vendor depending on whats happening at the time for each costcode. I currently dont have any table linking...

I have a Vendor field for each Vendor and a cost code field. What I need to setup is when a vendor is chosen only the appropriate cost codes for that vendor are available to choose from the combo box. How do I do this on my form. We are having problems where the data entry person enters a cost...

I have 4 different fields that I need to track the changes of. If I use Golom's suggestion would I need to create a table for each field that I need to track or would it be better to do one table like this? PrimaryKey(s) ChangedBy ChangeDate ChangeReason FieldName1 FieldName2 FieldName3...

That is way over my head... can someone please explain it in easier to follow terms?

I have a table that I want to lock the data once it is entered so that it cannot be changed. The data in the table however needs to be modified when errors are found and a history of the the changes, who changed them, and why needs to be recorded. What is the best way to go about this kind of...

PHV is correct... neither of those work ... im not in SQL view either... The solution that PHV gave in his earlier post worked perfectly in my case.

Neither of those actually work. Both <> "4097" OR <> "5002" OR <> "5474" and <> "4097" AND <> "5002" AND <> "5474" result in all records showing with only the 4097 removed. They work great for one value but with multiple values they only filter out the first one.