Search results

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

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

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

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

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 All, I have one case about validation in the form example: I have entry in table this mention below: No.Register | Code_machine ________________________ 001 | X01 002 | X01 001 | X02 003 | X02 003 | X01...

Dear All, I have faced one case now.honestly, I forgot my password to open my program in ms access 2010 once make all everything could not do more(meantime, I want to re build my program :(). I have more search program to unlocker my program but, all of them is trial and only 3 character have...

Dear all, Simple question from the link what i was given, how to insert data from query "view by datasheet" into a new table (view datasheet) http://img717.imageshack.us/img717/4932/newpicturebj.jpg before i had made the code that will load from event form LOAD in "form 1"...

here I have capture what is error actually when i make a DLOOKUP wizard. please see the box of wizard. there i want to make a relationship with table2. but we could see that table1 still show. yes right, it's reality making error and show message ""you can't modify the structure of table...

I don't know what I do,I searched in google but not found. my problem: when i make a LOOKUP wizard and all finished, warning message is show "you can't modify the structure of table, because it is already in use by another person or process" after i clicked ok, show message again "Microsoft...

Dear All, I have wrote in VBA access, and when i run combobox on this form, in Month1, i saw #name?, in datasheet. help me:banghead: Private Sub Combo33_AfterUpdate() [Form_Monthlyreportbydate].RecordSource = "PARAMETERS [forms].[Report Menu].[combo33] DateTime; " & _ "TRANSFORM...

good day master, honestly iam very2 new guys on learn ms. access. so can you be assistent me?:banghead: i have looked on google about what i want, like crosstab query in access and how to use it. now, i have question:confused: could i make the report automatic coloumns in access with a source...

good day master.. *maybe my question is not clear to understanding every body what i mean.. okay simple question who make driving me grazy. how to implementation crosstab to report? when field in crosstab added,what is the report will add field or only static report? if report only static, how...

name : A Huan skill : beginner level for Ms. Access Life : Libreville