Search results

I use access 97, not 2000 :D

Where do I find this feature? I don't remember seeing it under TOOLS/OPTIONS....?

Landscape mode I somehow managed to screw up the orientation of all my reports & now, despite the fact that all the reports show LANDSCAPE under the print preview option, they continually open in PORTRAIT. What’s to be done in this instance, where the setup is specified, but completely ignored &...

you use the ListIndex property

Commandbar combo box object I’m unable to find the property that sets a command bar combo box’s default value, is there even one? How can I set such a value? Please advise.

How to attach command bar object label The .DescriptionText and .Caption property don’t stick a LABEL beside a command bar object, could someone tell me what property does? Please advise. :D

Thanks for your help I got it, I fixed the references to 8.0 library & added a missing DIM statement for newCombo.

Editing a command bar I’m having a hard time deleting objects like a combo box from a command bar. I constantly wind up adding to it rather than deleting from it. I have macros that were designed to do both adding & deleting but nothing works for the delete part right now. I get a “Named...

Well I’m going the sophisticated way & trying to create my control in code & have linked the below function to a macro that runs when a report is run, this way after the report is run, the user has the option to further filter the results. However, this code tells me “Variable not defined” on...

Toolbar nightmare I’m trying to implement toolbars as a way to help filter reports & forms in my system, but I’m really stuck here. When I drop a bunch of controls onto my tool bar a couple of things happen: 1 – The control remains “greyed out” – ok granted I understand this as I haven’t linked...

CTRL Semicolon By accident I pressed CTRL + Semicolon & to my horror found that it can populate a field similar to CTRL + Colon, but what info is CTRL + Semicolon copying? I can’t tell. Please advise. :D

Are you aware of any applicable thread?

Crosstab Is it not possible to formulate a cross tab which reports on details as opposed to using aggregate functions? I have a column headings by region and row headings by type, but would like the results to be details separated by commas, say something like “item1, item2, item3…” Please...

Refresh report I’m currently trying to add buttons to a report so as to filter them further, by year for example. Is this a good approach and could someone point me to an applicable post as I can’t find any just now. Please advise.

Alignment What’s the quicket (easiest) way to align a text box underneath its label in report design mode? My text box is significantly smaller than the label and would like it centered exactly under its label rather than me manually moving it wit a mouse. Please advise.

That doesn’t help since I was doing that from the beginning.

Resizing forms I can never align my form detail and footer properly. When I run the form the window size is never exactly right to accommodate all the sections. It always seems as though the detail section is little bigger than the current screen size. This frustrates me to no end because if...

Tab index I specified the tab order on my form but whenever I goto a new record the cursor defaults to a field that is not correct.

Report prints no data In my report’s on open event I’ve called a macro that will filter the data. Currently, my report shows nothing. My macro is a single applyFilter action with a corresponding WHERE clause as such: [Reports]![rptJoe]![RetailerNumber]=50138 This field appears in the detail...

I just solved part of the problem as I was running an old function before the new SELECT CASE statements I entered. Now I’m working on whittling down that list even more.