Recent content by ak48

Hi, I have been using an Access database at work for a while but, as it gets bigger and bigger, It's seems to get slower, some computer under windows 98 won't even run it anymore as it lacks the system resources to do so. Should I plan on exporting to another database? Is this normal or is...

Hey, I have a form that is modal and I need to pop-up a query for the user in some situations but since the form is modal the query appears behind it and the user can't access it. Is there anything I could do?

Thank you. I am making this database for a professional business so I much more worried about the efficiency and stability of the database than it cost. Is MySQL still a good choice?

Hey, is it just me or the AppActivate function returns an error (Invalid procedure call or argument (5)) under win 2000 and win XP? Is there any way to prevent this or is there an API call that does the same thing?

Hey, I need to build an application to keep track stock options for a company. I am used to building database applications with access and visual basic but I am sick of it limitations so I decided to build this application using C++ but I don't know what database to use. Can somebody give me a...

Hey, I have an this input mask 9.9 but I need to be able to add a minus sign in front of the number. Is there a way to do it?

Hey, I have a this simple procedure in my from module : Private Function sngMattVol(PRDATE As String, Ctry As String, Prty As String) As Single Dim rec As Recordset Set rec = CurrentDb.OpenRecordset("Select Sum (ImportDetails.F15) as SumVol from...

Sorry I wasn't really clear in my last post. What I mean is, in a class module, you have a type of procedure "Property set". The help file is not quite clear about it but it seems to me that it can be used to control the 'Set' property of a user-defined object. Exemple : let's say I...

Hi, I'm trying to figure out how to use the Property Set statement but the help isn't quite clear about it. Could somebody help me. What I need is to be able to define an object by a number as : Set MyObject = "MyNumber". Can I do this?

Ok I found the problem and I gotta say I feel a bit dumb... The computer needed a good'ol reboot... Sorry I should have figured it out by myself :)

It was indeed disabled but re-enabling it hasn't solved my problem... Thanx for helping and tell me if you have any more ideas.

Well, I already tried what you did and the msgbox does appear. I also tried setting breakpoints in procedures that work for sure and it still doesn't break... Just to convince you that the program really get to the breakpoint here is a basic procedure I did espacially to test that Sub test()...

Hey, I'm trying to debug a procedure and for some reason all my breakpoints are ignored (even in other procedures). Why is going on?

hello, how can I hide or unhide a subform's (in datasheet view) culumns in real time through VBA?

Hi, I got this simple code exemple from an access 97 book Private sub ListDBProperties() Dim pty as property For Each pty in CurrentDb.Properties Debug.print pty.Name & ": " & pty.Value Next End Sub My problem is that the function won't work in access 2000 (I get a...