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!

Register Log in
  • Congratulations Rhinorhino 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: PaultheS
  • Content: Threads
  • Order by date
  1. PaultheS

    Excel 2003 - Reference a sheet described in a cell

    I'm wondering if there's any way to decide which sheet to reference based on a formula. Specifically, I have data for sales in sheet 'All Sales'. Then, I have a sheet outlining cost assumptions for each month. They all have identical format, and the sheet names are 'Costs - January', 'Costs -...
  2. PaultheS

    Add one year to date/time field

    I'm looking to run an update query in MS Access that will take an existing Date/Time field and add one year to it. I was looking at the DateSerial function but I believe that would get rid of the times and I need those to stay the same. Any thoughts?
  3. PaultheS

    Replacing "NOT IN" with a faster criterion

    I currently have a query that is meant to pick all customers who have not paid any of their purchases this year. A customer can have many purchases, and if they've paid even one, their number should not be selected. The query I'm using is this: SELECT DISTINCT [CustomerID] FROM [tbl: Sales]...
  4. PaultheS

    Order by criteria, with exceptions

    I'm currently working on a database to print individual customer statements. I use a recordset to get all transactions relevant to a particular customer, and then it prints all of these onto a form (paper form, not Access). The SQL statement looks something like this... SELECT [Balance]...
  5. PaultheS

    Disable word-wrap in textbox

    I have a multi-line text box that I'd like to disable word wrapping on. So, if a user were to type it would all go on the first line until they hit enter. Sort of like what a one-line text box will do, except having it be bigger so that the user can see multiple lines. I would've thought this...
  6. PaultheS

    Shared borders in design view but not preview

    Currently, I have a web site with a top and bottom shared border. It's applied to all the pages, and it all looks perfect in design view. When previewed in FrontPage or in the browser, however, a few of the pages don't have the borders at all (although most pages do). This is using FrontPage...
  7. PaultheS

    Possible quotation marks in an VBA-built SQL statement

    Right now, I have a form that users can fill out and send e-mails from. It's supposed to save the body, subject, date, etc. when every e-mail is sent. I've been doing this with an SQL statement that is built in VBA. So, something like: "INSERT INTO [tbl: History] ([Body], [Subject], [Date])...
  8. PaultheS

    Making a textbox show all text when clicked

    I have some text boxes on a form that contain more text than they automatically show. I'd like it to stay like that unless the user clicks in the text box, in which case the text box would pop up larger. Think of how a cell in Excel shows only a bit of text, but then shows the entire box once...
  9. PaultheS

    Scrollbar question - holding down left click

    I'm using a Microsoft Forms 2.0 Scrollbar on a form and it seems that when I left click a directional button and then hold down, it simply scrolls one record and stops. Is there a way to make it scroll continuously until I let off the button like most scrollbars?
  10. PaultheS

    Used range in Excel - including top left cells

    I'd like to be able to select the used range of a spreadsheet, starting from cell A1 and going down right until there's nothing left. However, The UsedRange function removes the first columns/rows if they are empty. Any suggestions on how to achieve this?
  11. PaultheS

    Normal.dot issues - not saving changes

    I recently upgraded to Office 2003 and my Normal.dot template had changed. I copied my old one back, and now when I open Word I do have my old macros, settings, etc. The problem is, when I make changes to AutoText and other things, it doesn't save properly. It seems to work throughout the...
  12. PaultheS

    How to only allow one box to be checked on a Word form

    I'm making a form right now with a pretty standard "How did you find our service? 1 (Bad) 2 (Not great) 3 (Satisfactory)...", where the headings are above the questions and then beside each question there are 5 check boxes. Naturally I want to only allow them to select one of the five...
  13. PaultheS

    SharePoint Team Services vs Windows SharePoint Services?

    Hi, I've been looking around for information about SharePoint and I seem to see these terms interchanged frequently. But, I've seen a few articles that mention "SharePoint Team Services or Windows SharePoint Services"... What is the difference between these? Is it just two terms for the same...
  14. PaultheS

    Changing Options of an Existing Column

    From my understanding of the Microsoft help, there's no way to change the data type of an existing column. However, is there any way to change the optional settings? Or if I want to change either, am I stuck deleting the column and creating a new one? The specific thing I'm looking at is...
  15. PaultheS

    Excel VBA Problem - Not Quitting Properly

    Okay, I have code in an Access module that creates an Excel sheet, does some stuff and then quits. Long story short, it looks like this: Set xl = CreateObject("Excel.Application") ...some stuff... xl.Quit Set xl = Nothing When I run it as visible, the Excel program opens, I see the...
  16. PaultheS

    Excel Hidden Columns - Scrollbar Issue

    Right now I'm working on a program for an Access database that creates a spreadsheet for a user to fill in and then imports the data back into Access. The first two columns of the spreadsheet contain data only useful to the program that would mean nothing to the user. So, I've had those two...
  17. PaultheS

    Filter by Date Not Working

    My form currently has three text boxes that a user can put filter criteria in, and then an "Apply Filter" button that applies the filter to the form (big surprise). The button has code behind it to build the filter statement. Two of the boxes work fine, which are E-mail Address (string) and...
  18. PaultheS

    Using a Verical Scrollbar to Select Records

    Hi, I'm using a single form and I'd like to be able to use a scrollbar to scroll down through my records (like when looking at powerpoint slides). A continuous form is not practical in this case. Is there a way to do this?
  19. PaultheS

    MsgBox/Form Problem - Conditional Statements

    I posted earlier about a problem I had with MsgBox only allowing 1024 characters. Someone suggested using a form, but part of the problem is the message to be displayed has some conditional statements, like... "You are going to send <this>. (If make default is set to true) You are going to...
  20. PaultheS

    Freezing a Column on the Screen

    I've got a bit of a problem with a form I'm creating in Excel with VBA. On the left side of the form there's a column that defines the row (eg. a name). Then, for the next 15-20 columns the user is to input data. The problem is, by the time you get far over you can't see the first column...

Part and Inventory Search

Back
Top