Automatically print the LAN ID into a form
I'm developing a form that will collect data from various users. To verify
which user the data is coming from, I want the form to automatically input
the user's LAN ID when the form is printed. Does anyone know if this is
possible and how you would do it?
...How to Enter Same Text in 1000s of Fields
I have a an Access 2003 db of 11,000+ records. Each record has a field named
Product Type. The field is now blank and I would like to enter the phrase
audio books into each field. Can I do this with a query? How?
You could use an update query with a SQL view like:
UPDATE [an Access 2003 db of 11,000+ records]
SET [Product Type]="audio books";
Microsoft Access MVP
> I have a an Access 2003 db of 11,000+ records. Each record has a field named
> Product Type. The field is now blank and I would like to enter the phrase
> audio...Preventing Names in Drop-Down Address Shortcut List After Sending Mass Mailings
I have to send out mass mailings, using Outlook 2003, for a
professional organization I'm involved with. After sending out these
mailings, the e-mail addresses for all of the people on the mass
mailing list show up in the drop-down e-mail address list that
appears when I start typing into the "To" field when sending a new
After each mass mailing, I have to type through each letter in the
alphabet in the To box, deleting all of the addresses I don't want, so
that I can have easy shortcuts to the people to whom I frequently send
Is there any way to preve...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-...Macro pause for input
I would like a macro to insert a footer with some data
already in a worksheet. I can do that, but I want it to
pause and offer choices, e.g. a dropdown box or something,
so that the choice is between two or more cells/named
ranges in the worksheet, or choices such as left or right
footer and Active.Workbook.FullName or "Date" such as date
is "Date: &D"
Suggestions greatly appreciated.
Have you tried using Forms in your macro? Or even using
the msgbox command will probably suffice.
Look msgbox up in the help from your macro
>...Calling a value from a form
I have a form that when a button is used opens a report.
The form has a field that references a value in a table the is needed on the
On the report control source I have the following:
=DLookUp("[CCIT]","CLIENT NAMES","[CACCTN] = " &
It gives me a #ERROR value.
The following line returns the correct result where "104" (a string, not a
number is correct)
=DLookUp("[CCNAM]","CLIENT NAMES","[CACCTN] = '104'")
I am out of ideas of this what should be a simple re...Accessing Exchange 2003 server form another site
Here's the situation:
- User's Outlook is configured to his local Exchange server. User is
connected to the network with DHCP.
- User goes to another office and would like to get connected on his
Exchange serveur. User is connected to the network with different DHCP
server and range. Users can only access resources that are locally.
- Both Exchange servers can see each other and are part of the same
Is there a way for the user to get access to his Exchange mailbox even
though he is not connected locally? Would opening the Exchange ports
on the firewall would be the bes...Visible control based on other inputs
I have a form where the user choose shift, Sektor, Cell, Date from 4
The cell combobox is based on a query that gives you the cells that
corisponds to a sektor when the sektor is choosed.
The query looks like this
SELECT TblCelle.CelleNr, TblCelle.CelleTxt, TblCelle.Sektor
ORDER BY TblCelle.CelleNr;
TblCelle has the following fields
CellNo, CellTxt, CellVar, CellCat, Sektor
The CellVar can have two input either L or H
I have a text box and a label that should not be visib...Show renamed user fields in PWA
In Project Pro 2007 I've defined the "text1" field to display as "Task Type".
How do I get this to carry over into PWA? The published project shows "Text1"
as the field heading.
You need to do this via the Enterprise Custom Fields in Server settings.
Create a task field of type text and call it Task Type. Open up project, and
you'll find it's available to everyone.
"Pete Hay" wrote:
> In Project Pro 2007 I'...Input music to WMP?
I know you can enter music by indicating what folder to watch, but I want
more control. Amazon Downloader is a free program to do this, but it is done
programmatically. Is there a non-programmatic way to do this?
On Mon, 29 Mar 2010 17:50:28 -0400, "Jim Cassilly"
>I know you can enter music by indicating what folder to watch, but I want
>more control. Amazon Downloader is a free program to do this, but it is done
>programmatically. Is there a non-programmatic way to do this?
Hi, it's not...adding navigational buttons to a form in datasheet view.
I'm creating two forms with navigational buttons to move inbetween the two of
them. One form is Columnar, and the other is in Datasheet. The button shows
up on the first form, but unfortunately I can't get the button to show up on
the form that is in datasheet view. Can anyone tell me how?
You can't! With a datasheet form you get what Access gives you; data fields
in rows! You can do all you want in Design View, add command buttons, labels,
comboboxes, etc, format fields with color and so forth, but they're not going
to show up when the form is run!
The best you can do is ...Combining two fields
I'm trying to combine two fields in a particular way, and am trying to write
a function to do so. However, I'm getting caught up in how to actually grab
the contents of the fields. I've tried going the DAO route, which I think
was misguided anyway, and am now trying to get to them directly from the
table. The following function should manipulate the values of the the two
fields in the specific table into a new string.
Function fCombineSemis(strTable As String, _
strFirstField As String, _
strSecondField As String) _
I have a spreadsheet set up containing products with a uniq reference code. I need to input sales quantities against these products each week. At present this is done manually. Has anyone any ideas how to auto mate this function. The sales quantities can be downloaded into an excel file
you may have a look at pivot tables if I understood you
>I have a spreadsheet set up containing products with a
uniq reference code. I need to input sales quantities
against these products each week. At present this is done
manually. Has an...Display value of a VBA variable inside a cell
I am using Excel 2007. I have created a VBA module called MyModule. Inside
this module, I have defined a public variable as follows:
Public blnMyBoolean As Boolean
Next, I created a Function to return the value of this variable as follows:
Public Function GetMyBoolean() As Boolean
GetMyBoolean = blnMyBoolean
Next, I used my function as a formula for a cell on one of my worksheets as
The formula in this cell works, but it does not update automatically. If my
code changes the value of blnMyBoolean, the only way I can s...forms in Excel
I would like to create a form in Excel that can be used as a source for an
Access table. I don't necessarily want to create the form in the VBA
editor. There are two form features in an Excel sheet: The Control toolbox
and the Forms toolbox. How should i decide which one to use?
My question is very simple (I hope): in MS Works, you can toggle between List
View and Form View, and print an individual record in the latter. Can this be
done in Excel?
> I would like to create a form in Excel that can be used as a source for an ...User input
I've used this forum before, and found it very useful.
I need to set up a worksheet, (worksheet1), to allow a
user to input surname,initials,id,location,date for
office files that move around the office. The result will
be stored in worksheet2 in 1 row and 5 columns called
Surname - Inits - ID - Location - Date
Each entry will be recorded in the next empty row in
worksheet2. I think I have found a way to identify the
next empty row using the Indirect function.
But, how can I set up worksheet1 to allow the user to
input the data he has which is then automatically
recorded into wo...send email from VB with minimum user input, mapi, cdo?
I want to add the ability for the user to email an attachment after
generating a report, but I don't want to have to rely on them for much
help in setting up the email, a lot of them would have trouble finding
their outgoing mail server, whether it requres authentication etc.
Is it possible to send mail from VB after looking up the outgoing server
and any authentication that may be required from the registry, just
asking the user to enter the destination email address?
And is there a recommended method for sending email that will work on XP
On Aug 13, 6:1...VBA problem when recording sound using Sound Recorder (> 4 Gig mem
I jave a VBA application in Word that records sound using Sound recorder.
UNFORTUNATELY Sound Recorder does not work correctrly in a machine which has
more than 4 Gig of memory
Can I test the amount of memory using VBA in Word so that I can give the
user an appropriate message?
Any assistance very gratefully received,
> Can I test the amount of memory using VBA in Word so that I can give the
> user an appropriate message?
Absolutely, using the GlobalMemoryStatusEx API.
See: http:/...order form
i am trying to create an order form. normally this would be easy
enough...item price x quanity etc, but there are some other variables.
allow me to explain....
1. let's say we are selling products 1 2 3 etc all the way to 250.
2. let's say that products 1 through 50 only should display options (styles)
of a b c d e f and g, while products 51 -100 should display options (styles)
of h i j k l m etc.
I was hoping the two things above could be in drop down boxes... so..for
example..a customer orders product 22, only the a to g options or styles are
Now..t...user defined fields #3
I would like to change the field name Comment 1 to Pledge Amt.
I am not able to do this. We have modifier. When I open the customer card
window and click on Tools > Customize the modifer opens. But I am not able to
change the Comment 1 Description. I can select the field, but I cannot seem
to change it. I have looked into the properties field without any sucess. I
am able to change it globally, but I would like to restrict it to this window
I am not sure what I am missing here.
You are not missing anything. Just go to the modified window, select the
Commen...Changing email recipient based on Order field
We are using CRM 3.0, Win 2003 Server and the Workflow Manager.
We want to alert an internal resource to start working an order via
email, upon order creation. The internal resource's email address is
entered as a field in the order.
Using Workflow Manager we seem to be able to either use a template, or
create a custom email.
Using a template does not allow us to control who the email goes to -
CRM automatically decides to send the email to the account contact. Not
what we want.
Using a custom email, we can select from a finite number of recipients,
including internal CRM users (of whi...update data in table through form
i have created customer data in table and im updating data through form, in
the form at one field i have created a formula [bill amt]-[paid amt] and it
works but is not updating in the table, kindly help in this i also want to
run query in form like i want to see reports from from date to end date of
On Fri, 5 Mar 2010 04:09:01 -0800, Srinivas
Formulas like that don't belong in a table, but in a query. So if you
ever need this value simply create a query, select your table, and set
one of the field...Re: Locking textbox input
Is there a way to enter info in a textbox ONCE and as soon as Tab or
Enter is pressed it locks automatically... so it wont be altered....
Message posted from http://www.ExcelForum.com/
how about not only a textbox but a plain old cell??
Message posted from http://www.ExcelForum.com/
How about anytime you get out of it?
I added a textbox from the control toolbox toolbar to a worksheet.
I double clicked on it and replaced this code:
Private Sub TextBox1_Change()
Private Sub TextBox1_LostFocus()
Me.TextBox1.Enabled = CBool(Me.T....OFT FORM file not opening
Is there any setting in outlook that would prevent
me from running an .OFT Form file..
Beginning with Outlook 2003 SP2, users can work with most .oft form =
templates files only by opening the template from the Tools | Forms | =
Choose Form dialog, browsing for User Templates in File System. This =
means that if the .oft file is sent as a message attachment, the user =
must save it to the local hard drive first.=20
The article at http://support.microsoft.com/?id=3D907985 explains this =
change in more detail, suggests best practices, and provides registry =
keys that can return Outlook 2003 ...VBA code needed to AUTOMATE SELECTION of names within VALIDATION dropdown then print
I have searched the blogs and cannot seem to locate anything related
to my challenge. I know you guys are gurus when It comes to things
I have a worksheet that tracks employee productivity for each cost
center with a region.
My excel worksheet contains three validation dropdowns that use the
"indirect" function with various named ranges that link these
dropdowns . So for instance lets say that the first dropdown relates
to a region, the second relates to a cost center (there can be many
cost centers in a region), and the third is a worker in that cost
center (there can...