Search results

Thanks Mile. Im applying the code to my tables and can get qryOne to work, but having problems with qryTwo here: rs.Open SQL, cnn, adOpenForwardOnly, adLockReadOnly Could you offer a bit of info as to what this line does? and these: Dim cnn As ADODB.Connection Dim rs As New ADODB.Recordset

Jon, Thats excellent, thanks! I've never done a union query before, how is it done, or is there a link i could read?

ok, ive done up some test data more suited to my situation that has vehicles leaving and arriving at different depots. Hopefully this may help. :)

This DOES actually work with the code ive been working with. Yeah, I was working it through in my head and came to this conclusion. Pitty theres not a combination of Excel and Access. I'll have to think through this one some more, as i've always struggled with normalisation. Thanks...

ok, bit of a update, Ive got a bit further using this test data: IDno......Field1.....Field2 1204.....House......House 2304.....Car 3404.....Tree......House 4504.....House Using this query expression: DCount("[IDno]","tblTest","[Field1] Or [Field2] ='House'") I get: IDno......Expr1...

So each field would have a drop down (combo) list, for you to select the values?

Sorry to be a pain here, but i cant really show the actual table. I have gotten pretty far writting this expression: Expr1: [Field1] & " " & [Field2] & " " & [Field3] & " " & [Field4] That gets me this: ID........Expr1 1.........House House 2.........House Car Car 3.........House Tree Car...

ok, can we presume the tables are normalised as the structures need to remain as they are. I do realise this is like the opposite to what the textbooks say. The tables are obviously more complex than the example here, but is it possible to do what is shown here? Can I count the strings and...

Ive never understood normalisation very well, i thought it would be easier to do it as detailed in this thread. Field1 is the unique key, and I have both those tables in my database.

Sorry, the first table should read: Field1.......Field2.........Field3.......Field4 1.............House...........House 2.............House...........Car............Car 3.............House...........Tree..........Car 4.............Car...............Car...........Car Then obviously combine all...

Is this possible to do in a query? I have the following table (for example): Field1.......Field2 1.............House, House 2.............House, Car, Car 3.............House, Tree, Car 4.............Car, Car, Car I want to count those text strings that are the same: Field1.......Field2...

Hi, I have a table structured as follows (for example): Field1----Field2 1--------House 2--------House 2--------Car 2--------Car 3--------Tree 3--------Car 4--------House 4--------Tree I want to combine the values in Field2 into one Field, for example: Field1----Field2 1--------House...

I'm trying to export a table as a (.txt .csv) file. When I click Finish on the Export wizard Im getting the following error: "The Field 'Field143' contains a start position of '32806'. The maximum start position allowed is 32767" All records in this field are empty, but it is required. Any...

Hi all, Could someone please help, as an example, i have a string in one field: 5, Woodlane, England I want some kind of query that will delete the commas so it would just be: 5 Woodland England Hope someone can help. Thanks

Its ok, theres actually an Unmatch Query Wizard i just found that works!!! Thanks anyway

Can u expand further? i just tried, and it didnt work.

This seems like a really simple query, and ive tried many ways to try and get it to work, but it wont! Hopefully someone here can help. To put it simply this is what i want to do: I have two tables: Table1 1 2 3 4 5 Table2 1 2 3 4 5 6 7 8 9 10 I want to delete the contents of Table1 form...

Another error here: sql = "Select * from Incidents Where IncidentID = " & Me.ID Method or Data member not found

Yes i am currently running Access 2000 to test this, but it will be running in Access 97. Will the first code work ok in 97?

Thanks wayne, but an error at the first hurdle: got an error here: Dim dbs As Database "User-defined type not defined"