Search results for query: *

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.

I have a record that excludes one record using this code <>"4097" I now need to exclude a few more records as well. I tried to use <>"4097" And "5002" And "5474" This did not work. It only excluded the 4097 .. so what do I use to exclude more than one non-consecutive record.

Worked like a charm!.. Thank you very much. You were also correct on the cost code not being numeric.

CostCode is a numeric field. The range I need is from 4099 to 4999z For example some are labled 4021, 4021a, 4021b [Amount] and [Price] are the same thing... I just used the word price to make it easier to understand my question. I am sorry I didnt make myself more clear at first. Thank you...

I tried that but when I run the report I get the following error: The expression is typed incorrectly or is too complex to be evaluated.... here is exactly what I have entered: =Sum(Abs([costCode] Between 4000 And 4999)*[Amount]) Let me clairify that each serial number(cost code) has a...

Here is a little more detail. I have a report for items that the detail shows me the color, size, serial number and price. My report groups the items by color and sorts them by size and subtotals them. At the bottom of my report I get a total price for all records. What I need is for my report...