Search results

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

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

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

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 All, I find myself faced with a variation on the usage of Proper Case that I can't find any reference to in a search of this section of the forum using keyword vbProperCase. The closest I've found is this thread: Numeric-Alpha propercase problem I have a text field that I require to be in...

Hi all, I have a strange one for you. A few weeks ago I coded an app to extract attributes out of an AutoCAD drawing using VBA code running from MS Access. Initially I was surprised that it handled such a complex revision numbering system straight off the bat. I say complex, because there are...

I have a strange (well, it seems strange to me) query to try to write, and so far I'm not having any joy. What I think I need is a Query within a Query, but I may be going about this the wrong way. The following is an attemp to portray what I'm trying to do - I know it doesn't work, that's the...

Hi, I have a form that has recently started printing without any data in the fields. It uses the exact same code to print every time, in the form of an OnClick event containing "DoCmd.PrintOut" created by simply placing a Command Button on the form. I am at a complete loss as to why this...