Search results

Anyone else have an idea. I would like to use a check box to check the grade level and a drop list for all of the school district and then be able to hit a command button "Enter" to run it.

It sort of was but it is not really working for me.

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

Yes it is. I kind of worked it out. I just made two string text. Broke it up into two sections. As you said "Well it will work, if you want to put in the time and effort." Just have to be creative. Thanks for your help.

Cause it is to big. Its over 255

That is not going to work. Its to much work and its hard to try to put it in to boxes and line them up together. Thanks for the idea though

Can anyone help me with this?

I attached the database. When you run the report Add/Drop just hit ok the error messages. The query with the string text is called "qry Add/Drop Student Data (active)" The table with the student info is called "tbl STUDENT DATA - ACTIVE". Thanks for any help you can give me.

I knew you where referring to that but in the table, the field for sex is set for 255 but so is the one for the non linked table but it still works

i did not know that you could set the string to 255 characters long in a query, where can that be done?

No its not. The linked table and the non linked table are set up the same way. Everything matches. The string text only gets cut off from the linked table and not the non linked table. (keep in mind I created the string text in the query)

The string text appears to be the same in the report as it is in the query for the linked table. In the non linked table, the string text gets cut off in query (even though in the expersion builder it shows everything) but it shows everything in the report

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 put the code in VB but it does not seem to work.

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 could not find the option for Running Sum un the sorting/group feature

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?

That worked prefectly!!! Thanks a lot!

Which field?