Search results

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

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

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

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

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

Hello all, Quick question, I have a table inported from an Excel sheet with tons of information. The table is set up like this CODE.......YEAR.......L1............. L2............ L3............ L4 ...A...........2000........5..............9..............3..............6...

[Forms]![frmSearch]![ReportMonth].Column(1) I have this on a Report in an unbound text box. I just cant get it to work, I am sure it is just a syntax error but any help is appreciated.

Howdy all, Well here is the question, I have a Report that totals alot of Financial figures. It is based off a query that gets its criteria from a form ( Month, Year, Etc... ). The report works like a charm except one part. I have a Field that works fine if I put the criteria right...

I need to change the default quarter ( 1=Jan-Mar Etc...) To (1= Oct-Dec Etc...). I would like to put it in one place for the whole DataBase because I use it for alot of reports and queries. Any help is appreciated. Frank

Sorry to beat a dead horse but I have looked around and tried several ideas in other posts with no avail. I have a form that displays records by a unique field. I need to have the user input the identifier if it is already been input the record displays for editing, If it is a new identifier the...

I have a database for tracking jobs, They are tracked by a unique number (350 tag #). In the form for logging in the job I am trying to get a message to come up if the 350 tag # that is entered into the field is a duplicate. I would like this to hapen when the user tries to tab out of that...