Search results for query: *

When doing data entry in data-sheet view, if you enter 2 consecutive integers in a field, the 3rd consecutive integers in the sequence will automatically appear in the 3rd field. If you continue pressing enter (or down, depending on you keyboard settings), you will continue to auto-fill the...

Access 2003: I have a situation where the user clicks an "up arrow" Command Button in order to re-order records. I want to allow the user to "click and hold" this button to prevent sometimes having to click many times. The software should halt for a second and then simulate rapid fire...

Sorry if this is commonly asked or something, the confusing way to ask the question makes it hard for me to find the answer. Example: Table 1 has: ID 1 1 1 1 2 2 3 3 4 5 5 6 6 Table 2 has: ID 2 2 3 3 4 4 5 I want to query from Table 1 everything that is NOT in Table 2. Table 2 is also...

Hello, I am opening multiple instances of a report using New, such as: (report_args is a global variable that gets used in the reports Open event because OpenArgs is not usable this way) Dim smt_report As New [Report_Defect Tracking] Dim assy_report As New [Report_Defect Tracking] report_args...

Hello, I have a seemingly simple command set up but I can't get it to work. Here is the pertinent code: Dim rs As ADODB.Recordset Set rs = CurrentProject.Connection.Execute("SELECT qryTotal_Compliance_Data.* FROM qryTotal_Compliance_Data;") I went ahead and copied the SQL right out of...

Hello, I somewhere somehow entered code, probably a Close function, that has left me unable to open my database. Possibly I put in a module or something. Anyways, as soon as I open it and the mainform enters, the database then immediately closes itself and Access closes. Is there anyway to...

We have a Database with a lot of tables and relationships. Queries that call other queries. The top level query that the user uses was taking 5-8 seconds. To get rid of this delay, we decided to do a daily make-table query, get all of the data in one large table and index it. So yes now all...

Hello, I have a query (qryTotal_Compliance_Data) whose select query takes about 5-8 seconds. Not the end of the world, but I am trying to improve it. This query reaches into other queries which then go to many tables. Because we only get daily updates anyway, I want to convert this query...