Change Automatic ID Field?
Hello, I could do this with SQL, but haven't found a way to do this with
Access 2007 (And have to imagine this is supported). Presently the ID Field
starts at "1". I would like the Automatic ID Field to start at four digits,
such as "0001". How can I make this change? I really appreciate the help.
Set AutoNumbers to start from ...
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot o...Closing Queries automatically saves them
I've noticed recently that when testing queries with filters, when i go to
close the query I am no longer prompted with the 'do you want to save' prompt.
Instead, the query just closes and saves my temporary filters. How can I
prevent this and get the prompt back please?
Is this happening in quereis with filters or even changes to forms and
reports? Open up a report and make a very minor change, such as moving a
label a little. Close it without saving. Do you get a prompt?
If not, someone has turned Set Warnings off in a macro or code, but forgot
to turn S...Automatic Update
I have two columns of data in a spreadsheet named for example September 08.
The two columns in the September spreadsheet are linked from another tab in
the same spreadsheet. This is then saved as Dec 2008 but the links in those
two columns still contain the September 2008 figures. I require those two
columns two automatically pick up the data contained in the now newly named
Any pointers would once again be much appreciated.
You should look at the =INDIRECT( ) function. Without complete details,
here is the idea. If you enter the ...Calendar: Automatically enable reminder for all new entries
I am not a proficient user of outlook, but we frequently use it to schedule
the meetings and discussions. Is there any setting by which the reminder
option is automatically enabled whenever we create new meeting request.
PS: In my outlook (2002) Tools->Options->Calendar, "Default Reminder" option
is enabled and set to 10 min.
Any help will be greatly appreciated. Thanks.
Rahul, I think it is not a standard option but perhaps it can be done so I
think you should ask your question here:
"R Jain" &...Enable Automatic Refresh #2
Hi, I'm using Excel 2003 and have ran into a issue I can't seem to
resolve. I have a sheet that gets external data from an Access
Database when I open the worksheet. The issue is I always get a pop
up with the following message, This Workbook contains queries to
external data that refresh automatically" I have two choices,
"Enable Automatic Refresh" or "Disable Automatic Refresh". I would
like it to automatically refresh everytime I open the file, but
everytime I open I get the same prompt. How can I shut off the prompt
and just refresh automatically? Th...automatic replacing of a VBE sub in all open workbooks
hi all !
i know how to make automatic replacing of a cell for all open workbooks..
now i neeed to replace a sub with another 1 with a little difference..
is there a way to make it ?
You can write another Sub procedure and call it from a third procedure based
If Range("A1") <> "Condition" Then
Range("A1") = "Condition")
Range(...Apay (automatic pay)
Using Money 2006
My bank supports e-pay (Apay in Microsoft talk) and I am enrolled.
When setting up a bill for next month (September 1) - it sends it
today. Or so it seems.
I get a dialog saying "sending to capital one", for example.
I also note the deduction in my account register.
of course this leaves a negative balance as the cash is not in the
account because there is no pay yet
This behaviour is ok on my end. However, will my bank see this
transaction today or on the date it is to be paid? I am worried they
will charge overdraft.
Also, what do I need to do to get the ava...Automatically save notes
I am trying to figure a way to have a notes section on my form. When a user
inputs a note I want the note to be saved and stamped in another text box.
Thanks in Advance for any help!
NEVERMIND!!! Sorry I search other posts and found my answer!
> Hi all!
> I am trying to figure a way to have a notes section on my form. When a user
> inputs a note I want the note to be saved and stamped in another text box.
> Thanks in Advance for any help!
...re-run macro automatically ?
I have a macro, e.g. myMacro(a, b)
when i use this Macro within an ExcelCell with references
to other cells, i.e. i enter
the result is calculated correctly. so far so good.
But when i change the cell value in A1 or in B7 the result
does not change. Even with <F9> i cannot bring the macro
to recalculate with the new cellvalues.
How can i do this ?
Sounds like a udf. Did you put
as the first line of the udf?
"biff" <email@example.com> wrote in message
news:1298401c4431e...How to Automatically Scale up Pages from 8.5x11 to 17x11
I was making a newsletter for a year in review as a booklet and I
accidentally made it in 8.5x11 so when printed its only brochure size
(8.5"tall by 5.5"wide), the problem is I wanted it printed on 17x11 paper so
when printed it would be full size. Is there any way I can auto scale
everything from my 8.5x11 document to a 17x11 document, or do I have to
recreate the whole thing all over again?
You could make the page an image file using a program like MWSnap and then
insert it into the 11x17 and resize it.
Don - Publisher 2000�
"sailz" &...transactions automatically entered into accounts
Recent switched from MONEY 2004 to 2006. As transactions are automatically
found and downloaded, they are automatically entered into the acounts in the
account register without allowing me to look it over and ensure the right
spending category is recorded - - - in MONEY 2004 you were required to
'accept' the downloaded transaction where you could assign a spending
category. Is there a way to force 2006 to allow the user to review the
downloaded tranaction before it is recorded into the account register?????
In microsoft.public.money, Rick Kaser wrote:
>Recent swi...How do I do automatic backups in excel xp?
I need to stop a user from losing data/worksheets!
File>save as>tools>general options and check always create backup
> I need to stop a user from losing data/worksheets!
...Message Recall will not process recalls automatically from users mailbox
I just ran into a strange issue with Outlook's Message Recall system. It
would appear that message recall is controlled by Outlook not Exchange. I
had a situation where an executive replied to all on a message and needed to
recall that message. It seems that it recalled the message for some Exchange
users but not all. And, the ones it didn't recall, they were still able to
read the message as long as they opened it first before they open the recall
message which caused the recall to fail and the users were able to see the
Is there anyway to set up message reca...automatic bcc to public folder
I am using Exchange 2003 (on SBS 2k3) with Outlook 2003 and OWA Clients.
I am searching for a script that sends all outgoing messages in bcc to a
I already "googled" around a lot but I had no success. I found some Outlook
Add-Ins but it should also work with OWA so I need an Server-script.
Enable "message journaling" on your Exchange server:
"F. Sch�fer" <firstname.lastname@example.org> wrote in...automatic entry in "Opportunity ID"
in "Opportunities" we created an extra-field "opportunity ID" (nvchar).
It would be great when the system would number automatically - but at
the moment we would be happy if the field "opportunity-ID" would
already contain the prefix (in our case "061") when creating a new
opportunity. Does anyone have an idea how to do it? It's surely an
onload script? Maybe you can give an example?
Thank you ver much for your help!!
in the onload of the form add:
if (crmForm.FormType == 1)
crmForm.all.new_opportunityid.DataValue = '061';
Thi...Automatic Quote Numbering
I am looking to develop a sales quote template that automaticall
updates each time I open the file and create a new quote by INCREASIN
the quote number by 1. For example, if the last quote I wrote is #233
the next time I open the file, it should be #234 automatically, and th
next time #235 etc.
Can I do this is Word or Excel? If so, can you please clearly explai
Roni's Profile: http://www.msusenet.com/member.php?userid=283
View this thread: http://www.msusenet.com/t-187057425
Excel: h...Automatic Calculation turns off intermittently
Running WinXP Pro with Office 200 Pro
I have noticed that occassionly, without rhyme or recognizeable reason, my
automatic calculation gets switched over to manual. Is this a bug? virus?
Southern California Realtor�
Excel picks up this setting from the first workbook you open in that session.
So if you're unlucky enough to open a (common???) workbook that someone saved
with manual calculation, you could be toggling that setting often.
(And if you open a workbook that has calculation set to automatic first, then
you'll get autocalc until you change it.)...Automatic choose and send account
When I was using Office 2000, I managed to configure things so that when I
sent email, it somehow automatically and successfully sent the email. I am
now using Office 2003. but if I receive email to account1, it automatically
chooses account1 to send the email. However, if I am not connected to the
correct ISP, then I have to manually change the account to match.
Sometimes, I don't realize that the mismatch has occurred, until I see that
the email has not been sent. Then I have to reopen the email and change the
account used to send the email.
Any idea on how to configure things so tha...How do I repeat phrases in a document automatically
I create larger documents that end up with the same phrase throughout the
document. Rather than copy and paste each time to the new locations is there
a way to set up a link that will automatically copy the phrase to the other
areas of the document?
Bookmark the first instance then use REF fields in the places the phrase
needs to repeat. See: http://gregmaxey.mvps.org/Repeating_Data.htm section
"Old and Slow" <Old and Slow@discussions.microsoft.com> wrote in message
>I create larger documents ...How can I automatically enter repeating data from one table to ano
Hi I am a novice so if you can help please do. I have set up a database and
have a range of tables established for each of my categories and they seem to
be working well. How do I get the database to automatically fill in
repeating data (ie names) from one table to the next so I don't have to keep
retyping? Hope this makes sense.
Please help in simple English.
In a properly designed relational database system, you shouldn't have the
same data in multiple tables. You may want to read up on Database
Normalization. Jeff Conrad has some goo...$150 to be automatically write as "one hundred fifty" in MS Excel
In MS Excel, I design an invoice which show total of Invoice in Value (i.e.
in number) and the same is to be write in word. For example - $150 to be
automatically write as "one hundred fifty" in MS Excel. Please which MS Excel
function to be used.
This MS Knowledge Base article might help:
The function at this site might be more inclusive:
> In MS Excel, I design an invoice which show total of Invoice in Value (i.e.
...Automatic Online Updates?
I guess I have two questions. First of all, I'm new to money and I went ahead
and hooked up my checking account to it and it seemed to work fine (in
essential mode). But then after reading some, I decided to change my account
to "Advanced" because I wanted to be able to split up transactions to fit my
budget categories. Now I can't figure out how to get it to connect (do I have
to start all over?) And also, do I have to use "Advanced" account register to
categorize transactions and be able to split the transaction up?
Thanks in advance for any help
You can ...Automatic archiving of mailbox e-mail on Exchange 2003
Is their anyway of autoarchiving e-mail from users mailbox if it reaches a certain limit in Exchange 2003 or mail over a certain date . Can this be done on the exchange server rather than relying on user archiving through outlook . Maybe there is third party tool that can be used to achive this .
Any suggestion would be greatly appriciated ?
EXMERGE utility will help you. Just keep in mind that mail in .pst takes
more disk space and .pst is less reliable storage.
> Is their anyway of autoarchiving e-mail from users mailbox if it
> reaches a certain limit in Exchange...Can excel automatically place a negetive sign in a number
One of our employees routinely enters a column of numbers that are all
negetive. Is there some way to have Excel automatically enter the negetive
"MKLeisure" <MKLeisure@discussions.microsoft.com> wrote in message
> One of our employees routinely enters a column of numbers that are all
> negetive. Is there some way to have Excel automatically enter the
> negetive sign?
Set up a custom format of (for example) -#,##0 . Then if you enter 2 in the
first cell so formatted, Excel will show -2.
I am not ...Computer doesn't switch off automatically.
I have a computer running Windows XP Home.
Until recently to switch this off I'd START > Turn Off Computer >
Turn Off. This would then tell me "Saving your settings" followed by
"Windows is shutting down". The computer would then switch off
Then, inexplicably, it stopped switching off automatically but just
hung at "Windows is shutting down" - leaving me to hold down the POWER
button to switch off the computer.
Thinking this was a problem within my Windows I re-installed it
expecting that to resolve the matt...