Search results for query: *

I am trying to write some macros to open several workbooks at a time and I am not having any luck. I have tried all the ways that I can think of to open workbooks, and the macro will not record any keystroke commands. I have done this before in infinite variety and never had a problem. I cannot...

I have a concatentate sentence that includes a date. The date comes up in number format, not date format ="not funded as of "&N2 n2 has the date in it. It comes up 37666 or some such, the absolute reference. Is there a way to convert this to a date that is recognizable? dbpcar

I want to build a pivot table report that shows months as the header. I cannot get the table to build on months, only individual days. What am I missing? The table I want has year on the column, and months on the row, producing a summary by month and year. I tried splitting the date apart, but...

Is there a way to sort the worksheets by tab, besides manually? Thanks dbpcar

Is there a way to keep the calculator that is in the accessories package on top, no matter what application I am using? dbpcar

I have an excel mailing list that has the address and phone number together as below: "Costa Mesa CA 92626 714-557-2670" This entry is in one cell, separated by the computer graphic for "enter" I need to identify the delimiter in Text To Columns. I cannot...

I have a macro that formats a stock number-the stock number is alphanumeric and the macro separates the numbers and letters. It is set to run as an equation in the workbook. I have to open the workbook that contains this macro to use it, I would like to set it as a either a button on my toolbar...

Currently, managers send daily reports, more or less reliably, by e-mail to the main office. Is it possible to set up Outlook to automatically send the reports, without prompting or any other action on the part of the manager, once a day? Thanks

I am doing credit/debit entries in a blank workbook and instead of a zero balance I am getting the following: -8.88178E-15 as the result instead of zero. I dumped that workbook and started a new one, and I still have the same problem. I am a little confused here. This is an issue because the...

Whenever I transfer a text document into excel it helpfully converts more data than it is supposed to...customer info is 3 letters and 4 numbers, and anytime this starts with 3 letters that excel thinks is a month it converts to a date. I need it to stay as a letter-number combination. I have...

I have a problem with a a query that connects three tables-the record in the sale table is duplicating when there is more than one record in the cost table. I want all the cost figures to add and summarize for each sale.

I am trying to print section headers-The report has several parts, and each is multiple pages: for example ABC Company Inventory Report widgets 10 pages whatsits 4 pages mrwho 9 pages These reports for each section take several pages. Repeating the title on each page is no problem, is there a...

I am importing the general ledger into an access db. Some of the acct # are a combination of letters and numbers. Even after changing the format of the field to text I cannot import any acct # with letters in them. Help!!!

i have a design problem-I am setting up a database to use for budgeting. One table (the income statement) will have historical data-each month's total in each account. The table will be updated once a month with the closing numbers. The question-is it better to have the accounts as fields and...

I have to repair a report that is not based on a query. I am not able to figure out the source of the information-example: the report is for specific make and model, but there is not a select option, and there are hundreds of makes and thousands of models. I need to know how just one was...

When I set up a report in Access, sometimes the formatting sticks -landscape sheet or column width, for example, and sometimes it won't stay the way I want it to. Any ideas?

I have several databases that have multiple users. In each one are maintenance queries that I would like to hide. Is there a way to hide queries and/or reports within a database? I don't want all the users to be playing with them. Thanks

I am unable to run the duplicate wizard in Access. The wizard is listed but nothing happens when I try to use it. What am I missing? Thanks

I am trying to create a link to a seperate database that hold all possible inventory items so that the report will convert a stock # into the description. Only stock # are stored in the data base at present. I can get both the stock # and the description to report, but not the description only.

I am trying to create a link to a seperate database that hold all possible inventory items so that the report will convert a stock # into the description. Only stock # are stored in the data base at present. I can get both the stock # and the description to report, but not the description only.