Search results for query: *

The Switchboard wizard makes modifying menus easier, because all the details are stored in a table. There is nothing really clever about Switchboards, you could design your own forms etc instead, they are there basically for people who use Wizards and don't want to do a lot of form design...

I think we're on our own Jeroen, I posted about this in July! Hope you sort it out because I gave up :( Regards, Andrew

Thanks for all your advice, it's definately shed some light on my problem. We are using a WinNT server with two CentreCOM FH724SW (24 port) hubs connected using the supplied link cable. We only have two 10 mbit cards on the network, which I now plan to replace. This came to my attention when...

Hello All, Please could any of you inform me as to the effects of adding 10 mbit network cards onto a 10/100 mbit network. All I really need to know is if this can cause errors and if the whole network slows down. Thanks in advance. Andrew.

This is really tricky if you wan't restrict traceability of your records. You basically need a way of finding out if your new random number has been used, there are a couple of ways you can do this: o Check your existing table to see if your new number is in there, if it is then get a new...

Hello all, Just a quick idea, why not have the pictures stored somewhere specific, and name them the same as your key field. Then you could load them into the form or report as needed and you could keep control of all the image locations and revisions because they would all have to be in the...

You have the same problem as me!, if you are scrolling down you are moving to a new record everytime.

I'm afraid your stuck with 'Drop' down list with Access. However, why not give this some thought: 1. Make a normal text box for your data entry. 2. Make a list box (not drop down) for your selections. 3. Make your new list box invisible and position it above your text box. 4. When your text...

David, You should mess around with your .exe file and see what keystrokes you need to close it down. Then you can return the .exe files application ID by using shell, as follows: ApplicationID=Shell("Myfile.exe") You can then switch to your .exe application using...

I'm pretty sure the bug is with our email server software. Basically when using SendObject, Access crashes randomly. I've tried re-installing and I've tried the latest patches, but they make no difference. I even tried using a little command line passing routine, which opens outlook and...

Why not make the above examples into a function?, you might find yourself using this in a query or report as well. Andrew.

Perhaps 'AddressOf WindowProc' is only available on Access 2000. Andrew.

Schwankieog, I need to know your email address so I can send it, I don't want to paste it onto the forum because it alters the registry and any formating changes the forum might make could cause problems. All that's involved is opening a .reg file and pressing yes when it asks if you wan't to...

Why not try: Matching the key field on the form with the key field on the report via the query? All you have to do is: Open the form in design view. Open the report in design view. Open the query for the report in design view. Now - In the conditions statement on your key field, use the...

Dawn, Why not re-install the wizards?, I don't know if this will work but remembering that the wizards are actually databases themselves, it's possible they could be corrupted. However, as Francescina pointed out - database wizards are next to useless, they have very little useful content and...

Hello Schwankieog, I know what your going through, I was in the exact situation when we upgraded to Access 2000. I did find a solution, but it's messy and it does'nt support memo fields, other than that though it works for us. I used the registry entries for Access 97's Foxpro support and...

Tiny, Im sure nobody has anything against visitors, if you did'nt get a response, perhaps nobody knew the answers. Andrew.

To tell the truth I wish we had'nt upgraded to Access 2000 at all, it uses a lot more of the system resources. It may be worth trying some of the analysis tools on Access 2000, this will highlight any problems you may have. One thing which probably would'nt cause problems for most people was...

Thanks Paul, I use Access 2000, but unfortunately my cheap-ass bosses won't buy me VB6, I only have VB4. Thanks anyway though, I might try and find someone who has VB6 and get them to compile the code for me. Andrew.

Francescina, You seem to have misunderstood my last post, at no point did I suggest anyone disables option explicit. I was simply stressing that you can often work faster if you disable it while developing a new piece of code. Tidying up code and adding error control and has always been...