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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DJS2
  • Order by date
  1. DJS2

    VBScript & Access procedures

    Why not create an autoexec macro to run webGotoItem() when the database is opened [lightsaber]
  2. DJS2

    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
  3. DJS2

    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.
  4. DJS2

    Getting NT/2000 Username

    This is the full page script that I use:.... ============================================================ <%@Language='vbscript'%> <% Option Explicit %> <html> <head> <meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=windows-1252&quot;> <meta...
  5. DJS2

    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
  6. DJS2

    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
  7. DJS2

    User Name

    PHV and Digga have the best answer. <%= Request.ServerVariables(&quot;LOGON_USER&quot;) %> I have been using this for years and it never fails. Excellent for adding security and identifying users
  8. DJS2

    Getting NT/2000 Username

    The short answer is: request.servervariables(&quot;LOGON_USER&quot;) 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 &quot;<Table>&quot; For Each V in Request.ServerVariables...
  9. DJS2

    IF Question

    Try If Me.Verificationbox.Value = -1 Then If MsgBox(&quot;Already printed!&quot; & chr(10) & &quot;Do you want to print again?&quot;)=vbYes then DoCmd.OpenReport ReportName, acViewNormal End If Else DoCmd.OpenReport ReportName, acPreview End If
  10. DJS2

    MAIL LISTS TO SEPERATE

    Use Word for the mail merge and set the options to pick up only those items selected
  11. DJS2

    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 &quot;oncurrent&quot; event.
  12. DJS2

    Can I prevent unauthorized access to DB?

    Look up &quot;AllowBypassKey Property&quot; in Access help. This contains the answer and it works.
  13. DJS2

    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)
  14. DJS2

    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
  15. DJS2

    Removing &quot;X&quot; 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.
  16. DJS2

    Removing &quot;X&quot; button and maximizing the windows?

    To always open the form maximised, you will need to place the command &quot;DoCmd.Maximize&quot; in the open event of the form
  17. DJS2

    inconsistent date format in unbound text box

    Regardless of the input date format,I have found that Access will always query using American dates. You will need to create a procedure to convert this date to American for the query. Day1 = Your Date Field Day2 = Month(Day1) & &quot;/&quot; & Day(Day1) & &quot;/&quot; & Year(Day1) You can...
  18. DJS2

    Additional Row in Subform

    You should be able to open the subform independently of the main form. You can then set the properties of the field to prevent it being used, tabbed to etc. You may also wish to change it to a label
  19. DJS2

    I need Word 97 to open specific Access97 file

    Set up a mail-merge to the access database. When you open the word document it will automatically open the database and access the correct table.
  20. DJS2

    Automatically goto last record in a subform

    Try putting the following line in the forms &quot;On Load&quot; event: DoCmd.GoToRecord , , acLast This will take you to the last record

Part and Inventory Search

Back
Top