Access doesn't see decimal point!
I have linked to an Oracle table using Access 2003. The Oracle table
contains a PRICE field which has decimal data such as 15.50. When
querying this data with Access, 1550 is displayed. The decimal point
On my other computer which has Access 2002, 15.50 is correctly
What could be the issue? Any info would be appreciated.
I thought of that as well, but the regional settings are the same.
English - Canada
The strange thing is that the data being displayed by the Access query
does have decimal places because when I do a query for (PRICE < 2.00...Find and Replace
Could you please elaborate what is the function of Control Find and Replace.
Especially when using it to replace a formula to a new coloum
It find stated values and replaces them with your stated replacement.
"bio" <firstname.lastname@example.org> wrote in message
> Could you please elaborate what is the function of Control Find and
> Especially when using it to replace a formula to a new coloum
...picking out matched data
I have 2 different sets of data each with 3 columns. I am going to place the
2 sets of data on Sheet 1 of a spreadsheet and Sheet 2 of a spreadsheet. The
data in a row across the 3 columns pertains to each other. This is true for
the data on each sheet. I need to take the data from sheet 1 and have it
match up with any entries that exist on sheet 2, and have it show these
matches on sheet 3. The problem is the data in sheet 1 and 2 are not exactly
the same. On sheet 1 the data is: Customer Name, Transaction#, Acct#. On
Sheet 2 the data is: Customer Name, Reference #, Acct#...Problem writing to an "ini" file in Access 2007
I have been trying to use Access 2007 VBA to write values to an ini file.
Here is my code:
System.PrivateProfileString("OurInformation.ini", TypeOfData, VariableName)
This works fine in Word 2007 but I keep getting a 429 error in Access
("ActiveX component can't create object").
Why can't I write and read from an ini file in Access when I can in Word?
Should I be using some other code to write/read to an ini file?
"LA Lawyer" <email@example.com> wrote in message
news:%23Mw9TQ21KHA.3868@TK2MSFTNGP06.phx.gbl......Access 2003 and Sharepoint
My company is moving most of our files into Sharepoint -- however, it
seems no one could explain how Sharepoint is going to affect our
current Access database.
Can someone please enlighten me regarding Sharepoint and how it will
benefit us if our Access database is stored in it? Will it make
accessing the database faster through our network? Right-now our
database is stored in a network drive and depending on where we are
located from the server -- it may take long to accesst the data.
Or any sites that will help explain the process of Sharepoint.
You cannot store your A...replace N/A by a blank
How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
the value if eveything is fine
In article <C7212BB1-1BC7-4546-ADFD-1985ED9AE697@microsoft.com>,
yyy <firstname.lastname@example.org> wrote:
> How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
> the value if eveything is fine
...Restricting Access to specific functions and overriding Lock recor
Hi, We have just implemented CRM 3.0 and things are going very well. However,
I would like to restrict some of the functionality of the sales people in the
team. I would like to disable the ability for them to assign records to
themselves i.e. records created will automatically be assigned to the owner
of the Company record? I have checked the security roles but cannot see how
to do this?
Also Is there a security setting that lets a user over ride locked records
for example when a quote has been activated it cannot be changed, what if we
want to change it can this be done?
Thanks for ...outlook web access cant reply to a message
i have a strange situation where i can use the same account from two
different pcs and on one owa connection i can call up a message and hit reply
and get a reply window, fill it in and send it. on the other machine i can
hit reply and no window comes up and the message i am reading will go away.
i can log on to the machine where the problem is under a different account
and not have the problem with owa doing replies.
i think it must be either outlook or ie related with that user's config on
that machine. have you had this before?
I was about to suggest that you look for a popu...Find and Replace in Access 2007
I have address columns:
705 First St #5
804 Main St #16
I just want to remove the pound (#) signs.
How do find/replace for just the #?
I tried the Replace Function but it deletes the entire cell.
I also tried the RemoveAlpha but I get an error saying its an
BACKUP DATABASE BACKUP DATABASE
Try this --
Replace([YourField], Chr(35), "")
Build a little, test a little.
"lil lam" wrote:
> I have address columns:
> 705 First St #5
> 804 Main St #16
> I just want to remove the ...Recreate VLookup in MS Access 2003 Form Using DLookup.....
PLEASE!!! Don’t reply back and tell me to use DLookup() unless you also
provide the coding I need as well. I have been trying for weeks to use
DLookup() and cannot code the query properly and I am VERY frustrated.
The MS Excel VLOOKUP query I am trying to recreate in MS Access 2003 is as
Example "Config No": MTU0301-0010
Example "Concatenated Config No_4" data:
0020000100050001000100010001000200050001000100010003000200030001000200030001000100040004000200010001000...Making pick list conditional on selection from previous pick list
I would like to know how to make a pick list (a "list" of names) conditional
on what was picked in the previous column pick list (e.g. of the 4 main areas
of a plant (pick list/ column A), there are anywhere from 3 to 5 sections
within each main area. I would like to format/program the second pick list
(coumn B) to only show the list of sections corresponding to the 'main area'
selected in column A. Then I need to do this for a third pick list (specific
equipment). If you have an example, it would be appreciated.
See Debra Dalgleish's Depend...How do I change highlight colour in Find and Replace
This applies to Word 2007. I saw the previous answer from you Danish MVP,
however when I go into the Find & Replace function, the Find item is
highlighted in blue even thought the font highlight colour is yellow. The
only time the Find item is highlighted in yellow is if the option 'Reading
Highlight -> Highlight All' is selected. I would like to change the highlight
colour only where there next Find item is selected, which is the default of
the Find & Replace function.
Thanks in advance,
As far as I know, you cannot customize the color that indicates...Outlook97 can't access Exchange Server 5.0
When ever I try to go into the control panel and configure the mail option,
I receive a "information store couldn't be open" error message. I've removed
and reinstalled Outlook97 but still receive the same message. I've also
installed client for Exchange with the same result.
Workstation: Windows NT 4.0 w/office97
What would be the proper way to resolve the problem?
"Travis S." <email@example.com> wrote:
>When ever I try to go into the control panel and configure the mail option,
>I receive a "information store couldn't...HR Requisitions access
I am unable to give access applicant requisitions for the company, division,
position and department fields. This same user is able to enter these fields
on the employee maintenance card. I have tried everything I can think of in
the security setup but can't get past this. We don't want this person to see
any actual payroll information (wages, etc).
Thank you for any help with this.
..."Word-like" table in Access Reports ?
I would like to create a "word-like" table in an Access word. That includes
vertical and horizontal lines. Is there a way? Also, I need the text inside
the table to be able to grow. I tried using the graphic lines between the
text fields. The horizontal lines are fine, since the growing text fields
moves those lines down. However, the vertical lines do not grow.
I tried using a rectangle, thinking that perhaps as the text fields would
"push-down" the lines the rectangle. However, that did not happen.
Has anyone faced this problem?
Maybe this wil...Pick cell from chart
I am developing an estimating spreadsheet that calculates labor hours. I have
built a separate 10 column and 6 row chart with info I want to pull into the
estimating spreadsheet. The colums are labeled as "Difficulty Factors" and
the rows are labeled as "Pipe Sizes". Each intersecting cell is a portion of
a labor hour.
The estimating sheet has 3 drop down lists. I want to build a IF AND
statement that will select a intersecting cell in the chart if certain
criteria from the drop down lists are true.
There are 60 different cells in the chart. Is it necessary to write ...Replace Date
I have a list of Customer IDs and delivery dates as
Here, I am trying to query this table so that if Deliv_Date = 1/1/1998
then Deliv_Date = Null.
My result should be something like this
Can you please help me to query this result using Access query?
SELECT [Cust_Id], IIF([Deliv_Date]=#1/1/1998#,Null,[Deliv_Date]), ...
"Give some...Replace Number
I have over 400 entries in a colomn which start with 0015...and then more
how can easily edit on mass so that they now begin with only 015 ???
To get these leading zeroes there are 2 likely possibilities:-
1. The cells are formatted to show them so simply alter the format.
2. The numbers are really text and I have assumed this is the case.
So if the 'numbers' start in a1 put this in b1 and drag down
Copy this new range and then select the 'old' range and
Edit|Paste special - select values - OK
delete t...Access 2003
I was using this function with Access 2000 and it was working fine; however,
I upgraded to Access 2003 and now it will not work. The Error message is
"The object doesn't contain the Automation object "MaxValueVariantArray."
You tried to run a VB procedure to set a property or method for an object.
However, the component doesn't make the property or method available for
automation operations. Can someone please assist. Thank you
Option Compare Database
Function MaxValueVariantArray(ParamArray ValuesArray() As Variant) As Variant
' ** THIS FUNCTION RETURNS...Order Pick-Up When Out of Stock
If you have an item on order (Layaway/Back Order/Work Order) which has no On
Hand quantity, you can still pick up the item. This causes the quantity to
become a negative number, even though the "do not allow sale of items when
out of stock" option is set.
Either the order pick-up routine should be modified to respect this option,
or there should be a new option for "do not allow pick-up of items when out
Hello Dear Sir/Madam
I have email in Yahoo&hotmail Account but I like to put both of them in
outlook how can do this please help me on that
"Mojtaba Sahak" <Mojtaba Sahak@discussions.microsoft.com> wrote in message
> Hello Dear Sir/Madam
> I have email in Yahoo&hotmail Account but I like to put both of them in
> outlook how can do this please help me on that
Yahoo.com mail will require you to have a paid-for account - for Hotmail you
need to convert your Hotmail account to a Hotmail Live account ...Impersonation and Custom Event Log
I have created a Custom Event Log. My ASP.NET application is
impersonating a specific Windows Account that currently has no
permissions on the web server, apart from Modify access to C:\WINDOWS
\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files.
I cannot currently write to the event log. I am using the Logging
What is the best practice way of writing to the event log when using
impersonation? I'd like to do this from within ASP.NET if possible and
I want to avoid raising permissions as far as possible.
...Find and replace new line character
I would like to find and replace a return character (or new line, or \n, or
chr(10) -- take your pick) at the beginning of a field with an empty string
I would really rather not have to write an update query or a script. Is
there a way to enter special characters into the find & replace dialogue box?
I would expect to be able to find "\n" and replace with "", matching "Start
of Field" but that doesn't work.
I'm using Access 2003.
On Sun, 2 Dec 2007 17:50:00 -0800, mmapes
The F&...Pie chart from access
I would like to know if there is a way for me to create a set of pie chart
which get their source information from an access database set of queries (1
query per chart) and then update when the workbook is opened? If so, what is
this called so I can google it specifically? Any good ressource that
demonstrate the basics to bring me up to speed?
I don't believe you can link and Access table or query to an Excel
spreadsheet. However, you could set up a routine to automatically export the
Access table into Excel. Once the data was exported from the database, your
Ex...MS Access 2007, Vista, network performance
I have a Vista Ultimate machine running Access 2007; this hardware
previously ran XP Pro with Access 2003. Now that I've upgraded, I've
found that I can't use even small Access MDBs that are stored on a
network share, while the same MDBs copied to local storage seem fine
(although slower than I remember with the old setup).
These MDBs are still in 2003-format, and don't seem to have any problem
being opened on the same network with XP/Acc2003 or even XP/Acc2007.
Clearly, I think my issues are Vista-related.
Although I'd love someone to respond with "here's ...