Search results for query: *

Hello all, Is there a way to get the Host Intergration Server End user Client to run from the Systray, instead of the task bar. I looked on microsoft support and was not able to find anything. Thanks in advance for the help Thanks GTLoco

The only thing i can think of is that when you set up you DSN, you did not specify a user name and password. So when you try to connect to it using and user name and password, it blows. Thanks Glen

yes

What version of Access are you using Thanks Glen

Yes, you can convert 97 DB to 2000, but then you still will not be able to open the converted DB in 97. One thing you might try is create all the tables in a Access 97 file, then you can link the tables to a file in Access 2000 with all your forms and queries. This would allow you to have a...

Is the 50mb size after you compact the database. Sometime when adding features to the database, it will grow in size from the code changes and such. Compacting will sometimes get rid of some of the temp garbage and reduce the size. Also, 50Mb is not really that bad.

If you are using Jet3.5 or latter, try running the compact instead of repair. Compact will fix many errors in the latter versions that repair will not check Thanks Glen

Thats what I was afraid of. Was hoping to avoid creating new menus, but that looks like the route I need to go. Thanks for the help Thanks Glen

I have a ChangeProperties Function I use to turn off/on full menu access based off the CurrentUser(). I have this fire off in the AutoExec macro for the database. The problem I have is that it does not actually change the menus until the next time I log in. I want the change to take affect...

Got it to load the workgroup for just this database. Thanks glen

Hello all! I have a database I created and it currently has three users. My self (Admin) and two other users (UserA, UserB for example purposes). I have never like Access 97 security so I wrote my own security module. My problem is, now I need to restrict access to full menues and I can not...

Ok, under default view, you set the Views Allowed property to datasheet? Thanks Glen

The only thing I can think of that would cause this is if you are truely setting the values of the fields to Null, or an empty string(I.E. ""). Thanks Glen

Since you are using And, it will only find duplicates where both the StafID and the Date have dulpicates. This will not work for you if I understand correctly, you have something like this Staff ID Date 6 1/1/03 6 1/2/03 6 1/3/03 etc... You have multiple...

Sure, Go to the properties on your form, and under Views allowed, make sure it is set to Datasheet, it is most likely set to both (That is default). This will cause your switchboard to open the form as a datasheet Thanks, GTLoco

The problem is with your AddToList function. Is this a function you wrote? Response = AddToList("NCType", "Type", NewData) Thanks GTLoco

Ok for the problem with this statement db.OpenRecordSetstrSQL, dbOpenSnapshot you need a space added. It should look like this, I may have typo'd it. db.OpenRecordSet strSQL, dbOpenSnapshot. As for your problem, you may try getting rid of your "Or" and create two If statements...

Make sure under references you have Microsofts DAO Library checked Thanks GTLoco

Sure there is. Try this Private Sub Area1_Edit_Click() Dim isgm As String Dim strSQL as String Dim db as Database Dim rs as Recordset strSQL = "SELECT Password.* FROM Password WHERE Password.Area Like "Area1";" Set db = CurrentDb() Set rs = db.OpenRecordSetstrSQL...

Yes this is possible. On your tool bar under more controls button, there is a Calendar control in the list. Add this control to a new form. On the form that has your date field, create a control button that will open the calendar form. On the calendar Updated event, add this code Code...