Recent content by bnefit

Examples of the asset number? AST001234, AST000089, etc. So 1) If the user did not enter "AST" but only enter 6 numbers, I would like the textbox to add "AST" in front of the numbers to result in format "AST000000" 2) If the user did not enter "AST" and only enter 4 numbers, I would like the...

I have a textbox for user to enter the asset number which consists of "AST" follow by 6 numbers. Can I customise the format of the textbox to align with our asset number and if yes, how can I do it? Thanks :)

Hi all. thanks for your help. With my limited knowledge, I was unable to progress with subform as per all your suggestions to achieve the desired outcome. Hence, I have reverted back to writing lots of If..else statements in frmEquip to achieve what I want. It may be arduous but at least I...

2. This is a new terminology to me....I need to look up some examples..... 3. Ok..I will try. cboLoc is located in the Form Header while the subform is in the Details. If I want to use cboLoc in the conditional formatting, will I need to express it as ([Forms!frmEquip!cboLoc]) or just simply...

I finally figured how to get the combo box to work. What was missing was the Control Source. I just need to add the field "Inspected" into the Control Source.

Made some progress but it seems like I have more questions than before :confused: 1) I have "Inspected" field in tblEquip and the format is "Yes/No". I added the "Inspected" field in the subform via "Add Existing Fields". However, I can only insert it either as Check Box, Toggle Button or...

Taking the advice of all, I have now use a continuous subform (I hope it is a continuous subform). When cboLoc is changed, Item and Test Dates will be updated accordingly. Is it possible to disable the Test Date for a particular item so that the user is unable to modify/change the date? I...

I thought about using a listbox but I'm not sure if it suits my needs. Once the items are displayed in individual textboxes, I want to select Yes/No for the inspection as shown in the photo below. Hence, I thought it will be neater to do it in textbox. Anyway, I have written the following...

Hi, I am wondering if this could be done. I have created a tblEquip, qryEquip and frmEquip. When cboLoc is selected, all the items belong to that Location will be populated in cboItem. However, I would like to make the number of textboxes visible depending on the number of items in cboItem and...

I've managed to get the coding to work. Thanks for all the help. :)

I did Google and tried all the examples that I found but it is still not working... Me.txtNewTag & " ,Notes = '" & Me.cboNotes.Values & "' " & _ Me.txtNewTag & " ,Notes = '" & Me.cboNotes.Text & "' " & _ Me.txtNewTag & " ,Notes = '" & Me.cboNotes.Column(1) & "' " & _ But none of these...

No...YOU ARE!!! ;) I hope you don't mind me asking a few more questions as I am trying to improve my Access skills. I want Notes to be updated from a Combo Box selection instead of text so I have tried the following codes but it is not updating. There's no error when I run it, just not...

Thanks for the tip! It's working now!!! :D Private Sub cmdSave_Click() If IsNull(Me.txtNewDate) = False And IsNull(Me.txtNewTag) = False And IsNull(Me.txtNewNotes) = False Then Currentdb.Execute "Update tblTestTag " & _ "Set TestDate = #" & Format(Me.txtNewDate,"mm\/dd\/yyyy") & "# ,TagNo =...

tblTestTag (just a screenshot of the entire Table. There are many more records in the table.) After inspection of any Item, I would like to update tblTestTag with the new TagNo, TestDate and Notes. In this instance, I want to inspect Troubleshoot Light from HIGHVOLT RTS. Using...

Hi arnelgp TestDate has always been set as Date/Time in all of my Tables and Queries. txtCurrentDate and txtNewDate in frmTestTagUpdate are also set as "Short Date" format in Properties. As you suggested, all the fields in the SQL can be found in tblTestTag but the error still exist.