Subform combobox won't populate from linked table
My Access 2003 database is shared across a network using a front end for
forms and a back end for data. After a recent upgrade of hardware I am
having problems with one desktop pc that will load the subform except that
one combo box (out of many) remains blank. The combo box like all the others
in the form is using data from linked tables. I have refreshed the link for
that table for that machine but have been unable to get the combo to populate
with data. I have also tried it with different user templates using full
Access install and Access runtime without results. Does an...excel emailed as the body of email loses formating
Now when I send an excel spreadsheet as the body of the email instead of as
an attachement it losses the formating ie. lines font alignment. If anyone
has a solution for this please help............ Thank you, Earl
p.s. I believe it started after a auto update from MS. It has affected all
the computers at my work even though they have diffrent versions of windows,
excel, and outlook.
...Paste special treats cells as a picture
I just got a new computer, and a newer version of excel, which is great, but
whenever I try to copy from one file to another, my paste special function
treats the copied cells as a picture. Instead of the normal paste special
popup, where it asks me how I want the data to come out, I get a different
popup that shows the source as a "Microsoft Office Excel Worksheet Object."
It asks me what format I want the picture to come out as, and gives me a list
of different file formats. If I try to just paste a link, it puts a picture
of the other file on the new one. I talked to so...Cannot access more than 250 items in a folder
My company has a custom Outlook form for handling vacation and sick time
requests. The form has fields for start date/time, end date/time, name,
I'm trying to write some code that will process a bunch of saved requests
and display some totals, but I'm having trouble. The code simply stops
working after about the 250th item in a folder. Any attempt to get at
the custom properties of any item after the 250th is a blank.
Here's some very simple code I wrote to illustrate the problem. It loops
through each saved item and checks if the "requestor" property contains
...how do i plot this kind of data using excel
need a help in plotting data presented in class form, e.g; variables for A in
condition 1 ranges from 67-89, in condition 2they range from 52-67, in
condition 3; 65-87, in conditon 4, 62-83.
Variables for B in condition 1 60-77,in condition 2, 50-64, in condition 3,
54-73, in condition 4 51-70
Try setting your data up like this:
A1 67 89
B1 60 77
A2 52 67
B2 50 64
A3 65 87
B3 54 73
A4 62 83
B4 51 70
Then, plot it using either a clustered column chart or a stacked column chart.
> need a he...Copy and paste formula; Value pastes instead
I've tried starting several worksheets, checking formats,
pasting special (formula only). For some reason the
formula actually copies OK by looking at the formula bar,
but the value in the cell is identical to the value of
the copied cell.Incorrect. Tried even the simplest
formulas with no joy.
...Will excel 2003 format a cell to the year?
It seems like it should be obvious, but I am finding it impossible to
get excel to do a date format that recognizes a year. Is there some
I typed a date in A1 (09/28/2006)
and used format|Cells|number tab|custom category|yyyy
with my USA settings.
> It seems like it should be obvious, but I am finding it impossible to
> get excel to do a date format that recognizes a year. Is there some
...Using Outlook 2003 Lotus Connector
I use Outlook XP and have it configured to use the Lotus Server connector
and it works great. Recently I tried to config Outlook 2003 to use the Lotus
Connector that is built into Outlook2003 and it fails everytime. Outlook
loads but then closes and says the connector failed. Anyone have any ideas?
That connector that looks built in is leftover cruft from your Outlook
2002 isntall. Ignore that. You need to wait for the Outlook 2003
connector, which is supposedly in beta now.
Until then, IMAP/LDAP is your buddy -- sans calendar, of course.
> I use Outlook XP ...access
��� ����� access?
��� ���� ������������ access?
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5167 (20100602) __________
The message was checked by ESET NOD32 Antivirus.
...Is there an Excel formula to round a date to the end of the month
User enters a specific date, I'd like to round that entry to the end of the
With a date in A1:
step into the next month and then back one day.
Gary''s Student - gsnu201003
> User enters a specific date, I'd like to round that entry to the end of the
This requires the Analysis ToolPak add-in be installed for Excel versions
prior to Excel 2007.
A1 = some date
Format as Date
Microsoft Excel MVP
"Siralec" &...PLEASE HELP: automate process to import tables from notepad to acc
Is there a way to import tables that are in text file (notepad) into access
automatically? at a specified time?
How can I do this?
I have a location where I receive 10-15 tables in text format (notepad) and
I want to import all those tables in access (access.2007) at a specified
time. Can this be automated?
Thanks in advance.
On Thu, 29 Apr 2010 10:15:01 -0700, sam <email@example.com> wrote:
>Is there a way to import tables that are in text file (notepad) into access
>automatically? at a specified time?
&g...Cannot access CRM
We have just migrated from Groupwise to Exchange 2003 as part of our move to
CRM. The migration had some issues but those have been resolved. There is one
user whose mailbox was deleted and recreated as part of the troubleshooting.
His Exchange account appears to be functioning correctly now. The problem is
the user is now unable to access the CRM website, whereas he could before the
migration. I discovered the problem when trying to install the CRM Sales For
Outlook client on his workstation. When I was prompted to enter the URL of
the CRM website, I received an error message saying &q...Unable to upgrade to Access 2000 from Access 97 and preserver Access 97
I have a workstation running W2K Service pack 4. On the machine is
Access 97. When I load Access 2000 to a unique directory it skips the
part on asking me to preserve Access 97. After the install 97 is
I removed Access 2000 and installed Access 97 again. I tried to
install Access 2000 into the same directory as 97 and it still skips
that step of asking me to preserve.
Anyone know if this is a registry setting that is having me skip this?
I tried both an upgrade version of Access 2000 and a full version of
If you do a *...RegisterBluetoothComPort function question in bluetooth test
we have a MIPSII BSP and board with UART 0,1,2,3
BSP uart driver define(nxc26uart.reg) and suport physical com port 1,2,3,4
i take reference from :
and AP sample
then write an AP to simulate blooth manager.
at the call h=RegisterBluetoothComPort(L"COM",index,&pp));or
h return NULL ,index=1,2,3,4
h return handle, if index...Excel
Can someone please help me. I have been trying to figure this one out all
day. It seems so simple, I guess I'm brain dead.
I'm trying to write a formula that will return results for the folowing
aaa A A B B A
bbb C A B B C
ccc A A B B B
aaa C C A A B
bbb C A B B C
ccc A A C C A
I need a formula that will count the total number of times each of the colum
results (A,B and C) appear for e...Searching against disabled users using Advanced Find
I am trying to search for leads using Advanced Find where
owner=disabled user. We need to reassign all of the leads owned by a
terminated user to a new user. When selecting owner as a search
parameter, disabled users do not show in the lookup. This is also the
case when trying to search against the created by and modified by
Is this simply a limitation of advanced find or is there a selection
option i am missing? If so, any workarounds anyone can think of other
than temporarily enabling the user?
Thanks in advance.
Try using the FilteredViews to build a report to show the l..."Paste Special" with the right click mouse
I would like to have the option of "Paste Special" with the right click mouse
in all microsoft office suite.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=de847738-df56-4...Delete row in table by code
I have a table named Uploaded Documents that is created by a code that was
developed by someone that used to work here. I have no coding experience so
need some help. I need to add something to the end of his code that would
delete any row where in the field SVBrand it contains either ## or @@
anywhere in that field. Any help would be apprectiated.
Put this in the code and it will delete those rows:
strSQL = "DELETE * FROM [Uploaded Documents] WHERE svBrand = '##' OR
Dave Hargis, Microsoft A...Clipboard pasting
I copy something to the clipboard using Publisher 2007 and the computer tells
me it is in the clipboard; however, when I go to paste that information into
another document, Publisher acts like it is not there. I then need to close
the document I wish to paste it into, reopen it, and then, like magic, there
is the information in the clipboard and I am able to paste it. UGH!!!!!!
Open the Office Clipboard in Publisher. Edit, Office Clipboard. What program
are you pasting to? If it is an Office program, open the Office Clipboard in
that program too.
...Access 2007 Disable Mode
When I try to run an update query or a make table query, the application wont
run and gives me the following erro message.
"The action or event has been blocked by disable mode."
How can I disable the disable mode?
This should help:
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
> When I try to r...Copy/Paste loop
I have a form on one sheet in excel, on the next sheet i have mad
different coloums with different headings. I want the data from th
form to be copyed to each heading e.g. name in form is copyed to unde
the coloum with title name.
So each time a user fills in there details he/she clicks submit an
there data is copyed to the next page, like a small database.
Is there a macro that can do this as i keep getting different error
each time. I want this to continue in a loop
Message posted from http://www.ExcelForum.com
This might get you started:
Opti...Cannot import send/receive dates for emails stored in Access (.mdb) file
I have some mdb (Access format) database files with thousands of emails
extracted from couple of Yahoo groups forums. I'd like to import these
into my Outlook 2003 PST so that I can search and read them offline.
The mdb files contain all the fields necessary for a proper email
message (HTML format)
When I use the Outlook "Import and Export Wizard", selecting Access
file type, etc., all appears fine. However, after the import
completes, in Outlook there is no date information populated under
either sent ...How do I remove links to external excel files
I need to remove the links to another excel file from my
new workbook. How can I accomplish this without re-
creating the spreadsheet from scratch?
Remove links means convert those formulas to values?
If you can find them, just copy|paste special|values.
But they can be difficult to find. I'd use Bill Manville's addin to help find
the pesky ones.
(And it's easy to use.
> I need to remove the links to another excel file from my
> new workbook. How can I accomplish this without re-
>...Pasting formulas advances cell reference
When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.
A1 formula ='Feb 2010'!C18 but when i paste it into another cell it pastes
The C changes to D, how do i stop this happening?
Thanks for any help in advance
Use absolute referencing. Below are the different reference styles.
A1 Relative referencing. Both column and row will change if you copy or drag
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and wil...Cannot e-mail an Access report using Excel
When I want to e-mail an Access report in Excel, that option is grayed out.
It worked with 2003 but not with 2007. I searched everywhere for an answer
but no solution. Does anyone know how to make this work?
You are very much in the wrong newsgroup.
Mary Sauer MSFT MVP
"mtnman" <firstname.lastname@example.org> wrote in message
> When I want to e-mail an Access report in Excel, that option is grayed out.
> It worked with...