Search results

Suggesting Do while Not .EOF would mean the record count check is obsolete? ThisCat() is a function that returns the numeric field Cat.

Thanks very much Mark, that's fixed it. And I should have known!

Interesting points, I had thought an unconditional rs.MoveLast would error if the recordset is empty. Debugging shows its not empty and the loop is executing. Should it populate the table as it's written? The recordsource is "Select Performer, Title, Track, Comp from Table9 where Cat= " &...

My Forms record source is a query and I'm trying to populate a field from an array called Tracks. Code is Set dc = CurrentDb.OpenRecordset(Form_frmHubAddress.RecordSource) If dc.RecordCount > 0 Then dc.MoveLast If dc.RecordCount = UBound(Tracks) Then dc.MoveFirst...

I have a Form sized to fit the screen but when I open another Form (popup) on top of it, the height alters slightly and it acquires a vertical scrollbar. To try and avoid this I want first to see the Forms height before and after this popup form opens. In Properties frmMain Detail under 'All' I...

Thank Doc_Man, permissions were wrong (actually the share name was wrong to) so all sorted now.

That didn't make any difference Arne., but if I move the mdb from the Mapped to local drive it's okay. Also found opening it (or any) databases in Q: with Access brings up a warning "This database has been Opened read only..." For the recordset read only is ok but I wonder what is setting them...

I'm trying to open an Access table from Excel and being told Run-time error '3051': The Microsoft Jet database engine cannot open the file 'Q:\CDList98K_BE - Copy.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Q: is a mapped drive which I can...

I would like to understand how to use/debug mciSendString to fix the issue (as described in msg #1). I've spent a few days Googling but haven't found much and have added to the mystery as some things found are for playing mp3's whereas mine are tracks from a CD (CDDA). May I could send a...

Haven't found it. Did find a few things via Google that also ref mciSendString. Is this the only method known ?

Does anyone have code to play a track on a CD? I have some old code which uses "mciSendString". This used to work ok but now is selective, it'll play some disks but not others. I've tried stepping through but nothing is obvious, no errors or problems. Some disks just won't play. So perhaps I...

I think I've solved it. Needed Val(nz([High]))

You're right plog, I was probably over thinking that.

Is there a limit to how many BETWEENS you can have ? I'm running into trouble with SELECT Year([Date Peaked]) AS Expr1, tblMain4.Prefix, tblMain4.High, tblMain4.SheetSort FROM tblMain4 WHERE (((Year([Date Peaked])) Between 1960 And 1960) AND ((tblMain4.SheetSort) Between 2 And 3) AND...

I am using <= and>=. It's just getting a bit unweildy. I'll google for a Between/And example. Thanks.

I'd like my select query to include Field1 where it's 1960 to 1961 and Field2 is any number 15 to19. But also work if the Year is only 1960 and my number only 16. Been playing around with > and < and having some success but maybe there's an Access method to include a number in a certain range?

Thanks Arne, yes I can now open it, and my original query works. I'm not quite sure what was wrong... it may have been something else but showing at the point. I did not know you could have Set db =opendatabase and that will be a huge help.

Am getting a problem with Set db = CurrentDb SQL = "SELECT TLabel FROM Tracks" & _ "IN '\\PETER\List\ListBE.mdb';" Set rst = db.OpenRecordset(SQL, dbOpenDynaset) Run—time error '3125': ”\\PETER\List\ListBE.mdb" is not a valid name. Make sure that it does not include invalid...

Thanks Dave., This forum is a great resource :)

Thanks arne, I found that worked too.