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!
-
Congratulations Rhinorhino 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: ivalum21
- Order by date
-
Open form to New Record
It worked great...I just changed the Data Entry property, thank you very much.- ivalum21
- Post #4
- Forum: Microsoft: Access Forms
-
Open form to New Record
I have some forms that I add Students or Classes into their respective tables. Just to make it more user friendly, how do I set it so when I open the form, everything is blanked out and is ready to enter in a new record? Right now I open the form and it displays the first record, then I have...- ivalum21
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Using combo boxes
I have two tables...Classes and Rooms. I have a form where I can add new classes and assign it a room. The rooms never change, so I am using a combo box to assign the classes to a room. But when I add a new class and select a room from my combo box, it adds a new RoomID into my Rooms...- ivalum21
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Create a "Next" button in Excel
Is there an easier way to create a "Next" macro in Excel than just recording a new macro and clicking on the next worksheet? I would like a button that I can just copy from one worksheet to the next that will go to the next page. Same applies for "Previous" button. Any assistance would be...- ivalum21
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
run a query on if a checkbox is checked
Okay, I just figured it out... In design view of your query, under criteria you put: =Yes That will display all the checkbox's that are checked.- ivalum21
- Post #3
- Forum: Microsoft: Access Other topics
-
run a query on if a checkbox is checked
I am drawing a blank on how I run a query on if a checkbox is checked. I have a table of people, and in that table is a column that specifies if they are a "Leader", if it's checked, they are a leader. I want to run a query on all the "Leaders" in the table...how do i do this? thanks for any...- ivalum21
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Can I use the TRIM function with a bound control in an Access report?
Do I change it in the Properties > Data > Control Source?? Because when I change it there, I get an error...- ivalum21
- Post #3
- Forum: Microsoft: Office
-
Can I use the TRIM function with a bound control in an Access report?
I am making an Access report...in this report I have a section that lists a person's First Name, Last Name, Address, City, State, Zip. Is there a way I can apply a trim function to those bound controls, so I don't have to worry about there being a lot of space between someone's first and last...- ivalum21
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
creating a font/color template in HTML
Is there a way that I can change the font/color scheme of my entire webpage? I want all of my pages to have the same font and color scheme...is there an easy "catch all" way of doing this?? -
SQL stuff
In my database I have a table called Employee. Within my Employee table I have a column called EmpNo...along with EmpName, EmpPhone, etc. ALSO in this table I have a column called SupEmpNo (Supervisor Employee Number). In that column I have the employee numbers of their supervisors. What I... -
SQL stuff
Okay, this is kind of weird... I have a table that keeps track of all of the employees for my company, we'll call it Employees. Within this table is a column for the supervisor for each employee. Since the supervisors themselves are employees, they are also in in the Employees table. So Joe... -
SQL statement
Here is my SQL statement: SELECT OrderTbl.OrdNo, OrdDate, OrdName, (ProdPrice * Qty) AS TotalAmount FROM OrderTbl, Customer, OrdLine, Product WHERE OrderTbl.OrdNo = OrdLine.OrdNo AND Product.ProdNo = OrdLine.ProdNo AND Customer.CustNo = OrderTbl.CustNo AND OrdDate = #1/23/2004# I need it to... -
More SQL
Okay...I have a list of customer orders with their totals. They are grouped by the items that were bought, so if you bought a car, that is one record, and if you also bought a truck, that is another record with the same order number. How do i group those two records to display the total amount... -
-
SQL Question
Okay...that worked, thanks a lot! But I was trying this for the fun of it, what if i needed to add in that the AvgBal needed to be less than 100? I tried this: SELECT CustCity, AVG(CustBal) AS AvgBal, left(CustZip, 5) AS ZipCode FROM Customer WHERE CustState = 'WA' AND AvgBal < 100 GROUP BY... -
SQL Question
Here is my SQL right now: SELECT CustCity, AVG(CustBal) AS AvgBal, left(CustZip, 5) AS ZipCode FROM Customer WHERE CustState = 'WA' GROUP BY CustCity It works fine when i take out the ZipCode part in my SELECT statement...how can i get it to work with the ZipCode part? -
SQL Question
I need to run a query that will take the average balances of customers by city. So for example, I would need the average balance for all customers from Chicago. So I would display one row for Chicago with the average balance of all customers from Chicago. I try using the DISTINCT function... -
Output displays more than once
The DISTINCT clause just ordered the repeated questions together. And when I changed it to just <cfoutput>, it only displayed the first question, and not the others. -
Output displays more than once
The output I am getting is correct. But it displays it three times, instead of one. I am display a question, and the answer to that question. I want it to run through that and display each question and answer once, but it displays it three times. Any ideas?? Here is my code: <cfquery...
