Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sgidley

    Click and Hold: MouseDown and Timer

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

    Turn off Auto-Entry

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

    Click and Hold: MouseDown and Timer

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

    Click and Hold: MouseDown and Timer

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

    Select Records unique to one table

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

    Select Records unique to one table

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

    Select Records unique to one table

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

    Multiple Instances of a Report & Printer Error

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

    Multiple Instances of a Report & Printer Error

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

    CurrentProject.Connection.Execute Error

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

    CurrentProject.Connection.Execute Error

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

    CurrentProject.Connection.Execute Error

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

    CurrentProject.Connection.Execute Error

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

    Disable VBA from outside of Database

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

    Disable VBA from outside of Database

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

    Make-Table Query much faster in a macro...Why?

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

    Make-Table Query much faster in a macro...Why?

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

    Make-Table Query much faster in a macro...Why?

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

    Append Query Too Slow

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

    Append Query Too Slow

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

Part and Inventory Search

Back
Top