Search results

I am re-designing a database for 2008 and trying to eliminate my Make Table Queries as I have found them to be somewhat consistant over the last year, particularily when the users do not open the database on a given date. It seems there should be a simple way to accomplish what I want but I am...

I am currently designing an employee suggestion database. Does anyone have, or does anyone know of a location to where I might find the shell of a Employee Suggestion Program?? sorry if this is the wrong place to post but was not sure where it should go.

Have a database that when opened, has a message box that appears and when this box is closed via a Close button that I have named "OK", the main form opens. I have a Tip table that I type in the message which then appears in the messaage box form. It works perfectly providing I use a Next...

I have a report "Work Order Details" that that is based on a query and opens along with a form that is used to set filters. Based on samples I have looked at and reading, I cannot figure out what is missing. When I select my item form one of 5 unbound combo box 's and click the "Set filter"...

I am not an expert by any means and after several hours of fighting with this I could really use some help. I have a form based on a table that has multiple combo boxes. I did make a query (with filter) from the table linking to the other tables used in the combo boxes so the fields would...

I have looked at multiple samples on this forum and others and cannot seem to get the result I want working. Have main form TmLdr made from table of same name. Entries include ReqName and CostCenter. These same entries are on a subform. On the After Update event on the CoRecDt (main form)...

Looking for advice on how to make changes required in my database designed to track health wellness. Here is a breakdown of what I have now: Membership Query built off membership table that isolates one employer group and creates age off birthdates that will change as the months go by...

Have a crosstab query for a running 12 months that is used for a report and I noticed today that each month is correct except that it is also picking up Feb of last year as well as this year. All other months are good. No other pre-queries have any date ranges in them. Anyone know what I have...

Is there any chance I could zip up a copy of what I am working on and have someone take a look at it. I actually have 2 problems to solve. (1) the issue of the contract num and the activie contract num. Depending on what number is input the correct member files will appear and active contract...

I know to most this is simple, but as a newer user putting everything in its right place is hard. Have checked multiple posts for my situation and cannot locate. I know I need to use DLookup. Membership table used to built form has among others, a contract #1 field (9-digit Soc.Sec. #) and a...

I have attached a condensed copy of my form/sub-form that has calendar controls on it for the RecvdDt and the Compliance date. I have it set up the say way as I have on other databases and it will not close/populate once opened. I have reset the events on it multiple times and I just can't get...

Have a database that I am working on this is constructed to perform Compliance tracking of wellness activity by employees. Have all my tables, queries and a form that has 3 tab controls as well as a subform on one of the tabs. It is necessary to create a quarterly report card based on 6...

I have a report that is the result of data imported from Crystal Reports to Excel to Access. In Excel, the Cell is listed as a General Number and formatted like 00:00:00. The first 2 zeros are for Minutes, the second set for Seconds, and the third set for partial seconds, whatever that is...

Have a couple of queries that I am trying to joing and I am having problems with matching the date and figures from one query to the other query. In other words, 1 query has has a date field with measurements that began effective Oct 2003. The other query has a date field with measurements...

I have a program that Tracks the projects received within a department, who works on them, the time used and the costs associated. I now have a request from that area to adjust a report that will show a designated employees results. Normally, I would set the query/report criteria to ask for...

On report, formated Check Boxes That only show a yes, are shown below and work just fine. Have 2 text boxs on form for Dollars and Dollars2. The user will pick q check box for Prof or Fac and show a $ amount in “Dollars”. They will then pick a check box from Prof2 or Fac2 and show a $ amount...

Not sure where my problem lies so will tell you what I have done and what my result should be. Have primary CustomerTbl, ServiceTbl, ReasonTbl, and LocationTbl, with the 3 latter tables related to customer table. Have a form allowing for 2 entries of facts if necessary; Customer name, Contract...