Search results

I did a response.write and got this: INSERT INTO members(username, pass, add) VALUES('uytr','67456546','546') SQL looks ok to me. Can anybody shed any light on please as its driving me nuts thanks Martin

Hi all, I have this code: Dim objConn, objRS, strQ, a, b, stsql, stuser, stpass, stadd, stpost, stfull strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath("\test\example.mdb") Set objconnection = Server.CreateObject("ADODB.Connection") objconnection.Open...

Hi, Do any of you know if it is possible to do the below? I have an access database that I want to add a box to a box and then the user uses the styles (database will be on a tablet) and scribbles their signature into the box and then when they click 'add' the db takes whats in that box and...

Hi spent, thats works fine. Thanks for this. Great help. Now got to sort out Macro issue. Thanks again

Hi all, I am after the code along the lines of.... If mainpage.item1.text = the same as any record in table [main query] in fields item1 or item2 or item3 or item4. Then - msgbox Is this possible with a line of VBA? Thanks Martin

Hi all, I have upsized my SQL database. Now when I create tables in my database they dont show in the SQL server. How do I make this happen? I am using access 2007 and SQL server 2008. Thanks Martin

excellent cheers, was only a " mark out of place.

Hi all, Is there any reason why this wont work? Dim SQL As String Dim IDhere As String IDhere = idh SQL = "UPDATE Main SET Main.Out = 0 WHERE Main.ID = 'IDhere'" DoCmd.RunSQL SQL DoCmd.Close acForm, "Loggedout" idh is a text box on the form that is linked to the ID field...

thats great. didn't know that function was there.

Hi all, I was wondering is there a way of deleting rows where there is a duplicate. i.e. 1 a a a 2 a a a 3 b b b 4 b b b I would like it to delete rows 2 and 4 leaving just 1 row in that has the data in. Thanks Martin

All, Is it possible to have a vbs script untick some addins boxes in Excel on start-up? Thanks Martin

The A column is for title like you said but sometimes the title is missing and the rest of the row is fine. If I search for I column then it picks up the row that I want. make sense - im losing myself here. :)

I think I have tidyed it up a bit and it seems to work. Sub blah() Dim i As Variant For i = Worksheets("react").UsedRange.Rows.Count To 2 Step -1 If IsEmpty(Worksheets("react").Range("I" & i)) Then Worksheets("react").Range("B" & i, "F" & i).Copy...

I have edited it below: Is this correct? what should I dim i as? my sheet is called react. Could you explain what A is please? Sorry about the questions. Sub blah() Dim i As String For i = Worksheets("react").UsedRange.Rows.Count To 2 Step -1 If IsEmpty(Worksheets("react").Range("A"...

some background: This is a sheet exported from another system in excel to then import into an sql database. In cell K5227 there is a caraige return inserted in ( / ) and therefore it puts the rest of the line onto a new line below and I want to place that info on the new line onto the end of...

Hi all, I have a sheet with quite a few records. In Column A is the title of the person but there are some gaps. i.e. Row 5228 might not have a title in it. when I get to this row can I copy the cells B5228, C5228, D5228, E5228, F5228 and place them in L5227, M5227, N5227, O5227, P5227 ...

Hi all, I am getting the following Technical Information (for support personnel) Error Type: Provider (0x80004005) Unspecified error /add_to_guestbook.asp, line 60 Browser Type: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152...

jzwp: The code behind the button is: Dim stDocName As String a = [Forms]![holidaymainbasic]![ComboYear] strwhere = "HolidayBookings.Yearfld = [Forms]![HolidayMainBasic]![ComboYear]" DoCmd.OpenReport "Rpt_HolidayDetail2", acViewPreview, , strwhere Mr B: I have changed the WHERE line to...

Hi all, I have the following query named as Qry_Rpt_02. SELECT BaseData.FirstName, BaseData.LastName, BaseData.Title, BaseData.Department, HolidayBookings.Yearfld, Entitlement.Entitlementfld, BaseData.EmpTerm, HolidayBookings.DateBooked, HolidayBookings.HalfDay, IIf([Halfday] Like...

cheers bob serves me right copying from an insert into statement using strings cheers again