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 Chriss Miller 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: *

  • Users: Zygor
  • Order by date
  1. Zygor

    Unique values in a recordset

    I remmebr now. It is a collection. Thanks
  2. Zygor

    Unique values in a recordset

    I need a memory jog. A long, long time ago...in a galaxy... no. Really. I remember being able to create a recordset that eliminated duplicate values. Since I am not using a query I cannot use "select distinct..." I thought there was another method, like creating a group that would not allow...
  3. Zygor

    Select case with an And...

    Excellent! Thank you both! :)
  4. Zygor

    Select case with an And...

    ...Private Sub Command0_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("SELECT Table1.* FROM Table1;") rst.MoveLast rst.MoveFirst For Inti = 1 To rst.RecordCount Select Case rst.Fields(0) Case Is = Format(rst.Fields(0), "Short...
  5. Zygor

    hide text in powerpoint

    Is there a way to hide (and unhide) an object (or text) in Powerpoint when a selected piece of text is clicked on? I know there is an on click event of the text...I just can't figure out the syntax to hide and unhide a separate object on the same slide
  6. Zygor

    copy records from 1 table to another

    ...procedure but I'll execute it after I create it. CREATE PROCEDURE UpdateTable @StartDate DATETIME, @EndDate DATETIME AS INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE ActPatInDate BETWEEN @StartDate AND @EndDate; I intend to pass the criteria when I execute it in VBA. TABLE2 is my sql server...
  7. Zygor

    how can i import data from 1 access table to 2 joined ms sql tables?

    doh! I meant to start a new thread. sorry
  8. Zygor

    how can i import data from 1 access table to 2 joined ms sql tables?

    ...procedure but I'll execute it after I create it. CREATE PROCEDURE UpdateTable @StartDate DATETIME, @EndDate DATETIME AS INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE ActPatInDate BETWEEN @StartDate AND @EndDate; I intend to pass the criteria when I execute it in VBA. TABLE2 is my sql server...
  9. Zygor

    Has anyone seen this before?

    PHV, I know you sometimes answer a question with a question as a clue to help steer them to the answer. Is this such a situation? When I link to the table, it doesn't present the option to select the pk. Nor can I change it once it's in the Access database. Is there something I'm overlooking?
  10. Zygor

    Has anyone seen this before?

    Excellent question. No. It has assigned it's own (incorrect) PK.
  11. Zygor

    Has anyone seen this before?

    My bad. The linked table is an Oracle table. I have duplicated this issue in a brand spankin new database with only the linked table.
  12. Zygor

    Has anyone seen this before?

    I see duplicate records in a table where there aren't any. If I open the linked table I see duplicate records. If I sort the table, the duplicate records don't sort together. If I run a find duplicates query it doesn't find any. It gets better. If I copy and paste the entire table to Excel...
  13. Zygor

    How can I change a fields Format property to "Short Time" using VBA?

    That's how I got the above code. I checked other posts before I asked to see if anyone came across this problem. Thanks for the quick reply.
  14. Zygor

    How can I change a fields Format property to "Short Time" using VBA?

    I have a make table query that creates a new table everyday. I have tried- Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim db As DAO.Database Set db = CurrentDb Set tdf = db.TableDefs("MyTableName") Set fld = tdf.Fields("MtFieldName") fld.Properties("Format") =...
  15. Zygor

    Find a folder

    Thank you Remou. That's just what I needed.
  16. Zygor

    Find a folder

    Please forgive me but I have searched FAQs and done searches till my eyes are bleeding but I can't seem to find anything to help. All I want is to be able to have a user click a button and navigate to a folder where they want to save a file to. I tried to use fileopensave but it requires you to...
  17. Zygor

    compact on close issue?

    Found my own answer. http://support.microsoft.com/kb/945674
  18. Zygor

    compact on close issue?

    I am noticing the endusers are leaving temp files behind. i will go into the directory and there will be a dozen tem files db1...db2...db12...etc. This started happening when I checked the compact on close box. I use Access 2003. Has anyone experienced this before?
  19. Zygor

    SQL criteria doesn't like my "Like" condition

    ...the no filter (nothing selected in the cbo box) isn't working. Anyone see what I'm doing wrong? Set rstSurg = db.OpenRecordset("SELECT tblMyTable.*, tblMyTable.Dept FROM tblMyTable WHERE (((tblMyTable.Dept)=IIf([forms]![frmMyForm]![cboDept]<>'',[forms]![frmMyForm]![cboDept],(tblMyTable.Dept)...
  20. Zygor

    Loop through tables

    Worked awesome! Thanks!

Part and Inventory Search

Back
Top