Recent content by snoopy92211

have a table, Loans. Fields: ID (key) Loan Number Principal Balance. I have another table, Transaction, that's based off the Loan Number field on the loans table. Fields: LoanNumber Payment Type (2 choices, payment and advance) Amount I have a user form where users can specify the payment...

Thanks for the reply. Now here's my next question. So the user uses my form to query the records they want to update. What I would like to be able to do is have the user select the exact records they want to track. For example, if Suze queries on all fields containing apples within a date...

Ok. I have a doozy of an issue. I have a table, tblobligation. I want my users to be able to make changes to this table (using a form to query the info they need), but before the changes are made, i want the changed information to be added to a stage table. that way,the approver can review...

Hi folks! Here's my problem. I have a multiselect listbox named fruit on a form. (simple multiselect). The user should be able to select anywhere from none to all values. from this information, a report populates depending on what I select in my multiselect listbox. The report is populating...

I'm having a devil of a time getting this report to load. My report is based on a parameter query. My combobox serves as a parameter. The combobox is based on this query: SELECT AItemType.ItemTypeID, AItemType.ItemType FROM Aitemtype order by Aitemtype.itemtype; There are 4 choices the...

All - I made the changes that were suggested. The statement is x <> y, because I want to update every field where (before the update, the location codes don't match). However, when I open my 'all' table, the location information from the master table isn't appended to the location fields in...

This is driving me NUTS!! :eek: I am trying to update a table based on an inner join. Do update tables have to be based on primary keys? arrrh! the error is saying that my syntax for the update is incorrect. PLEASE HELP! :( (ALL and mpslocations are tablenames, respectively)...