Thankyou so much, Hymn.
I tried the online and offline help files before posting here.
Thankyou for taking the time to point me out one method and doing it so quickly. MFFL-
Mavericks Fan For Life
:+) I hid my tables of my Access 2000 Application by right clicking them and setting shortcut properties to hidden, so the user would never think of messing with the tables.
However, is there away for me to show them again? or recreate shortcuts for each table in the database window.
Ive found...
honestly
opensource benefits everyone, me being able to look at your code is not going to devalue what u do. u in return being able to look at others code will make u more valuable.
bottomline just because some can look at your code doesnt mean they will, there is a reason why people hire...
not urgent, not important really, just curious.
i have no trouble referencing changing rowsource of combobox using:
.rowsource ="Select..."
However I would like to know if its possible to reference a query.
I figured [Forms]![membersModify] worked to access a form so I tried...
Thanks fellas, really, thankyou both.
I knew it was something obvious, I guessed I had worked so long yesterday I worked to the point of unproductivity.
MMFL-
Mavericks Fan For Life
this what i had and worked:
Me.lblNone1.visible = false '... to lblname10
Me.reqPref1.Caption = "" '... to reqPref10
Me.ComboReq1 ="" '... to ComboReq10
and so forth...
This is what i thought I should change to:
Dim i As Integer
For i = 1 To 10
Me("lblNone"...
dang it, I knew the answer to your question AccessAce, vbSlammer is quick, hopefully, I have other chances to return the favor. MMFL-
Mavericks Fan For Life
AccessAce, DJN thankyou for your guidance. I gave you both stars.
JeremyNYC, get off your highhorse. while i have not given a lot of advice in access forums i have in other forums here. I also, because I do depend on help here, make donations (financial) to this forum. I also award stars...
thread181-427995
this was posted in the "Access Other Topics" forum it deals with printing and a dialog.
Thankyou for taking your time to look, even if you don't know answer. MMFL-
Mavericks Fan For Life
Sticking with the baseball analogy.
AccessAce consolidating the reports into one is not an option.
I need to be able to print 28 seperate reports with team headings on each report. With only the batting averages of such and such team on such and such report.
You understand my dilema now...
For instance want to print say baseball batting averages report. Dialog pops up with listbox to select which team's roster i want to print.
now is there a way to create a button that prints the batting averages reports of all the teams in that dialog box?
need guidance
any help much...
sothink <- if you're intentions are good.
AS2FLA <-- looks most promising, but not quite there, if your are intentions are not.
give me a star if this helped you. MMFL-
Mavericks Fan For Life
zip w/out winzip?
windows XP seems to zip files and i don't have winzip installed.
is there way to automate zipping w/out installing it?
not an urgent question just curious how to approach it. MMFL-
Mavericks Fan For Life
RickSpr
yes, that worked great!
it must've seen so obvious to you. i'm very thankful you took the time to reply and point it out. that's why i gave you a star. MMFL-
Mavericks Fan For Life
a2brute,
your right, smart to rename the textbox
but can't use .text property? not sure why not?
the solution i came up was with create in the query that is the recordsource for the report.
still interested in using .text property though
for instance having difficult time changing a...
i get:
Run-time error '-2117467259(50004005)':
Method 'Text; of object'_CommandBarComboBox' failed
when i try to execute this:
Public Function CmdBarChangeText()
Dim cbr As CommandBar, Dim cbrCtl As CommandBarControl ' Set a reference to the Access menu bar
Set cbr =...
cbrCtl.Text = "Something Else"
doesn't work can someone tell me why? and how i can change the .text property of a msoControledit without reloading the whole commandbarmenu.
much appreciated
MMFL-
Mavericks Fan For Life
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.