Recent content by ajap99

I get the following error when I enter this code BC30205: end of statement expected

When I enter the date in manually as follows the query will work WHERE (((qyRoomPeriods.ResourceDates)=#17/01/2005#)) If I put a textbox.text = 17/01/2005 it will not How can I get the value into the sql in the format #dd/mm/yyyy# from the textbox what are the # doing ?

The following SQL returns booking mage on a certain date ie =Date() I now want to select a date using a calendar. I have tried populating a textbox and replacing the =Date() with =textbox12.text but it will not work How could i get this to work Dim queryString As String = "TRANSFORM...

I have a field in an access db that contains a number when it is booked. When I delete a booking I want to set this field back to being empty. I am using the following SQL statement.This works when eg i put a 1 into textbox12 strDelete = "Update ResourceDates Set BookingRef=(" &"'" &...

How would I use the find control method ?

The following message is displayed Exception Details: System.NullReferenceException: Object reference not set to an instance of an object Fails at strInsert = "INSERT INTO Bookings (StartDate) VALUES ( '" & tbstartDate.Text & "')" I am just using webmatrix to compile code I put the...

When I use that code the following Compiler error Message is displayed BC30451:name 'tbStartDate' is not declared

I am using a datalist to display one entry in Access DB. I want to enter new values into the textboxes on datalist and hit a submit button to insert new record in DB I can do this when with the following code strInsert = "INSERT INTO Bookings (StartDate, NoWeeks, Available) VALUES (...

Is there any more examples ?

I have bound buttons on an datagrid on an aspx page. The buttons contain information from a table in an access database. When I click on a button it opens another aspx page on which I want to display all the details associated with this button. I have got the correct SQL query working on the...

Got it working Thank-You for help

How would you display this then on page 2 (I know I have to read up on the basics)

If I use 1) Request.Querystring What code needs to go on each page

If I have a text value on one page How can I display this text value on the next page that I go to

Excellent Help Thank-You