Search results

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

I have a medical Dispatch system that I can send to you if it would help. The system tracks the drivers, their status, time in time out, their qualifications, Vehicles and Maintenance, Passengers, and all sort of statistical data in reports for grant justifications. Just let me know.

I have two databases I created for my office. One tracks vehicle statistics and maintenance. The other tracks customer usage for medical appointments with the VA. I have been updating the system because the customers move quite a bit. I split the contact table in 2 one containing the customer...

Names Joe I have worked with basic access for years since my time in the Army. Needs were easier back then but lately I am feeling like an idiot and came here hoping for some help. I have read many access 2007 and 2010 books, even own a few classics from the 90's. Currently I am working on a...