Search results

Hello all, I'm trying to database clothing process. From material purchasing to clothing sales. But now i'm in doubt how to create table structure for the Product. Each product will have six different size : S, M, L, XL, XLL, and CuS. if you have Product A, it will have these six size, say AS...

Hello, I have shortcut menu that show on right click event...Is there anyway to change, so that the menu appear on mouse move? I'm using Access 2007..and how to set up it on the subform control like textbox? Thanks

Hello, I've some question about form validation.., hope you can help me. I have form which contain a subform. Main form bound to tbl_Product and subform bound to tbl_Componen_Product. I need to create product number (part number) base on some textbox value from main form and subform..To do...

Hello, I try to use this code : dim ctlc as control For Each ctlc In Me.Controls If Not ctlc.Name = "txt_Id_Barang" Then If ctlc.ControlType = acTextBox Then ctlc.Value = ctlc.OldValue End If End If Next ctlc But i...

I have four table: tblTempRunningCash Field are : Date, CashBalance tblTempRunningInvValue Field: Date, InvBalance tblTemRunningReceivable Field: Date, RecBalance tblTempRunningPayable Filed: Date, PayBalance My objective is : I want to display from those table in a report or form a report...

i tried the following code to update a field in a table, table name is Perpindahan Aset. Private Sub cmdUpdate_Click() Dim rs As ADODB.Recordset If Not IsNull(Me!txtIDAset) Then Set rs = New ADODB.Recordset rs.Open "SELECT*FROM [Perpindahan Aset] WHERE [ID Aset]=" & Me!txtIDAset, _...

Can we use ADO in VBA for access 2007? Cozz when i declare variable for connection such as: dim curconn as New ADODB.Connection, run it i got message error: " User define type not defined" I need to use ADO object to manipulate my Access aplication help me pls.. sory i have solved it, :D, but...

Say, i have tabel or query : Asset ID, User ID, Movemen Date, Document Number. I want to print or preview a report for a given value of User ID. what's the simplest way to do that? Thanks..

I create autonumber as primary key in a table, then i tried to enter a record in that table. Then i deleted it, but when i enter a new record, auto number started with the next number. Ex: i enter a record and autonumber for it is 1. I deleted this record and entered a new record, but i found...