Recent content by Sess

I am trying to use the wizard on A2003 and I am completely lost on how to make the gantt chart. I think that is what it is called. Basically I need a horizontal bar graph that shows when people are due to start and finish in certain production sectors as a duty roster. Data set is: Person...

You need to put # around a date/time IIf ( [visitorlog]![createtime] => #07:00:00 AM# and <= #03:00:00 PM# , 1, 0)

Make a field in the query, put the data test into an IIF statement and make true = 1 false = 0 and sum the field.

I was going to suggect same as this except to put a union query for the query source and have " All Orders" as the default value of the combobox. I do this for things like looking for order details so here is my sample for the union query. SELECT " All Orders" as TempOrder FROM tblYOURTABLE...

Thank you. Again. I tried to add to your reputation but you helped me so many times that I can not boost your ego that way. I wish your workstation was right beside mine!

Thank you. Yes I do have a copy of the FE on each machine. So then if I have multiple users mining data from the BE it does not matter who is on first or second or whatever, it only matters who gets out last to trigger the compact. Right?

I could not find this in search but probably I did not search right. Anyway. I have been building an application with FE on each network station and BE on the server. On all of the FE copies I have the checkbox for Compact on close checked ON in Tools Options General. On the BE I have the...

Worked like a dream in the Detail section of the report - thank you!

I need to hide or unhide things on a report so I was going to set some fields to Visible = False and then turn them to visible if the criteria is met. I did this on a form in the OnLoad event and it works how I like it (hope that is the best place to put it). If Me.MACHMODCOV = "LINE A" Then...

Am I allowed to post "OOOPS" here and try to sneak away like no one noticed my dumbness? Thank you for all of your help and now I am looking at SOS's posts and I am thiking what or something and I notice his says FormHeader and mine says PageHeader and then I realise there is BOTH, one if for...

That was the full list I posted before Name Height Back Color Special Effect Tag On Click On Dbl Click On Mouse Down On Mouse Move On Mouse Up Now I am thinking it is one of those MicroSoft things just put in to confuse people and does nothing because you can not mouse over something that is not...

Thank you for your answers. I looked in properties and there is not much you can do with headers/footers. Name Height Back Color Special Effect Tag On Click On Dbl Click On Mouse Down On Mouse Move On Mouse Up Even if it is not an extensive list of things the events are suggesting that you can...

I am using Access2003 and I have a form with a header that I can see in Design view but on Form view it is not there. I am losing my mind on this and it probably is just a setting or something I am missing but one of those things that I can not seem to find. Thank you.

Thank you for the fast answer. I guess I have a lot more work to do on this one.

I need to know how to make the fonts larger on a MsgBox. I have some code in VB to warn the end user that input is needed prior to proceeding, that works how I need it to work. The customer has informed me that the font in the popup needs to be larger and more pronounced on the screen. I...