Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

I run my query below, but I don't get any output. I outputted the URL.CatID to be sure that was getting passed, and it is...so it has to be something with my output statement. Help please! <cfquery name="GetQuestion" datasource="FAQ"> SELECT * FROM FAQQandA WHERE FAQID = #URL.CatID#...

I have a book mark set up like this: <a href="###GetCat.CatID#"><h3>#GetCat.CategoryName#</h3></a .. .. .. <cfoutput> <a name="#GetCat.CatID#"><h2>#GetCat.CategoryName#</h2><br></a> </cfoutput> My first <a href> displays the category names at the top, hyperlinked to the bookmark I have set...

This is what I got so far. I'm looping my category names into a table and trying to link them to sections on the same page below the table of categories. What am I doing wrong? <cfoutput> <cfset I = 1> <cfset columns = 3> <table align="center" cellspacing="5" cellpadding="5" border="0">...

This should be pretty simple, I'm just having a rough day today. I want to display hyperlinks at the top of my page, and when one of them is clicked, it will jump down to the correct info down the same page. How do I do this??

Here is my query: INSERT INTO Car_Checkout (CEmp_ID,CCar_ID,Date_Out,Date_In,Odometer_before,Odometer_after,Destination,Miles_Travelled,Business,Personal) VALUES (#form.EmpID#, #car_id#, #CreateODBCDate(form.StartDate)#, NULL, #form.car_present_odometer#, NULL, '#form.Destination#'...

Here is my SQL statement: <cfquery name="EmpIn" datasource="Mileage"> SELECT EmpID FROM Employee_Info WHERE First_Name = '#Form.FirstName#' And Last_Name = '#Form.LastName#' </cfquery> I get a "too few parameters error. Expecting 2" error. What is the problem here?

How do I open a new window after clicking on a hyperlink?? First person to answer this correctly gets 2 points...

In my database, I have a column of hyperlinks for the assigned companies. For example, if ABC Company has a website, in the HYPERLINKS column in my database, it has http://www.abccompany.com or something. It's not a real website, but I'm sure people will click on it anyway...;) I have...

I have a table that has two columns, COMPANY NAME and CITY. The company can have locations in many different cities. I want to display the company name once, and the under CITY, have the cities listed...seperated by commas or something. How can I do this??