Controlling display of forms
I'm trying to control what parts of a form are visible or not depending
on the user of the computer.
I've managed to find and adapt some code to tell me who the user is and
I have a table set up with user names and a permission level (1 or 0)
I can manually alter the On_Load event of my form to hide the parts I
Can anybody help me out with putting it all together so that the forms
On_Load event looks at GetUserName function which looks at the
UserPermissions table and sets Visible True or False accordingly.
This is taking me so long and it looks like it ought ...recall of infor on a form
I have created two tables: table one has basic info lname, fname, grade,
student id number. Table two is an incident report form with fields: student
id number, date ,grade , etc. I have a relationship from table one to to
table two in a one to many relationship respectively. My user wishes to enter
incidents on a form. So I created a form from table two and all works as
planned. However my user would like to enter either a)student number or b)
last name with out using a drop down list( long list of choices.) and then
have it display both student number and last name then save...Can I print a 18" form in Excel
I need to print a custon contract form excel. I do not have the parper size
I need is not in the drop down in the page set box?
Excel should adapt to whatever printer you have, if you don't have a printer
where you can customize the print size then excel won't give that choice
either, it's all in the printer
"peetzaman" <firstname.lastname@example.org> wrote in message
> I need to print a custon contract form excel. I do not have the parper
> I need is not in...Calling a SQL stored procedure from modified form button by VBA C
I have a requirement to call the SQL stored procedure from GP modified form
through button press and I do not want to use dextertiy development for this,
I so can anyone show me how to do this through VBA code.
Thanks in advance.
Use the following code:
Dim conMain as New ADODB.Connection(ConnectionString)
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
"Dexdev" ...Tournament Brackets
How do I set up a tournament bracket in Excel?
Microsoft Template Gallery has a few templates for tournament bracketing.
Gord Dibben Excel MVP
On Tue, 4 Jan 2005 16:23:02 -0800, billymick
>How do I set up a tournament bracket in Excel?
...Help with user form
I need help with a user form that basically mimicks my worksheet. I need to
get the data from the 29 text boxes on the user form to the matching columns
and row on my worksheet.
My worksheet looks like this:
V# Vendor Name Inv-No Inv Amount Cat Amount Cost Retail Cost Retail
the above columns are repeated 4 times
My user form basically follows the same form. I need to have the user enter
the data for the invoice which is then copied to the worksheet, and start the
process over again until all invoice are entered.
Any help is appreciated, I have been struggling with th...print w2-g forms (gambling)
Can Great Plains print w2-g forms? Are there any 3rd party solutions to do
...Firing Change event from popup form
This code is on the AfterUpdate event of a list box on a popup form.
Private Sub Company_AfterUpdate()
Dim frm As Form
Set frm = Forms![LoadSheetsMain]![LoadSheetsST].Form
frm.Controls(OpenArgs) = Me.ActiveControl
It assignes a value to a textbox on the calling form. I need to fire the
change event of that textbox, but don't know the method.
Thanks for any help.
Mark A. Sam
The change event of the textbox must be Public. You can then call it from a
different control or form:
Mark A. Sam wrote:
>Th...Form based on crosstab query
I had set up a form and am having trouble getting information from a crosstab
query into it. In the expression builder I can go to the query I want and
pull any info except for the crosstab portion. I tried setting the forms
recordsource property to the crosstab query then everything I had done
disappeared. Deleting that brings it all back. I'm obviously clueless
How can I successfully import crosstab query info into a form control as
For a form or report you need to know the column headings or it will bomb
out. There are two ways of doing thi...Control Form form a Sub Form
How do I activate a command button on the main form when I double click on
the sub form?
"TonyAntique" <u59027@uwe> wrote in message news:a5a6118d13dbf@uwe...
> How do I activate a command button on the main form when I double click
> on the sub form?
The code would be like this:
Me.Parent!Command99.Enabled = True
But you'll need to define "double-click on the subform" more precisely. It's
probably the dblClick event of the subform's Detail section you want to use.
Allen Browne - Microsoft MVP. Perth, Western Australia
T...Creating a form to query data
I have a linked table that contains various rows of data. I cannot
modify the data in that table. However, I would like to create a form
where users can go in and select rows from that table. What I am
envisioning is a tabular form where some fields from the linked table
are shown and the user can then click a checkbox next to the row that
s/he wants to select.
I am completely blanking out right now how to approach this. Any help
would be greatly appreciated.
...How do I create a clear filters button in a form?
Just looking for a way to have a quick way to clear any filters created on a
form. If its a visual basic command please be specific on how I do it
please. :-) thanks in advance for any help!
>Just looking for a way to have a quick way to clear any filters created on a
>form. If its a visual basic command please be specific on how I do it
You can turn off the current filter by using:
Me.FilterOn = False
You can clear it with:
Me.Filter = ""
If that's not what you want, please explain ...CRM 4.0 : How to have a pre-selected price list in quote forms
In my crm application, I have just one Price list. When I create a quote, I
would like to have my Price list pre-selected and not that the user have to
(It is the same for th unit in product...)
Do you have an idea how to do this ?
Thanks for tour Help
You may write Javacript to populate the PriceList field in the onLoad
property of a Quote. You may refer to CRM SDK if you would like to
learn more about client side scripting.
Darren Liu, Microsoft CRM MVP
On Dec 16, 7:41=A0am, Fr=E9d=E9ric BAILLON
<FrdricBAIL...@discuss...form for bank reconcile
does anyone have the format for this? It sure would save me some work!
Just the basic format. Thanks so much.
There are at least two good examples that you can download available via this
> does anyone have the format for this? It sure would save me some work!
> Just the basic format. Thanks so much.
...Can't Send HTML Form Reply
I received an HTML form from Staples to update my information, however, when
I click the [Submit] button, I get a message saying my security settings
won't allow it.
What security settings?
outlook's security settings. If you open the message and choose View, View
in internet zone it should work... however, if the information you are
updating at staples is anything that could be used by scammers, you should
go to the staples site and correct the information. A favorite trick of
scammers is sending out this messages to trick you into giving o...Is it possible that a button in a form deletes the form?
I'd like to know if it is possible for a form in a workbook to have a
command button whose click action deletes the form and saves the workbook
(with the same or different name) without the form.
Thanks in advance.
That is possible. Personally I don't like VBA code to delete things from my
workbooks. I would prefer a solution that changes the value of a certain
variable, so that the form won't show up anymore. You will need to check for
the value of the variable on every form-call, but at least it won't do
anything to your spreadsheet that cannot be reversed......Where is the Microsoft Money Plus Deluxe\TaxCut $40 Rebate form
I just purchased the Microsoft Money Plus Deluxe and TaxCut combo from the
following offer from Money 2007. I was provided with only a $20 rebate
form... what's the
You need to make sure both packages, Money and TaxCut are the versions that
have the rebates, not all packages do. It is clearly labeled on the outside
of the boxes
"Brandon" <Brandon@discussions.microsoft.com> wrote in message
>I just purchased the Microsoft Mon...Making a search form
I need help writting code behind a search form i made.
It has combo boxes of different things you can search by account number,
Date etc what is the code behind the button that will make another form pop
up with the info i asked to search by in it?
>I need help writting code behind a search form i made.
>It has combo boxes of different things you can search by account number,
>Date etc what is the code behind the button that will make another form pop
>up with the info i asked to search by in it?
Here's a article on that topic:
http://allenbrowne.com/ser-...Recording Sports Tournaments
I am trying to concoct a spreadsheet that will keep a track of sport
tournaments as they progress.
The tournament format is one of four pools of four teams, the top tw
teams progressing to the knockout stages.
I have a list of the fixtures and cells in which to put the score
during matches. From these cells I want to know how I can get Excel t
calculate league tables for each group.
I know there is a RANK function that may be of some use but it is stil
a mystery to me how to run league tables in Excel and moreover how t
present four different leagues on one sheet.
If anyone has expe...cloning forms
I come to MS CRM from the S**b*l world. If I am creating
a vertical app that will use the same schemas for
different purposes, I might need two different accounts
forms, In the other app, we just clone the forms (applets
in that world) and modify - then use security to decide
who gets what. In MS CRM, do I make a copy of the ASP
file, create a new ASP page and link it in, or what?
Sorry if this is a bit vague - I am trying to make a quick
demo up, and cannot find the nswer easily in the doc.
Unfortunately, there is not built-in support for what you are tryin...Form Help.....
I am hoping someone can help.
What I want to do is have my forms show up with a drop down box
showing my client names and then when I select my client the form
should show all my accounts for that client.
I do not know how to do this or whether this should be done from my
I hope someone can help.
Thanks so much,
I have one table which I plan to expand as my database become more
The fields in my table are Client, Account, Date1, Date2, Date3,
I want a form to filter down to show only the records relating to my
I am also going to tr...how can i adjust this tournament bracket?
I am not an exp. Excel user.I already have the tournament template of the
microsoft excel website. I am trying to make a tournament bracket that lets
you pick the winners by choosing a picture. Once you pick on a bracket it
shoots you to a screen with a picture of the opponets with a button under
each one. You click on the one you want to win and move on to the next
bracket. It also has a reset button that will randomly moves the opponets
around so you dont use the same order over and over again. any help with be
Just for info...........you can Right-click > Assign Ma...Create order
I have a database with tables:
I need to create a form for entering a new order.
Essentially it needs a way to select the customer who the order is
And then it should have some sort of list/table where I can add a new
line for each item on the order.
Can someone please give me a detailed insight into how to do this?
Thanks in advance,
On 2 May 2007 11:56:16 -0700, BigAl.NZ@gmail.com wrote:
>I have a database with tables:
Surely a table of Products as well...!?
>I need...Form Query Refresh
I have setup a form with multiple tabs that represent each milestone
of the process. A query supports each so that items "move" from one
tab to another based on what stage the item is at, allowing the user
to select the item & click a button to enter their portion.
This so far works great except that the data on all of the tabs is
only valid as of the time the form is opened. Is there a way for the
information to "refresh" on a regular basis without closing &
reopening the form?
"David" <email@example.com> wrote in message
news:cea2d...Calculate total amount on continuous form line in sub-form
I’m on Access in Office 2003.
I have a sub-form which has a default view of “Continuous Forms”. This form
is comprised of a single line which has the fields:
Work Date Hours Miles Other Expense Total
The work date, hours, miles, and Other expenses are data entry fields. The
Total field is equal to (Hours * HourlyRate) + (Miles * MilageRate) + Other
Expenses. The rates are retrieved from the main form. That part is working
The Work Date, Hours, Miles, and Other Expenses are bound to fields on my
table. The Total field is unbound.
The problem ...