Search results

Hi Mick, Thanks for your swift response. I consider adding a field to my table: CapexTypeID_FK, which would refer to table CapexTypeT: CapexTypeID_PK, CapexType: small or BIG. To solve the issue incase I can't filter a and A using a query. B. Rgds, Siegfried

Dear Experts, Is it possible to do query basis lower or uppercaps of a field in a record? In our company a Capex is numbered with a letter but both small and upper exist: Capex number AEANT20a (for amount under 500 USD) Capex number AEANT20A (for amount above 500 USD) 20 being they year...

I changed my code as suggested but then the count isn't working anymore in [txtCharsUsed] unbound text box? In my original code, when I try to type into the notes field [InfoNotes] a text box, it jumps to the cboUserStatus eacht time. The code to enter 0 is from the original code, at first it...

Hi Colin, Thanks again for the swift response and for your help. I'm using two buttons because I once saw this in an old database example. So I was trying to go with this approach but then encountered the button load delay when opening the form. Which code can I use to change the command button...

Thanks everyone, learned something now

Dear experts, I have placed on my main menu form command buttons with an picture to access forms/reports. The picture in the button is gray by default, I created the same button with a orange button and set it hidden Underneath the command button I put a textbox with label. The label gives the...

Hi, thanks for your swift response and help. I created those table to avoid double data entry in the names? If I have 3 employees having both the first name Marc, then I'm entering that info three times in the database not? Shouldn't that be avoided? Perhaps I'm approaching that wrongly? I'm...

Dear Experts, I need your advice on a Foreign Key issue, let me explain with an example. I have set up the following 3 tables: EmployeeT EmployeeID PK 1 FirstNameID FK Ward MiddleNameID FK LastNameID FK Peters PreferredNameID FK...

Solved, picture attached.:):):)

Colin, Adam, Thanks for your help. Conditional formatting did the truck. Best regards, Siegfried

dbse uploaded.

attached the database

Hi, Thanks for your response and help. I'll upload a sample later toady. Best regard,

Dear Experts, I have a set focus issue on my form ADUserF when creating a new record!? The form has a text box InfoNotes, set to field size 255. I've added an unbound text box textCharsUsed to display the remaining characters available when typing in comment in the InfoNotes field I have...

Dear experts, Appreciate if you could help me with the following issue I'm stuck with. I have a continuous form EmployeeDashboardF. On the form I would like to display a label with a colored dot basis the content of the text box EmployeeStatus. I have following 4 labels: show lblblack if...

I figured it out, thank to your remark on the default values. They were incorrect, now all working. Thanks a lot!!!

Hi June, Thanks again for your interest in my post/question. I have uploaded a picture, you will understand when you see. This is what I get after pressing my New button for adding a new record.

I got on more last question. When I select for a new record in form only one Option Group show a button and the right color, my other 3 Option Groups don't show buttons and all have color red value false? How can I fix that? Thanks.

Thanks, overlooked that. I'm almost there, but when I close the form the colors go back to default transparant, how can I make that it stays green when yes and red when no? Private Sub Frame28_AfterUpdate() With Me.Frame28 .BackStyle = 1 .BackColor = vbGreen If .Value = -1 Then .BackColor =...

I got confused. I entered the code as you showed, I can toggle the buttons but no color, option group background stays transparent? Private Sub Frame28_AfterUpdate() With Me.Frame28 .BackColor = vbWhite If .Value = 1 Then .BackColor = vbGreen Else .BackColor = vbRed End If End With End Sub