DO NOT Convert

Oct 26, 2006

We have both Access 2003 and Access 97 users on our network and i have a database that is written in 97. But lately we've been getting unrecognized format when we open it. So my guess is someone out there is opening it in 2003 and converting it. Is there a way to tell the database to ONLY run on 97 and DO NOT convert to a different version?

Thanks,
Rick

View Replies


ADVERTISEMENT

Convert XLS To CSV

Oct 10, 2005

Maybe someone could point me in the right direction:

What I am trying to do is convert a XLS file to CSV by the press of a button, how would I go about doing this?

Cheers

Will

View 14 Replies View Related

Convert Db

Oct 15, 2005

Ineed a Db converted to 97 can some one do it for me.
I only have 97 on my machine at home

View 2 Replies View Related

Convert To Yes / No

Aug 7, 2006

I have the following SQL Expression :
SELECT tblDeal.DealCode, UCase([HirerForename] & " " & [HirerSurname] & " " & [HirerBusinessName]) AS FullHirerName, UCase([DealerName] & " ( " & [DealerTownCity] & ")") AS FullDealerName, tblHirer.JointHirer, tblDeal.DateDealIn, UCase([CurrentStatus]) AS FullCurrentStatus, UCase([CurrentFinanceCo]) AS FullCurrFinCo, UCase([LastUser] & " / " & [LastUserDate]) AS FullLastUser, tblDeal.InUse, tblVehicles.VehicleRegNo, tblDeal.DealType, tblDealer.DealerName, tblDeal.LastUpdatedDate, tblDealer.DealerName, tblDeal.DateDealIn, tblRep.BrokerCode, tblHirer.HirerCurrPostcode, tblDealer.DealerTownCity, tblDealer.DealerFranchise1, tblDealer.DealerFranchise2, tblDealer.DealerFranchise3, tblDeal.LastUser, tblDeal.LastUserDate, tblHirer.HirerSurname, tblHirer.HirerBusinessName, tblHirer.HirerForename, tblHirer.ProposalType
FROM tblVehicles INNER JOIN (((tblBroker INNER JOIN ((tblRep INNER JOIN tblDealer ON tblRep.RepCode = tblDealer.RepCode) INNER JOIN tblDealerContacts ON tblDealer.DealerCode = tblDealerContacts.DealerCode) ON tblBroker.BrokerCode = tblRep.BrokerCode) INNER JOIN tblHirer ON tblDealerContacts.DealerContactCode = tblHirer.DealerContactCode) INNER JOIN tblDeal ON tblHirer.HirerCode = tblDeal.HirerCode) ON tblVehicles.VehicleCode = tblDeal.VehicleCode
WHERE (((tblDeal.DateDealIn)>=[Forms]![frmSearchCustomer]![Text110]) AND ((UCase([CurrentStatus]))<>"Deleted") AND ((tblVehicles.VehicleRegNo) Like "*" & [Forms]![frmSearchCustomer]![Combo96] & "*") AND ((tblDealer.DealerName) Like "*" & [Forms]![frmSearchCustomer]![Combo92] & "*") AND ((tblRep.BrokerCode)=[Forms]![frmIntro]![BrokerCode]) AND ((tblHirer.HirerCurrPostcode) Like "*" & [Forms]![frmSearchCustomer]![Combo100] & "*") AND ((tblHirer.HirerSurname) Like "*" & [Forms]![frmSearchCustomer]![Combo29] & "*"));

What I would really like to do is tell the query to dislpay YES or NO instead of 0 or -1 in the Joint Hirer field. Can anyone help please

Thanks

View 1 Replies View Related

Convert Hh:mm:ss To Seconds

Jun 1, 2005

Hi

This is my 1st post so please be gentle

I am running an Access Database for a large uk companys call centre.. I use many diffrent systems which allow me to show our centres productivity...

I have hit a wall

When i first developed the DB i used the time formatting hh:mm:ss but later down the line i found if you *the time by 86400 it converts the hh:mm:ss into a workable seconds format....

One of my old extracts that i feedinto the DB are in the old format therefor i do this calculation within an access query which *the time by 86400

however i have found an probelm.. if the time is over 24hrs it seems to double the time there or there abouts in seeconds

example

01/01/1900 01:42:00 which is basically 25 hrs should be around 92520 seconds

