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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.