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 wOOdy-Soft 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: perrymans
  • Content: Threads
  • Order by date
  1. perrymans

    Copy the same tasks to multiple projects

    Yeah, so I know how to use Project like Excel, not like Project. I have multiple projects, short four month efforts. They all have the same tasks and the tasks have the same duration. Each project has its own hard end date (there is a certification needed by date X). I want to set the task...
  2. perrymans

    Access runtime installer include ODBC

    I have an Access front-end to MySQL database online. Currently, the myODBC and Access distribution and configuration is manual. I was thinking of using the Access 2007 installer (but require Access 2007). I was wondering if the myODBC installation and configuration can be included too...
  3. perrymans

    Wordpress 3.0 Twenty Ten Double Titles

    Love the new Wordpress 3.0 theme, but I like the titles I put on my own pages, not the ones the theme is putting there. Attached shows the page where both the name of the page (on top) and the title I placed (bottom) is shown. How do I remove the top one? Thanks. Sean.
  4. perrymans

    Row lines in TinyMCE Generated Table

    I can't get the lines between my rows to disappear. How is this done? Thanks. Sean. HTML Snippet: <table class="aligncenter" style="width: 600px; background-color: #ffffff; border: 0px none #ffffff;" border="0" cellspacing="0" cellpadding="0" frame="void" align="center"> <tbody> <tr>...
  5. perrymans

    What is different with /NOLOG?

    What would be the reason for connections to work with /NOLOG, but not without? Works: >sqlplus /NOLOG >connect sys/orcl as sysdba Does not work: >sqlplus sys/orcl as sysdba What is the difference? Thanks. Sean.
  6. perrymans

    sp_addlogin Password Protection

    Is there a way to protect the password passed as part of an sp_addlogin command from a client to server using OpenClient? Thanks. Sean.
  7. perrymans

    Bring DropDown Menu to the Front

    I am building a WordPress site and put in a PixoPoint multi-level menu. My problem is the sub menus do not show over top of the Posts/Pages area. What is the right setting for this? Would I bring the menu to the front? Or change something in the style.css of the pages/posts? Thanks. Sean.
  8. perrymans

    Ribbon opens Form

    How do I code (XML) a button to open a form? What about setting the property of a subform? Thanks. Sean.
  9. perrymans

    Make A Pass-Through Query On the Fly

    I want to be able to have queries defined in a table and executed by users as recordsources for reports. I want them to be Pass-Through for speed, however I can't make SelQ_Mailing a Pass-Through and then try and pass criteria to it with DoCmd.RunSQL. So I would like to know how I can build...
  10. perrymans

    Vertical Text

    When I set the vertical property to Yes for a label or textbox, it puts the beginning of the word at the top, reading down. I would like the text to start at the bottom, reading up (basically 180 degrees out from where it is now). Any way to do this? Thanks. Sean.
  11. perrymans

    Crosstab Report

    I am using the Microsoft Article for making a Crosstab Report: http://support.microsoft.com/kb/328320 However, the report is only printing a single line from the crosstab. If I leave the code as: If Not rstReport.EOF Then then only first line displays because it exits the sub without...
  12. perrymans

    Finding Records in 2007

    Must be something different, because I am getting a data type mismatch error on my findfirst. With Me.RecordsetClone .FindFirst "[MemberNr] = " & Str(Nz(Me![txtMemberNr_Search], 0)) If Not .NoMatch Then Me.Bookmark = .Bookmark End With Oddly, it works with the...
  13. perrymans

    Code Doesn't Work in 2007

    I have the following code in 2003, but it doesn't work in 2007. I don't have a 2007 install to test with. The crix is the updating of the value in Tbl_Members.DuesYearID and refreshing the MainPage.ubSubform. My user is telling me it is not updating. Is there a difference for this in 2007...
  14. perrymans

    Advanced Excel Export

    I have a query I would like to export as a spreadsheet, for not-advanced-computer-users. The problem is that the docmd.transferspreadsheet doesn't seem to provide some normal functionality like choosing where to save and warning if overwriting etc. Is there a way to get that same functionality...
  15. perrymans

    Best way to reuse items?

    So, I am making a database that is going to use a database of checks to generate point-in-time tests. The checks change frequently (as in they are updated) but the original check used for the tesst must be preserved. The solution I am thinking are separate Project tables. So a project would be...
  16. perrymans

    Append Query clips Memo Field

    The source is a Memo field, the destination is a Memo field, but the Append query truncates the field information. How do I get around this? Thanks. Sean.
  17. perrymans

    Different Method to reference a subform

    I have the following code from a database that is using a reference to a form with Forms(): CurrentDb.Execute " INSERT INTO tblFilesFound" & _ " (" & _ " FilePath," & _ " FileName" & _...
  18. perrymans

    Access and Google Maps Mashup

    Has anyone seen a database that does not just map one record in a database, but would show many addresses as points on a map? Let's say I place foreign exchange students, and wanted to see all of there locations at once on a map based on the host family address. Anyone seen something like this...
  19. perrymans

    Passing Filters from Access Front-End is Slow.

    I have a Access front-end to a MySQL database over the internet. I use a report system that allows users to define some custom query parameters. These are Jet queries because of the need to allowing filtering like this. I have not been able to get this to work by using a Pass-Through query...
  20. perrymans

    Progress Bar for Opening a Report

    I have some reports that are taking quite awhile to run and open (connecting to a MySQL server over the internet). I have several good examples of progress bars, but they all have coding that is driven by a timer or a set number of iterations. I know that I am supposed to substitute the number...

Part and Inventory Search

Back
Top