Search results

Thanks for the reply, Could you possibly go into a bit more detail with . The reports that are pulled off were REALLY slow, so what I did was run a basic select query, then using DAO I copied the data that the query produced into a local table, and ran all other queries etc from this table...

hmm, I dunno, I can post the code if you like and screenshots etc, the form itself is straight forward, but the code Is heavy stuff !! CALV

Hi all, I have just about finished my db, the back end sits on an nt4 server, the fe's on nt4 workstations, now when I test this at home, its perfect, even with 200k records in it, its pretty fast, but at work, its SLOW (even with only about 10000 records), the basic setup is that the user...

Odd, I downloaded the above zip, and got the message about not being able to make changes as it was created in a prior version, anyway I converted it again and here it is, hope it works!. CALV

Well, I fixed it! Still doesnt work with the mscal, but works fine with snapshot viewer, turns out that you get "runtim error 9 subscript out of range" if the reference either cant be removed (dunno why this would be) or its ALREADY removed, bit of a stupid error IMO. Anyway the following code...

Attatchment this time :)

No problem, glad to be finally giving something back instead of just asking questions all the time :) CALV oops

What a good idea!, I sometimes need people to close their front end also, and of course they all do - apart from the ones that are on lunch/gone home etc. What I did (which you also may find a use for ) is downloaded appuser which gives a lits of people logged in, and then modified it a bit to...

Hi all, Thanks for the replies, I seem to be making SLOW progress!, I read all of the articles, and I'm getting a little closer, hres the situation now: I put the following code in to a function which is called by autoexec macro so it runs right away, and put the snapshot viewer ocx into a...

Hi, I managed to finally try this, the snag is, I get the error as soon as the form loads, I tried deleting ALL the code from the form_load, and replacing it with the code to set the references, but then I get the error on the line: Set ref = References.AddFromFile(blah blah) So the lack of...

Thanks a lot, that looks just like what I need, I'll give it a try later on today. CALV

Hi all, Just finishong of a dbase, which has a snapshot viewer control on one of the forms, works fine on my system, but when I try it on another system, the second line of code gives an error about mising references (the line is nothing to do with snapshot controls! its lbluser.caption=UCASE...

Thanks! I'll look into an alternate method, I did search the help files, and the net but didnt come up with hte answer CALV

Thanks for the reply, The table is a memo, when the data is entered it stores it fine, it displays whats I require in a listbox (part of the text) , but, if I put for eg: dim mytext as string mytext = mylistbox.column(1,1) then mytext only holds the first 255 characters of the selected item...

Hi all, I'm trying to edit some data which goes into a table via a text box, however, as soon as I try and use a variable for the text, it takes the first 255 characters then dumps the rest! is there a way around this? TIA CALV

Hi all, I have a lsitbox, but the amount of info in it is quite big, and somewhat cramped, is there a way to change the hieght of the rows? each item is between 10 and 300 characters, what my idea is, is to display part of it in the listbox, then when clicked, transfer the data into a textbox...

how did you fix it? I get the same problem on ONE machine, I get it when I try to do this: Set wshnet = CreateObject("wscript.network") lbluser.Caption = UCase(wshnet.username) I get an error on the 1st line, how did you fix it ? or is yours a different problem? CALV

Hi all have a databse I made a bit ago (with plenty of help from folks on here!!), only now they want an update :( The database basically logs jobs, when a job is booked, the date etc are put in a table, along with a job_status field, this status is initially set to "pending", once the job is...

Thanks, woprks fine with a message box, just wont allow me to access a text box or other control in the same way :( this is really bugging me now lol

worked fine, thanks a lot!! out of interest though, how would you address a control using a variable? i.e. x="parts1" x.value="hello" rather than parts1.value="hello" CALV