Search results

Just wondering what people use to see who's in the a database? We have a few systems where we need to know who's in and its proving difficult. ldb only shows the computer name, and thats not good enough (we can't use net send to tell em "to get orff":D) One of the ones I inherited uses a table...

ah right, you will need two functions. The first would be the isloaded function i posted. The second would look something like this: public function MyCode if isloaded("FormAName") then mycode=FormA.text1 elseif isloaded("FormBName") then mycode=formb.text2 end if end function Then in your...

I'm being asked to update a existing set of databases, and as the current structure isn't at all very good I can start from scratch. It is a audit type application and the way the current system works is that there is a database for unapproved and a database for approved, and all though the...

what's a BLOB? :) But yea a table which contains the reference to the location will be all thats needed. I can do the organization of the physical location on the server (the users in this case wont care)

List Box in Form sorry to butt in but what is the advantage of using the me.?

use a function instead? that way the function could check if the form was open Public Function IsLoaded(ByVal strFormName As String) As Boolean ' Purpose: to see if a form is open (loaded) ' Arguments: strFormName is the name of the form ' Notes Returns True if the specified...

Could try this: Public Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _ (ByVal hWnd As Long, _ ByVal nIndex As Long, _ ByVal dwNewLong As Long) As Long Public Declare Function SetWindowPos Lib "user32" _ (ByVal hWnd As Long, _ ByVal...

I've been given a system/process that needs updating and I'm a little unsure about the best route. The system needs to track the process of developing promo leaflets, through out the different revisions. It needs to store all the revisions and associated docs for at least 6 years, and some...

select case, easier to read, easier to expand.

well that should be easy to stop! the first line should check for the existance of the zipped file...if it does exist then cancel the sub. This can be used to check for existance of file/dir. Public Function Exists(sFileName As String) As Boolean 'check if a file exists Dim l As Long On Error...

ah Printers isn't an object/collection thats supported in any Access afaik, it is in VB though.

where is this occuring??

urm they can't work on with the data if its currently being zipped! To do what your thinking you will need to loop through the list of windows and match title's, which I think I did work out once...but forgotten now:) I do remember a problem actually getting the window titles for command...

On the toolbar click the 'Filter By Form' Button (2 right from the z->a sort). The toolbar will change, the buttons will all be disabled, and the form will clear. You can now enter criteria in as many boxes as you like. Eg if you had a name field and wanted all names starting with G then you...

huh? whats your input supposed to mean? If I put .5 in, I get 50 out?? Now I'd have said I should get 30? but thats assuming 1=1 hour.

well:) 95 was released in 94, 97 was released in 96, 2000 was released in 1999, 2002 was released in 2001 and 2003 was released in 2003. Access 2, not sure, I think 92 or 91.

If that doesn't work (I'm sure it didn't when I tried it years ago) try this: 'Type Definitons '=============== Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String lpTitle As String dwX As Long dwY As Long dwXSize As Long dwYSize As Long...

Filter by form should grey out/disable the buttons afaik. You put the filter conditions in any/all of the fields then apply the filter, it will the renable everything, and show just those records that match your conditions.

oops, i meant DJN!

I don't think there is an easy way to convert 1.5 to 1h 30mins...post what your currently using, maybe someone knows a more efficent or simpler method.