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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jay2502

  1. jay2502

    Linked Tables

    Is it possible to link tables in Vba Code? If so how does one do it? Justin
  2. jay2502

    Certification Benifits

    I am looking at doing a mcad or a mcsd or a mspd. I am quite new to the industry and am looking for abit of guidance in terms of choosing one and the benefits of the certification eg. jobs, salarys, room for growth in the industry etc. Thanks Justin
  3. jay2502

    Help File

    Not to worry Seem to have figured it out
  4. jay2502

    Help File

    I've seen on the properties menu there is an option for help files. How do I do this?
  5. jay2502

    Database Limitation

    I'm planning to create a database that will hold +- 1.7 million records per year and I've checked the size limitation and it will not be a problem! my question is Will the amount of data cause a lag how bad do you think the lag will be! Any thoughts will be appreciated
  6. jay2502

    Event Problem

    I have a form with a sub form! How can I know in vba when data has been changed on the subform but only when the parentforms record has been changed? thanks!
  7. jay2502

    Form Problem

    Thanks that makes sense but how would I do the Cancel flag?
  8. jay2502

    Form Problem

    How Can make a form only close with code? I have taken the X (close button away) but can still right click on the window in the toolbar and close it how can i stop this?
  9. jay2502

    vba variable problem

    How would I Write out and read in the variable? Just an example please
  10. jay2502

    vba variable problem

    I have a variable in vba but it defults to zero when i start the database everytime how can i get the database to save it when it closes.
  11. jay2502

    Very interesting problem

    the rowsource is nb this is a sub form SELECT TblTransaction.[Transaction Number], TblTransaction.[Vendor name], TblTransaction.[Requisition number], TblTransaction.[Vehicle Registration], TblTransaction.[Kilometer reading], TblTransaction.[Number of Litres filled], TblTransaction.Comment...
  12. jay2502

    Very interesting problem

    i've checked that and its not that
  13. jay2502

    Very interesting problem

    the figure is 7531.6 and its out by 1071 how could i slove the problem if it was that
  14. jay2502

    Very interesting problem

    I have an access database that i have created for a company I have a tbl with a list of transactions I also have a Report that lists the transactions by the criteria(which is a field). In the report footer i have a field that is a =sum(of the relevant field) to calculate the list of tranactions...
  15. jay2502

    Database Problems

    It is a sql Database.

Part and Inventory Search

Back
Top