|
by: Billy Cormic |
last post by:
Hi,
I would like to create a calculated column using the formula
section for a table. I am having some trouble doing this.
The table's name is ReportParameter. The calculated column's name is
tbcalculatedcolumn and tb1 and tb2 are boolean columns in the table.
I would like to use an If then statement such as the following (in
psuedo code):
If tb1 = 1 then tbcalculatedcolumn = 1
|
by: vulcaned |
last post by:
I'm thinking I might want to move the back-end to one of my Access97
applications to SQLServer instead of continuing to use Access jet but
before I start/do that I have several questions I'm hoping can be
answered as I have not yet used SQLServer for a back-end.
1. Just moving my tables from a jet back-end to a SQLServer back-end
and not changing anything else will not improve performance, True????
2. If I create pass-thru queries can...
|
by: Orchid |
last post by:
How can I change a Date datatype to a Number datatype? For example, I
want a date 10/31/2006 to show 1031 as Number datatype. But I don't
want it becomes 39021. What formula should I use? Thanks for your
help!!
|
by: muddasirmunir |
last post by:
i am using vb6 and crystal report 10 with sqlserver 2000
i made a formulal field in crystal report 10 where i had a table
name sales , it has two numeric fields credit and debit and
give theme a code
(slaes.credit)-(sales.debit) +200
and then made a runnnig total of formula field
its work fine
|
by: mlwerth |
last post by:
Dear Access Group:
This is the most basic and most embarrassing of questions, but I
cannot find where to change the data type of a text field that I have
in Access 2003 to a number field. I've searched high and low through
help databases and on the internet.
The directions say to :
Open the table in Design view
Click the Data Type column of the field you want to change, click the
|
|
by: Reshmi Jacob |
last post by:
Hello.....
In my program I have 3 variables, say
a = 10
b = 20
c = 30
I have a variable as string
|
by: =?Utf-8?B?amtyYW1vczIwMDU=?= |
last post by:
Hi,
I had received some help earlier in the week with regards to writing a
Change Macro for Excel. Now I am getting an error message and I wanted to
confirm why. Below is the part of the code that is highlighted with I get
the error message:
Run-time error '1004':
Method 'Range' of object_Worksheet failed
|
by: =?Utf-8?B?c2lwcHl1Y29ubg==?= |
last post by:
Hi
In C# ide if you have a SqlServer attached and Create a New XSD Item in a
solution you can then drag a db from the SQLServer and ti creates a XSD
modelled after the db. Can this be done thru code???
If I have a EXE that is passed a db can I generate a XSD on the fly???
Thanks
|
by: greglobal |
last post by:
I have a varchar couln in a table. How do i store a formula with superscripts like x^2 + y^2 = z ^ 2 which appears as a mathematical formula as x square 2 + y square 2 = z square ?
Thanks
atul
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|