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

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?

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

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

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

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

I am trying to build an expression in an update query that will give me the info, of unmatched data. For instance I have the following two tables and corresponding fields: TABLE1: field1= country -record1 = Netherlands field2= country Code-record1= NLROT TABLE2: field1=country -record 1 =...

I need to move subtotals to a different cell, and want to do it in a macro. Currently the subtotals are appearing below the last value of a PO Group. I need them to appear to the right (in the totals column,as shown above) of the last poNumber group.I want it to look like the following: columnA...