Search results for query: *

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

Harleyquinns code works OK But I have 3 = signs in the string eg string is 7Class=9p Teacher=Sean Bloggs RID=7 And I want the contents after the last = (above is 7)

I need to strip the numbers off the right hand side of as string as far as the = sign Example Joe Bloggs RID=1234 I need the 1234 from above I can get the last digit from code below lbl3.text=Right(""& e.Item.Cells(1).text &" ",2) Above will display the last digit i.e. 3 The lenth after the...

I am developing a room booking app On the booking page I need to display the bookings for 3 rooms for that particular day. I am using a calander on the booking page I am connecting to a MS Access database. I guess I will have to use a SQL query to get this info, but what is the best, easiest way...