Recent content by jagilman

Hey Karl, I have a similar need. My customers need to be able to upload files. I wanted to be able to create folders for them also. The problem I seem to be running into is keeping the "upload" folder private to prevent any user from creating a web folder link to the folder. I hope...

If the user is a manager, the session variable is set to True and then when I hit the refresh button my page reloads and because the variable is True the manager menu choice is now visible. All I need is some way for my code to refresh the browser right in the middle of the "If...

Ok guys! Here is the problem again! I failed to fully explain the problem. If the user who logs in is a manager I set a session variable (manager) = True If I click the refresh button, my menu choices change and the management button will show up. I am using frames and the extra button is on...

After the user logs into my site I would like the code to perform the same step as if the user clicked the refresh button. This is being used to make additional menu choices available for different users. I have not found any VBScript code to cause this to happen. Thanks John A. Gilman...

I now have the sample database on the web: http://uslink.net/~jagilman/CoolStuff.htm John A. Gilman gms@uslink.net

ruthcali, have you used the break mode for watching code execution? This will allow you to see just what is happening as your code executes. John A. Gilman gms@uslink.net

use the openArgs part of the DoCmd.OpenForm "FrmLateProjects",,,,,,"Form To Return To" that way you can tell the form what to do when it is closed. in your onclose event check the information you placed into the OpenArgs and take the required action. I use it this way...

On the close event of your FrmLateProjects do this. Forms("frmSwitchboard").SetFocus John A. Gilman gms@uslink.net

Burro, I have made a quick and dirty sample database to show you how to populate a temp table with all the days affected by the users attempt to check out a property. It starts with the earlier of the checked out date or the users selected check out date and then goes to the latter date for...

I would avoid the use of daily entries. The check out and check in dates provide enough info for a test, however is there a need to overlap the check in and out dates. As in returning the property in the AM and checking it out in the PM. Use the following logic for your availability test...

TriggerMom, it would appear that you could create a basic sql statement that only required the user to generate the "where part of the statement" then put the whole thing togeather and execute it. Do I have part of this right? John A. Gilman gms@uslink.net

Here is an example of an Access query using ODBC. The value of 0 = forever!! Set qry = db.QueryDefs("qryPackage") If Err Then Set qry = db.CreateQueryDef("qryPackage") Err.Clear qry.Connect = ConnectionString qry.sql = "sp_SWPackage @ShipBatch = " & ThisBatch...

Just a thought, in Access I would use the error object to test for this duplicate value error. Try to follow your insert statement with an error test somthing like this. If (@@Error > 0) --See if an error was produced If (@@Error = YourError#) --Expose your error (Resume or T-SQL...

Rick Sprague, send me an email if you would be interested in kicking around some questions regarding ODBC connection problems using Access and SQL Server. John A. Gilman gms@uslink.net

Rick Sprague, wow! Just another note. I wonder how many Access 2000 users are familar with the conditional formatting available that can give a wide range of formating capabilities to data sheet or Continuous forms? John A. Gilman gms@uslink.net