Search results for query: *

How do I restore database to its values? I accidentally changed numeric values, by doing ctrl+F Replace and when I did that I was attempting to delete all 0. consequently, any value that was 10 or 100 or 1000 has now been reduced to 1. All the values that were at 50 are now showing as 5...

Great it worked. Thanks!!!!!!!

I need to lock certain columns and cells in a worksheet, however, I also want other columns cells to be available for data input (to place number of orders per item) how do I lock specific cells?

great, think I have something working here! THanks for all your help.!

That didn't seem to help or work....any other suggestions?

I have created a database, have a command button but can't figure out VBA Code to select a file from the shared drive. I would like to be able to click Command1 button and be prompted to select file from specific folder on shared drive so that I can import it. Anyone know what the string is for...

Great. Thanks for your help!

We definitely want to use this tool as an inventory databse too. As right now we maintain inventory manually on excel spreadsheets. I guess my question is how will the database be able to gauge inventory/stock levels? Do we need a table of current inventory items? The vendor does do drop...

I am continuing to work on this database and need help. What I have done is taken the template and tweaked it to my needs. However, need hlp with the following: Have a product catalogue ie: A B C D E...

Thanks. I looked at the wizard and decided to select the orders template. However, when I started deleting some of the stufff I don't need a number of error messages come popping up becasue of the intricate relationships throughout the database template. So for instance the template format...

ACCESS DATABSE- I manage promotional items and their distribution for my company. Is there an easy way to develop a promo database? I need to have the distribution list in there, the orders they place, the list of promotional items, invoice, and the vendor information. Is there a template for...

I have a pdf file that I would liek to convert to a word document is there a way?

I am compiling a contact list with contact name, company name, address, phone number etc. I want to make the zip code two columns. Column A with the first portion and column B with the last 4 numbers. I have been given a spreadsheet with the zip code in one column. As follows. What I currently...

Well this is the thing...I don't actually want to print the document. I need to post it on the company's intranet site and eventually internet site, but when its converted to pdf format, it still appears as though image is not far enough over to edge. ANy way to rectify it so that when posted on...

Actually, Its not a printing issue. Its that when I have the vertical picuture on the page in word, it looks like its all the way to the edge, but then when I go to page preview/print preview, there is some white space to the left of it, on top and on bottom. Does this make sense?

I have a vertical picture that I want to bleed to the edge. (It's actually in a word doc.)then I write over to PDF. Is there a way either in Word or Adobe to bring the picture to the left hand side without it appearing that margins are creating a white space on teh top/bttom and left hand side...

I have two JPG files that I want to combine into one file. Is this possible? For instance one JPG is a picture of a box. The second JPG is a picture of what's in the box. Is it possible to combine this in one file, so it looks like it was one picture that was taken?

I have 157,000 records in an Access database. And I need one field of information to be consistant. i.e If I have the name: GAP in 5 records and GAP Inc. on 1 record, and GAP USA on 2 records, How do I make the Gap Inc. and Gap USA = to GAP? Is there a simple way to find all the GAP and fix it...

Just wanted to thank everyone for their help. For this case, I was actually able to just use the match/unmatch formula. thanks again.

I think I need to do a V-LOOKUP to compare the values of column A to the values of column B. I need to find the value that do not match. How do I do a VLOOKUP? My problem is set up below: COLUMN A Column B ROW (1) VALUES SUBTOTAL ***** ******...