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!

  • Congratulations strongm 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. Dryseals

    Fields collection

    Thanks Skip, I'm not sure if I can do this, self taught. But the outer join would be between two different tables correct? This crosstab is compiled from one table. It's a table pulled out of SAP. It's an operation table so each operation represents a record. In each record is the craft, the...
  2. Dryseals

    Fields collection

    I'm using code to create a crosstab table for me, this is for scheduling multiple crafts by date, tally the time and post it in a form. Problem is not all crafts are schedule each day, so any craft not scheduled will not create a field in the crosstab. What's the best way to determine if a...
  3. Dryseals

    Copying a record

    Thanks to both of you, I used adalger's method and with a little massaging was able to get it to work just like I needed it to.
  4. Dryseals

    Copying a record

    I have a dump from a system that I'll need to break apart into around 50 individual tables. I'll need to do this a few times a year so I wanted to automate the process. I'm down to the final part of the program and I'm having a brain poof. I want to copy a whole record out of one table and...
  5. Dryseals

    Attributes

    If I could find a method to do it without opening the file, that would be great. I started lisp many years ago but never stuck with it, most of the things I did were for proprietary machines. I know VB well enough to get most things, but I do not know the Acad libray well enough to get there...
  6. Dryseals

    Attributes

    Hi all, I've been tossed into a well fire with a water hose to put it out. Seems I've been placed in the I/E design group to clean things ups. The guy before me kept multiple copies of drawing in tons of locations and I have to straighten it out. I've use ACad since the early 90's and Access...
  7. Dryseals

    String Issue

    I'm not sure what you are trying to accomplish, but maybe I can help. Looking for a string within a string can be accomplished fairly easy with a For/Next get the string Txt do a length LN = len(Txt) For I = 1 to LN "" look for the text here""" Next I then you can look for the string by...
  8. Dryseals

    How to create a timeout to throw users out of the database?

    Thats funny, I was just talking with a friend on how I accomplished this. A quick and simple way for me was that I have a main form that cannot be closed. On that form I have a check box is visible only to my username. On the main form under the ontimer, it goes out and look for the table that...
  9. Dryseals

    Best way to update records on a form?

    Thanks PHV, always wondered hopw I could use that. But I still have a question. If I check if it is dirty, what would be the best way to fix it, do a save I guess?
  10. Dryseals

    Best way to update records on a form?

    Hello again, I have a subform in a tabular format that the users add and remove data. Also is the ability to renumber certian records. So I ran into a bit of a problem and need a quick fix (I leave for five days after today and do not want to be called at home, otherwise I would struggle...
  11. Dryseals

    Deleting a record, very slow.

    I have a db with multiple users and multiple tables. One particular table is a bill of material. In the BOM table there is a BOM number, BOM item number and a part number. When the user needs to delete a part from the BOM, I run a simple query in code that seems to work but is at times extremely...
  12. Dryseals

    Check if Exists

    I use a recordest and then check to see the record count of the recordset to see if certian things exist. You could also use a findfirst.
  13. Dryseals

    Sharing a record source

    Thank you, sometimes the simplest way is the best, I don't know why I didn't think of the on open statement. It would still be nice to know how to put this string in a variable that can be used anywhere.
  14. Dryseals

    Sharing a record source

    I have a form that allows the users to make multiple selections and type in variables that allow them to do a search. When they click the search button, I build an sql string and use it as the recordsource of a form that opens with their results. On rare occasions the user would like to print...
  15. Dryseals

    Rights for Access forms

    Thank you all for your input. I've messed with the security groups about four years ago and it became such a headache that I have avoided using them since. For the most part in the umpteen dbs I've created I was able to control access by a simple login, but those with a little knowledge could...
  16. Dryseals

    Rights for Access forms

    I knew this was coming but I avoided it until now. I have an Access db that started very small and has grown very large. There is a small group of us entering and editing the data, so it is easy to control. Now there are about twenty more people that want access to the data, read only rights...
  17. Dryseals

    Split semicolon separated field into 12 new fields

    Roy, Thanks for the split function, and to think I've been doing it by searching a mid function for years.
  18. Dryseals

    How to transfer values from one form to another as I select a value

    Lots of ways to do this, the simplest is on open arg me.Id = Forms![Form1].Id
  19. Dryseals

    Updating table from textbox input

    How are you trying to pass the data from the text box to the table, what initiates the transfer, a push button, afterupdate? Also are you actually viewing the form when you do this?
  20. Dryseals

    Finding a control on a form

    I used a couple of short loops to do what I needed. Dim dbs As Database, rst As Recordset, Brst As Recordset Dim NM As String Dim oControl As Control Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Add Parts", dbOpenDynaset) Set Brst = dbs.OpenRecordset("Add Parts Base", dbOpenDynaset) FC...

Part and Inventory Search

Back
Top