Search results for query: *

I'm trying to find out if an embedded database can be used online as part of a shopping cart or as a order system. I have a feeling the answer is no from what little i've read about embedded databases so far but i've not found any articles that address this issue. any body know of any...

Thanks VBSlammer it worked a treat :o)

I need to get an account number from my access form to a url which will be processed by an ASP page. Can you tell me how I would get the variable by the name of strAccount from the form onto the end of following URL: http://xyz123/accounts/account.asp? It's not really covered anywhere i've...

We use a batch file that copies the front end to the users c drive and a short cut that is saved to their windows start up menu that points to the front end on the c drive. so yes desktop shortcut =)

Hi, I have a front end database that attaches to the back end. When the front end loads I do not want to display the database window. In the start up for the front end I have unticked the Display Database Window and Use Access Special Keys check boxes and for most users when the database loads...

I'm trying to use a recordset to display all records based on a query with a maximum of 5 records displayed on a page. The records are displayed in a table. I need a submit button to take the value of each particular record to the next page via ASP. I'm trying to use a rollover image to act as...

I've solved this... basically it was the calling of Server Variable CONTENT_LENGTH. The data had already been posted from the search page so it was not setting the page number = 1. I rquested the value of the submit button from the form as my marker for a value of 0 rather than the...

Yes they are... tried an interesting test... I took the code out for the data from the search form on the previous page, substituting the acctount number instead of the strAccount variable in the SQL.It worked fine. Now i just need to work out where the problem is. Any ideas?

yes it is :0)

I've built the following page which gets input from a search form on another page. I'm getting the following error: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /wakeywakey/dispute.asp, line 156 Line 156 is...

its ok i worked it out. I hadn't used the LIKE condition when opening the form. Blindness is indeed a disability ;o)

I have to search for an account that is made up of a letter and then numbers. I want the user to be able to search without the letter. Ihave used the following code: Private Sub cmdAccountSearch_Click() On Error GoTo Err_cmdAccountSearch_Click strAccountNo = Me.AccountNo If...

Wasn't sure if i was allowed to post code last time i did it i got a rolicking from someone - ah well at end of my tether now. Code from page with form and connection file is below. Code on page with form (line 76 is in bold): <%@LANGUAGE=&quot;JAVASCRIPT&quot;%> <!--#include...

The code underlying the pages doesn't use a record set. I think the problem is to do with the connection string because that is what line 76 refers to.

New to dreamweaver mx. Using ASP with JavaScript Built a form to send data to MS Access database and get the following error: Error Type: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /ntsa/register.asp, line 76...

how is this done exactly I'm not sure, new to ASP.

I get the following error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. I've checked the names allocated to the table and field names against an SQL reserved word list and they do not appear on there...

Pete - thanks for the info. Since your last post I've been busy trying to do a work round getting the autonumber id. Now I've hit a wall in that the order_id I need to get from the database is only uniquely identified by the customer_id and the date/time. I've tried to select the right...

Clue, have since discovered that problem is not with SQL code as it works fine if the following is taken out of the code: <jsp:useBean id=&quot;basket&quot; class=&quot;ShoppingBasket&quot; scope=&quot;session&quot;/> <% String title = request.getParameter(&quot;title&quot;); if(title!=null)...

Ok thanks to Sem's help I now only have 2 errors relating to the : getLastInsertID() Someone has given me a tip that this is not in the java.sql API so does anybody know how to get an autonumber id out of an access database from a newly inserted record? Thanks