Search results

I'm confused by what you mean by field in (1,2,3) attached is an example of what I'm trying to do if it helps... (although it works in this one because there aren't as many yes/no tabs as my actual db).

Apparantly the code works for all types of fields (I should have checked first); however, my new problem is this... I receive an error that says "The filter operation was cancelled, The filter would be too long". I figure it's because I'm trying to create a where condition for each field...

Hello Guys, I attempting to develop a code that generates a report via a form with text, numeric, and yes/no fields where the user can enter desired parameters in the form and click the "btnReport" button. It works for the text fields, but I don't know how to alter the code to work for...

Thanks Bob, but I'm not sure that's what I was looking for. I'm actually trying to set it up so the same form that I use to input data into a table can be used to generate a report based on the parameters entered. The types of fields on the form include text boxes, cbo boxes, and yes/no boxes...

does the code send the data to a report or filter the form itself? Thanks for the info.

If that's possible, that'd be cool...As long as by using the same form, I don't create a new record in the process. I know there's a code you can add to your thread that tells the program to undo the entry, but I can't remember what it is. It's been a while since I've messed with Access.

Hello All, I'm sure this has been covered before so I apologize ahead of time if someone has to submit a link to a previous thread... I have a basic form that displays records. How do create a form that looks exactly like the first form but is used as a query to tell a report which records...

hello all, It may sound like a simple question, but I'm very new to this...I'm considering buying a web template and was wondering if an html page can have code (php?) written into it to retrieve information from a database? How would that work? Can I just save the edited file with...

Oh... Thanks a lot for your help.

That didn't work, but I got it to work via your other recommendation. I changed the box from fldStatus to boxfldStatus (vs. chanigng the txt) and now it works. Is it that having the Box name and Row name the same causes conflicts?

how do I do a select case structure

I have two reports that look similar except that one grabs directly from the table and the other via a query. Each report has a box (box30) that I want the BackColor to change either green, red, or yellow based on the value of one field. When I entered the following code in the On_Format Event...

I added the code as you recommended for a second filter, but it doesn't seem to recognize the second filter I put in. The first filter still works just fine. I tried using the "AND" operator instead of "OR" but the listbox came up blank. Could you possibly add to your posted db so I can see an...

Darrent, did you ever get an answer to your question? I would like to know this too, and if vice versa is possible as well.

Thanks for the help. I got the first part you presented to work. I saw you said to either add a filter, requery action, or complementing operator to allow the additional lines to do the same. When you say add a requery action, do you mean repeat the code for each and add a...

Hello all. Don't know if I'm doing this correctly, but I previously started a thread that went dead before I could get a solution: Basically, I am trying to create a subform that allows a user to select criteria to filter records by. When the user hits the "go" button on that subform, I...

What is an AACDB?

If you build a DB in Access 2007, can it be operated in earlier versions?

Hello, I have a main form with textboxes, selecting buttons, a save button, and a subform. Each selecting button brings up a different subform: each containing a different listbox. I set the save button to refresh the listbox by entering the following code...

It would apply more than one filter. I.E. - SELECT fldAnimal = Dog AND fldcolor = brown Result: Record 1. Bailey..........Brown..........3YO..........12LBS Record 2. Ms. Bailey....Brown..........7YO..........29LBS