Search results

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

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

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

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.

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

I have hard to please customer so I just need to know if there is a shortcut or some way to adjust the font in all of the textboxes on a form without adjusting their corresponding labels. And also adjust all of the labels without adjusting the corresponding text boxes. Right now I am using...

I am using Access2003. I want to make a little pop up message to inform the end user if the current data is missing an element they should be updating. So I want to place this If Nz(Me.BoMDate, " ") = " " Then MsgBox "This item needs a Bill of Material", vbOKOnyl, "Company Name LTD" End If...

In Access2003, in the property of a form on the Record Type there is a choice of Dynaset, Snapshot and Dynaset (Inconsistent Updates). I understand the Dynaset you can update, Snapshot you can not, but what is with the "Inconsistent Updates"? Thank you.

I am building a database with some parameters based on observed performance and I am wondering which is more efficient way to store the parameters. Allowing a user to select Poor - Fair - Good - VeryGood - Excellent would it be good practice to store the information numerically as 1 2 3 4 5...

I have a continuous form that opens with a summary of information and I have placed a control on it which opens up a continuous form which shows a 'detail' of the information. On the detail form I want to be able to run an SQL to update some of the information in the data and then requery BOTH...

I tried to search this but all the answers seemed to lead to people making a form fit different size screens and being centered, actually all I want to do is to have my forms open up in the top left corner of the screen. Hopefully this is just a setting to either find the top left or something...

I have tried to search this out but have found conflicting suggestions and still have not found a solution. I have a form with two fields, one a ComboBox and the other a text box, both are unbound and two controls, one is to close the form the other is to close the application . On entering...

I searched and did not find an answer so maybe this is something newish. I have a textbox on a printed report made from contatenating some fields and what I want to do within the textbox is to have just a portion of the text print bold if it matches a certain condition. Can I have the...

Someone mentioned to me that the speed pf a big query will be improved if I include the primary key index field in the query. Just I am wondering if any of the people that program lots know if this is right. Thank you.

I have a Combo Box on a unbound form that has its RowSource populated based on what is typed in a text box. The end user would be entering in a text and then select an item from the Combo Box which would populate other fields from other fields brought in to the columns of the Combo Box. The...