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

    DOS in XP Pro

    Software is an in-house proprietary test program that needs to gain access to COM1 to get info from the equipment under test. Software was written in assembler and makes calls directly to the port.
  2. nhtraven

    DOS in XP Pro

    Hi all I am having a problem when in DOS on a windows XP PRO machine. For some reason i cannot access COM port thru the DOS window. Any help would be appreciated. Raven
  3. nhtraven

    Dynamic Query to Form

    Ken Sorry i was not clear. I have a find form that allows the user to enter information into 6 different fields, then using this code i build a dynamic query: Private Sub cmdfind_Click() 'declarations Dim db As DAO.Database Dim QD As QueryDef Dim where As Variant...
  4. nhtraven

    Dynamic Query to Form

    Hi all I have a form that allows the users to build a query, allowing up to 6 fields. I have another form that will display the results. My problem is it all works except i cannot get rid of the query datasheet with results. I have tried this code in a multitude of places docmd.close...
  5. nhtraven

    Pictures in Forms

    jacque When i put a picture in a report, i use the image control from the toolbox. I have a field in the table called picname to store the name of the picture. You could also store the pathname. < i do not store images in my database>. In the porperties of the image control change the Picture...
  6. nhtraven

    Limit Record in Form

    THank you yduckfr!! how could i have missed the obvious? Thanks Raven
  7. nhtraven

    Limit Record in Form

    impulse i have used the query builder in the properties of the form, i found thru the access help files that i have too many tables for the original query to allow updates. BUT i found if i change the recordset property to dynaset(inconsistant updates) it works. <allows edits> Now the word...
  8. nhtraven

    Limit Record in Form

    Hi all I am trying to make a form open to just one record, and the user be able to edit that record. This is probably easy, but i am having a brain cramp and cannot get it to work. THe form also has a subform in the tab control. i tried to use the find next command button, but i am using...
  9. nhtraven

    Subform VS tab control

    Hi all I am wondering if one or more of the expert programmers would give me insight into the difference between tab control and a subform. Is it just aesthetics? Is there a benefit to using one over the other? I see that i can add a subform within a tab control. Is a tab control more for...
  10. nhtraven

    Autonumber

    Sorry all I figured it out, i had to compact and repair database to reset autonumber.
  11. nhtraven

    Autonumber

    I have an autonumber field that i changed the starting value. Well, now i need to change the starting value to a lower number and cannot do that. I have tried to delete the field, and that hasnt worked. I am to point were i am going to have to scrap this database and start over. Any help is...
  12. nhtraven

    Another Picture in a form question

    Peter, I hope this helps. You type the pathname or choose the pathname of the picture < image > < that is where the picture is physically stored on the computer or server> then the picture is loaded into the image control on your form. I am going to assume that this is done with VBA. It is...
  13. nhtraven

    Update Query in Form

    Jer U might want to check your preferences in the fields your updating. This maybe the problem. HTH Raven
  14. nhtraven

    restore on record of file

    SQLBill, Thank you for your reply. What I need to do is open the MSAccess database, and get the individual record out of a table. I cannot restore the whole database because there is a wealth of information that is inputted daily, and it will put us back a few days. So with this being said...
  15. nhtraven

    restore on record of file

    Can someone tell me how to, or if it is possible, to restore just one record of a file. I have Veritas v8.6 backup exec. Someone has deleted one record of an access database, and i am trying to restore it, or look at it, so i can copy that file back into the database. I cannot do a complete...
  16. nhtraven

    add a computer to novell server

    If someone out there could help me figure out how to add a computer to a novell server, it would be greatly appreciated. I am used to windows based servers, and have no clue how to add acomputer to a novell one. THanks in advance raven
  17. nhtraven

    A web - based form question

    Hi all, I am wondering if anyone has an opinion, when building a database to be accessed from the web which is the best way to go, msde or mdb? ANd is it better to make a ADP to connect to database? I am a little confused and have been reading, still have a bit to do before i tackle this...
  18. nhtraven

    I know how to do this in Excel, but...

    How did you word the SQL statement?? did u use like &quot;*&quot; & [txtboxname] & &quot;*&quot; I am just guessing here, but assume you have somewhere u are typing in the ALbany school d. That is the [txtboxname]. Hope this helps raven
  19. nhtraven

    Subform problem

    try me.refresh in the lost_focus or after update event hope this helps Raven
  20. nhtraven

    Inserting a record into a subform

    crp, Actually i figured it out, i did not have the code in correct order or the enough of it. Here is what i did, if any inquiring minds want to know = ) Function AddBalance(rstTemp As DAO.Recordset, Bal As Double, CID As Long) 'Adds a new record to the recordset using the balance for...

Part and Inventory Search

Back
Top