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

  1. cainemart

    Direction/Advice

    Thanks for replying with all of the useful info.
  2. cainemart

    Direction/Advice

    Please give me some direction! I am a programmer for the accounting department for a corp. I mainly do VBA, Access, and VB but I want to expand my skill set. I like the database programming I do, but I want to get into the visual side as well. So my question is, what should I study up on...
  3. cainemart

    Explain a sentence

    Thanks for replying
  4. cainemart

    Removing last 7 chars in query

    Why not use the Left("Your string", Len("Your string")-7)
  5. cainemart

    Explain a sentence

    "If you have a multiuser environment and want to speed it up, you can create class modules that represent your records as reusable objects. " The part about represent your records as reusable objects. Are they talking about your tables or just the specific info you are using at that...
  6. cainemart

    Bold Error

    I'm using 123 on an Win 2000 machine. Now all of a sudden when I highlight a cell, go to range properties, and select BOLD, I get an error saying "123 error, error log being created." Any suggestions would be greatly appreciated!
  7. cainemart

    Text file Import Question

    I appreciate both of your comments. I guess when I was asked the question I was thinking which would be faster! Thanks again. cainebean
  8. cainemart

    Text file Import Question

    We have an Excel program and imports bank text files and formats the numbers to be used in an Access database. So I suggested doing it in Access since the numbers end up in Access. But they told me that the same numbers were also used in Excel for some of their spreadsheet stuff... I was given...
  9. cainemart

    out of memory problem when using forms

    When I get this message I close the database, restart my computer, then compact the database. This helps for awhile. cainebean
  10. cainemart

    How to run code? Access VBA

    I don't use Oracle but I would think it would have an import or link option. If you can't import the tables that way, import them into a Excel file then import that file into Access.
  11. cainemart

    How can I have a warning message that will prompt

    If(MsgBox(“Question”, vbYesNo, “Question Title”))=vbNo Then Then send next message End if cainebean
  12. cainemart

    Showing Earliest time

    Couldn't you get the min/max for the specific fields?
  13. cainemart

    How to run code? Access VBA

    You create a form, then you use the toolbox to create a button. Then you highlight the button, right click and go to properties. Find the onclick event then put in the specific code you are trying to run. You have a bunch of different functions in the code you have listed so you can't just...
  14. cainemart

    Subtracting minutes from a Time?

    Couldn't you convert the 8 hours to minutes then add the other 30 minutes to this total then subtract the minutes you want removed? You might also check DateDiff in help. cainebean
  15. cainemart

    Transferring import specs from one Access database to another...

    I'm not sure what you are asking. If you expand on it some, I "might" be able to help out. cainebean
  16. cainemart

    populating 'the same' fields that occur on > 1 tables

    This would be an example tblOrders OrdDate <--- First part of primary key OrdID <--- Second part of primary key StaffID <--- Foreign key to tblStaff TableID tblStaff StaffID <--- Primary / Foreign key FName LName SSN Now if you wanted to get the info from tblStaff you would join it like...
  17. cainemart

    How to run code? Access VBA

    You have to make something trigger the specific code that you want run. Like when you push this button, this code will execute. You have a few differnt functions in the code listed. Would need more info on what you are doing. cainebean
  18. cainemart

    populating 'the same' fields that occur on &gt; 1 tables

    Couldn't you make a table with the two fields you need then link all of the other tables back to the first?
  19. cainemart

    Need to know all fields that have default values

    I think you are going to have to check every table and every field in the tables to get the info you need but I'm not 100% sure. cainebean
  20. cainemart

    Import Question

    You can import regardless of who was in the database. Especially since you are importing. The way I understand it is you would only have a problem if the records you are importing are on the same page as someone else using the same records. Since you are importing this shouldn't happen...

Part and Inventory Search

Back
Top