Search results

Thankyou! Of course it's obvious now that you've pointed it out. What you've suggested has actually allowed me to completely do away with the snippet of code that I posted in my first post, as all I really needed to do was to swap 'GetObject' for 'CreateObject' in my mailer module - a one...

I have some simple code that checks for the presence of Outlook, and if it's not already running then it launches it. Problem is that it then won't return to Access and continue execution of the code unless I manually return focus to either the VBA editor or Access itself, then it continues on...

Try loading this code in a module: Function IsLoadedRPT(ByVal strReportName As String) As Boolean ' Returns True if the specified Report is open. Const conObjStateClosed = 0 If SysCmd(acSysCmdGetObjectState, acReport, strReportName) <> conObjStateClosed Then IsLoadedRPT =...

You've assumed that I'm going back and correcting them, (which I guess is a reasonable assumption, considering that you don't have the background knowledge of how our system functions), and you've also assumed that the situation I have described is a problem. It's not, it is by design. At this...

Thanks very much for the query, that was precisely what I needed in order to progress further. I had started to look at 'Not In' after I posted this, but hadn't gotten it to work yet as I posted late Friday and just got back to it now. I knew there had to be an easier wayt to solve the problem...

I have a table that contains records of drawings called 'tblDWGIndexMain'. Each record has drawing number field 'DWG' and project number field 'ProjectNumber' neither of these fields is unique, as a ProjectNumber can affect multiple drawings. The best way I could think to explain this is in a...

Agreed - prevention is better than cure. I think I've prevented any future duplications with code. Records are already indexed, so they aren't true identical records, but the data in the record has been duplicated in the past in some cases. I like that solution - I can work with that by...

Hi All, I'm trying to create a function to delete records from a table. I've done everything I can think of to prevent these records from being created in the first place, (short of multiple "Are you sure?" and "Have you checked xxxxx?" type message boxes, which just frustrate the users) but...

Does anyone have any idea why these two queries would return the same recordset bar the addition of 'txtStatus' to the second query (that part is obvious, they're meant to), but when the record data is changed via another form (launched from a button on the 'results' form) the form populated by...

Beware the typo's in the code in the thread you link to if you are going to copy & paste, namely "Dim db As DAO.Datebase" and "Dim rs As DAO.Recordet" - both of which will throw errors. It was not identified in that thread, but they were at least part of the OP's problems.

I know, but it's called 'force of habit', and it does no harm. I agree entirely - unfortunately, it doesn't. :( I've already tried the suggestion that you give, but with no luck. I've also tried setting the value of the field to a zero length string, but to no avail. I've just now come...

Yes, I've used it exactly as you suggested... Private Sub txtDateTo_BeforeUpdate(Cancel As Integer) If Me.txtDateTo.Value < Me.txtDateFrom.Value Then Cancel = True Me.txtDateTo.Undo MsgBox "A date range must END later than it BEGINS!", vbCritical Else End If...

Bob, I'm using the code you've given above to check that the TO date is later than the FROM date, and it works fine but I'd like to empty the field and then return focus to it so the user can either enter an acceptable date, or no date at all. At the moment it returns and highlights the...

Thank you so much for this solution! :) That problem has been bugging me for years!!! :mad:

So it's not viable for you to force the DB to run as runtime? If not, why not?

OK, I'm still a little confused. (Thanks for your help, though, I'm learning a huge amount this week!) I followed your instructions in the above post and got to this: Key Name: HKEY_CLASSES_ROOT\TypeLib\{E072BCE4-9027-4F86-BAE2-EF119FD0A0D3}\1.0\409\win32 Data: C:\Program Files\Common...

Which version of AutoCAD do you have? Mine (2010) is very light on for VBA examples using AcDbBlockReference. (Plenty with AcadBlockReference though.) After your pointing me in the right direction, I managed to figure it out by trying it with "AcadBlockReference" and seeing that it wasn't...

Close! So very, very close!!! If objEnt.EntityName = "AcDbBlockReference" Then This does the trick! Thankyou VERY MUCH!!! :D:D:D I've been struggling with this for DAYS - it's almost embarassing to see that such a small change was all that was holding me up. I must ask - How did you know...

Hi, I'm really hoping somebody can help with this.... I have an Access database that contains code to extract information from AutoCAD and populate the database fields with it. Currently I have the 'acax18enu.tlb' AutoCAD 2010 type library referenced in the VBA project, but this causes a...

Hi, You wouldn't happen to also be known as BrenBren on the AUGI forums, would you? If so then your post have helped me out numerous times! :-D Jonno_G (aka jguest on AUGI)