Help filling in form from 2 different tables
I have two tables, CustomerData and EmployeeData. CustomerData has all the
address, phn, name, empid# of last employee to help em and custid (primary
key) and employeedata has name addr phn and empid (primarykey) I have a combo
box that pulls up custdata (by Custid sorting by Lastname & ", " & Firstname)
I wanna do an Afterupdate event to fill out the following textboxes (based on
the Custid it fills out the Lastname, Firstname, Address, Phnnumber) and then
based on the Empid of the last Employee that helped em it will fill out the
textboxes witht he first and last na...syntax for tab on a form
I constructed a search routine for a database. It is a form with a subform
as a datasheet. The form has the search button and a reset button and
various criteria boxes. Everything appears to work fine!
The above was just a test or practice. I am very new to access. Now I
would like to begin the finished product and the above routine would be on
the first tab of a new form. The above search routine doesn't work and I can
not find the proper syntax anywhere to move it to a form with a tab.
Below are two lines from the search routine if that will help any
Me.frmsubAllR...Excel Data printed out as a Form
I have data in an Excel Spreadsheet where each row of data pertains to a
single family in our church. the information was downloaded from our online
data base and Excel is the only method available for export.
I would like to have each row of data print out as a form (one row of info
on a single 8 1/2 x 11 page). Does anyone know how to do this? Or if it
Use a Microsoft Word mail merge. It can use the Excel list, and you can
make it as pretty as you like. Exactly what you need. You can also use an
Access Report (printout), but if you're not familiar wit...Outlook /Calendars Delegation Issues.....
Maybe this is a question for the outlook or exchange user
groups, but I just setup SBS2003 with outlook 2003 on all
5 clients. I setup one (primary) of the clients outlook
calendar to allow delegate rights to the other four,
which works great. My problem is that when the "primary"
user goes in and creates an appt,event, meeting or even
just updates anything in their calendar the other four
recieve updates of the changes.
I've looked at how to stop this but cannot find anything.
Anyone have any Ideas.
Thanks in advance for your help.
Use a public calendar instead.
...required field in a form.
I have a form that consists of a field that if it is double clicked it will
enter Now(). I need to make sure that the user doesn't miss this field and
cannot go to the next record until the field has Now(). I have tried the
following... Before Update, After Update and the validation rule. I don't
get any errors but I can still go to the next record. Please Help!!! I am
sure that this is really easy and I probably did something real stupid. Can
you give me an example of the best way to do it.
The field that I need to require is Post_Called_Customer
The Form Name is Main Info
And...Sub Form not showing all records
I have created a form (PartSuffixSubFrm) that shows Part Number, Suffix and a
check box from the table PartSuffixTbl. When I open the PartSuffixSubFrm as
a Form all of the Part and Suffix records in the table show up. But when I
include this as a subform on my LocationFrm the PartSuffixSubFrm only shows
the first Part Number and it's Suffixes. I cannot see, nor reach, the rest
of the records. Can anyone tell what I have missed based on this explination?
Never mind - I am actually going a different way on this project. But for
others found the Parent Child relationships are what...Password Issue
Don't get me wrong here, I have received plenty of great
information from MVP's and other regarding MS software,
but to make us all sound like idiots because we used the
suggested password system for a product is unacceptable.
MS specifically tells you it is highly recommended to use
Passport. Now while we all wait for the fix, we get to
listen to all of you tell us how stupid we are for even
using it in the first place. Personally, I can get
around using it for now, but it is rather annoying that
it is taking this long.
Funny thing, I had always used Quicken in the pas..."the path is not of a legal form" during CRM install
On a couple different servers while installing various CRM components I've
run into an error that halts installation. On the "Select Installation
Location" screen for the CRM outlook client and the Microsoft Dynamics CRM
Data Migration manager setup I get a dialogue box with a big red X that reads
"The path is not of a legal form" with an OK button. Hitting OK returns to to
the installation location screen, but if you hit next it just keeps popping
up, leaving you with cancel as the only option.
The illegal path does not seem to refer to the install path...Copy Attachments from Outlook to a Web Form?
I am looking for ways my users can copy an email (w/attachments) from
Outlook and paste it in to a web form / control?
If this isn't possible, then I am open to other suggestions, thoughts!
Thanks in advance!
...executing code on access forms on different pc's
We have several access databases that we used without any problems for years.
All databases are in access2003 format and have forms with VB code behind it.
recently we are getting new PC's that cannot execute the forms in (MDE
version) databases. It reports missing references. Opening the MDB version is
no problem but then it cannot be opened on the older PC's anymore. Both old
and new PC's have Office 2003 installed and are running XPSP2. The missing
references are 3 files:
Does anyone know where these files come from? Could they belon...Needing help with my first form
This will be my first post so hi.
I've been asked to design a Laptop pool form for the company. The form should be able to record who in the company has a laptop and for how long.
I imagine this is quite strait forward. the form should have a couple of drop downs and a couple of text boxes to save the persons details. Then, when they save the info, it should enter into that day of a Calendar.
If the entry is clicked, i'd like a form to pop up with the details of that person and who made the booking of that lap top etc.
That's it. There's not a great deal of info...Exchange 5.5 mailbox issues
We are currently using a exchange 5.5 server and one of our directors is not
getting all his emails sent. Its been when 3 or 4 external users send him
email but he does not get it and the external senders get an NDR. The NDR
sent to the senders refers to the exceeding storage allocation, but our
director is not over the storage limit, as we individually set large limits
for the director. It only happens occassionally and the director has said
it could be more than the 4 senders, as its difficult to monitor. And today
another user who was sent email from the same sender has the same problem...Copy value of field to other form
How do I copy the value of a field from one form to another form that is not
part of a subform relationship?
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
mattc66 via AccessMonster.com wrote:
> How do I copy the value of a field from one form to another form that is not
> part of a subform relationship?
You can access any form, if it is loaded, with
Forms("OtherForm").Form![FieldName] = Me![FieldName]
Forms("OtherForm").Form![FieldN...Date field behavior differs between forms
I have two forms with seemingly identical date fields. In one, if I place my
cursor in the middle of it, the first number I type gets put in the far left
of the field. In the field on the other form, if I place the cursor in the
middle, it starts typing right where I am. Any ideas?
I have thoroughly looked through the properties of each field and each form
and I cannot find what is causing this behavior. I would love to get both of
them to start placing typed characters at the far left instead of where the
...Full Screen Forms in 2007
I recently upgraded to 2007...and I'm not entirely happy. I created all my
forms in 2003 and had them all full screen, working the way I wanted clients
to see them,. In 2007 I have the ribbon on top and the
table/forms/reports/etc box on the left. How can I get the same form
behavior I had in 2003?
It's not intutitive, but possible:
Arvin Meyer, MCP, MVP
"Bruce Rodtnick" <Rodtnick@comcast.net> wrot...Excel graphing and equation issues
Okay so here is my problem. For work, I have a curve that I need to put into
excel and find the equation. So I look at the curve and record data points
from the curve into excel. I will then graph the points and it will produce a
curve just like the one have on paper. My problem comes when I ask excel to
produce equations for the curves. The equations it produces do not match the
curves when I enter a value into the equation. Why does this happen or how
can I fix it?
Make sure you start with an XY chart, not a line chart. Then make sure
the equation has enough digits, so apply ...calculated field from a form to table
Can you take a calculated field from a form and pull it in to a table??
You can but you should not. Instead, calculate the value each time
you need it. Stored values are almost guaranteed to get out of synch
sooner or later.
"Darren" <Darren@discussions.microsoft.com> wrote in message
> Can you take a calculated field from a form and pull it in to a
Ok, makes sense. If i wanted to do it to get a snapshot and save that in the
table, how do you do this?
"Larry Daugherty" w...Issues after upgrade to Exchange 2007
After upgrading to Exchange 2007, we are experiencing these issues:
1. E-mails sent from CRM are not routing thru Exchange to the Internet (we
use a forwarding e-mail, and all lights are green within the Router Config
2. Incoming CRM-related e-mails in Outlook are not automatically tagged with
the CRM icon
Specific to item #1, we are seeing this error:
#27938 - An error occurred while checking for e-mail messages to process in
mailbox email@example.com. System.Net.WebException: The remote server
returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse(...How can I find out what the firewall issue is on a Printer?
I was having problems reinstalling HP software for my All-In-One printer,
and HP Tech support had me add ten or fifteen programs to the Firewall as
allowed programs, plus about that many ports. I'm still having firewall
issues according to the HP networks diagnostic tool, and the HP software
does not "see" my printer on the network.
I can go to its IP address in Internet Explorer and see info about its
status, etc, and I can install basic drivers for other similar printers and
it will print, but not from the Full Software package that I need for OCR
scanning. It ...Time sheet issues
There are three questions
I am preparing a time shhet.
To strart with I have to prepare a blank sheet and give one sheet for each
Here are the blank walls I am hitting
1. I want to format a cell (E2 in my time sheet) in such a way that if
enter "1" it should display "January" and so on. How to do it?
2. The First cell of last row (A 34 in my of the time sheet) should have 28,
29, 30 or 31 depending the conditions of E2 and H2 which has month and year
3. The cells B4 to B34 should have days cooresponding to dates (number) in
A4 to B34
I'm having a problem loading data in a subform. The fields in the
subform and main form are not bound. I'm using MSAccess 2007
I put VBA code in the "On Load" event of the subform to get records
from a table and populate the fields on the subform after the main form is
opened from a previous form but I'm getting the message:
" MSAccess can't find the form referenced in the VBA code" (referring to the
As a test, I put the code to populate the subform (including, as the first
line of the code, "DoCmd...Outlook Contacts always suggests "Custom Form Cannot Be Opened"
I have ascertained by searching "Message Class Field" that all contacts in
the search come up as found.
Therefore I think somehow I have put in place a Custom Form and would like
Outlook to go back to using the default / standard form.
Thank you for any further Help.
Get http://www.publicshareware.com/download/DocMessageClass.zip and use it
to change the message class back to the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.sli...Issue when combining fields
I have combined 3 fields (firstname, lastname, business) in a query to come
up with a concatenated field called custname. The only problem is when one
of the fields has no data it puts a space in where the data would have been
inserted into the string. For instance, if neither firstname nor lastname
have data, and business does, I end up with something like (space) Scott's.
The problem with this is that if I want to sort alphabetically, anything with
a space before it comes up first. Is there a way to fix this?
Trim(FirstName & " " & LastName )
If Fir...How do I prevent pictures form moving when adding text?
Right click the picture, format picture, Layout tab, Object position, change to
"Peggy" <Peggy@discussions.microsoft.com> wrote in message
Is there a way when inserting pictures and clipart of have them all wrap the
way you want when you bring them in. Some option or setup or something for
when you insert pictures? Everytime I insert pictures I need to change the
"Mary Sauer" wrote:
> Right click the picture, format picture, Layout t...Activity creation issues
I have coma across a couple of issues when creating activities:
1) When creating phone call, regardless of the direction, the sender remains
as the owner and the recipient the related customer (assuming this is created
from within a contact's view). This means that the incoming phonecall is
recorded as being sent by one of our staff, despite it being received by
them. I have attempted to create workflow to rectify this but it appears to
fail to fire (presumably because there is a conflict as one cannot simply get
the sender/recipient to switch, resulting in duplicates, and thus e...