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 Chriss Miller 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: *

  1. PaulBricker

    VBA won't run on one database

    I have a db on the network that 2 of us use. On my pc, it runs fine. The AutoExec macro works and all the VBA event procedures work. On our Admin Assistants machine, the AutoExec Macro works but none of the VBA code executes. If I type something in her Immediate Window like ?Asc("m") I get...
  2. PaulBricker

    Vista Business dumps my cookies

    This seems weird to me, but when I go home at night (or leave my pc for short periods sometimes), my machine will lock itself. When it does that, it dumps my cookies (are they session cookies?). I'm not sure it actually dumps them, but, for example, when I open Tek-Tips I have to log back in...
  3. PaulBricker

    Hiding a web link

    I have to generate bulk emails using VBA. The email includes a link in it to a page on our intranet. I don't want the actual link to show but would rather cover it in a manner similar to TGML or HTML methods. In TGML, you can have something like this: Google and you end up seeing Google Is it...
  4. PaulBricker

    Order By problem

    I have a database for our Track and Field coach. The result field in the Results Table is a text field that needs to hold information in a couple different formats. For Track events, the results field looks like ##:##.## 42:05.91 would be an example. For Field events, the results field looks...
  5. PaulBricker

    Add external data to formatted worksheet

    I wasn't sure exactly how to describe this problem in the subject line but it's fairly straight forward. I have an attendance database in MS Access. We take attendance daily and have always printed a report that goes to 'central office'. Now central office want this done electronically. I...
  6. PaulBricker

    Access .adp or accdb

    I'm looking for a little advice on what might be the smarter development platform for a FE database. The situation is we have an SQL database that controls all our card-access door locks. The card-access database allows us to enter users and modify data, but it falls short when it comes to any...
  7. PaulBricker

    Send emails without Outlook being open

    For a few years I have been able to send out bulk emails (not spam) during the night when I'm not at my desk. I used some code in MS Access to accomplish this and Outlook didn't have to be open. Now we have an Exchange Server and with the account set up we have, I have to leave Outlook open to...
  8. PaulBricker

    duplicate records being inserted in database table

    I have 3 HTML pages with forms on them. The are very similar in style and structure. They all submit the data to ASP pages for the info to be inserted in my database tables. The ASP pages are all very similar as well. The problem is the data from one form gets inserted twice in the...
  9. PaulBricker

    html form creates double record in database

    This may be an HTML problem or it might be an ASP problem, but I have not figured out where the issue is so I thought I would start with the HTML forum. I have 3 html pages that contain forms on them. They are all very similar in style and content. All three send their info to ASP pages which...
  10. PaulBricker

    call asp page when html page loads

    I have an asp page that returns values from a database, and inserts them in a javascript routine that I got from DynamicDrive. The javascript routine displays a scrolling list of the 'contents' from the database table. I would like to display the results on an html page. Of course, I can...
  11. PaulBricker

    use Javascript in VBScript(ASP) routine

    What I currently have is a page (sorry it's an intranet site so I can't display it)that has a scroller I got at Dynamic Drive. I have to go in manually and change the content of that scroller each week. I would like to be able to pull the content for the scroller from a database table instead...
  12. PaulBricker

    dynamic variables(?)

    I currently have a loop that pulls values from a table and writes them to a page. <%WHILE NOT rst.EOF FOR i = 0 to rst.recordcount-1 Response.Write rst(i) NEXT rst.MoveNext WEND%> But what I would like to do is store the values returned by the loop in variables...
  13. PaulBricker

    Problem with a href links

    The second link below does not work. <a href="\\serverName\dbpysplant\leadcomplianceletters\91 Park Street Lead.pdf">91 Park St Lead Report</a> <a href="http://physicalplant.williston.com\91 Park Street Lead.pdf">91 Park St Lead Report</a>Does not work <a...
  14. PaulBricker

    Changing BackColor for controls

    I already know how to change the Backcolor for a control using VBA, but this has a little twist to it. I'm going to end up with close to 150 controls on this form we are building, and I don't want to have to open Event Procedures for On_Got_Focus and On_Lost_Focus for every control inorder to...
  15. PaulBricker

    Error creating report engine/no such interface supported

    This may be a little long winded so I'll condense as much as possible. 1. We have now installed a card reader on one of our student dorms and the associated software on my machine. 2. I have worked in MSAccess for almost 15 years but this new software uses SQL Server 2000. 3. The reports for...
  16. PaulBricker

    3D reference a range of cells

    I export data from a database to an excel spreadsheet. The data always writes to the same range of cells (overwrites existing data). Now, my bosses want to set up the spreadsheet so it is formatted for appearances but when I export, any formatting I add to the spreadsheet is lost. My solution...
  17. PaulBricker

    Cross platform weekday glitch

    Someone in the MS Access forum is developing a database that is being opened by users with Win98, NT and XP. On one of the forms, there is an ActiveX calendar control. In Win98 and NT, the calendar opens with Sunday as the First Day of the Week, but the XP users are seeing Monday as the First...
  18. PaulBricker

    Can't View Linked CSS Pages

    In this thread, thread215-844105 there are two links http://www.uniquesolutions.com.au/ms/metro.css http://www.uniquesolutions.com.au/ms/index.html When I click on the first link all I see is a little icon up in the left corner of my browser window. I have no problem viewing the second link...
  19. PaulBricker

    capture the name of the link in a variable

    I have an asp page that takes the names of all the files in a Folder and creates a link to them so users can open the files. Now I have a little wrinkle. They decided to store all the files in subfolders. I changed my original code so I can open all the subfolders as links, but now I need to...
  20. PaulBricker

    links don't show up on a Mac

    I've got 5 links on my intranet homepage. We debuted it the other day and we had complaints from a couple Mac users that they couldn't see any of the links to other pages. The funny thing is they could see the links to the email addresses on another part of the page. I built the page using...

Part and Inventory Search

Back
Top