Search results for query: *

I have set up a very simple workbook with 9 others linked to it, each with 31 pages. We are having several problems with it, the first of the two major being the autocalculation control has turned off on it's own a couple of times, and I know they were all turned on because of this happening...

I've set up a macro in Excel linked with a control button that will SaveAs when clicked and will make a duplicate of the workbook. My problem is that I have linked the workbooks together so that totals will carry from one month to the next; what's happening is that the new workbook is still...

I would like to create a "SaveAs" (or whatever you suggest) control button that will 1). create a new worksheet in a folder *and* 2). remove values from columns 1&2; 3). replace values from columns 5&6 to 3&4, 4). and remove values from columns 5&6. I know how to do it...

I have a small workbook I set up on two computers; on one it suddenly stopped adding two columns together; the other the function works fine. It was just noticed today; what's even weirder is that the previous month's workbook has also suddenly stopped calculating. Could this have anything to...

I have a workbook that has 32 worksheets in it...inventory...and I want to delete certain items across each sheet (one for each day of the week). I have the row formula so they equal the total sheet so that when I did corrections it would do it for all the sheets; however, when I go to hide the...

One more time..I keep click the wrong links :)ended up in SQL last time! I already checked with the other forum (Office General) and was directed back here :) Easy questions, probably, but finding the answers isn't :) 1) Can I get Excel to automatically add data in the same cell as it is...

I already checked with the other forum and was directed back here :) Easy questions, probably, but finding the answers isn't :) 1) Can I get Excel to automatically add data in the same cell as it is being entered (ie, 5 of a product went out; then four hours later 5 more). I don't want to...

Easy questions, probably, but finding the answers isn't :) 1) Can I get Excel to automatically add data in the same cell as it is being entered (ie, 5 of a product went out; then four hours later 5 more). I don't want to have a column for each time the product goes; just want Excel to add to...

I have an InventoryControl Database I am setting up. It has two tables: Table One: InventoryDescription: CharterNo (PrimaryKey) OldCharterNo Description VendorNo Vendor Manufacturer StartInventory AmtRecd AmtIssued EndInventory ItemCost ReorderAmt Table Two: InventoryTransactions...

I have this in AfterUpdate: Private Sub EndInventory_AfterUpdate() EndInventory As Variant varEndInventory = ("[StartInventory] + [AmtRecd] - [AmtIssued]") End Sub Obviously, it's not working :). I tried to tell it to go to "InventoryTransactions" table but it kept...

What is the most efficient way to write a Macro (I'm assuming that would work best) so that if someone puts the wrong data in a cell, the cell turns, say, red? I know it's "not equal to" but how do I get it to change color? What would be the formula? Thank you! Jackie

I really appreciate any help; I hope these are not too basic questions, but I have read and reread the book for hours and they are just not makeing sense suddenly. I've got 3 tables I am working with: Inventory Description, Inventory Supply, Inventory Transactions. I am attempting to make...

Basically, I can't figure how to get them to exist. Under Ch. 27 (Creating Forms) in the Unleashing Acess book, it says to go to Control Wizard and then draw the control on the form. Then the Combo Wizard will appear. Well, I've dragged, I've clicked, I've done all I can think of. If I click...

I'm trying to get Excel 97 to do the following: I want to be able to enter a company number in one cell; have Excel go to another workbook, lookup the number, then return the description to the next cell so that whoever is entering the number will see the item. I can make a seperate worksheet...

I have several worksheets that I am working with as inventory control. They have Start Inv; # In, # Out, End Inv. Pretty basic. I have a Summary worksheet that shows the Start Inv. and End Inv (which I've linked). How can I make a link that adds the # In/# Out columns for the month without...

I formatted cells for date mode; when I type in the date, say, 06/06/00, I get wacky dates, like 11/29/2065. I feel like I'm in a time warp! Please help! Thanks! Jackie

Okay, I'm feeling pretty silly, but I cannot get my backend DB to link to my frontend DB. The backend is on another network drive; I went through the steps and told it to go to G drive like the directions say. I then when to my FE and told it to link all tables to my BE. It finds where to go...

I am trying to set up my database to save any changes *somewhere* so that I can go back and pull up the dates/changes in the future (it's for an inventory control for a warehouse...I need to know when items are received, distributed, etc.). Quick question...will the "AfterUpdate" in...

Link a field in Acess to a field in Excel so that when an amount of items in entered in a field in Access it will automatically be entered in Excel (where I have a spreadsheet to figure out costs, etc.)? I thought I'd ask here before I spend hours finding out I can't do it. Thanks Big Time! Jackie

Went to import Access to Excel; according to the Ofice 97 Big Book, I go to Tools/Add-Ins, activate AccessLinks Add-In check box...only there is not one. Only Analysis, Analysi, AutoSave, Condi. Sum Wizard, Look Up Wizard, MS Bookshelf, Template, and Update Add Ins. The book says AcessLinks...