when is do this calculation in an access query it is coming out 178920 all the other times are correct so this rules out how i link 2 querys ....

any ideas???

View 3 Replies View Related

Splitting Db - Convert Or Not?

Aug 17, 2006

Hi, hope someone here has experience with this issue.

Our system was recently converted to much tighter secured network environment and moved to Office 2003 (still Windows XP).

Within the next couple of weeks we expect to split/secure our new db for shared use across a network (approx. 6-8 users at any one time).

I want to keep the db in 2000 as long as possible because I'm doing lots of the work at home and that's what I have. After deployment there will be lots more changes but in managed releases. (sounds official, eh?...)

Does anyone know of any risks I'm running by keeping it in 2000 within Access2003?

Thanks very much,

View 4 Replies View Related

Convert 0 (zero) To Null

Apr 23, 2007

Hi.
I have a db with a numeric field called Eur_2.
This field is populated with data imported from an excel file.
When the Eur_2 excel field contain Null, in the correspondent Access Field the value inserted is 0 (zero).
I have necessity to put in the Access field Null value.
The VBA code that I use for import is:

Eur_2 = XL.Application.Cells(indriga, indcolonna + 10)
If Eur_2 = 0 Or _
Eur_2 = Empty Then
Eur_2 = Null
End If

but when i open the Access table, the value inserted is 0 (zero).
There's something to do for change 0 (zero) to Null?

Thanks
Luigi

View 7 Replies View Related

Convert Access

Feb 16, 2008

Hello

It been a while since i have been on the forum. I developed a database last year and since then i have moved to a MAC.

I would like to know if there is a quick and easy way of converting a database to application which works on any PC or MAC which does not have access?

View 2 Replies View Related

How To Convert XLS To MDB And Add An Index?

Feb 21, 2008

When I load a spreadsheet I can't add an index because it is a linked table, so I want to save it in MDB format so that I can add an index and then export it to SQL. However, when I save the file as an MDB file the data is all still linked as a spreadsheet and I still can't add an index. (I would add the index at the last step in SQL, but Pervasive SQL is very temperamental.)

Basically I just want to export an Excel spreadsheet into SQL and add an index.

View 3 Replies View Related

Convert To Currency

Jun 3, 2005

Hi All.
In my calculation in a query:
Cost: Sum([Cost]/12*(DateDiff("m",[StartDate],Now())))
Cost is Currency;
StartDate is Date.

The result look like Numeric format I would like to have Currency format. Is it possible?
Thanks.

View 1 Replies View Related

Convert Date

Apr 4, 2006

I have a query in which I am splitting a long integer into Month, Day, Year and then putting it back together using Date Serial in another query. When I originally set this up, the date was coming through as 5 numbers. Now it is coming through as six. However, Access will error out if I try to set it as a date.

So, how can I redo the fields below to get 2 digits for the month instead of one. The date now comes through as 041706

CInt(Mid([Field1],1,2)) AS iMo,
CInt(Mid([Field1],2,2)) AS iDay,
CInt(Mid([Field1],4,2)) AS iYear

View 1 Replies View Related

Convert To Date

Nov 8, 2006

Looked through DateSerial but possibly not the way to go. I have a text field, "Month", with the dates in this format: Jan-06, Feb-06. What do I use to convert these to date format? 1/1/06, 2/1/06.

Thanks

Toni

View 2 Replies View Related

Convert To Datetime And Right()

Nov 14, 2006

Hey Guys,

Having some trouble doing a couple of things using both Data Definition Language and a Right() Query.

What I am trying to do is convert this field:
August 17, 2006 3:56 PM
into this
15:56:00

Using this:
Right([Travel Date/Time To],InStr([Travel Date/Time To],",")-1)

Now because the time part in my first field can vary from being 3:56 PM to 12:56 PM Right() is only getting those where the time has two digits.

I tried to use DDL to convert my field to DATETIME but cannot convert two columns in one SQL statement.

Can anyone help me out with this? Sorry if the details are sketchy but I'm being kicked out of the office (after 5:00pm you see!).

Cheers.

View 1 Replies View Related

Convert A Row To One Column.

Dec 16, 2006

Hi,

I have a query that outputs results as follows:

Expr1 Expr2 Expr3 Expr4 Expr5
1 2 3 4 5


I want to write another query to output the above result as follows:

Expr
1
2
3
4
5

