Recent content by bryn30

How do I create a system table within access2000?

well I got this to work, not by the option group like I had hoped but by the way of multiple query buttons. each "option" now has a unique button that changes the rowsource of the listbox to support the user parameter. thanks for the help

I am trying to set up a search form allowing the users to search a table using 4 different criteria. when the form is opened I get an parameters and an error, it asks for the user to give it parameters for [Forms]![Search]![NPA] [Forms]![Search]![NXX] [Forms]![Search]![LineRange]...

I have a doc that has a table with 4 columns and 50 rows, column 4 instructs the reader to go to Next Step?? or start reading at row ??. Now there are additions/deletions of some action within the process so these steps change, not often but they do change. as it is now, the table column one is...

Rick, Thanks for your help pointing me in the new direction. it works beautifly. here is the final code with many thanks to Rick Sprague! Dim db As DAO.Database, rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("StatusHistory") With rst .AddNew ![OrderID] =...

Rick, Thanks for your help pointing me in the new direction. it works beautifly. here is the final code with many thanks to Rick Sprague! Dim db As DAO.Database, rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("StatusHistory") With rst .AddNew ![OrderID] =...

Rick, Thanks for your help pointing me in the new direction. it works beautifly. here is the final code with many thanks to Rick Sprague! Dim db As DAO.Database, rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("StatusHistory") With rst .AddNew ![OrderID] =...

Thanks Rick... I am a newbi at this, I will rework the form and give it a try using the OldValue property.

Thanks Pezamystik :)

No reason, just novice coding. will take it out. thanks.

Goal: create a status History table for Intervals Reason: Status changes all the time, Need to track the interval in days that a order was within each status. I have changed some object names to easier understand what I am trying to accomplish, here is what I have so far: Running code...

Goal: create a status History table for Intervals Reason: Status changes all the time, Need to track the interval in days that a order was within each status. I have changed some object names to easier understand what I am trying to accomplish, here is what I have so far: Running code...

Goal: create a status History table for Intervals Reason: Status changes all the time, Need to track the interval in days that a order was within each status. I have changed some object names to easier understand what I am trying to accomplish, here is what I have so far: Running code...

Thanks RickSpr I think I have it... it seems to work here is the final Code Sub AlterFieldType(TblName As String, AlterTempField As String, NewDataType As String) On Error GoTo Err_AlterFieldType Dim db As DAO.Database Dim qdf As DAO.QueryDef Set db = CurrentDb()...

I found this code that will do what I am needing posted by DougP. Thanks Doug, How do I place this code in a sub routine and How do I put the last piece of info in a Debug window? Sub AlterFieldType(TblName As String, FieldName As String, NewDataType As String) Dim db As Database Dim qdf As...