Search results

not sure on this myself. Have you tried setting the modified recordset clone back as the recordset of the form though?

Uni module on algorithms last year spent far too much time on sorting algorithms :( Of course, if you want some fun, you could always write an optimised sorter using entirely assmbler code :) wouldnt be much good for access, but you would certainly learn why its best to leave writing optimised...

Bah, access has resisited all my efforts to do this :( A nested SQL statment can only return one value, a lookup just doesnt work. Any attempt I make at programatically flattening the data only does so for the first row on a datasheet and then copies it down for the rest of it. Its getting...

use the access sorting, as it will already be optimised(probably using an optimised heap sort or something similar) and will be running as win32 native compiled code rather than the mish-mash of compiled and interpreted code that is VBA. Implementing your own sorting algorithm on top of access...

Its something I need to do as well. I'm going to look at using nested SQL statements. If I get something that works, I will post it up later today.

I just did a split on my access db(not rolled it out yet though), and I noticed poor performance if I used linked tables. As most of my forms were using ADODB connections, I merely changed them to link straight to the db file and got the same performance as before(a couple of forms rely on...

Go to the tools menu|options. On the advanced tab, change default locking to edited record. I set up a 2 - 3 user db using this and not had any trouble with record locks yet. If you need more than 4 people using it, I would suggest using something other than access.

for the ADODB, try this conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & CurrentDb.Name conn.Open this gives an adodb connection to the db that you are working in. Other db's and so on, just change the data source and/or provider as neccesarry

the c and d were thrown in as column headers from the looks of things, started with 2 columns of data, a and b, ended up with 4 columns of data, a, b, c and d. its just data grouping in the end (all the data items in b where the A column is the same get grouped, etc).

try putting the code in the onChange method as well.

"UPDATE " & lsttables & " SET " & lsttables & ".ID = " & Forms!PDTScript_ACAD!pretext & [ID] perhaps that will work?

try this CurrentDb.Execute ("UPDATE [Log Table] SET Locked = 1") to update the records to locked status The locked status you want a statement similar to this, but not sure where to put it (cant even remember what to use in the if condition, im half asleep :)) if locked = 1 Then...

open a recordset using the following sql code (adapted to your tables/fields etc) Dim rs as DAO.RecordSet rs.OpenRecordSet("SELECT Status FROM table WHERE [Serial Number] = " & txtSerialNumber) Then use the if statement here If rs.Fields("Status") = "pass" Then <Open Form> End If Hope...

hmm one other thing, I remember something in my databases lectures about certain things that make queries updateable. Something like the queries need to have the primary keys of all tables they are referencing in their view. It could be that SQL server is making sure the queries are updatable...

Dim sql as String sql = "INSERT INTO [All Points](obsID) SELECT " & cmbid & " FROM " & lsttables then just give sql as the argument for whatever you are using to execute the sql :)

I've done it several times fro a variety of reasons. Basically you use this code textbox1 = textbox1 & " " & combobox1 rather than textbox1 = combobox1 hope that helps :)

Methinks the jet engine makes something read only by default, where sql server makes it read-write by default. If it involves cursors, have a look at making access cursors updateable(not sure how to myself, but I'm sure a quick ggogle will turn something up :))

From the sounds of it, you are either going to have to give instructions, as KenHigg suggested, going step by step through the process of converting (and on the front page saying "MAKE A BACKUP OF YOUR DATABASE FIRST!!!!", otherwise you have no fallback for the fool who breaks it). Other option...

if the db is in the same folder as the other files (or the files are in a subfolder of the folder the db is kept in), you could also use the currentdb attributes to get it accurate every time, no changes neccesarry (as long as the db name stays constant) Dim dbname as string, firstpath as...

or just use If Me.MyTextBox & "" = "" Then as this performs a check for empty string and null at the same time. Found it on this forum, with logic behind it going like this: If you concatenate (use &) a null string with "", you get "". If you concatenate "" with "" you get "". If you...