Search results

Thank you very much Mr. Stoper Very helping

Dear All, How to create the code for recording data/edit from form datasheet using vba code. all of textbox is unbound. Thanks a lot

So please amend what you think to correct this code..

yes.. I have re code again like your suggest.. Like this after I modified and show error again in other line.. 'begin Option Compare Database Option Explicit Dim db As Database --------cut code Private Sub show() Dim at As Variant Dim bb As Variant Dim url As String Dim bc As Variant Dim...

You can repair this code, please? Honestly, for VBA Coding, I'm new. thanks

I ever change this code using redim or dim example dim x () as integer I always face error.. so my question is, what there different on vba rule if I use office 2010 why i say like that? because I use this code in my old machine and office 2003 have installed, and there nothing found error...

So with this code above, how to fix it my friend?

Sorry.. I will amend my post...

Dear All, What the Variant value on Ms Access latest version is same with Ms Access previously(97,2003).? Im using office 2010 I have face error again in line ----------------------------------------- bd = "" bd = Split(bx(1), " ") For i = 0 To (UBound(bd) - 1) Me("p" & i).Caption = bd(i)...

Solved(Re: Code Error when load data from server) Dear CJ_London, Thank you so much that your suggest...yes, you're right..but previously code I have declare is rbs as Recordset code function is here: ----------------------------------------------------------------- Function hp_tb(n_tb) Dim...

Dear All, I faced something error that my self don't know how to fix it.:banghead: Im using ms access 2010 and this program compatible with previously ms access. the error show is type mismatch (error 13) on ---------------------------- Set rbs = CurrentDb.OpenRecordset("SELECT...

thanks your reply honestly, I added this script on form_load. this code : Sub runFormAll() Dim con As ADODB.Connection Dim recSet As ADODB.Recordset Dim strFrmNm As String Dim strcon As String Set recSet = New ADODB.Recordset recSet.CursorType =...

Dear Friend.. I faced this error : Run-time error '-2147467259(80004005) The database has been placed in a state by user 'Admin' on machine "topleveldomain' that prevents it from being opened or locked. in vba code : I write such as : con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data...

Dear All, I have build database from mysql as server online and ms access as front end. next, for connecting to database, I have used get data link external via ODBC connector and load all table. When I want to submit some data, connecting still on and nothing effect. but I leave my laptop for...

[Solved]Query make me crazy Dear All, What I do in facing the problem, finally is solved. I just remove written "format" in SQL format (Format([Time1],"dd/mm/yyyy")) :D to WHERE ((([Time1]) >=[forms].[printDataLogin].[txtstartDate] And...

write "#" ? where I will write ?. I make code in SQL design in ms access, so I think I needn't "#", Except there I will write direct the date value.. as like #01/01/2014# and #01/01/2015#. and we know, there code or each of value will be submit from txtstartDate and txtendDate(be half of...

SELECT ActivityLogs.NameForm, ActivityLogs.NameUser, ActivityLogs.Time1 FROM ActivityLogs WHERE (((Format([Time1],"dd/mm/yyyy"))>=[forms].[printDataLogin].[txtstartDate] And (Format([Time1],"dd/mm/yyyy"))<=[forms].[printdatalogin].[txtenddate])) GROUP BY ActivityLogs.NameForm...

Good Day for you, Sir Have you ever experienced the strangeness of that query with "multiple criteria" in the ms access 2013 or 2010 can not show the result as well(blank datasheet)? please help me.:banghead: noticed: The first :Result of query previously, could be run and show the result in...

Dear my friend SELECT ActivityLogs.NameForm, ActivityLogs.NameUser, ActivityLogs.Time1 FROM ActivityLogs WHERE (((Format([Time1],"dd/mm/yyyy"))>=[forms].[printDataLogin].[txtstartDate] And (Format([Time1],"dd/mm/yyyy"))<=[forms].[printdatalogin].[txtenddate])) GROUP BY...

Dear JHB, Thank you so much... the code very nice..simple and ....(i dont know how to thank to you) :) Now, I already know how to use that the DLookup function or DAO programming, It could be write two condition or more may be. Thank you so much...:) Happy weekend