Search results

Another question I have a text box followed by three drop down boxes (Combo boxes). After I Input a number into the text box I have a query that runs to give me information on that number. SELECT [tbl Matches].Date, [tbl Matches].[Guest Team], [tbl Matches].[Home Team] FROM [tbl Matches] WHERE...

I have a text box followed by three drop down boxes (Combo boxes). After I Inpute a number into the text box I have a query that runs to give me information on that number. SELECT [tbl Matches].Date, [tbl Matches].[Guest Team], [tbl Matches].[Home Team] FROM [tbl Matches] WHERE ((([tbl...

I have a form with two drop downs (combo box) School and Players. The first drop down I select a school. After I select the school, I go to the next drop down (combo box) and select the players I want. When I go to the second combo box (players) its has a query that runs for me. It takes...

I want to create a form that will update a table. I have two columns, an item number and a paid column. On the form I want to plug in the item number and then I want to hit ok and it will find that item number and put a value (for example "X") in the paid column. I have tried running an update...

I am not sure if this is place to put this. I am running an auction. I have a report that runs from a table. To get this report I run a form that I plug in the paddle number and prints out their receipt with all the items they won. Sometimes they will come up and want to pay each item...

I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?

I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?

I am trying to make a query with two tables. Each row consist of a student ID, their name and all their personal information. Both tables are exactly the same. But one table is a link table. That link table gets update every so often from an outside program and the other table is not linked...

I have a text box that has an Input Mask setup. The box is format to be ##-### (00\-000;0;). My problem is, when the user clicks in the box it does not start at the beginning, it starts where ever the user clicks inside the box. Is there way to for when you click inside the box it...

I have a command button that brings up a report on my form. After the report comes up and the users has viewed it and printed it, I want a message box to come up saying "Are you done with the report." But when I set up the message box it comes up right after the report comes up. And the user...

I have a one page form set up into 4 different sections. Each section has its own command. First section is Radio buttons with a drop down list. The next three are text boxes. I have a rather simple question, next to my OK command button I want a to create a button that will say "Clear" and...

I have 4 check boxes represent 4 grade levels. When I click on a grade I have a query run for me a list of all 9th graders or 10th graders or both together. When I run the form for the first time, all four boxes are check, when I unclick all of them and I click which ones I want the form does...

I am trying to make a form that will allow me to make several selections and run a report. I want to be able to select from a list of Grade Levels, 9th, 10th, 11th and 12th. After I have picked my grade level or selected more then 1 grade level I want to be able to choose from a drop down list...

I have created a report that has string text from a query I created. The query, with the string text, take the information from a table. When I run the report the string text gets cut off (The box is big enough to hold the information). The table I have is a linked table to a text file that...

I am trying to add a find button to the form. But I keep getting an error saying "Error accessing file. Network connection may have been lost" I have a feeling it has something to do with the Event Procedure. Any thoughts?

I am trying to count how many times a name comes up. I dont want to tally how many in field. For example. I have a field name: School District. Underneath that I have hundreds of schools. I want to know how many times JFK High School or Plainview High School in a report. Thank you

I have a table with book information. I want to be able to change information in that table by using a form. Is there a way for when the form opens, to type in the books number to bring up that information so I can change it?

I am creating a letter in a report for parents. In the report I want it to figure out whether it should say son or daughter. I do have a field for sex (M/F). Is there a way to tell the report to say son or daughter base on the sex field?

I am creating a letter in a report for parents. In the report I want it to figure out whether it should say son or daughter. I do have a field for sex (M/F). Is there a way to tell the report to say son or daughter base on the sex field?

Can you append to a table that is empty? If you can please let me know. I made table through "make table" query and now I run the append query to the empty table but it is not putting any information in the empty table Can you append to a table that is empty?