Search results

I appreciate the post but that is exactly what I was trying to get around. I did not really want 31 on click procedures. Frank

Was woundering if the was a way to habdle multiple command buttons with one procedure. I have done a little VB.Net and I remember that you coud use one sub to handle multiple buttons using the handles key word. I was wondering if Access could do that. What I have is 37 command buttons named...

I all ready downloaded your DBase and gat some very helpfull info, Thanks! Could you please show me an example of what the loop procedure would look like. I would greatly appreciate it. Frank

OK I used this in my query AS timeTaken...

Let me try again I have a record Status StartDate EndDate Status1 01/30/2005 12:00 02/02/2005 12:00 Lets say I pull a report for status for the month of march I need the report to say Jan Status Time Status1 0days 12hours Then I pull...

I would like my report to look somthing like this Status time for March Status1 1day 2hours 15minutes Status2 7days 8hours 2minutes Etc... Report for only month at a time Thanks

I am not sure what you mean by "filter your data by date field ". Which one start or end? I do not see where either would help. If I have a status that starts Mar 2nd 12:00 and ends May 7th 10:00 I need to be able to show that status time in the Mar, Apr, and May report.

I know this subject has been covered pretty extensively but my search has not uncovered the info I am looking for. I have a StartDate, an EndDate, and a Status per record what I need is to be able to pull a report by month for each status. March Report Status 1 3hrs 2min Status 2 6hrs 9min My...

Got ya, thanks for the help

Yes that is how I have it now but it displays ID 1 ID 2 SubID1 ID 2 SubID2 I NEED ID 1 ID 2 ID 2 SubID1 ID 2 SubID2 See my problem??

I have two tables with a one to many relationship but not every record has a match on the many side. When I run a query containing both tables and tell the relationship to use all records from the one side and only the records that match from the many side it returns correct execpt when the 1...

OK but still where do I store the new total hours number? Do I put it in a table or what?

Yes and no there will be no FAA I am actually in the Air Force and I am creating a simple tracking system for a foreign Air Force until they learn what info they need to track and purchase a professional DB.

I am pretty far but I want it right I have done several DBases but I am in no way an expert, with that being said I am not sure what you mean by balance carry-over type record? Thanks for the quick responce

I know it is said that you should not store calculated data in tables so I need some input on how to go about a problem I am having. I am creating a DBase with some aircraft info in it. The DBase will be around for awhile so I plan to implement so sort of archiving later on. The problem is one...

Thanks for your help, for some reason after returning to it after a night of sleep it worked fine. Just one of thoses things I guess. Thanks again

I have read several other threads and can not get any of the solutions to work. I would like to change the forecolor of a date field in a report if it is within a week (or past due) of the date the report is pulled. I can do it so it prints the color change but I would like to have the color...

Thanks guys it works like a charm now.

Still need help I have tried several things to make this work but no joy. I am not sure if it is possible but I really need it or at least a work around. I have a database with over 700,00 records. The database has a table with a unique field Registration Number. There is a webpage that...

Hello all, Just woundering how to take information in a field combine it with a common hyperlink. Example: the field could be ID# and I want it to hyperlink to WWW.whatever.com/ID#. All that is stored in the field is is the number. Thanks for any help