Search results for query: *

That sounds like a very reasonable alternative, and I did not know how to get to the slider control so thanks for letting me know! I may give it a try later.

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

Yes, I think you may be missing what my goal is. As an example, say you are using an alarm clock or a car stereo and you are setting the time. Now say there is only a "Time up" and a "Time Down" button. Each time you press the button, the time changes by one minute. To change the time by 4...

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

I see, so it was a solid SQL command after all. I hadn't seen aliases until now. Thanks all. The link was also very helpful.

Thx for the reply, but I'm afraid I don't follow the answer. I see you said t1 and t2 for my table 1 and table 2 from my example. but what is this "a" and "b"? Is this whole line a literal sql example? I can't tell the difference between when you are giving literal syntax and when you are...

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

Ok, thought of something on a good nights rest. I put in the magic DoEvents command between each ...Visible = True command and all is well now. I still welcome any insight on why DoEvents is needed, but at least my problem appears to be solved.

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

Thanks PHV, that's probably what I was really looking for in the beginning, since my query is allready built up in Access anywyas, and yes the parameter's form is open. Using an Access function with one line of code instead of ADO with many... out of curiosity, does anyone know which method...

Thanks for the good information! So About this... <<Neither ADO nor DAO knows anything about Access objects <<(forms, text controls and suchlike), they are methods for <<retrieval and manipulation of data and data structure, so <<parameters needs to be resolved. Hmmm. So I'm thinking this is...

hmmm, it looks like you were right in that my error message had to do with parameters. I didn't think that would be a problem... The Access query references some (hidden) text boxes on the main form and uses them as parameters. It works when I open the query with the Access UI, and I thought I...

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

I see, that bypasses the Main Form, and solved my problem. Thanks!

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

Hmm. Thanks for the insight Mike. What do you mean by "Your load must be wierd to take so long" Inefficent queries?

Ok, I stand Corrected, my apologies. I thought I had tried this several times before and ruled out the following, but now it doesn't appear to be the case: It still takes a very long time the FIRST time the make-table query is done. Then every one after that is very fast AS LONG AS I DON'T...

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

Thank you for your reply, Remou. This code does work, and the reason the SQL is coded that way is because those 3 are actually a reference to the same field in the same table. The Query is set up to treat this one table as 3 different tables in order to access several parts of the table for...

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