Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by DJS2
-
VBScript & Access procedures
Why not create an autoexec macro to run webGotoItem() when the database is opened [lightsaber] -
VBA in Access Help
Presumably the Function WorkbookIsOpen(wbname) is not on the spreadsheet being tested by the Sub cmdNewBusCon_Click(). This being the case, I would not expect the Function WorkbookIsOpen(wbname) to be private- DJS2
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access- Decimal part missing
Numeric datatypes on Access tend to default to integer. You will need to change it to something like double and set the decimal places.- DJS2
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Getting NT/2000 Username
This is the full page script that I use:.... ============================================================ <%@Language='vbscript'%> <% Option Explicit %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta... -
Getting NT/2000 Username
Hi James, I assume that your web server is configured for ASP? I'm using IIS5 (it also works on IIS4) and the code is hand-written in Front Page 2000. It is a standard ASP page written in VBScript. I use it all of the time to test connections. I hope that this helps. David -
EYEDOG.ocx in Access 2000
Eyedog is an ActiveX control that was used to perform diagnostic function in Windows. For more information, search online for eyedog.ocx- DJS2
- Post #2
- Forum: Microsoft: Office
-
Getting NT/2000 Username
The short answer is: request.servervariables("LOGON_USER") If you put the following on an ASP page you will get a list of all variables and their values: <h2>Request Server Variables List</h2> <% Dim V response.Write "<Table>" For Each V in Request.ServerVariables... -
IF Question
Try If Me.Verificationbox.Value = -1 Then If MsgBox("Already printed!" & chr(10) & "Do you want to print again?")=vbYes then DoCmd.OpenReport ReportName, acViewNormal End If Else DoCmd.OpenReport ReportName, acPreview End If- DJS2
- Post #2
- Forum: Microsoft: Access Forms
-
MAIL LISTS TO SEPERATE
Use Word for the mail merge and set the options to pick up only those items selected- DJS2
- Post #2
- Forum: Microsoft: Access Other topics
-
Adding a value to a table
set the datasource of the list box as a query in the table that the text box reads/posts. Set grouping so that you only get one of each item and don't forget to requery the form in the "oncurrent" event.- DJS2
- Post #2
- Forum: Microsoft: Access Other topics
-
Can I prevent unauthorized access to DB?
Look up "AllowBypassKey Property" in Access help. This contains the answer and it works.- DJS2
- Post #3
- Forum: Microsoft: Access Other topics
-
Adding Notepad (or something) to form to edit memo field
Use a standard text box but enable scroll bars (and make it a bit bigger)- DJS2
- Post #2
- Forum: Microsoft: Access Forms
-
Create a Signature from currentuser()
If your users are networked, you can look up their name on the network. This would save having to maintain the table- DJS2
- Post #3
- Forum: Microsoft: Access Forms
-
Removing "X" button and maximizing the windows?
If you put the VBA coding that I have suggested in the on activate event, the form will maximise whenever it becomes active, i.e whenever anyone looks at it. This will resolve your problem of resizing.- DJS2
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
