Recent content by bgoad

Pat, Thanks for the reply. I did try what youy suggested and was not able to get it to work in Access 2003. So I then moved to another machine that had Access 2000 on it and was able to get it to work. I think part of my problem is Access 2003. SJ, Thanks for your code, I was able to do some...

That does solve one of problems thanks for the pointer. However, I had to convert this app from Fox for DOS and the original DB was not normalized at all. In saying that, I have a field that has a relationship to another table, this field contains a int and can not be set to AutoNum because it...

Are you saying that I would need to load the table as a Rescordset and then utilize the recordset to ID the current, first and last record? I am very familiar with ADO, unless Access uses something other than a normal DE control. Brian

How can I identify the current record I am on using VBA? Also how can I determine if this is the first or last record in the table?

I have a form that has an active record, I have several fields in the record that are not items of the form. Can I gain access to them? If so what is the best way to handle this? BTW my form is bound. Thanks in advance, Brian

Here you go

I have tried to upload the database here, but it is to large. Any suggestions on the best way to get it to you?? Brian

I am not sure why it was not working. The original form was created using the wizard, "wizard bad", I have since rebuilt it manually, "manual good", and it is now working. If anyone has any idea as to why the wizrd form was acting weird I would love an explanation. Brian

I have a menu that has command buttons that call other forms. The problem I am having is that the other forms do not seem to be executing the code that I place in them. For instance I place a msgbox in the load event of a form and it does not execute. I am a programmer from the VC++ world and...