Search results

i believe that is possible. may be you should try with add new unbound textbox into your subform. write the code to get for qty level ..

Basicly you should place your insert data code in submit button click event. you could do it like this: if msgbox("Save data?", vbyesno)=vbyes then if me!Yourcheckbox1 then insertdata end if if me!youcheckbox2 then insertdata end if . . etc end if can you explain more about question 2?

That's happened to me too, don't know why. But you can try this: in the subform1 footer create new unbound textbox named txtTotQty with formula =sum([Qty]), set subform1.visible=false then in your main form set subtotal=subform1.Form!txtTotQty

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 assume you want to open the invoice in report view. Just delete the macro for this report in "onOpen" event.

i think u missed one ")" - bracket.. it should be : DateAdd("d",-Weekday([Day]+7),[Day])

Thanks for your respond... yes, i think so.. but i don't know which query i must use for this purpose. Maybe my explanation is insufficient. Sory, My english is bad :o. But i'll try to make it clear for you. I've create 4 temporary tables that stored running balance for cash, Inventory...

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...

It's been four years, then i have similiar but quite different case. Let say I need to show Ending Inventory Level vs Day in access pivot table like this: Ending Inventori Level 12/01/2009 x 12/02/2009 y . . ...

it is solved now. Thanks, i've searched the answer for a day :D, just to get that ..[ID Aset]='" & Me!txtIDAset & "'"...:o.. can you explain how is it work? what's the concept btw, so later i don't need to ask anymore. are there any variation for other data type?? thanks

sory it's solved a half :D. i try ..if not rs.eof..but last record won't change, how to update all record btw?

thanks it work :), but maybe some others problem, the code won't update anything in field [Lokasi Sekarang]. I tried to remove ...if rs.EOF ..then i found there a change but just for first record in rs. i want to update all the data in rs. i think i have to use other code, something like...

data type for [Id Aset] is string (text). yes, i have a prediction it is about data type because when i changed me!txtidaset with ""text in ID aset""" then it work. so how to write the code? sory i'm newbie in vba code..what's the syntax? thanks

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, _...

ohh so for current database, connection implicitly already exist?

Thanks, but i have the next question.. I tried this code in ACCESS 2007: Dim curconn As ADODB.Connection Dim rst As New ADODB.Recordset Dim curDb As Database Set curDb = CurrentDb Set curconn = New ADODB.Connection With curconn .Provider = "Microsoft.Jet.oledb.4.0" .ConnectionString =...

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...

The me![User ID] is a correct one, the thing i mean is when i click cmdPreview (I put the code in event cmdPreview_Click), Access ask me to enter a parameter (criteria), in this case an user id that i want to display in report. I want to choose a parameter from a combobox, or listbox, not...

Thanks thats really simple.. the problem is i have to enter (type) an user id for that. I've a lot of user so i can't remember it. Can i display them in a List Box first, choose one of them as a filter criteria, and display it in a report ? how can i do that? Thanks again..

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..