Search results

Honestly, I want to know how to write with ADO Object code with vba. usually I use the code example in vb6: ... .lockType= ..... .open "select * from ..... where noregister = ' " & blablabla & "' and code_machine = '" & blabla &"'",conn if not .EOF then msgbox_warning_will_be_show else...

Thank you very much... I have saw the program and there need to setting up in primary key by you setting and code, and this is very nice. But if we want to write full code in vba without setting as like you do before, how to do with code?

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

yes right..i think so.. cause it might unsuccessfull for making DLOOKUP Wizard

the thread http://www.access-programmers.co.uk/forums/showthread.php?t=237757 it's continue what i faced but there i make screenshoot. please..

no no.. database on my laptop is not involved with databse my PC. i create a new database and make 2 table and DLookup wizard on my pc, the issue i was faced,It came from my pc. in my laptop, no problem when i make DLOOKUP wizard. it's always make me driving grazy :banghead:

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

first remember what your password to encrypt your database.

thank you very much what are your answer... for that sure and Im sure, nothing open parent table or form when i make this field. for case this, I usually make same a step for making DLOOKUP wizard on my laptop and nothing problem I found. when i transferred my file to my pc, and make again this...

I cant understand anything to change it. I only know make it what i learn.. please help me, i have read this site but not clear no solved before i ask here.:banghead:

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

hi friends, that's made me confuse because i have check all but no problem. okay, actually, when i wrote the code in vba access with control Combo33_AfterUpdate() the error message in vba access, to show "mmmm-yyyy" in format, and then i had replace with 'mmmm-yyyy', after that when i ran...

thank you for supporting but here i was found error in month1. on datasheet month1 coloumn,display like #name?.. but for another data could be view be well.:(

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