Search results

Hello, I would like to create a field that autoincrements everytime the form is opened. It must be based with 3 letters KTN- 2 digits from month,- last 2 from year and then 5 fields for counter 00001, 00002 like -- KTN-0609-00001 KTN-0609-00002 KTN-0609-00003 KTN-0609-00004 KTN-0609-00005 So...

Hello there.. Is there a VBA for on click modifying all the filtered data in a subform ? Me!Variable = False --- ( Alll the variables filtered in subform convert them to false? ). Thanks in advance.

Hey, I found how.. Private Sub Command1_Click() If Me!subform2.Form!chkbox = True Then Me!subform2.Form!Number = "777" Me!subform2.Form!chkbox2 = True End If End Sub Just how can I make a repeat form, cause it only put the data to the first line and it wont continue...

Hello there.. Is it possible to send values from a button on a form to a subform data? For example, If I mark data from a checkbox inside the subform, then I click on button on the form.. it will check for True values on checkboxes I just marked, if it is true, then it will write a number from a...

Dang.. ill make it up to fix it, do you have Yahoo Messenger or MSN messenger?.. would really appreciatte dedicated help, I can pay via paypal ..

still breaking my head to figure out something friendly and intuitive.

Thanks for the help SOS and Husky.. I used the following code on each button I have on the form, unless the saving button. If Me.Dirty Then MsgBox "Changed not made, please click on save button before browsing.", vbExclamation, "buhorus: change not made." Me.Undo End If...

This is what Im trying to do.. http://img188.imageshack.us/img188/2599/salidasform.jpg That way I can add shipments into the number of the shipment.. But I just want to click the items so they add automatically with the shipment number on the textfield and automark ON, that would move it to the...

I already read that, still dont know what to do, sorry Im newbie in VBA.. Just need to uncheck the chkbox when I click on the whole line :S And erase the column value from data

Hello there, Im trying to apply vba into data on the subform, for example Private Sub subform_Click() Me.chkbox.Value = 0 Me.data.Value = "" Me.Refresh Subform2.Refresh End Sub I dont know it wont work.. It is for creating an automatic adder from subform to form, checking and adding data...

Is there a way to block just some columns inside query for no writing? I got 5 columns, just want to be able to modify 2, and block the other 3. Is this possible?

Hello.. let me explain.. I got a table with all the products I got in stock in a warehouse. I would like to create a form with 2 subforms and search fields (I know how to filter search fields on the first subform). Then when I have a new shipment Ill open that form to search for the products...

Ok created what you said before, I made a declaration for blnsave Then I entered the code in the save button. But this last code before update I got it like this. Private Sub Entradas_beforeupdate() If Len(Me.Lote & "") = 0 Then Cancel = True If MsgBox("You have not filled in LOTE." &...

How I check my fields therE? Which would be the code? Thanks for fast response SOS

Mr. B I realy Like you're Idea on the OK button.. Id better put the required fields then enable the save button. But I have to make sure that it automatically do not save the data on the database.. thats Me.Dirty command right? Can you provide the VBA code please?

Hello there.. I just the next code for required fields in a form for entry data. Private Sub Textbox_BeforeUpdate(Cancel As Integer) If IsNull(Me![Textbox]) Then MsgBox "Its obligatory that you type something in this field.", vbInformation, "obligatory." Cancel = True End...

Hello there.. I have a database of a warehouse, I got lots of tables nested into the BASE table that keeps all the records from the received and delivered materials. I got a Yes/No button that shows if the material is IN or OUT the warehouse. I would like to create a form where you can find IN...

SO how can I add a function on the form that doesnt saves the record until I click on saverecord button, and If I was addding a new record but decided to close the form and not clicked the saverecord button, then it displays a message that it doesnt saved, that if i would like to proceed. Is...

Hello.. I got a Form that introduces info into a table.. When I edit (Me.field.Enabled = True ) is on. Then I change info but I do not click on saverecord button, it stills saves the info, the same with the new records. How can I make it obligatory to click on save button to be able to modify...

In case there are duplicated fields and I create a None duplicated field on table, how can I add an error message when it detects a duplicated entry? How can I add another error message with a data is not typed on Data 1 or Data 2?. I added a click err.. ----------------------- rs.AddNew...