Search results for query: *

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 -...

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?

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]...

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]...

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...

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...

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])...

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...

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?

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?

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...