Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. snoopy92211

    Sum and update query

    Thanks for the tip. Can you please give some instruction on how I would create the query? An example would help greatly. much appreciated! snoopy92211
  2. snoopy92211

    Sum and update query

    I 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...
  3. snoopy92211

    Field showing bound column ID instead of name

    Thanks for all of the tips! :)
  4. snoopy92211

    Field showing bound column ID instead of name

    oops! lol. I meant to say this. SELECT DISTINCTROW Investments.Borrower, Bankdata.BankID, Bankdata.Name FROM Investments INNER JOIN Bankdata ON Investment.borrower = Bankdata.id; (borrower is bankID)
  5. snoopy92211

    Field showing bound column ID instead of name

    Thanks Lynchg! Now, how do I do that? I tried to do a query using a join join on BankID, but that didn't work. Here's my query, which doesn't work at all. lol SELECT DISTINCTROW ICLoans.LENDER, BusinessUnit.BusinessUnitID, BusinessUnit.Name FROM ICLoans INNER JOIN BusinessUnit ON...
  6. snoopy92211

    Field showing bound column ID instead of name

    Ok. This is driving me insane! I have a table, BankData, that lists bank information. It's a pretty simple table, just a primary key, and a bank name. I have several tables that use this bank name as a field. For example, I have an Investments table that uses a bank name field(field name...
  7. snoopy92211

    Date is less than Date in recordset

    I've tried both of these options as well,and the module just errs out. For the second option, this section '*' is commented out.
  8. snoopy92211

    Date is less than Date in recordset

    Thanks! one more question. This is really simple,but for the life of me, i can't figure it out. I want to create a query that says like = *. This is what i have in my sql. and it errs out everytime!! dim fn as string If Forms!obligationselector.Check157 = -1 Then fn = "Like...
  9. snoopy92211

    Date is less than Date in recordset

    Jadams0173, thanks! I forgot to mention that I've tried the 'Format' function, and for the 2/6/06 date, the obligations that were marked inactive were the following dates: 10/6/06 - 1/6/07. So this function didn't seem to work...am i missing something that should go within the format...
  10. snoopy92211

    Date is less than Date in recordset

    Hi. I have some code that I'm using to update a table in a recordset. I have this date function. For j = 1 To 12 Set rst = DB.openrecordset("obligations", dbOpenTable, dbAppendOnly) rst.AddNew If j > 1 Then rst.Fields("DueDate") = CVDate(Str(j) & "/" &...
  11. snoopy92211

    Preview Updates before Updating Table

    PLEASE HELP! :(
  12. snoopy92211

    Preview Updates before Updating Table

    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 the...
  13. snoopy92211

    <All> option on form to report

    But.... I changed that part of the query, and the report still isn't appearing. The combobox, Itemtype has this are the RowSource: SELECT IRSItemType.ItemTypeID, IRSItemType.ItemType FROM IRSItemType UNION SELECT "*", "<All>" FROM irsitemtype order by irsitemtype.itemtype; When I changed...
  14. snoopy92211

    &lt;All&gt; option on form to report

    ahh... The report's underlying data source is a query. Here's a sample of the code: SELECT IRSItem.ItemType, IRSItem.ItemTypeII, IRSItem.ItemNumber, IRSItem.ItemDescription, IRSItem.Company, IRSItem.CompletionPercentage, IRSItem.Comments, IRSItem.Name FROM IRSItem WHERE...
  15. snoopy92211

    &lt;All&gt; option on form to report

    Hello. I have a form with several comboboxes. This form will allow users to select whatever criteria they want and print a report using named criteria. The reports are working fine until I decided that I wanted to add an <all> option in the combobox. Here's my combobox, named ItemType. The...
  16. snoopy92211

    Filter Issues using a form command button

    Howdy folks! I tried to search on this one, but it didn't find any applicable info. I have a form with several controls that serve as filter. I managed to fix all of my filter buttons with the exception of this one. I have 2 calendar controls ...I'm trying to filter the data on a date range...
  17. snoopy92211

    Form - Edit, Updates when changing records

    hmm...an incomplete flag? I've never heard of that. How do you do it?
  18. snoopy92211

    Form - Edit, Updates when changing records

    Well, the issue is that I don't want to append anything to the tblmain unless all of the information is input by the user. Why? Because once the locationtable is updated, I will then run an update query and some append statements to add the info from tblmain to the imported table. If that makes...
  19. snoopy92211

    Form - Edit, Updates when changing records

    Here's another spin on this same topic. (Sorry to barge in, but it's related). I have a form that I want users to utilize to edit records. The form's recordsource is based on a query, Missing X without Y. The form has the following fields. LocationCode - control source: Locationfield...
  20. snoopy92211

    Stop a module; then re-execute after criteria met

    I have this function that updates a table, tblTable with additional fields, etc. That all works fine and dandy. However, I have to check if a code in tblTable matches with a code in tblMaster. That also works fine and dandy. If the code doesn't match in tblTable, I have a form that pops up...

Part and Inventory Search

Back
Top