Search results for query: *

I need to create a data entry user interface hooked to Access database to allow salesmen record their sales activity. The salesman will pull the Client from a drop-down menu, which is reading from the “clients” table. The client's contact information will show up to call. The salesman should be...

I have a file in Excel 2010? How can I create an expiry date for the file (let's say after 1 day). if macro is required, how can I make it invisible? Can this work with a file saved as a regular excel file (which I anticipate) not macro-enabled file?

Hello, I use excel 2010. When I select range of data, and click on "Format as Table". I select "My table has header". It does not seem that same name can be used in multiple headers. Excel appends a number to the header name if repeated. Is there a way around this?

I have a main folder located on the c: drive contains about twenty (20) subfolders. Each subfolder contains between 5 to 20 word files. I need to create a form with VBA code (within Excel or word) to do the following: 1- Shows all the subfolders (i.e. tree view or list with check boxes, etc.)...

I am preparing a presentation and need to extract eighty(80) images from word file then import them into powerpoint presentation. I think three macros will be needed in this sequence: 1- A word macro to extract all images from word document, then save them in a folder on the hard drive using...

I have an excel table with three fields (file uploaded and link attached). I need to generate tables to count data cells based on multiple criteria within the table. The data and the tables are described in the attached excel file. I think this could be accompolished by using either excel...

My colleague has created a matrix for construction site in excel spread sheet. The matrix will be updated on daily basis during the inspection activities. The matrix contains lots of information that will be difficult to follow. I was asked to create a user interface that allows data entry of...

Thanks MajP for the great help! I will experiment with these various methods. If I know your whereabouts, I would send you a rose! Thanks a lot!

Thanks MajP, "I see that in the columns there is always a decreasing slope" Ans: Yes that should make sense due to the typical nature of sloped ground as well as the row numbering system. I strongly suggest that you look at the file I uploaded. This will be the best to visualize the condition...

I apologize; I didn’t ignore your questions at all, but it was a combination of we both have been posting in the same time and also couldn’t manage to respond timely until I get some information first. Below are the answers: QUESTION 1: Ans.: I agree with this concept. It sounds to provide...

Yes!it is pretty much it. recorded values are too low, and best estimate to the missing 95% of the data. This mandated new rules to avoid the side effects in a reasonable way. For instance, the negative values that I get through column extrapolations (the piles should always have positive...

Sorry MajP! Didn't see your two posts before I send mine. Will get back to you

Thanks MajP, I think I got it to work with reasonable outcomes. I noticed another limitation in extrapolation through column that I get negatives, which gets even worse if I follow this with Row interpolation. I locked the minimum value to 0.5 during Column extrapolation (step 2)so it doesn'...

MajP! Just to sum up with my last 2 posts. I constructed the first column and last column within a location manually, to skip the row extrapolation. But it seems that the it still extrapolate, I appreciate if you can help on figuring out the reason and advice. Thanks Two files are uploaded...

MajP, Further to my previous post above, the offest is in meters. I uploaded the database: http://www.4shared.com/file/149391818/f8a7600b/InterpolateExtrapolate_15-adfo.html I manually identified the edging columns for each location and filled them with data (see "qrySelectBentsToFill" for...

Thanks MajP! I'm not sure if the actual data will have such problems. I will look into this and get back to you. I will upload the actual data may be tomorrow. The preference is to interpolate through "valid columns" first, then by Rows. I proposed a "simplification" to the approach which I...

Thanks a lot MajP, it seems that you have the right match of skills lucky you! I think the best is the pure linear (straight line intrpolation between two known points considering the distance between them (in case of rows). I think this is the most simple approach. Your question brought up my...

Thanks MajP! I've been trying the code, and was working fine mathematically wise. However, due to the nature and low number of recorded depths in the database to interpolate from, The "Row extrapolation" doesn't seem to provide reasonable results. For example, if a "group" has 50 columns, and...

Thanks MajP for the great help! I may have to wait couple of days or so until I get more 'depth' values filled into the database to do through testing. I did a quick test on subset of the actual database, which has many depth values recorded to date. Just few uncalculated values are still...

I apologize MajP, There was a typo in some Id's I reoprted and this what probably caused you some confusion.. I meant ID (3643, 3644, 3645, and 3646) it seems that I switched 4 & 6. I'm glad that I reported another case which you responded with the corrected code above. I think this corrects...