Search results

John, can you explain a little more about the "Or" argument, I have tried several combinations and I can't get any returns when I run the event procedure. Can you show an example of how the "Or" argument should be used. You also mention that my code is missing a few elements. I am not sure...

I am running the following event procedure and would like to know if it is possible to return more than one selection. As an example on Private Sub Command90_Click() I would like to return "Y99" & "Y98" & "Y97" So that when the "Yesteryear Quick Search Form Query" opens it will return all models...

I have a table for pictures of cars where I am setting up the default value to be "C:/mypictures/cars/buick.jpg" Can I have the default value automatically import the cars ID field & NUMBER field As an example the buick is ID = 123 and the NUMBER is 01A I was thinking of something like...

I have a table with 25 different cars in it. Each record has a picture associated with it. I would like to ba able to display these pictures in a 5 x 5 grid on a report. When I select (click on that picture) I would like to see a larger version of it. I can only seem to get the 5 x 5 grid with...

Paul, Thanks for the info, but the only way I can display the report is in print preview to show the 5 x 5 grid, otherwise when I open the report it just shows the single column. The only option that I have in print preview is to zoom in or zoom out on the page itself. Can you offer anymore...

Hi Everyone, I was wondering if its possible to put columns on a form? As an example I have a master table with 25 cars, I want to have a form that displays all 25 pictures (5 across, 5 down). I want to be able to select the image and enlarge it by clicking on it. I know I can set up a...

What is the best way to store pictures on a form. I have close to 5,000 pictures that I want to store in my database. On the form that I am using I show a main picture, front, left, rear, right, base, & box. I would like the pictures to display as soon as I open the form. Right now I have to...

John, This solution works great, I have a catagory called "catalog", since a catalog doesn't have a box, is it possible to set it so that it doesn't open a form when the catagory is set to "catalog"?

I have a "Master Form" where I enter models onto a table. I also have a text box on that form that (on focus) it opens another form showing all the "regular wheel boxes" that are available for that model. I would like to set this up so that (on focus) it will open the "regular wheel boxes" form...

Chris, Thanks for the reply but I want to do this on a form, not a report. Can you help?

Is it possible to set up records so they display across a form and then down as in a 10 by 10 grid? I want to display some pictures but not sure how to accomplish this? Thanks, John

rodmc, Thanks here is what I have Model Name Main Picture Ford Pict1 Chevy Pict2 Nissan Pict3 My control names are "Model Name" & "Main Picture" When I open the form I only want to see the pictures of the 3 cars and...

Is it possible to design a form that will display multiple images even though they have the same control but are from different records. As an example: I have ten cars that I have a main picture of. I would like to open up a form that will display all tem pictures of the cars and then be...

Just the answer I needed.

I have a database form that opens maximized when I open my database. I can enter new records on a sub form, but I set the main form to close when finished. It now won't let me into design view and closes the database. Am I screwed? I can't open any other forms or get into design view to change...

John, your the "MAN" Thanks for all your help, such a simple solution when all is said and done. I'm sure I'll have many more questions before this project is done!!!! Thanks Again, John

John, Thanks but let me give you a little more detail if you can help me out. Form1 is a form that contains cars Form2 is a form that contains boxes I have Form1 set as the main form, when it is open and I am entering data I get to a text box for "box type" I am using the got focus to open...

I have two forms (main form & boxes) when form "boxes" is open I want to be able to press a command button and enter a set value in the "main form" for the Field "box type" on the current open record. Can someone please help solve this small problem?

Thanks Linq, I already have this set up as a combo box and am trying to make it a little fancier with a pop up showing pictures of the boxes that I could easily select. There are about 25 different boxes and having them pictured would make it so much nicer.

First let me give you a little synopsis of what I am trying to accomplish. I am fairly new to VBA code and need some help. I have a form "Cars" that I enter information about my collection into. On that form is a text box for "box type". As I am entering data into my Cars form when I tab to...