Search results

Greetings.. What I want to do is making operations with data inside the BASE table, Im gonna split weights. For example. If I got 1000 lbs of chocolate from the same lot, and I want to split it for sending 400 lbs to a client?, Is there a Way of duplicating the the entire field just making the...

And How it would be the error If user dont type MAYUS character?

Hello there, I used to have this code for generate fields from Data1 to Data2, like A001 to A005, it would generate A001, A002, A003, A004, A005. So it works with this code. Set db = CurrentDb Set rs = db.OpenRecordset("Almacenes") For x = Val(Right(Me!Data1, 3)) To Val(Right(Me!Data2, 3))...

Clever.. You saved my week.. Literally. Thank You ezfriend.

Forgot to mention I generate a Report via that filtered data.

Here I post the image.. that form displays the query based subform filtered by the document number, I marked all. Thanks in advance.

The subform filters all the data by an order number, while you are navigating by arrows when you reach other order number data, it will filter the data. I guess this cant be made by listbox right?

Hello there, is this possible? I got this query subform with the same fields that appear on the main form, what I want to to is when chosing the row of data in subform, make it display on the main form. Thanks

I got this code that generates data from a rank you asign on "Data 1" and "Data 2" fields, it works great except I dont how how to display an error message if you dont put the same letter on Data 2 that Data 1 and viceversa.. and if you use Minus. -------------------------------- Private Sub...

Thanks alot for your kind help ezfriend. Is it possible that you could make an example file?.. if not dont worry Ill figure it out.. newbie in VBA

Hello.. I got a form with a click button, when I click it I want it to generate a number like "AAA0900001" the 09 number means the current year, and the 00001 number is the counter +1 When it generates, place it on a field on the new form. Thanks in advance.

Thats what Im talking about :D.. gemma-the-husky.. Will I be able to check all the filtered checkboxes from the query that points to table?, without checking the ones that are not filtered? Supposing my form is called "INDEX" and the Subform "Queryfiltersubform" that filters the data via the...

UPDATE Mysubform SET ColumnID=MyValue Is thatthe UPDAT E you are talking about right? Would that update all the filtered records on the subform?

Sorry for my Ignorance, would you provide me information about append query or update query in my case? Thanks in advance

Hello, I got this code for setting data into my filtered subform. --- Private Sub Command18_Click() Forms!SALIDAS!SALIDASpickingsubform.Form.SalidaAlmacen.Value = False Forms!SALIDAS!SALIDASpickingsubform.Form.EnAlmacen.Value = True...

I need to use the loop for chboxing multiple filtered records on subform.. Please.. How I use that code?

How would I use that?, on The button_Click() ??? Supposing my checkbox column is chkbox2 and my subform is "subfrm2" How would I do it? :S

So how should it be? Im confused. Suppose that I got this button called, "checkin". On click it then.. All the filtered data on subform in the field "Checkbox2" referring to that order will be marked as true.

It would be better if it wasnt used, then it stay still... I mean, if I dont save the record, then It would not generate on table, it would stay the same for the next time opened.

Id prefer the hidden table.. Well actually it doesnt have to be necesary hidden. But do you know what would be the VBA?