Search results for query: *

PHV - part of my problem may be that the recordSource for my form is qryResults which gets info from a number of related tables, including the coding. Then I try to write the Coding that is used in the form to a table called tblResults. tblResults is one of the related tables in the Record...

Thank you PHV - both the ControlSource and the label are called Coding. Could this be the problem?

I've recently returned to work from sick leave and think that my brain is still off. I have a form that has a field called Coding. Users select the "Leader" and the Coding gets displayed on the form. My problem comes when I try to update tblResults. The Coding field is blank. When I close...

I have a few links to rooms on a 10 page floorplan that disappear. Once they disappear I cannot find them. I know that they exist because I do a search by room no. when I publish to web page. When I click on the Room name in the left panel, the arrow goes to the correct room on the floor...

Unfortunately I don't have access to autocad to create an example. I also don't have the autocad skills to do it. Our autocad floorplans are developed by a contractor and made available to us. I will look under other shapes and see if I can find the room nos.

Thank you for your suggestion. I will give it a try today. Elaine

I'm new to Autocad and Visio. I have been saving an Autocad 2004 floorplan as a dwg or dwf file and then opening it with Visio 2007. My problem is when the file is imported in Visio the room nos. associated with the spaces is lost. Is there any way for me to retain the space information when...

Thanks jges - last_PM is formatted as a number field. I currently have next_PM_due as a text field - it has been both a text field and a number field during my attempts to solve the problem.

Thank you MajP. I have tried using =Sum((last_PM)=5000) in a query and on my form without success. Obviously it has to do with my syntax but I haven't been able to find the answer to my problem. Any further suggestions? Thanks

Good morning, Sorry for posting in both tables and forms, but I think that this is a basic question that I should know the answer to, but can't get it to work. I have a field in my vehicle table called Preventative Maintenance that holds the mileage that the last PM was completed. Now I...

Good morning, I'm working on a fleet database that requires a Preventative Maintenance flag to appear when users are signing out a vehicle so that users know when the next PM is scheduled for, we use mileage rather than dates. Not sure that I'm going about it properly. I have a field called...

I have since found a suggestion to save as jpg. The floorplan is now visible but my left navigation is gone. For what I'm asked to accomplish that is one of the important features that we need.

I have created a visio floor plan. When I publish it to html and look at the web page from a local network drive it looks fine. When I publish to an apache server and look at the page from my intranet website the page appears blank. Does anyone know the solution to this problem?

I have an Oracle 8i database into which I have uploaded images as a blob file. I'm having difficulty downloading the images, one appears as a dump of the table and the other in binary format. Any suggestions on how I go about fixing this problem? Thanks

Thank you for your help. It works perfectly.

I have a fleet db that I'm making changes to. We plan to start charging a sliding rate for each type of vehicle (cars, trucks and vans). I have a report that displays the distance travelled x the rate for that type of vehicle. My problems is that I'm unable to provide a sum of the calculated...

I have a database that manages our fleet of vehicles. This year I am trying to add a new feature. The ability to assign different coding to various sign outs of vehicles. Users select the vehicle that they wish to use, then select their name from the list of users. As they make each of these...

I have a vehicles database. I have a text box that calculates the kms travelled. =Sum([KMs_Travelled])and in a later box I calculate the cost using an ever changing mileage rate. This has been working correctly for some time. Now I have some vehicles that will be charged by a daily rate and...

Thank you for your help.

Thank you for looking at my problem. I have a form that allows users to edit an item in an inventory system. The Checkbox is a problem - users can change turn off enabled without a problem. when enabled is turned on - it fails. No error message is displayed.