I am in the process of moving our RFC/ECR (Request for Change/Engineering Change Request) data from Excel to Access. The problem I am having is creating the primary key. Our RFC/ECR number is a combination of YearMonthSequence, meaning the current year, the current month, and the sequence of...
I want to import Excel into Access without linking the 2 together. I followed the directions on:
http://office.microsoft.com/en-us/assistance/HA010546501033.aspx
"Creating a new Access database from an Excel spreadsheet"
After opening the Excel file in Access with the import wizard (I can't...
For some reason, macros are no longer working on one of our computers. We are running Solidworks 2006 SP1.0, Windows XP Pro, and Microsoft Office 2003, and McAfee Viruscan. I am not sure if a Windows automatic update changed some security settings, or if it is a McAfee changed script settings...
After reading several posts here, I noticed that tables are not recommended anymore; typically "divs" or something else is recommended instead. I know how to layout a web page with tables using a header, and 2 columns below it. For example the left column being 30% of the screen, and the right...
On sheet 2 there are 7 columns:
A1 is Job #
B1 is Client Name
C1 is Product Ordered
etc.
On Sheet 1, in cell A1 I want to enter a job #, then it will copy all rows with the matching job #'s from Sheet 2 to Sheet 1. Any suggestions?
Flores
I have an item number, for example: in cell A1, which is 1224-A25, and I have a cell next to it that strips the last numbers after the first 4 digits. In column B, I have tried this 2 ways:
LEFT(A1,4)
and also:
=LEFT(A2,FIND("-",A2)-1)
I'm using conditional formatting to highlight the...
I have to make a somewhat simple "automatic" inventory in Excel, but am having trouble getting this accomplished. Basically I have the following:
Date Description In Stock Shipped Balance
8/15/03 8'Units 650 450 200
8/17/03 4'Units 850 500...
Does anyone know how or where to get a Spanish spellchecker for Word 2000? I am in need of writing documents in Spanish from time to time. I can speak it and write somewhat in Spanish, but I would like a way to double check it.
Thanks in advance.
I am having trouble searching only in a specific folder in Windows XP Profesional edition. In Win98, I could search for a word in any specific folder. In WinXP, I can only search either drive A, C, D, or My Computer. For example, if I want to look in a folder named "Drawings" for a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.