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

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

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

Lets say I have a table: Where "petID" is ofcourse the pk, "name" is the name of the breed, and "type" is the species of the pet(dog or cat). There is also another table - "Cages" - with two fields - "cageID" as the pk, and "pet" which is linked to "Pets.petID". Now, I've made a continuous...

Sometimes, when I open a report via a "DoCmd.openReport" command(a filter is used), I can't close it - the X button turns gray, as well as the close item in the right click menu. The only way to close the report is to go to design mode and close it from there. Does anyone know why this happens...

In continuous forms, is there a way to use a VB command on a single form component? If I want to do something(like changing a textbox) on only ONE form, is there a way to do it? Is there a way to filter the list in a combobox, so some records won't be displayed in the list, but if a value...

I have a few questions about formatting the controls in a report. Does access have a stretching text control? Something that works like WordArt in Word, where you write in the text and specify the height and width, and the text's size automatically change to fit? How do you get rid of the...