Search results for query: *

How do I create a system table within access2000?

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

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

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

Goal - Pull data from Production DB and populate fields in an Operations DB. First determine Orders to pull. so I created a Union Query to get a list of Orders. Pull Data From Production. built a query using the Union query to pull three fields, Date1, Date2, Text1 I need to send this...

Is there a way to change the datatype of a field from Text using VB?

can't figure this one out. this code works to archive when the tables are local. However I need this to be a split database with the tables on the server. When that happens the code errors. it stops on the Delete portion. and it cannot find the search key. here is the error; Run Time Error...

can't figure this one out. this code works to archive when the tables are local. However I need this to be a split database with the tables on the server. When that happens the code errors. it stops on the Delete portion. and it cannot find the search key. here is the error; Run Time Error...

ok here is the update... it works as far as placing these orders to a assigned order table. I have to do some more tweeking to get the order over but here it is. ok here is the process flow prespective order is placed into a table called titan, orders is then assigned and placed in a table...

one other thing to hopefully clear things up, I select the varitems, and then the rep and hit the button, and it requerys the listbox. I choose the same order again and change the name or leave it the same and it give me a duplicate order.

In a MultiSelect ListBox (extended) is it possible to sort the list by clicking on the header of the column you are wanting to sort by?

In a MultiSelect ListBox (extended) is it possible to sort the list by clicking on the header of the column you are wanting to sort by?

In a MultiSelect ListBox (extended) is it possible to sort the list by clicking on the header of the column you are wanting to sort by?

I have a list of orders say 2000, and a few reps, about 12. I am using a multiselect ComboBox to select the order to be assigned. The ComboBox is a list of the reps. I am thinking a command button to execute the magic wand. How do I get the button to copy the ComboBox value (rep name) to the...

I have a list of orders say 2000, and a few reps, about 12. I am using a multiselect ComboBox (Extended) to select the order to be assigned. The ComboBox is a list of the reps. I am thinking a command button to execute the magic wand. How do I get the button to copy the ComboBox value (rep name)...

I have a list of orders say 2000, and a few reps, about 12. I am using a multiselect ComboBox (Extended) to select the order to be assigned. The ComboBox is a list of the reps. I am thinking a command button to execute the magic wand. How do I get the button to copy the ComboBox value (rep name)...

I have a list of orders say 2000, and a few reps, about 12. I am using a multiselect ComboBox (Extended) to select the order to be assigned. The ComboBox is a list of the reps. I am thinking a command button to execute the magic wand. How do I get the button to copy the ComboBox value (rep name)...