Updating a database 08-22-07
I use to work with a database I created; I run this database in a little
business of mine and I use to work in the database in my house. Usually I add
new tables, forms, queries and reports in my house and then I go to my
business and import the new things. But when I make too many changes it
becomes complicated. Does anybody know some way to do this updating process
in a better way?
Thanks and Regards,
You should be working with a split frontend/backend database.
The backend databse has just your tables and would remain at work.
The frontend database has al...deleted emails 03-10-10
how do i retrieve deleted emails from two specific email addresses?
sort the deleted items folder on FROM address
> how do i retrieve deleted emails from two specific email addresses?
...List output to a x by 10 range
I have a list that x lines long. I want to transpose that list to
another range (starting on cell M1) that is 10 columns wide and
however many rows long.
I know this is super simple.
Does it have something to do with range resizing?
No doubt you've already experimented with macro recorder, discovering
the standard transpose command wont wrap within a range. So we need
handle the transposition manually.
Presuming your data begins in cell A2:
For Each c In Range("A2", "A" & Range("A65536").End(xlUp).Row)
Row = Row + 1
...Work Hours 10-25-06
I want to change the default work hours setting for users of the
system. At the moment they are set to work all day everyday of the
week. Realistically I want this to be 9 a.m. to 5 p.m. Monday to
Friday. Is there any way I can change this using customization and have
it apply to all users? Pergaps it is a system setting I can change
rather than customize?
Go to Settings | Business Unit Settings | User and select a user (can also
go Service calander and then select the user from there as well)
Then view the Work Hours, and select Set Up | New Weekly S...Can't send or receive 07-27-10
I set up Windows Mail to my gmail account. I've double checked the settings,
and they are correct.
I got the following message when I tried to send an e-mail:
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Mail", and read the
"I'm having problems sending e-mail" section. If you need help determining
the proper server settings, please contact your e-mail service provider.
The rejected e-mail address ...IE8 text size 01-25-10
The situation described occurs in IE8 on both Vista home premium and
Windows 7 professional.
Using the page options, I set the text size to smaller. It will
remain that way for a while but within hours or sometimes a day the
text size reverts to medium.
...Business Portal 4.0 & GP 10.0 Smartlist
Is there a way to use our GP 10 smartlists in the query sections of Business
Portal 4.0 ?
I've look at the Business Portal query builder and I don't think you can use
SQL (in this case I could have extract Smartlists SQL). You have to used
predefined entities. Maybe I get it wrong ?
Thanks in advance for any help !
Thanks for using the newsgroups. You are correct. You need an entity for
querying in Business Portal.
Software Quality Assurance
Microsoft Business Solutions
This posting is provided "AS IS" with no warranties...Filter #10
We have the following code that filters a range in database(no problem)
this code is looking at column A which is a week number(11)
what we now need to do is extend this code to filter two ranges
the second range is column H and is days of the week(Monday)
Is it possible to expand this code to do this?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 3 Then
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=She...Outlook security #10
I have Office 2003 with Outlook 2003 running on Windows 2000.
When sending emails from a different program, I can set Outlook security to
bypass further warnings for up to 10 minutes.
A customer, also with Outlook 2003, but updated from 2002, has to respond to
every email with a 5 second pause.
Why the different behaviour?
How do I change the latter behaviour to the former?
The security settings for Outlook 2003 can be found using the
Tools->Options->Security Tab and security zone settings button. It works
exactly the same way Internet ...Office 2010 Beta 02-24-10
I have installed 2010 Beta and like it but I no longer can click on a file to
open. When I try to associate the program to use none of the office programs
show up. Is there a way aroung this?
Microsoft Office Diagnostics perhaps, Or select Browse and look for the
thom kamp wrote:
> I have installed 2010 Beta and like it but I no longer can click on a file to
> open. When I try to associate the program to use none of the office programs
> show up. Is there a way aroung this?
...formula help #11
I have a time sheet format for employees and
I just don't know how to create the formula for overtime.
I only want to input finished time in column C.
I don't have much experience in formula function.
The timesheet example is below and please help me to
A B C D E
1 30-01-04 08:00 18:00 1:00
2 31-01-04 08:00 12:00
3 01-02-04 08:00 14:00 5:00
4 07-02-04 08:00 17:00 8:00
5 08-02-04 08:00 12:00 4:00
Column (A) is Date
(B) is started time
(C) is finished time
(D) is over...Installing Visio 07 on Vista
I KNOW I'm not the first one to get this but Google doesn't have a lot to get
this to work.
I've got Office07 Pro Plus on my Vista box, I put the Visio 07 Pro CD in and
attempt to run setup only to be greeted by 'The language of this installation
package is not supported by your system' error.
So....I have the latest OS, Office package and now trying Visio but
nooooo....Bill and his boys have to block me from using their own sw.
Anyone know the fix/workaround for this?
And yes, I've uninstalled/reinstalled Office 07 - though I really shouldn't
have had to. ...WIndows Live Mail 11-27-09
Where's the send-receive button?
It's the Sync button now. Place the mouse pointer over it and you will see
MS-MVP Outlook Express
Imperial Beach, CA
"wes" <firstname.lastname@example.org> wrote in message
> Where's the send-receive button?
Send and Receive in Windows Live Mail 2009
msft mvp mail
"wes" <wes@di...Time calculations for Scheduled vs Actual Employee Time and Wages 11-28-09
I am THRYING and TRYING to make a simple schedule worksheet for a manger to
use to calculate the time he schedules an employee to clock in and out and
what it will cost him in regards to his allocated budget and then to be able
to compare it after the job is completed. BUT time calculations have thrown
me for loop and I am stuck for hours on trying to calculate time fields.
PLEASE DEAR GOD can someone help me.
Below is a simple example of my worksheet.
A2 (Time IN) = 1:00 PM
A3 (Time OUT) = 5:00 PM
A4 (Time Worked) = 4:00 (h:mm format) ...Generating Multiple Choice Tests
I currently use Access 2003 to create tests. I am looking to use a grouping
and random sampling method to improve efficiency. In as much that I use
access to create tests now, is VBA an appropriate platform for randomizing
and group sampling or should I go to an independent language. Any advice
will be greatly appreciated.
SELECT TOP 1 Rnd([TestID]) AS Expr1, TestText
ORDER BY Rnd([TestID])
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, inform...Attempting to create a CRM Test Environment
I am attempting to create a CRM test environment using the database name
"Adventure Works Cycle". After the database is created and the users added I
have attempted to import the XML schema and form changes from our Production
Environment but everytime I do this I recieve the error "An Error has
occurred. For more information, contact your system administrator". This
error appears when I click on the "Services" tab. I know that it is
attempting to query the database at this time. I am able to click on the
"New Case" button and bring up the p...integration manager 10.0-SQL Data Source
We are trying to run an integration by using a link to the GP tables. One of
our data sources is using the SQL Server as the data source. We can query
the data source and return all rows in the integration. However, when we run
the integration we receive the error: An error handler was not found for:
Object reference not set to an instance of an object. We are on the latest
service pack too.
Are you using any field script or event script in IM?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
error "Permission Denied" on the bottom toobar.
It works with the Windows 2000 machines, but not our Win XP SP2 machines?
Is there some sort of security setting we need to set?
Any help would be appreciated.
For anyone else who is looking I finally found it on MSDN.
"Brian Linden" <email@example.com> wrote in message
> We just installed the CRM to evaluate it and we are g...windows media player 02-07-10
when trying to play a dvd this message appears.
windows media player cannot dvd video.
I have installed decoders.
How can i get it to play my dvds
On Sat, 6 Feb 2010 16:29:01 -0800, lmorris
>when trying to play a dvd this message appears.
>windows media player cannot dvd video.
>I have installed decoders.
>How can i get it to play my dvds
Do you have suitable DVD decoders ? Only a subset are media center
compatible (the feature you need to look out for)
DecCheck for XP, and the Vista VMCD utility can help here :
...Multiple Commas 02-11-10
Some people decided to play a cruel joke and pulled two commas into a name
field and i need to split the name into a first and last name column.
Normally i could do this but the second comma is throwing me off. It looks
last name,first name,
Ive tried doing a replace on the last comma but its not working. Does anyone
know any tricks on how to either get rid of that second comma or split the
field into two seperate columns as it is? Thanks for any help.
dim aName() as string
dim strName as string
dim strLastName as string
dim strFirstName as string
' just ...Can't receive mail 07-29-10
I have problems receiving mail. I've worked through the trouble shooting
guidelines and nothing works. I get a Windows Security box requesting user
name and password but entering the details doesn't fix the problem The
strange thing is that sometimes after I have gone in and reentered details in
the Accounts Properties - Server tab it will down load them BUT NOT EVERY
TIME. The Error message below is the most common one that I get.
Account: 'mail.bigpond.com', Server: 'mail.bigpond.com', Protocol: POP3,
Server Response: '-ERR [IN-USE] account is...PRODUCT KEY 04-05-10
I've just purchased this hp and the cd that was provided to me with the
product key sticker on front does not work. I was under the impression that
there would be some type of trial period that would allow me to use the
product to determine if I want it or not. I am unable to open any documents
in word on my cpu because this software has somehow locked me out of my
papers for school. I can't edit copy or even view the docs w/o the product
key. The product key provided is 7X4P3 Q24MX KHRKH R6CX2 G76Y4 it clearly
doesn't work rather it is in lower case or upper case for...Stats microsoft.public.windowsxp.general (last 7 days) 07-05-10
"Caveat: Quantity is not necessarily a measure of Quality"
Stats Were Taken..........: Mon, 05 Jul 2010 08:15:20 GMT
Stats Begin...............: Mon, 28 Jun 2010 08:26:44 GMT
Stats End.................: Mon, 05 Jul 2010 07:03:30 GMT
Total No. of Articles.....: 606
Total No. of Characters...: 1707259
Total Volume..............: 1667
Messages Per Day..........: 86.6
Characters Per Day........: 243894.1
Average Daily Volume......: 238 kB
Total Posters This Week...:...Word spell check 04-21-10
Operating System: Mac OS X 10.6 (Snow Leopard)
How do I skip all repeated words. My documents intentionally use repeat words but the spell checker always stops at each one. The ignore all and the add functions are not available
The spelling checker will always stop at repeated words.
Your only option is not to use Spelling.
On 21/04/10 4:34 PM, in article 59bb736f.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard...Reinstalled Office 07: Now can't do merge to email
Hi guys, every Friday I send out a message to about 100 emails. This
week I had to reinstall Vista and Office 07 and now I can't get emails
to go out.
The merge happens in that I can see the names being filled in but
basically the messages don't get sent. They are not appearing in my
outbox or sent mail.
I'm on an Exchange server, but that's not new.
Grateful for advice so I can get this message out urgently.
Thanks in advance
On Jul 24, 1:48=A0pm, Boppy <therealbo...@yahoo.com> wrote:
> Hi guys, every Friday I send out a message to about 100 emails. This