Search results

First of all why are you storing redundant data? Two tables should not have the same information in them, that is what relationships and primary keys are for. Anyway, off my database normalization horse and to answer your question. I will give you my way of doing it, although I am sure there...

It sounds like you have your rowsource from a query? If so you are selecting both the employee name and the employee ID. If this is the case, under properties set your bound columns to 1. If that doesn't help, you need to tell us what your record source is and what your control source is. (Both...

It's me again, I don't understand what I am doing wrong, once again my code isn't working. Here is the newest version: Private Sub Form_Current() If IsNull(Me!FPGACheckSum) Then Me![Me!FPGACheckSum].Visible = False ElseIf IsNull(Me!GPHLCheckSum) Then Me![Me!GPHLCheckSum].Visible = False ElseIf...

Hi me again, I tried to set them to not visible, this is the code I used. (It didn't work) Private Sub Form_Current() If Me.FPGACheckSum = Null Then Me.FPGACheckSum.Visible = False If Me.GPHLCheckSum = Null Then Me.GPHLCheckSum.Visible = False If Me.PLDCheckSum = Null Then...

Hi all, I have a form which has five textboxes on it (as well as other info). I have 7 different types of circuit boards I am tracking, and they each have different combinations of programmable logic devices. I have five fields in my Board table, [FPGA, GPHL, PLD1, PLD2, PLD3]. Some of the...

Hello, Easy fix, I had this problem too. Go to design view for your form and look at the properties for your form. On the data tab, set "Data Entry" to no. This doesn't prevent you from entering new data, it just is saying this is not an exclusive data entry form. HTH Robert

Sol, Kind of. If you go to Tools -> Startup -> advanced, then press "disable Access special keys". This will prevent your users from hitting F-11. Unfortunatelly it prevents you from it also, so you have to keep a copy on your hard drive in case you ever need to make changes.

Sol, The easiest way I could see would be to add a AutoNumber column, then on your forms record source select all columns individually and sort descending on the Autonum column. HTH Robert

Hello all, I have two subforms on my main form. One subform has a check box on it, when the user checks it, I would like to open a msgbox asking if they are sure. (A append and delete query fire off at main form close). I would like the msgbox to open and then if they click yes to run my 2...