Hello all,
I have an Access database linked to SQL Server tables and Views.
When I upsized the Access tables all the yes/no fields remained the
same, i.e., I see a check mark or not. When I create a yes/no field in
SQL Server, I see a 1 or a 0. I would like the new SQL server fields
to show me a check mark in the Access front-end. Is there any way of
doing this?
Also, for data entry purposes, I need to be able to enter mm/yyyy and
have the slash there automatically. It seems like SQL Server will not
let me do it. Can anyone tell me if it is possible, and how to do it?
I appreciate all the help I can get!!
Thanks,
Monica 2 3230
A few days ago I posted the following, does anyone have an answer?
thank you!! Hello all, I have an Access database linked to SQL Server tables and Views.
When I upsized the Access tables all the yes/no fields remained the same, i.e., I see a check mark or not. When I create a yes/no field in SQL Server, I see a 1 or a 0. I would like the new SQL server fields to show me a check mark in the Access front-end. Is there any way of doing this?
Also, for data entry purposes, I need to be able to enter mm/yyyy and have the slash there automatically. It seems like SQL Server will not let me do it. Can anyone tell me if it is possible, and how to do it?
I appreciate all the help I can get!!
Thanks,
Monica
Monica,
My experience with SQL Server backends is limited, but...
I assume that the examples you cite are from the A2K front end. So formating
what you see is accomplished from the frontend and is not related to the
backend.
1. Yes/No fields - You claim to see 0 & 1. I suspect that you actually see 0
& -1. This is how the data is stored, 0 means false/no and -1 means
true/yes.
2. If you want to see a checkbox, then set that as the format property. If
you want to see a checkbox from the table, then set the format property of
that field in the table design. If you want to see a checkbox from a form,
then set the format property of that control in the form design.
3. If you want to enter data into the format of mm/yyyy and have the slash
appear automatically, then that is accomplished using the input mask
property, example 99/9999. Remember that this is not a date so this field
must not be defined as date. It must be defined as either numeric or text.
Fred Zuckerman
San Diego, CA, USA
"Monica Roman" <mo*********@ya hoo.com> wrote in message
news:9e******** *************** ***@posting.goo gle.com... A few days ago I posted the following, does anyone have an answer? thank you!!
Hello all, I have an Access database linked to SQL Server tables and Views.
When I upsized the Access tables all the yes/no fields remained the same, i.e., I see a check mark or not. When I create a yes/no field in SQL Server, I see a 1 or a 0. I would like the new SQL server fields to show me a check mark in the Access front-end. Is there any way of doing this?
Also, for data entry purposes, I need to be able to enter mm/yyyy and have the slash there automatically. It seems like SQL Server will not let me do it. Can anyone tell me if it is possible, and how to do it?
I appreciate all the help I can get!!
Thanks,
Monica This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Lauren Quantrell |
last post by:
I'm hoping someone can tell me if I'm doing the correct thing here or
if there is a better way to do this with Access2K connecting to SQL
Server 2K:
Dim myConn As String
myConn = "PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST
SECURITY INFO=FALSE;INITIAL CATALOG=myCatagolName;DATA
SOURCE=myServerName;Network=DBMSSOCN"
CurrentProject.OpenConnection myConn
|
by: Lauren Quantrell |
last post by:
I'm trying to drop a file from Windows Explorer (or desktop, etc.)
onto a field in Access2K and capture the full file path.
I found an posting below that says this is possible but I cannot
simutate it.
Can anyone help?
Thanks
**************************
previous post:
Message 1 in thread
|
by: Monica Roman |
last post by:
Hello all,
I have an Access database linked to SQL Server tables and Views.
When I upsized the Access tables all the yes/no fields remained the
same, i.e., I see a check mark or not. When I create a yes/no field in
SQL Server, I see a 1 or a 0. I would like the new SQL server fields
to show me a check mark in the Access front-end. Is there any way of
doing this?
Also, for data entry purposes, I need to be able to enter mm/yyyy and
|
by: Dave |
last post by:
How can i detect the date style that the users system is using.
I have some customers that have dd/mm/yy and some that have dd/mm/yyyy
I have a input mask (99/99/00;0;_) that is set for dd/mm/yy.
Is it possible to check what format the system uses and then dynamically
alter
the input mask in the OnOpen Event
|
by: F. Michael Miller |
last post by:
I have a db with Access front end, sql back, linked tables. I need to be
able to change input masks at the table level in code.
Any ideas?
Thanks!
| |
by: mrhicks |
last post by:
Hello all,
I have a question regarding efficeny and how to find the best
approach when trying to find flag with in a structure of bit fields. I
have several structures which look similar to
typedef unsigned long int uint32; /* 32 bits */
// Up to 36 request flags, so this will take up to 3
|
by: Charles Law |
last post by:
Sorry for asking this one again, but with the newsgroup now holding things
for an ever shorter time, I can't find my original question (and the
answers) from a few months ago.
I know that structures in VB.NET don't have bit fields, but I am looking for
a convenient way to reproduce the convenience afforded in C/C++.
If I have
typedef struct _MyStruct {
|
by: carriolan |
last post by:
Hi
I have a very simple problem indeed, but I am unable to solve it. I
am inputing a short date into an unbound text box with a short date
input mask. I am in the UK so my date format is dd/mm/yyyy. Everything
works superbly well with one exception.
Example: Suppose I accidentally keyed in 04/13/2005 the program
assumes that I meant 13/04/2005 and swaps the day and the month field
around without displaying an error, so the date is...
|
by: andrew |
last post by:
Hi,
I am trying to develop a database that will store dates in the format -
21.02.2006 rather than the standard 21/02/2006.
This is because of the SAP feeds that i am pulling in - since SAP
stores dates as dd.mm.yyyy
I would just store the dates as text but this makes processing the data
much harder.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |