Search results

This is an interesting question. I don't have a solution for you, but my initial thought is that you could write a timeout function to start a timer and then kill the database when the timer reaches a certain value using a simple docmd.quit instruction. The trick would be to write a line of...

There are many utilities (commercial and free) that crack MS Access passwords. Generally speaking, I highly recommend performing a Google search for [insert technology name] plus "crack" before attempting to use any kind of technology. Though I have had mixed success when trying, you can...

I suspect you are passing the data extracted from the combo box as a string value, not a date value. As such you will probably need to wrap the value in pound/hash characters (a/k/a chr(35)) to get the code to process. Any test to evaluate whether a string is less than a date will return a...

The simplest way of referencing a control on a subform is to open a query in design view, then click on the EXPRESSION BUILDER and browse out to the form ==> subform ==> and control. Good syntax will be written for you and you can copy/paste it into yoru code. Once you have done this a few times...

Perhaps I'm missing something...are you refreshign the parent form or the child form/subform. If you want the child form to requery and your code only tells the parent form to requery, then only the parent form will requery. If all else fails, you could reopen the child form/subform and make...

any tips on how to define a recordset using a pass through query?

Michael, Why would the query optimizer allow the SQL statement to be run from a query created at design time (QUERIES ==> NEW QUERY ==> ==> SQL VIEW), but not when the SQL statement is run from within a VBA module? I'm still a little confused.

Thanks for the response. I fear I may have mistitled this post. I'm not using an Oracle stored procedure and did not create a pass through query. I create a dynamic SQL statement and then execute it. Here are my code snippets: Form module declarations Option Compare Database Option Explicit...

As an aside, you might also want to check the values in the table that populate your result set. Remember that it is possible to receive null values. Performing any kind of comparator operation against a null can generate Type Mismatch errors. It is always good practice to add a few lines...

I have a block of VBA code that provides search functionality within an MS Access 2000 database. The end user needs to query a linked Oracle data table that I cannot access. I was able to create link to the Oracle 11g table, then copy the table structure and data to a local MS Access table for...

UPDATE: I changed table field data type to a number again, saved, then back to a text and the problem appears to have gone away....I have no idea why this appears to have worked.

I'm trying to use a procedure to write phone numbers to a text field and unable to have the phone number post correctly. Duplicating the query in the pure query environment writes the wrong value to the table too. Here is the SQL as simplified as it can be to duplicate the behavior...

Bob, Thanks for the reply. It's a shame that MS Access 2000 does not fully support this standard ANSI-92 SQL standard. Here's what I just found <quote> Note The check constraint statement can only be executed through the Jet OLE DB provider and ADO; it will return an error message if...

BACKGROUND I'm in the process of migrating a flat database application to a relational system. As part of this effort I need to build scripts to create a new relational data model and migrate data. ENVIRONMENT MS Access 2000 APPROACH I'm using DDL to define new table structures, migrate...

Another approach that I like to use is to have the DB check to see who is logged into Windows and in effect 'piggy back' off of the windows security to restrict what a user can do within MS Access. This simplifies things because you only maintain a table of logins, not passwords. It also means...

I can't say that I've tried this, but you did peek my interest enough to find the following post (http://www.tek-tips.com/viewthread.cfm?qid=1607993&page=1) <code> Sub MyCreateFromTemplate() On Error Resume Next Dim myOlApp As Outlook.Application Dim MyItem As Outlook.MailItem Dim...

Thanks for the follow up - it's a shame that such a useful function has outlived it's attribution. I'm glad you were able to retrieve the code so quickly. ________ EASY VAPE REVIEW

I like MWSnap. (http://www.snapfiles.com/get/mwsnap.html) The installer makes a registry entry. but you don't need it. Just copy the MWSnap.exe file to any Windows PC and the tool will run just fine. ________ LOS ANGELES DISPENSARY

This is BEAUTIFUL! I'd like to attribute this function to you in my code. Would you be OK with the author being listed as 'ghudson' and the source as http://www.access-programmers.co.uk/forums/showthread.php?t=195620&goto=newpost ? ________ HOW TO ROAST

(1) write a cross tab query that sums accross each row (2) write a SELECT query witha GROUPBY clause that will summ each field (3) write a UNION query to combine the results of steps (1) and Step (2) NOTE: you will want to include a static value field (e.g. Expr1: 'A') at the beginning of step...