Search results

The latest is that copied the back end onto the users computer as well and re-linked the FE to this new BE location. The database runs nice and fast! So i figure it must be a network connection issue. But it seems to ping the same as other users. So....how does a split database work? Does it...

Sorry Sorry posted to wrong thread was supposed to be. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46807

The latest is that copied the back end onto the users computer as well and re-linked the FE to this new BE location. The database runs nice and fast! So i figure it must be a network connection issue. But it seems to ping the same as other users. So....how does a split database work? Does it...

Thanks PDX_Man Thats fixed it!

Nope this is another one.

Some do/some dont! Only 2 of my forms use bitmaps. And other Databases dont seem to have anything but plain default grey forms and these run as slow if not slower ????? But i will look into the video memory issue. How can i display these settings? From the control Panel somewhere? Thanks

I have a number field set to 000/\00 this retains the intial char even if zero ie 012/34. I have a problem with this feild being Concatenated into a text box. ie. ="Project " & [project] gives me Project 1234 Not Project 012/34 I have tried it in VB and as an expression same thing. How can...

Slow as a snail No at machine at the mo but think is quite new with probable P3 processer, 1 Gb HD with very little used 200-300mb at most, and over 500 MB RAM. Its connecting to a LAN via a docking station, beyond that i dont know the companies local IT guys have the keys i guess a network...

I have a user on Windows 2000 pro using a laptop. She is accessesing a database over a network. The performance is very very slow. -The database runs fast for all other users. All Ms Access are slow on this machine. -The machine set-up seems fine lots of RAM and Virual Memory (paging...

Great stuff but Beware! This is a great way of stoppping the age old mouse problem but.... i was using this on several databases and i found that on some users machines the code or perhaps the .DLL effected stability. On closing Access it would still be running in the background and users...

Thanks Rich Thanks Rich thats done it saved me a lot of pointless code too!!

too complex Thanks for the help i didnt know you could drop expressions into a qry like that!! It works well but i actually have 20 comment boxes and if code for 20 the expression is too long. How can i get around this??

??? I dont know if its because its monday morning or just the as always wonderful wording of MS help files. but i cant seem to get this to work.. i can tag a multi selection of fields but this tag name doesnt appear in VB window? Have i got the wrong end of the stick here or what???

simplified i have a table of 5 memo fields called named comment1-comment5 the table also contains a txt feild which says how many comment boxes are completed.(number comp) i want a qry that will report the most recent comment only ie if number comp = 4 then only show comment 4 in a report...

Is it possible to group a set of field and name this group so i can call enable from VB. ie at the moment if testing = "yes" then me.field1.enabled =True me.field2.enabled =True ect ect ect for 50 odd fields If i could name groups if testing = "yes" then me.group1.enabled =True less code...

What about some kind of update qry I got it working again!!! i had changed the format of the field to 00\/000 but the input mask said 00/000. Would still welcome any other comments on this. is a form a stable way to do this function?

I have set up a large access 2000 data base. I have a form where a user inputs a Project number ie. 123/02 and then clicks create. This textbox is called Intial. It runs code as follows.... Private Sub create_this_record_Click() On Error GoTo Err_Create_this_record_Click Forms]![create...

Horay!! Thats exactly what i was looking for just didnt know it existed!! Thanks for you help you have done it again !!

Yes i had similar thoughts on tagging with a hidden text box but how do i change the access level to the form whats 'logid'? Is there a built in control that can lock all the fields on a form?

Dang!!! I have started rolling out my database and am finding that the mouse wheel driver makes it very unstable on some users machines..i.e if they close the database the .ldb stays open and MSACESS.EXE shows in the Task Manager Processes. I also cant get some machines to update there system...