Cannot save my form
Hi.Can you please help me with my problem.I create my database last
week.At first,the database worked smoothly.But,when I when I reopen
my database,my last forms was dissapeared.Can you help me to solve my
problem?Any post will help.Thank you.
When you open the database do you see the database window? If not press the
Next go to Forms on the objects bar. Do you see vertical or horizontal
scroll bars? If so the new forms might just be a little off screen and using
the scroll bars should find them.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bont...Inserting form values into a table
We have a form with values taken from an sql query that comes from two
different tables. We would like to enter the information into a third table.
Can some one direct me to code that will do the following:
1. Provide the Insert sql that shows us how to add the form values to the
2. Show us how to loop while inserting the information into the table (there
could be several lines on the form, each must be inserted one at a time).
I have worked with Access before and have never had a problem inserting
information. However, I cannot quite figure out how to insert informtion
through an ...function to check for entry
I'll try and make this as clear as I can...
I am looking for a function that will check column b,c,d,e for an entr
if there is an entry then check row n in the same row for it's value.
that's the first bit, then I need to be able to check the date valu
(month) in column a and total it for the month.
perhaps I could run the first function only looking for month=1 o
something and just run it 12 times?
not sure how to go about this
Message posted from http://www.ExcelForum.com
well I've got this far but it still doesn't work and gives an error:
=IF(MONTH(A3:A167)=4,...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...New Disk storage
I'm planning on adding a new SAN to our Exchange system (Active/Passive 2
node cluster) and this has been connected to the Exchange cluster nodes and
is accessible as shared disk storage.
But that isn't the question I've got, basically the mail stores are
currently located on a Powervault (Drive S:) and I need to present a plan for
moving this data (14 databases) onto the SAN storage, I can see two options
Option1) Use the ESM to migrate databases to new drive letter
1. Use exmerge to export all email to PST files (and ensure backup)
2. use the ESM utility to change the...SQL deadlock problem
I am currently having a big issue with sql deadlocking on the
The last few months I have been working on a synchronization process using a
Biztalk orchestration. The sync uses the crm webservices to create and update
account and contact records in CRM. But now deployment to the production
environment gives me some problems. It seems that when trying to update
account records (which is one of the first actions in the sync process) the
webservice gives me Generic SQL errors and SQL timeouts. After extensive
profiling and tracing in SQL I found that there are...Input Excel 'Password to Open' through control in access form
We know,Excel has prompt password
to open it files.
Is it possible to create a code that can
supplies the excel prompt password?.So that when we
open the excel file through our access control in a form,
the excel files can be opened automatically.But when the
excel files opened from its default icon,it will prompt a
I am using access 97 and tried to import a csv file to the mdb table. I run
a code as following:
DoCmd.TransferText acImportDelim, "Specification4", "input",
DEFAULT_PATH & "online.txt", 1
In online.txt, there is a field which is 10 digit number and I specified it
as a double datatype in the specification4. After the import, I found out
that the 10 digit number data in the field get empty in the destined table
while other fields are all right. Therefore I import manually using
specification4 instead of running code. This time the 1...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...Exchange update problem
I have tried to upgrade exch2k3 sp1 to sp2, but the update fails with "the
file pcproxy.dll is in use, and setup cannot identify the app or srvc. setup
Any clues/ideas/suggestions? Please.
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may not ...how do I automatically update a text box in a chart?
You can link the textbox to a cell. When you update the cell the textbox
should reflect this.
Select the textbox border and then in the formula bar enter the complete
cell reference, for example,
Andy Pope, Microsoft MVP - Excel
...Transferring over outlook data to new XP machine
How do I transfer over my old emails, address book to my
new XP machine? I have looked over the internet and found
nothing the tells me EXACTLY how to do this, any help
would be greatly appreciated.
If your using MS Outlook copy your .PST file across and import it into the new install.
>If your using MS Outlook copy your .PST file across and import it into the
No, don't import it. Simply use "File">"Open"
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the nam...multiple Domain name delivery problem
hi, I currently have Exchange Server 2003 Build 7638:2 SP2,. We have multiple
domain names being delivered to the exchange store. I have nothad any
problems, but i currently have one user that is not receiving emails with
attachments from one certain "internet" sender to one of her email addresses,
but the other address works fine & if they send emails without attachments,
everything works fine from either address. I have had the user send them
message with attachments to me & the user with the problem & i get the
message, but not the other user! I even use message...Find prev record on other requeried form
Using access 2003. I have a main form for name and address info. A subform
shows limited info on client placement.
Click a command button on the main form and user opens another form for full
screen entry of placement data. That form opens showing the client selected
on the initial main form.
When the full screen placement form closes, it requeries the original main
form with the placement subform to show the added placement. It goes to the
first record in the table though. It does not show the original client whose
placement was just added.
How do I set the mai...Set request parameters for web services
My .net application is to consume a Java web services exposed using
The web service will extract the user name and password to perform some
/** Java **/
userId = hReq.getParameter("wsUserName");
password = hReq.getParameter("wsPassword");
So my ASP.net application will need to set the user id and password to
be passed as a HTTP request parameters
upon calling the java web service.
I have added a web refernce to this web service inside my .net
But i can't seems to find any methods or parameters to set the request
parameters...Creating new attributes
When using Schema Manager to create new attributes, I'm not able to create a
new attribute with "Lookup" as type, "Lookup" is not availabe as one of the
type options. But yet some of the exist fields, for example, in Account
table came with "Lookup" as type. Why? Is there a work-around? Please
You cannot add custom lookup's to the current release of MSCRM. The only way
around is to build a custom .aspx page and build your own. Might be possible
in the next release.
> When using Schema Manager to crea...Install Exchange 2003 Server on new Hardware with same name
I got a new server to move my Exchange Server Installation. I want to
keep the name I'm using now for my Server. Already read TechNet Article
"How to Move Exchange Server 2003 to New Hardware and Keep the Same
Server Name". Is there anything else that I should be aware of that is
not on this TechNet article? I'm using a different Disk Configuration,
does this matters? Should this be a smooth process?
Thanks for any help you can give.
The drive letters MUST match, because the paths of the databases are at the
Active Directory. The disks can have different sizes than the or...How do I create several NEW templates from start to finish please?
Hi knowledgeable people.
I am looking for instructions on how to create a range of basic templates
that I can use, perhaps even by selecting them as 'stationery', for example;
if I go to >New >Format >Apply stationery, or any other similar method.
I can create new html stationery backgrounds, but this is NOT what I am
looking for, as a lot of people still read email in plain text only...does
this make sense?
Plain text templates would be fine.
I simply can't find any info on creating email templates anywhere to suit
this Windows Live Mail Desktop versio...transferring to new pc
I had to replace my pc and to migrate my money files to
the new pc i first made a new backup diskette which I
then opened on my new pc. Afer downloading transactions,
the balances on about half my credit card and bank
account are slightly off. What gives?
...Strange Access Denied Problem with Windows 7
I got a new computer about six months ago that came with Windows Vista
Home Premium 64bit. Before that I had done all of my .NET development
either on an XP Pro VM or my former XP Pro computer at home. Shortly
after getting my new computer at home, I also got a license for VMWare
to be able to test my software on multiple platforms and
I had wrote an application originally in VB.NET that was a simple
backup utility. It supports mutiple backup configurations. Any given
copnfiguration would define a backup which would be a list of files to
backup, a list of folders to ...Invalid XML error when I open customization setting
I have a problem when I try to open customization setting after I import an
entity. The system errored "Invalid XML" "The XML passed to the platform is
not well-formed XML". Please recommend how to resolve this problem. Thanks.
...outlook 98 corperate forms
In a corperate environment, Outlook 98 forms not active
for using on some of the PCs. Why it happens? How can I
solve this problem.
...Automatic incremental of records
I have a table with several records and arranged serially, i.e 1,2,3 .....25.
When I delete arecod like record number 3 I would like record number 4 to
become record number 3. But in my case Record number 4 still remains serial
number 4 although it is actually the third record. Is there a way it can be
> I have a table with several records and arranged serially, i.e 1,2,3
> .....25. When I delete arecod like record number 3 I would like
> record number 4 to become record number 3. But in my case Record
> number 4 still remains serial number ...Setting MDI Parent Size To Fit Around A Child Form
How do you set the client size of an MDI parent to fit around a child form?
Breakpoints in the constructor and load event handler show the child size to
be already modified to fit into the parent; the child's size does not match
what shows in the Designer. I suppose the real question might be how do you
determine the size of the child window or keep the parent from changing it
What you're asking for is a little backwards, but I'm sure you have your
At any rate, these are the properties you will want to investigate:
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to
my local hard drive. Every time I try to open it, it takes forver and
sometimes never opens but I do not get any error messages, let me just tell
you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else
running when I try to open it. As I said it is set for manual calculation,
and it is cleared to not auto calculate when opening or closing. Any idea's
as to why this is happening?
I don't know why you're having this problem but I would like to point
something out for w...