Search results

1) Is there a way to create a global variable in VBA? I mean a variable that I can use no matter which document is open? 2) How can I create a text box in Word using VBA? I figured I need to do it with the CreateTextBox function, but how can I set the properties of the text box, and how can I...

Sorry for the trouble guys, but it turned out that I didn't need it after all. All I had to do is add a blank field to the query, and use Word to turn it into a numbered list. Anyways, I think I'll still add a number field to the table, to control the order.

Yup. Can it be done?

Well, I want to use a database field in a word document to create an updateable phone list from a database. I need that list numbered, so for that I need a field in the query that represents the number of row.

Thanks, Bob!

Thanks for the idea MStef, but is there a way to reset the function from inside the query? Basically, I need to link to that query as a field from a Word document, so I can't call the reset function from a form.

When I do that, each field that I put there as an index is unique by itself. I need to make a combination of fields unique.

Is there a way to return the number of row in a query as a query function? For example, if I have a table: George John Dave I want a query that returns: 1|George 2|John 3|Dave If I sort it: 1|Dave 2|George 3|John If I filter John out: 1|George 2|Dave And so on. No matter what I do, the...

I know you can set a single field in a table to be unique(not allowing duplications), but is there a way to do it to a combination of fields? For example, if I have a day field and an hour field, and I want to set it that there can only be one row in the table for each combination of day and...

Well, I'm using Access reports to create cuttable printouts from my tables. There is a table where each row represents a single printout data, many more tables linked to it. Now, I want to let the user choose how many units of each printout he wants to print, so I created a table with the main...

Is there a way to make rows repeat themselves several times in a query? Lets say I have a table: value count A 2 B 5 C 1 D 3 E 4 I want a query that gives the result: A A B B B B B C D D D E E E E Each field repeat itself as much times as...

just requery...

There are two methods of doing it. The first one is to use a quary, and make the name the first field in the quary. The default is to display the first field, so if you make the name the first field, it will be displayed instead of the pk. Also, after you do that you can set the "BoundColumn"...

Well, you just need to set up it's "RowSource" property. It can be a quary, or simply the name of the source table. Also, shouldn't a wizard pop when you create a new combobox?

What do you mean by "can not seem to create the combobox"? Is access not letting you draw it on the form? Or is the problem in populating it?

No, that's not what I've meant. I've attached an example with my workaround number 2 - a textbox containing the breed name that covers the combobox. Guess I should have attached it from the beginning...

So, it's not possible, ha? K, thanks everyone. I guess 2 should be good enough a option.

OK, I've uploaded the images as attachments. "petsTable.png" is the table "Pets". "cagesForm.png" is the continuous form representing the cages. "filteredCagesForm.png" is the same form, after filtering the cats out. I only wanted to filter the cats out of the dropdown list in the comboboxes...

That's not it either... I think you'll understand better if you see the pictures. Do you have a problem with imageshack?

Showing all the cages is not the problem. The problem is showing the filtered out animals in the cages that contain them.