Search results

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") was right about to suggest that Dim OutlookObject As Object but then i recalled a thread i engaged in erlier that the user had all sorts of bizercal problems with outlook object as well that were all solved by...

oh , if you need to just edit an excel than rather creating a whole new one to retain specific functions use the following code instead : Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Set objXL = CreateObject("Excel.Application") objXL.Visible = True Set xlWB =...

Private Sub Form_BeforeInsert(Cancel As Integer) Dim db As Database Dim rs As Recordset Dim i As Integer Set db = CurrentDb Set rs = db.OpenRecordset("SELECT Min(ApplicantId) As Expr1 FROM Applicant", DB_OPEN_DYNASET) If Not rs.EOF Then rs.MoveFirst i = CInt(rs.Fields("Expr1").Value) i = i -...

Re: Creating and managing DSN-less connections usually whenever we get to discuss MSysObject one of us is lost : * my point of view states that yes MSysObject stores connection string which reveals usernames and passwords to hole exploiters . ** however your point of view is no for the reason...

Interesting article (http://www.access-programmers.co.uk/forums/showthread.php?p=760764#post760764). a bunch of observations though: 1 - the following posted code : Set tdfCurrent = CurrentDb.CreateTableDef(NameForTableInAccess) tdfCurrent.Connect = MyConnectionString...

also do note that sending mails throughout objects might be categorized as "worm" like activity and is halted by some antiviruses , yet an antivirus should pop up a confirmation dialogue or a warning at least. you can check and see if avast warnings are disabled. still i would recommend the...

emails should be posted in same string.. use "name@domain.com;name2@domain.com" instead of multiple strings seperated by ; like you did

<<CustomUIXML is a varrible string containing your designd FUI aka ribbon chunk>>

ok this keeps poping up time and again so here goes one single answer to all : adobe acrobat is a format that was created mainly to secure texts from being ripped off and thus widly relied on as the primial choice when it comes to ebooks , heck acrobat is ebooks. the procedure to which acrobat...

try Forms!SubFormNameHere.requery

try to search all three forms for "bookmark" or "DoCmd.Gotorecord" You are trying to convince us that there is a problem with your access ? I highly suspect malcoding :S

i wouldnt suggest waiting till form close and applying all circus loops above mind you a form filter isnt exactly a query but just an additional where close to a query ;) now let me see how to work your problem in a way that is more calm. ah yes : in whichever event you change form filter add...

dispite that it was prtty diffcult to get along with wat you'r saying but i will try to assume, better than leaving you in a dazzle : 1 - Either you have the button not placed in details section of the form OR you have another event you set and cant figure where that moves your record selector...

yes exactly you will not need no button , it will just populate it the minute the record is to be saved. yet i dont get you, this code is working fine for me , what error messages does it produce ??

zaeed !? you substitute the between quotation section in the above code with real values ? hello ?

no i know of it (nope doesnt leave referances) yet its open sourced , so take a look at its source see if you can make yourself a custom build you can communicate with :)

DoCmd.SendObject acSendReport, "report2", acFormatHTML, "client mail here!", , , "subject here", "message body here"

mr danz013 , you are looking up email address in sales table by invoice number ?? are you saveing a client email by every sale ?

i would rather suggest that u create a new Autonumbered field (Indented field if you'r using sql server) which you assign as your primary key and quit relying on ApplicantId since it's shifting to irrelevance. however if you r realy obligued to achieve your -ve key quest then here goes: In...

your problem may come to that your table names were updated or changed during migration process , check that tblInput is still named tblInput (check for prefixes added such as "dbo_" , "sql" or database object owner name).