Recent content by jdoathout

While not exactly how I envisioned it to work, I solved the problem myself. I reintroduced the Switches as separate code in the query by subcategory. I then placed them on the form and made the border and back ground transparent and laid them over top over each other to produce what I had...

I think I have to be more specific. The system needs to display the right data given those fields meeting the criteria set forth in the queries. The queries should only return a non null value if the conditions are met and then displayed by Name and Case ID as 1 individual can have multiple case...

I had to make a Dbase for a coding Class to calculate the E/M Code for given medical services. Access switches worked perfectly, but there were a few limitations. Because of this I had to break up the one Main Query into separate queries. 16 in total. Because their have calculated fields I...

Adam, Thank you for the information. I set the structure as best as I could with my needs although I am sure it could be better. The amount is the amount of money the Department of Veterans affairs pays to ambulance services via the ratio $.41 a mile. Given that when addresses changes so does...

Here is my dbase.. It has changed alot from the original as I have been attempting to resolve this issue on my own but have had no luck

I have to take the data out for Hippa reasons but will post it in an hour. I thought I did this with my query but maybe I implemented it wrong.

Thanks Jdraw. yeah I have tried your suggestions but the system always updates to the current address. I need to make it track specifics in the history for accounting issues. Payments are $.41 per mile. It therefor is required to provide accurate payment histories for grants and budgets.

http://office.microsoft.com/en-us/templates/desktop-sales-pipeline-TC001225353.aspx That help?

Here is a sample dbase from access called Desktop Customer Service. If you modify the fields tables and relationships to customers=employees employees=managers you can create what you are looking for.in the form that opens is a drop down to the right for reports. Select the Cases Details Report...

Starting something now for you. Its not going to be to advanced though.

In the long date format you could set the query to exclude saturdays and sundays however holidays would need to be through VBA

Most serious dbase programmers prefer an sql based system. For your needs, access sounds perfect. Their are already many templates that include the fields you desire. You will need to tweak a few and make a few tables queries forms and reports. The question is, how confidant are you that you can...

C# or visual basic possibly. You need to take the time to figure out some sort of password restriction set. If its an app, why not just make the link only accessible by buying it online?

Nathan, you should be able to go to save as and save it as an access 2007 dbase and post it. I too use access 2007. A few things I note that may help is maybe for your staff hub you could create Specific Switchboards? it is possible to use a login form to send the person to the switchboard. as...

Kimmi You need to create a comment table that's basically a calander. Attach it to the emloyee ID, create a query with the employee ID as the criteria. You should be able to create a drop down on your page/form that's can access comments sorted ascending by date. You could go a step farther and...