Parameter Conversion

Apr 6, 2007

Hi Guys,

I am using MS Access 2007 and have the following query:

SELECT HoursLostThroughAccident
FROM Accidents
WHERE AccidentDate LIKE ? +'%'

The error I get after selecting values from a drop down list like 2001 or 2002 is:

'Failed to convert parameter values from a string to a datetime'

Is there a way that access converts the values like 2001 to something like
01.01.2001 and the values which have dates that are in the year 2001 will be displayed?

Thanks for any suggestions,

Phil

View Replies

Conversion To SQL

Nov 3, 2005

I'm in the process of migrating my Access database to SQL, but am encountering problems. Firstly when I exported it I discovered that all of my Access queries had been converted to Tables. After deleting these, I attempted to cut and past the SQL code from the Access Queries to SQL's "views", which I had been taught were effectively the same thing.

However, now I come to test them I get an error that says it cannot be displayed because the query is a "view object".

What is happening here, am i doing the correct thing?

Thanks.

View 2 Replies View Related

PDF To JPG Conversion

Sep 1, 2014

I have thousands of PDFs of which I want to present a number as thumbnails on a form and allow the users to select any one and have the full PDF displayed.

The only way in which I can see this working is to have the thumbnail as a JPG image and set the On Click property to display the relevant PDF. This part is quite simple, the problem I have is converting the existing PDFs to JPGs.

Any way of converting PDFs to JPGs using VBA code?

View 6 Replies View Related

Date Conversion

Jun 10, 2005

I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?

View 1 Replies View Related

Date Conversion

Nov 18, 2005

I'm imported data from a csv file. The dates stored in there are in a dd-mm-yyyy time format. How can I work with this since Access's date format is just mm/dd/yyyy? I imagine I need to do some sort of conversion? Does Access provide anything for me to do this?

View 6 Replies View Related

SQL Conversion Tool

Jan 3, 2006

Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:

View 2 Replies View Related

Undo Conversion From 97 To 2K

Feb 17, 2006

