Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 -...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...