Search results

Are you just looking for documentation on the treeview or are you wanting to create your own OCX files?

I like the second one of Audreys as well. Third one is nice too I just like the second one better.

EjS: What you want to create is a "Form". Open the database window and select the Forms tab. Click the new button. Select the Option of Design View. Now you will create buttons. In the toolbar you will see one that has a hammer and wrench crossing each other. Click on that and the...

Is there any reason for the user to see this form? If all it does is sit there and refresh data and the user has no reason to ever see it just set the visible property to false. That way it sits hidden from the user and won't pop in front of your form.

bbrendan: go to www.freevbcode.com and search for encryption. There are many examples of encryption techniques and most should work (with some minor tweaking) with Access.

The screen will flicker when it requeries. The only way to change it from nonstop flicker is to only requery every 15 seconds or so. Then it isn't so hazardous on your eyes.

I cant even draw a stickman properly otherwise i would happily give it a whirl.

Try this Function fExistTable(strTableName As String) As Integer Dim db As Database Dim i As Integer Set db = DBEngine.Workspaces(0).Databases(0) fExistTable = False db.TableDefs.Refresh For i = 0 To db.TableDefs.Count - 1 If strTableName = db.TableDefs(i).Name Then...

You could try putting your snippet in the mousedown event for a button and try that. FlashEmail = False Me.cmdEmail.Transparent = False Or try getting the err.number for that error. I have never seen that one before so don't have any real working methods for it.

Sorry blaze I don't think I understand your problem. Do you want to move a database of yours to the web or are you looking at linking up the information from this other company to your database?

Yeah that was my other thought after typing that was if Access needed to be reloaded. Thanks for reading my mind. :)

What is ListItemData referred to in your code? Is that the list box?

Well if it is stored in the registry you could always change that key when your app is loaded and then change it back when you are done with your import. I don't really condone messing with the registry however it is an option.

Option Compare Database Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _ ByVal lpClassName As String, _ ByVal lpWindowName As String _ ) As Long Private Sub Command0_Click() 'appName should be equal to what your applications name is in the...

I know when i had to work with a lot of text files before from various companies I would open them up get the headers and order and save those into code. Then i would read line by line the text of the file and input those values into a table. You could try something like this if you so...

Yeah my darn code worked fine the first time after that kaput just like you said. :) So I decided to make an administrative decision and say screw em. Put a nice label and told them the limits of password and all the business rules. If they go over 10 chars it pops up telling them they are...

Let me know if that ldb file search does not work and i can get you the API code to see if a program is running or not. -nate

You "shouldn't" need admin access to that file. All API calls do is lookup functions in those dll files. I have never been on a system that locked down so i cannot say for sure tho. Hope you can get it to work tho :)

This is for Windows versions I think 95+? I think 95 was when MS introduced the 32 bit stuff. Sorry I have never used AS400 so I am not sure what that platform is. Is it run on 16 bit? if so i can try to hunt down the 16 bit code. user32 is a Windows dll file installed with Windows.

1. I don't know if you can "disable" the x in the corner. But you can try this method to prevent users from exiting that way http://www.mvps.org/access/general/gen0005.htm 2. Go to Tools | Startup and uncheck the show database window checkbox.