Recent content by nhtraven

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.

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

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

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

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

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

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

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

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

Sorry all I figured it out, i had to compact and repair database to reset 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...

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

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

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

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