We have an mdb back end on our server with read / write permissions for several approved users. One of them (don't know who yet) has converted the mdb file from 1997 to 2000. Is there a way to undo this? :o (a few have both versions on their machines which is why this was possible to begin to with)

We have had this set up for almost four years now, with no issues might I add but always knew in the back of my mind something like this would happen.

Thanks

View 1 Replies View Related

Access To VB Conversion

Mar 24, 2006

Hi,

I have been tasked with updating an Access 97 database with several forms that would take me a good while to recreate.

I wondering if there is a way to convert them from 97 to either VB6 of VB.NET that is free of charge to me. All the solutions I have come across thus far cost money, and it is not possible for me to do this.

I have tried exporting the forms to an external file but it won't let me save them as a file type that my VB6 installation can open.

Cheers
Murray

View 3 Replies View Related

Conversion Error

Apr 22, 2006

Hello,
Its been a long time since i've been in this forum. I have a question about a conversion error i received not sure whats its about

i'm converting from access 97 to 2000. i ran the access 2000 conversion utility and then the following appeared and the conversion error table

Object TypeObject NameError Description
TableMSysObjects-1611: Could not find field 'Description'.

It looks like the database is fine

View 3 Replies View Related

MS SQL Conversion And Deployment

Jul 31, 2006

Hi guys, I hope somebody can give me a quick step-by-step.

I've nearly completed a program written in Access and have started to venture into marketing the program to a local company. When asked what other modifications they would like to see i was sent an email stating;

"A major item would be to deploy in MS SQL. You should be able to do that free of charge with the low tier version of SQL."

I had a feeling this would come up, but I don't want to sound like a total idot when talking to these folks... I really have no true understanding of what they are asking, but I suspect it refers to conversion from jet. Question: Is this a reasonably easy modification? What do I need to purchase? Would I be better off telling them the program is 'as-is'? Can this be easily done by someone who has never done it before? I'm sure other threads addressed this issued but I would truly appreciate a full understanding of my specific problem. Thanks, Scott.

View 10 Replies View Related

Access To VB Conversion

Feb 11, 2007

Considering the difficulties in packaging Access software, I am wondering about the feasibility of converting my Access project to VB and distributing that instead. Has anyone done this and if so how difficult would it be. Does it mean a complete rewrite or can I use existing forms, reports and coding etc.

View 12 Replies View Related

Number Conversion Help

Jun 10, 2007

I am in the process of building a table on Access 97 where one column will have a list of various buildings. The problem is I will need to import a spreadsheet from Excel 97 into the Table, and although the spreadsheet will match the Access table in terms of column headings, it's data is numerical ie a number has been assigned for each buliding instead of the building name. I need the Access table to show the building name instead of the number.

Is there a validation rule I could use when creating the Access table where a number will = a specific building name. ie 1= Lunar House 2= Apollo House 3 = Mackenzie House etc. So when it does come to importing my spreadsheet the numbers will show as buildings.

Hope you can help....many thanks

Russell from UK

View 2 Replies View Related

Date Conversion

Jun 10, 2005

I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?

View 2 Replies View Related

Conversion / Format Help

Sep 6, 2005

I have 2 questions that I think maybe similar.

First Question
When building a Select query through query builder, is there a function or a way I can convert the field, fldWebSite, which is of the datatype Hyperlink to text? The problem I am having is that when I export the results to a csv or txt file, the field instead of saying "www.website.com" turns into "www.website.com#http://www.website.com#"

Second Question
When building a Select query through query builder, How do I convert a field that is of the type currency into a fixed 2 dec. number? Inother words, I get "$1,234,567.00" when what I really want is "1234567.00".

View 1 Replies View Related

Help With LIKE Syntax Conversion

Sep 11, 2006

Hello

I'm trying to convert my exsting LIKE Command to search Contians a word.

Example currently it will search for word starting with word in the search box.

I type in 2006, it will only look for project names starting with 2006.

I would like to Motify the search to "Contain" 2006 in the field anywhere.

Here's the code I like to convert.

"SELECT * FROM [qryProjects]" & "[PROJECT] LIKE """ & Me.txtSearchString2 & "*"" AND "

View 2 Replies View Related

Date Conversion

Jan 12, 2007

I have a time stamp field from an Oracle database that I want to convert to a regular date field in my Access query so that I can pull data from the table base on start and end date.
The time stamp field is formatted as: 09/19/2006 03:16:00 PM

In my query I have tried the following formatting:

1. DateRcvd: Format((Left([time_stamp],10)),"mm/dd/yy")
or
2. DateRcvd: Format([time_stamp],"Short Date")

Without criteria I get all the records in the following format:

1. 09/19/06
2. 9/19/06

Dates in the table are from 06/01/06 to current date 07.

Using the following criteria - I get varing results but never what I want. For example, using format #1, if I enter 09/16/06 and 01/10/07 I get everything for 07 and nothing for 06
If I use format #2, I get everything for 9/16/06 (no other records) and everything for 07

Criteria:
Between [Forms]![frmDateRange]![StartDate] And [Forms]![frmDateRange]![EndDate]

Any suggestions?:confused:

View 5 Replies View Related

Data Conversion - Help?

Sep 18, 2007

I have a table with data in the following format:

OppID Year 1 2 3 4 5 6 7 8 9 10 11 12
1 2007 $1 $2 $1 $3 $2 $3 $1 0 0 $3 $4 $2
I need to convert the data into:

OppID Date Amount
1 1/1/2007 $1
1 2/1/2007 $2
etc.
What is the best approach to complete this conversion 'on the fly', so that as the data is modified in the table, later the user can run a report (PivotTable) that uses the converted data? (Note that the day of the month is not defined, so I plan to assign each the 1st of the month).

Really would appreciate any help you can offer!

View 3 Replies View Related

Conversion From 97 Problem

Sep 3, 2004

I have this code in an Access97 database that works just fine. But it doesn't like it in Access2003. Any ideas of what the problem is?
Thanks in advance - John
_______________________________________

' this adds date checking

If Not IsNull(Me!StartDate) Then
If ArgCount > 0 Then myCriteria = myCriteria + " AND "
myCriteria = myCriteria + " [Main Table].[Date] >= #" + Me!StartDate + "#"
ArgCount = ArgCount + 1
End If
If Not IsNull(Me!EndDate) Then
If ArgCount > 0 Then myCriteria = myCriteria + " AND "
myCriteria = myCriteria + " [Main Table].[Date] <= #" + Me!EndDate + "#"
ArgCount = ArgCount + 1
End If

View 2 Replies View Related

Access 97 To XP Conversion

Oct 14, 2004

I have an Access 97 database that I�ve converted to Access XP. The font end database is on each user�s computer and the backend is on a network server. The database is updated with data from a mainframe db2 databases. I have 87 queries that pull the data from the db2 data base and import the data into an Access database that resides on a net work server. All these 87 queries are append and update queries that clean up the data and set it up in Access.

In the Access 97 database it takes 9 minutes to run all these updates but in the Access XP database is takes about 32 minutes. Both the front end database and network database are converted to XP. I have found that if you link a 97 table to an Access XP database, you slow everything down in the XP database ???, so I�ve made sure that all linked tables are XP. I�ve looked at my queries and tried to optimize as much as I can but nothing has worked.

I have several parameter queries that really seems to run extremely slow. I�m updating fields in on table with data from a field in another table. I using the query execute method with a loop to set the parameter each time and then execute the query This works well in 97 but in XP it�s extremely slow. I�ve changes indexes in the tables and at one point and at one point removed all indexes except for the index on the joining fields in the table.

All of the forms and reports in the database also run much slower.

My company has also upgraded. When I was using the 97 database I was using windows NT. With the XP database I�m using Windows XP.

If anyone has any advice or ideas, I would appreciate hearing from you.

View 4 Replies View Related

Time Conversion

Aug 29, 2006

I have placed a combo box on the form. The combo box displays time from 7:00 to 13:00 in the same format. There is a label adjacent to combo box that converts the time selected in the combo box to IST. the code for this is like this

Dim arrLoginTime() As String
arrLoginTime = Split(cmbLoginTime, ":")

lblIST.Caption = Format(TimeSerial(CInt(arrLoginTime(0)), CInt(arrLoginTime(1)), 0) + TimeSerial(10, 30, 0), "hh:mm AM/PM") & " IST"

If I select 12:00 it converts correctly and displays 10:30PM IST. When I select 13:00, it displays 11:30 AM IST instead of 11:30 PM IST.

Any idea how is it behaving and what to do to correct it?

View 2 Replies View Related

Data Conversion Help Needed

Apr 24, 2006

Hello I am a relative newbie for access and have searched many different sites hoping to find the solutions to my two (seemingly simple) problems. I thought I had found the answers several times but it is not the case. If you could possibly help I would appreciate it greatly.
First: I have a table with a field with the currency in Euros, i need to convert it into dollars and add 1 to the result. I have searched how to run calculations in access and would take the data out and put it into excel and run the calculation but I have too many rows of data and will be doing this calculation often so was hoping to find one simple solution.

Second: I have one column with text separated by a "-". I was looking to see how I could create two new fields with the first field having the data before the "-" and the second field with the data following. I found a query that allows me to separate first and last name but not a string of data separated by a -. Any help would be greatly appreciated, Brian

View 4 Replies View Related

Conversion To .mde Causing Trouble!

Sep 26, 2006

I have a DB in .mdb format which works perfectly and when all the code is compiled it results in no problems. However. When I convert this to a .mde file, it doesn't work at all and it suggests that there are compile errors where there weren't any before! Please can anyone suggest what the problem might be as I don't particularly want to run this as a .mdb. Thanks

View 2 Replies View Related

Access 2000 Db Conversion To SQL

Nov 10, 2006

Hi,

I've got a fairly complex access 2000 database that's split into front and back ends.

There's 32 back end tables and a whole host of complex front end queries and forms. The whole thing's around 25,000 lines of code so not a 5 minute job to rebuild! (sorry but i just can't stop tweaking it!!)

I hate the idea of all that data moving across the network, and having to make the front end machines work so hard so I'd like to get the server doing it's fair share of work because it's got dual 3Ghz Xeon processors which aren't earning their keep! I was thinking about converting the mdb to SQL and although i could pay someone to do it for me, i do like to learn! (so when it breaks i'm not at anyone's mercy!!)

I assume there isn't an upsizing tool on the planet that will let me do this by clicking a button so can anyone point me in the right direction with regard to something decent that can automate as much as possible. PLUS a good source of information on the differentces between access and SQL so that i can start seeing how to accomplish with SQL what i'd do in Access?

Thanks,
Vince

View 3 Replies View Related

Number To Time Conversion

Jul 16, 2006

I am using MS Access 2000 and have imported some raw data one of the rows of data shows a time but displays this as a general number ie; 1246 or 745 is there any way I can convert this number into a time, 24hr would be nice, so 1246 displays as 12:46 and 745 displays as 07:45 or 1530 displays as 15:30 ?

Best Wishes

Richard

View 1 Replies View Related

Type Conversion Error

Feb 13, 2007

i am importing from excel and i have a column that has account numbers and at some point i have an account like this... 2C1C18100

on the import i get an error.

i set the field to memo, numner or text and still get the same error..

any suggestions?

thanks in advance

View 9 Replies View Related

Update - Conversion Error

May 22, 2006

I have a text column of alpha-numeric fields and some start P123456, P111111, P222222 etc. I want to remove the P from these fields.

I thought the following update query would do this but gives a type conversion error, regardless if the new column to copy them to is type text or number. Can someone help explain what is wrong.

UPDATE 2006 SET D2 = CLng(RIGHT(D1,LEN(D1-1)))
WHERE LEFT(D1,1)="P";

Thanks,
Andy

View 2 Replies View Related