473,387 Members | 1,536 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Access Default Values

Greetings,

I have a VB application that uses an Access database. One of the
fields in a table I write to has a default value of Chr$(168) which
seems to work fine for all users except 2 users in Taiwan. When I
open a database returned from a Taiwan user the table has the data I
wrote to it but the default value fields are blank. If I manually
type new records in the default values are correctly set to Chr$(168).
Any ideas why?

Any help appreciated.

Thanks,
Wayne
Nov 13 '05 #1
2 1667
On 1 Nov 2004 08:55:47 -0800, wa***********@yahoo.com (Wayner) wrote:

They use a different code page than you are.
-Tom.
Greetings,

I have a VB application that uses an Access database. One of the
fields in a table I write to has a default value of Chr$(168) which
seems to work fine for all users except 2 users in Taiwan. When I
open a database returned from a Taiwan user the table has the data I
wrote to it but the default value fields are blank. If I manually
type new records in the default values are correctly set to Chr$(168).
Any ideas why?

Any help appreciated.

Thanks,
Wayne


Nov 13 '05 #2
Thanks Tom,

I'm not familiar with code pages, where can I look? I looked in the
Access help file but they weren't helpful.

Regards,
Wayne

Tom van Stiphout <no*************@cox.net> wrote in message news:<85********************************@4ax.com>. ..
On 1 Nov 2004 08:55:47 -0800, wa***********@yahoo.com (Wayner) wrote:

They use a different code page than you are.
-Tom.
Greetings,

I have a VB application that uses an Access database. One of the
fields in a table I write to has a default value of Chr$(168) which
seems to work fine for all users except 2 users in Taiwan. When I
open a database returned from a Taiwan user the table has the data I
wrote to it but the default value fields are blank. If I manually
type new records in the default values are correctly set to Chr$(168).
Any ideas why?

Any help appreciated.

Thanks,
Wayne

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Andrew L. Gould | last post by:
This email is semi-off topic; but documents a problem and the server-side solution when using MS Access as a client to many (all?) database servers. I decided to post the problem/solution because...
14
by: Sean C. | last post by:
Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...
0
by: ImraneA | last post by:
Hi there I had pleasure of upsizing Access v97 db to Access v2K/SQL 2K. Wish to provide some knowledge gained back to community - hopefully help others. 1.Question how do you test stored...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
9
by: Shivam | last post by:
Hi All, I have a mysql dump file... something like. __________________________________________________ CREATE TABLE nation ( ip int(11) unsigned NOT NULL default '0', country char(2) NOT...
4
by: RedHair | last post by:
I developed a Win form with VS.NET 2005 + .NET 2.0 in C# There are some application settings are "User" scope and stored in xxx.settings, I can access them via Settings class and changethem with...
1
MMcCarthy
by: MMcCarthy | last post by:
Access has a number of built-in functions which can be generally used in queries or VBA code. Some of the more common ones are: Note: anything in square brackets is optional Date Functions ...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.