Search results for query: *

I have a simple database, 2 tables. One is the contact table one is the service calls table. Linked by ContactID Being that each contact can have multiple calls I wanted to create a query to display on the contacts form showing the latest call date from the service calls table for the contact...

I hope that I am placing this on the correct board. I am trying to figure this php,SSI,html,shtml thing out and to be frank I'm so confused, I am not even sure what I am asking for help on (LOL). I have a php page that I am using as a template, I am trying to get all page requests to open in the...

I know this has been covered but I need to have it translated to me in "Stupid". I am trying to sort a Formula field that contains a summary The Forumla is for getting mileage from an odometer reading field. Basicly max(odometer) - the min(odometer) Maximum ({WBVEH.MILEAGE}...

Thanks croberts@monroecounty.gov I'll report back Have a Good Weekend Curt

I am creating a list on a seperate worksheet that shows Tax Map Number,and each corrisponding- Account Number,Water Consumption for Each Account,and the Name and Address for each account. This list is then used to create a text string for each account that is fed into a mainframe to generate the...

Sorry for the confusion, Column A contains tax map numbers and Column B contains Water account numbers. A tax map can contain more than one water account ( ie: appartment complex) So the same tax map number may be repeated several times in the column depending on how many water accounts the...

I am trying to match up account numbers based on a map number where the map number could have more than one account number. Vlookup works great where there is one account number for each map number, but when it gets to a map number with more than one account it assigns the same value ( normally...

I found this out while toying with Match. It worked fine so long as there was a match but errored out if there was not. I will go back and see if I can make it work as you have described. Also the application that started this entire thing is (with this group effort) working to the point that it...

Geoff, I am still getting the same error. I created another workbook with just a small list of numbers on one sheet and a single "find Me" number on another sheet. I have the code exactly as above. and all names ( sheets/ranges) are correct. I am really curious now as to why this is...

Hope you guys don't mind VBA 101... I have tried some of the above. With the list of Numbers in Worksheets("VEHICLES").Range("veh") and the New vehicle Number being requested in WorkSheets("Form").Range(new") I tried this which found no matches even though I...

Hi Dale, and Everyone ! Wow Thanks for all of the help! Y'all have to know that I went and bought some reading material for Visual Basic and VBA, hoping to learn this as it seems that I am required to use it more and more. I will try these ideas and report back.. Dale, the aplication that you...

I am trying to set up a loop to check a column of numbers in Excel, to ensure that a number being added to this column does not already exsist. I am having trouble getting the loop to break off when it evaluates, there is no chance for more than one duplication of a number in this column. and...

I want to stop back and Thank Skip, and Dale For their Help Dale Really went way beyond " HELP " and came up with a solution to the problem that did what we needed plus alot more. Thanks Guys! Curt

Yeah, I did that, What Can I say not all stories have Happy Endings! You want to talk about hard headed people! I while being lost, and playing with the code you sent. Like I said I can follow some of it. But not all of it. if you'd like to see what I am looking at send me and email and I will...

Not Sure why all the static data is going into this. Not my call :p( I'm Just the Grunt at the Bottom of hill that is suppose to catch all this Uh.. Stuff as it comes rolling Down!

Skip, Just ran your code, Very nice ! ,even prompts for date! But when I ran it ,I get all of the vehicle Info in one Column and Week#'s in the Next, Then The Dates in the Next It reads across the Columns, instead of down I get Vin# Week# Date Make Week# Date Year Week# Date...

Trust Me ! this is the boss, Cause he just start learning notes and the best he can do at this point is calling for this dataset. All of this data already resides in an Oracle Database with a Hansen Front end. I started this VB stuff This AM Like I told Dale, I'll Stick to Select Statements...

The County is trying to create a method into which everyone is to place the odometer readings for their vehicles every week, along with check boxes to mark the days the vehicle was used during the week. They are doing this in Lotus Notes. So basicly there will be a template (Form) for Each...

Dale, They need all the info I mentioned plus some. I will email you a same of what I was given. Thanks Curt

I have a list of 1253 Vehicle numbers in Excel. I need to end up with Vehicle Number week # Week Start Date Week end Date 0057 1 12/30/2001 01/05/2002 0057 2 01/06/2202 01/12/2002 I have created seperate columns of data for vehicle Number...