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 derfloh 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: *

  • Users: wxkeep
  • Content: Threads
  • Order by date
  1. wxkeep

    return record id of row with largest value

    Back in the saddle. Been a while since I've done any VBA coding and the software has seen some changes since last I played with it 10 years ago. Here's what I'm trying to do (short term) IN VBA - use a query (or DLOOKUP etc) to search a table for the row that contains the highest value that...
  2. wxkeep

    Joins and Unions

    Have two tables Sales -Sold Date -Salesman -Amount Returns -Return Date -Salesman -Refund Amount Anytime a sale is made - its recorded into the sales table. Likewise anytime a return is made - it's recorded in the return table. I have a form - that accepts dates- to build a custom query...
  3. wxkeep

    Totals in queries

    I've got a db - that tracks customers and sales numbers. Each customer may have multiple sales, and thus, multiple entries: sales id | Name | Amount 1 John 500 2 Mark 500 3 Luke 100 4 John 200 I run a query on this table that...
  4. wxkeep

    Simplify a report

    For the past year I have been responsible for a database at work. In the beginning it simply kept track of loan applications (date, score, name, source, decision, etc). And I had one report that would show all the applications as well as summary numbers (total amt approved, avg credit score...
  5. wxkeep

    Simplify a process

    For the past year I have been responsible for a database at work. In the beginning it simply kept track of loan applications (date, score, name, source, decision, etc). And I had one report that would show all the applications as well as summary numbers (total amt approved, avg credit score...
  6. wxkeep

    Look at next record

    I have database that runs a query across several tables. That query's results are then sorted by department, office, employee, date, receipt order. The problem is - there is no unique or primary key anywhere in this data. The departments are numbered 1-25, each department has an office...
  7. wxkeep

    Determining if primary key exists

    I know this question has been asked numerous times - but I have to be honest - I've become very confused reading through posts looking for answers. I have an unbound form. Where the user is going to create a new record in tbl2. tbl2 has a field that is linked to a primary key in tbl1. And...
  8. wxkeep

    Mimic a Sort/Group list on a form

    Have a form that lists all of my customers - with a "detail" button that opens up a new form with all the specifics. ie. Mickey T Mouse Account Number click for detail Daffy Duck Account Number click for detail Each customer has relationships with a variety of...
  9. wxkeep

    combining text boxes (or labels)

    In my database I have an opening screen - essentially a list of all the records in the database. It doesn't display all the data - obviously - just some of the key info - like an account number and a full name etc. Well, the name is split into three fields - first middle and last - but in my...
  10. wxkeep

    Best way to design my tables...

    Need some help with ideas for my database design. The database tracks various projects that our company monitors. Each project will have a case that its related to, typically there is only one project per case - but sometimes there can be multiple projects per case. As information comes in -...
  11. wxkeep

    update field without code?

    I have a button (actually a label with an onclick) that when you click it - it sets the value of a nearby textfield to today's date. I'm using VBA code (code builder) to achieve this. I have more than one label though that to assign this too - and wondered if there were an easier way - perhaps...
  12. wxkeep

    Recordsource of mainform used by subform

    Alright - I may have gone about this COMPLETELY the wrong way (which may explain why I'm confused and begging for help). I have 4 tables: Project Bids Company Bidders And all 4 tables are linked together by generated id numbers. There is obviously only one record for each company - but that...
  13. wxkeep

    Relationships, Grouping, Aggregate Function - make it simple

    Well, I have been posting for the past couple of weeks regarding this project and now I fear that I've become more complicated than I need to be and would love some insight from everyone here. I am building a salesman database. It has evolved to the point of having three tables for...
  14. wxkeep

    requery

    Probably another simple question. I have a form with a subform. The main form has a combobox on it. That combobox has a list of employees in it. The subform displays the result of a query based on an employee id number ( a primary key among the tables queried by the query). "SELECT <lots of...
  15. wxkeep

    Problems Sorting an SQL Query

    I'm working on a database that stores sales information. I have a query on said table that does a lot of calculations based on region. All of my salespeople have an id, a region they are in, sales numbers, success ratios, etc. The query I have designed is more concerned with the regions than...
  16. wxkeep

    Mulitple After Updates Using the same code

    I have about a dozen textboxes on my form - each with a Private Sub txtBox1_AfterUpdate() runFilter End Sub Where runFilter is a sub that I developed that checks the status of all the textboxes to build a filter. Here's my question, is there an easier way for each of these controls to...
  17. wxkeep

    Formatting the appearance of my datasheet

    I have two forms (one is a subform of the other). Essentially the subform is just a datasheet view of my entire table. The main form has a few textboxes that when updated filter the data below for easier searching. But it doesn't look the way I want it to. My datasheet view has a row and a...
  18. wxkeep

    Simple Question: Arrow Keys and textboxes

    On my form, when I tab into a textbox containing a short date (with an input mask of short date) it highlights the entire date. This is fine because if my user starts typing - they will start keying in an entire date. But many of my users do not need to change the entire date so they press the...
  19. wxkeep

    Multi Field Combo Box

    This will probably seem really easy, but for some reason I can't even come close to developing and idea for how to make this work. I have a database of people, named tblPeople, with about 20 fields. Among these fields are: First, Middle, and Last. Which, obviously, are meant to hold the...
  20. wxkeep

    Multiple Counting SQL

    This is probably a very easy question. I have one database that contains several columns of data. In this instance I'm only concerned with two: Customers and Status. Now, typically there are only about 10 customers - but there are 75-100 records (meaning that some customers have several...

Part and Inventory Search

Back
Top