Search results for query: *

I have a file that has been, for lack of a better word, butchered by various users. It appears the fonts for a large number of fields have been changed using the font setting(larger font size). When I try to apply text styles it only works on some of fields,(the ones that were hidden in the...

If you are talking about on your Gantt Chart just use the Gantt Chart Wizard and when asked choose not to show link lines...the tasks still move but the lines don't show on the chart.

Thank You!

I need to rearrange the columns in a project file automatically when the file is opened. Users insert, move and hide columns in the file depending on the info they need to see/update so when the next person opens the file it may have any number of columns showing in any order. The majority of...

Thanks to all...I was offline for awhile...our company was taken over by a much larger company and we had a little trouble transferring resources. I ended up doing it the microsoft way and used formatting and properties to hide the totals on the subform. I later tried PHV's solution and it...

I was wrong and right...Remember I said I was working with a continuous form, not a datasheet; I was right that the total does show but only after the last record and I can size and hide it so the text box does not show on the main form. The problem I have now is trying to get the thing to...

That's how I would do it normally but since the sub form is a continuous form and not a datasheet the subform total field will show after every record.

I found instuctions for this if the sub form is a datasheet but the sub form I'm working with is a continuous form. The main form loads based on the input of a login form and shows employee info. The sub form is a timesheet showing each project as a row with fields for each day and is summed at...

My boss wants to be able to get a late finish schedule that works backward from the deadline date rather than the project finish date. This is the only way I have found to get Project to calculate the results he wants to see but I just didn't have the expertise to put it into a single module...

You're my hero!!! Need another constraint change. I also need any task with a desdline to change from ASAP to FNET before recording the revised Late Finish Date. Is this possible?

Would it be possible to Change the constaint to ALAP then have the new late finish saved in a date column then change the constraint back to ASAP? I can Change the constraint with --- Sub MakeALAP() Dim T As Task For Each T In ActiveProject.Tasks If T.Summary = False Then If...

I need to display a result that is similar to the "Late Finish Date" and can get it by using the "As Late As Possible" constraint and the late finish date column...the problem is that I need to keep the rest of the information as calculated with the "As Soon As Possible" constraint. I hoped I...

I need to create a formula/macro to display finish dates in a column for a project using the "As Late As Possible" constraint while keeping the "As soon As Possible" constraint on the task. Can anyone help?

Got another question....I have a main form and a search form that opens using a cmd button. When I created the database the form opened on top of the data entry form, since I added code to hide(minimize) the Access workspace/window the search form opens behind the data entry form...what can I...

I have a combo box on my form that shows the class type, now my boss wants the "Type Description" to show, but only when the user clicks the drop down arrow. The types are generally two characters but most of the descriptions are very lengthy. Is there some code that will enlarge the combo box...

Thanks Remou...glad you added the annoying tip...after opening the db a few times I decided to remove it although it worked great. It's one of those "You have to be careful what you wish for" things..not always what you expect!

I used some info from this site to have the MS Access window to minimize when my database opens showing only the forms on the desktop. The only problem is that unless I maximize the screen other apps show on the desktop. Is there a way to minimize all other windows automatically when I open my...

I've already created about 30 reports and each time I create one someone askes for the same info only sorted differently, without some fields etc, add some fields, only data for one site, etc... Thus the interest. Maybe outputting to exel is the best idea in this case...Thanks bunches for your...

That's exactly the dilema ...How do I create a report that will show the fields requested by the user and then direct access to use the sql statment created. Is there another way to create "Reports on the Fly"?

I've been stuck on this one for awhile and still can't find the answer...(I'm not skilled enough to figure it out myself!). I want to create Access reports from the queries generated by the "applet" mentioned in Thread...