Search results for query: *

I have a spreadsheet that was developed by exporting from a database (I don't have access to this database and cannot have the information re-ran). One of the columns has currency data, however, I cannot add or change the format. An example of the data within a cell appears as $45,652.32 when...

I have a spreadsheet that someone else created, and he somehow limited how far I can scroll both vertically & horizontally within the worksheet. How is this done? Basically, you can only scroll as far as there's data that you're allowed to see. I know there's more data but I cannot scroll...

I have the following: Account Desc 2004 2005 100200 CASH $3,000 $4,000 100200 CASH $2,000 $5,000 103500 BONDS $10,000 $6,000 104110 STOCK $1,000 $0 And would like to have: Account Desc 2004 2005 100200 CASH $5,000 $9,000 103500 BONDS $10,000...

I need to have a report shown in the following manner: Dept1 Dept2 Dept3 Dept4 Total Element 1 $300 $40 $0 $100 $440 Element 2 $1,000 $500 $500 $200 $2,200 Element 3 $400 $20 $0 $40 $460 Total $1,700 $560 $500 $340...

Two areas contribute to a particular program each having different contribution levels and limits. As payments are made, each contributor should be charged their portion of the payment. The user need only enter the total payment amount and a formula porates the amount accross the two areas...

Computer: XP Professional Pentium IV 2.25GHz processor 512MB RAM GeForce2 MX 400 (Gateway) 64MB Video Card Problem: I won't run Halo: Combat Evolved. Rather, it state "Your Computer's video driver is known to have serious issues with this game. A newer version that is compatible may be...

Can anyone tell me why I might be getting the error "Method or data member not found" when using the FindFirst Method in a procedure? It works fine in another database I've built. And both databases are using the same Reference Libraries. Below is an excerpt of my code: Set dbs = CurrentDb...

Is there an easy way to calculate the number of days in a month or range of months? The NETWORKDAYS formula doesn't include the weekends and the DAYS360 formula is based on 360 days. I need it to be based on a 365 day calendar year (i.e. actual days).

Is there anyway to format a textbox for decimal points or percentages (much the same way one would in a spreadsheet)? For example: if the user typed 1.08 in the textbox, I would like it to show 108% after they leave the textbox.

Is there anyway to create multiple vertical lines (i.e. Columns) in an Access report. I realize I could use the Line tool, but that would make the lines constant in length. I'm needing something that would expand or shrink according to the size of detail for each row of data. Any suggestions???

Does anyone know the character code for the combination lock in Webdings? In Microsoft Word, it shows up as 00CF. But that won't work. HTML seems to only accept one digit codes. Thanks

I would like to have a button on an Access form that opens a custom Outlook form I created. I know how to use the following code to open and send a default mail message, but of course, this isn’t what I need. Set outLookApp = CreateObject("Outlook.Application") Set eMailItem =...

I'm trying to update two distinct tables in the same database using two seperate record sets. While the 1st record set (RDSet) is updated, the 2nd one (RDSet2) isn't. Below is the code I'm using along with the ASP error I recieve. Line 55 in the error message is the very 1st RDSet.Close...

Below is the code I am using and the include statement contains both the database & recordset createobject statements (among other things). I recieve no erros, and everything works except for the response.redirect statements found near the bottom just befor the VBScript Error Checker. Why not...

Below is the code I am using and the include statement contains both the database & recordset createobject statements (among other things). I recieve no erros, and everything works except for the response.redirect statements found near the bottom just befor the VBScript Error Checker. Why not...

I have an HTM form passing values to an ASP page that creates a new record in an SQL database. And for some reason, I receive the following error after clicking the form’s submit button: Database Errors Occured -2147217913 : Syntax error converting the varchar value 'asp_qust17' to a column...

I'm using the SendMail method in Excel to send a workbook for review then approval. The method, however, only offers three parameters (Recipients, Subject & ReturnReceipt). Is there anyway I can also send a message along with the attached workbook? Note that I'd rather not use the Route...

With much frustration, I finally captured some video from my Sony DCR-TRV27 MiniDV using Adobe Premiere 6.5. When I saved the file, Premiere only gave me a few choices as the save option. I chose AVI since it seemed to be the best format in the list. Is there a way to have Premiere save or...

I'm sending an e-mail from Access with the following code: Dim outLookApp As Outlook.Application Dim eMailItem As Outlook.MailItem Dim strTo As Outlook.Recipient Dim strCc As Outlook.Recipient Dim strRecipient As String, strRecipient2 As String strSubject =...

I'm sending an e-mail from Access with the following code: Dim outLookApp As Outlook.Application Dim eMailItem As Outlook.MailItem Dim strTo As Outlook.Recipient Dim strCc As Outlook.Recipient Dim strRecipient As String, strRecipient2 As String strSubject =...