Does anyone know how to do this please? Thanks!

View 10 Replies View Related

Convert Num To Date

Apr 6, 2007

Hi all,I'v been at this for awhile nowI did a search and tried out some of the examples but for some reason they didnt work.Heres the format i have it in. D| O | B04 | 30 |1967 all in a text fieldI need to convert it into 4/30/1967I tried creating a new field called DOB and setting it to date/time and then using a concate query but it said it could not convert it.UPDATE Table1 SET Table1.DOB = [D] & "'/" & [O] & "/" & [B];UPDATE Table1 SET Table1.DOB = "#" & [D] & "'/" & [O] & "/" & [B] & "#";Please helpTake care

View 5 Replies View Related

CAST And CONVERT

Jul 12, 2007

My query is...
SELECT tblExtensions.Extensions AS 'PIN', tblExtensions.Budget AS 'LIMIT',

tblExtensions.Extension is text
tblExtensions.Budget is number

I would like to convert the tblExtensions.Budget to a text/character filed for further manipulation.
In SQL it all works, how do I change this in MS Access?

View 1 Replies View Related

Convert Null To 0

Dec 20, 2007

Hi Guys, i have a problem in converting NULL to 0 , i wrote a query which gave me a Null value, But i would like to know if there is any way i can change the NUll value to 0.

ex
SELECT Sum(xxxx) AS yyyy FROM zzzzz WHERE******=#####;

i got NULL.
I need to get 0 instead of Null.

Plz help

View 4 Replies View Related

Convert A Form Into ASP

Sep 14, 2004

I have created a database application using forms and reports as user interface. Now I have to make that database available on the internet. I was wondering if there is a way to convert the forms into active server pages without loosing any event handling code. Or do I have to design the pages from the scratch?

Will appreciate any pointers. Thanks.

GreetInfo

View 3 Replies View Related

Convert Access To Web

Mar 11, 2005

Can anyone tell me the best and easiest way to convert an
existing ms access database to run on the web.

I am just a beginner at this so please tell me in simple terms.

thanks

View 1 Replies View Related

Convert Number

May 27, 2005

i have data stored in my paid field as negative ex: 000000460p which is $40.00. how can i convert this into $40.00?
I know i have to make a query but how can i make access pick up all the negatives that end in P and transform them into a negativ e number?
thanks

View 12 Replies View Related

Convert To MySQL

Mar 28, 2008

I notice there is a lot freeware for converting Access database to MySQL. Can anyone recommend one that they've used (with no adware!).

Thanks,
GG.

View 3 Replies View Related

Convert Row To Column

Oct 15, 2011

I need to convert the following dataset from:

ClmSys Code
1111 V1
1111 V2
1111 V3
2222 V2
2222 H4
2222 H4

[code]...

View 4 Replies View Related

How To Convert ID Numbers Into A Name

Feb 24, 2015

I have one table with an auto-number field which creates an employee ID. I have another table where I want an employees name to appear rather than the ID. How can I convert these ID numbers into a name?

View 2 Replies View Related

Convert String To Number

May 31, 2005

I have a field on my Report called Revenue. It is used in a calculation and there is a calculated field called Profit. Revenue-Cost=Profit. That all works.

The only thing that is wrong is that the Revenue field displays its numbers like this:

0.7
12.43
4.3
0

etc.

i.e. not formatted for currency. But I don't get the currency option under Format. It is based on a Query and this Query is based on a Linked Table.

Any suggestions on how to get it formatted as currency while still having the calculated field working?

View 3 Replies View Related

Convert A Txt File To A Table

Jun 28, 2005

I have a txt file that includes X and Y variables like below, with a comma seperating the x from the y.

1.5,2
1.9,30.25
100.00,5.23
4.16,12.3
10.23,14.5
..
....
..... up to an unspecified number

how can I import the txt file data and place that data into a table.

A GPS device creates the txt file that will be placed in a folder.

thank you in advance

View 5 Replies View Related

Help To Convert Date To Week.

Aug 8, 2005

Hi,
I'm looking for a module wich converts a date to a week.
Ex: i type 08/02/2005 and i obtain Week #2
(Some years have 52 and other 53 weeks, depend on the date of the 1st week of the year, an other problem is that some people say the week begins the monday, other say it begins a sunday)
Maybe a built in fonction exists.
Thanks in advance for help.
VINCENT

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved