Search results for query: *

Thanks for your help. I have already seen the documents that these threads link to. Even in the Microsoft article 884185 the resolution is to reseed the table. I do this (and it fixes the problem) but the problem keeps recurring. I never had to reseed my tables before and now I have to do it...

Hi there! I recently converted my access database from 97 version to 2000. (I have also converted it back to 97 and forward to 2002 but I still get the same problem) I have the following problem which I can not find a resolution. I have a function that adds a new record to a table. This...

Hello, I am a newbie on Perl. I am creating a site for our bookshop where the details (ISBN, Title, Cost, Book cover Image) of the books that we are selling can be viewed online. The book records are held in an Access Database. I have managed to display the records for all text fields, but...

Thanks Richard, Traingamer and everyone else. It worked perfectly. Its really exciting when something that has stumped me for a while actually works! Cheers!!

Thanks for your suggestions. Richard your idea I think is great. I've created a sample text box on my label report. This textbox's datasource points to the function GetTitles() that you suggested. But when I preview the report, NUM!! is shown in the text box. I think there's something wrong...

Hi, I have been having difficulty with the following problem for sometime. My boss is asking for some functionality on a MS Access database that I designed but I haven't been able to crack it yet! Please can anybody help?? The database is an ordering system, whereby customer orders (quantities...

Okay, here goes.... On the cfform page the two date variables are sent as a string like "01/04/2003". On the action page this is how I format the dates. I've tried to show the bits of the code thats relevant. <cfset setLocale("English (UK)")> <!--- set the coldfusion server to UK setting...

Hi Everyone, Here's my problem. I have a coldfusion form which requires the users to selected from list boxes start and end dates. These dates are then used in a query on the database. All works well on my computer,(i.e. all the right files are downloaded) but when I put my site on the web...

Thanks for your reply ...but this doesn't entirely work because I don't know which fields the user wants in the query until they select them from the list box. I.e. in the list box is an option to view 'all fields' of the database in the records that they want or to select multiple field names...

Hi all, Am getting stuck on how to code the query using multiple selections from a listbox (named which_fields). Have read various threads and can't get what others say to work. The scenario for this prob is: I want the user to be able to select from a listbox (which contains a list of all...

Thanks that did the trick!!! Cheers

I'm sorry for being really basic but the system still doesn't seem to be finding the column name even when I add: #MyColumnName#...i just get a long drop down list with many repeated #MyColumnName#'s. Any advice... or am I being really thick on a Friday afternoon trying to code? My code...

Hi does anybody know how to populate a list box (named which_fields) with the column names of a table from a query (named database_fields)? I have tried various things and the best I've done is create a list box with no column names in it using this code: <cfFORM name="DateForm"...

Hi Ecobb, Yes that's right, for some reason the database needs date variables to be in US format in order to execute a query properly on data held in the database which is format in UK format ( but maybe it's transport in US format??) I must say its mind boggling! The database is as far as I...

Dear readers, This has been a great thread....very useful. But as I can undertstand from it many people seem to have the same problem as me... but I can't see any solutions. The problem is: when I download a recordset, resulting from a query, from ColdFusion to Excel...the default extension...

Dear readers, Just to let you know that I fixed the problem by using LSParseDateTime() function. See below for code: <cfset CreateODBCDate(form.startdate)> <cfset CreateODBCDate(form.enddate)> <cfquery name="export_selected_records" datasource="supporting_peopleTESTDB"> SELECT * FROM...

Dear NorthStarDA and Ecobb (+ other readers), Thanks for your reply. I tried NorthStarDA's code but no records came out of the query when there should be some. The date that users enter is understood by Access as being American, regardless, it seems, of the format I give the date variable to...

Dear reader, I was wondering if you could help me with a problem that I haven't been able to solve despite lots of Web searching. I am desiging a ColdFusion web application and using Microsoft Access 2000. The date problem details: In one form I have created two textboxes that require the...