Search results for query: *

I am attempting to add a clock to an access form, mainly following this thread: http://www.tek-tips.com/viewthread.cfm?qid=1282461 When I compile the module I get this error: Compile Error: Invalid use of Me keyword Here is the code that I am using: Private Sub Form_Timer()...

Let me start by saying I am new to CSS and not good at it yet. So feel free to tell me if there is a better way to do this. I have two CSS problems. 1. I'm trying to put a background in the center of the browser window at the top, and stay there when the user resizes their browser. Problem, IE7...

I thought this was simple, but my query yields a datetime value in 12 hour format and I can not get it to convert to 24hour (and I do need it in 24 hour). The query below has three commented sections, and I denoted the steps, originally it is 24 hr, I convert it to float, average it convert it...

So when I run this I get the "the remaining text doesn't appear to be part of this formula" error. What I want to do is output text for a bunch of procedure codes, that's the HOSP part, but if it is HOSP I want to dump the billed amount into a global variable to report on it at the end...

This is one of those things I've spent to much time on and still can't solve, so here goes: I have an age field, calculated using this formula: WhileReadingRecords; DateTimeVar Birth := {Abha7105_93005.MceHdr_BirthDate}; DateVar CurDate := CurrentDate; If (Month(CurDate)*100) + Day(CurDate)...

Hey all, I have a report that I'm trying to suppress some data, but here's the problem. I will have a subscriberName, a SubscriberID an EFFDate and a TermDate. The subsc will have 2 records sometimes, one that says effdate is 01/01/2006 and term date is 01/01/2006 and the following row shows...

I have a strange problem with session.timeout, no matter what I set it to, no matter which page I set it on, it doesn't seem to work. it also isn't defaulted to 20 minutes, it's more like 12 minutes. I have in order to try to get it working, have set it at the point of login, the commonly used...

I am having page expiration problems. I am unsure of several things. One, the session.timeout value, do I need to set that on every page accessed if I want it to be something other than the default? and If I do not, then why do all my pages expire so quickly. and Is it at all possible to...

Hello, I'm attempting to concatinate an sql statement that looks like this: SQL = "SELECT * FROM [companyList] WHERE [customers] = ['"& newCompany & "']" Basically the newCompany variable needs to contain puncuation, such as ' and possibly others. newCompany might be a...

It appears there is no mssql query to rename a table (yet oracle and mysql both have one), Here is what I have, and I need to write a query to rename a table. It's a bit messy at the moment, but basically I've got a customer table and my user entered the name wrong and added a bunch of data...

I've got a system setup that takes input through an input text box and stores it in a database. Unfortunatly I need to have symbols, specifically a '. this of coruse will end a string if it's written out, so I need to escape it. Can someone write a statement to seach a string for all the major...

I'm trying to do a simple removal of a table, and after my handy dandy book I came up with a drop table statement that looks like this, but it doesn't work: SQL = "DROP TABLE " & companyName & "" Rs.Open SQL, outsales, 1,3 It gives me a Syntax error. I've never even had...

I've successfully forwarded terminal server through my linux firewall, and just figured it would be the same procedure to forward win2k's vpn server, so I forwarded port 1723 to the appropriate IP address, but it timesout. However if I access it through the internal lan address it works just...

SQL = "SELECT * FROM products WHERE department = '"& strDepartment &"' AND Course = '"& strCourse &"' AND [Section] = '"& strSection &"'" Basically I have a large book database, that I need to query individual books out of it, it is formatted like so with...

SQL = "SELECT customerName, department, FROM reservations, depList WHERE customerName = '" & customerName & "'" I'm getting the error: Microsoft JET Database Engine error '80040e14' The SELECT statement includes a reserved word or an argument name that is misspelled or...

Set Rs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT DISTINCT deplist.department, deplist.course from depList" Rs.Open SQL, deplist, 1,3 The query will display distinct if I remove deplist.course, but since I will actually need two more columns later including...

I'm running into a type mismatch while trying to pass data to a hidden field, or even write it out using response.write, and I don't understand why. The first block of code contains a listbox that populates from a database, the idea is that I want the selected option to assign to the hidden...

My company is in process of consolidating all office suites into one (lotus, corel, and MS to openoffice). I have been give the task of transfering all of our spreadsheets. Not easy, as some of the old lotus macro's are very messy. Is there some reference for the staroffice basic language so...

I want to take formCount from the previous form, add it to count and start again with the incremented number. Is it possible? Is there an easier way? dim count dim formCount count = 0 formCount = server.htmlencode(request.form(&quot;inputcount&quot;)) count = formCount <form post self blah...

I'm trying to pass an incrementing value through a loop of forms. But I keep running into a type mismatch, here's the deal. I have two variables varLoopNum and classNumber varLoopNum is a hidden field that contains a 0 to start with, classNumber is just a variable, that is trying to contain...