Search results

Hello everyone - I am trying to find a way to set field's width to be based on a control on a form. I have a form that shows the progress of selection waves and there is a field called "Percentage Done" on which I want to based the width of a field called rctBar. I found a thread that did...

Thank you for the response. Yes the columns are pivoted from the table. The table (tblInventory) consists of three fields - InventoryDate, ItemNumber and QuantityOnHand. These fields are consistent week to week. I created a crosstab query based on that table using ItemNumber as the Row...

Hi everyone - I have a report based on a crosstab. Every week when the inventory numbers are entered into the database, a new field gets added to the crosstab with the date as the column header but this field does not show on the report. I am wondering if there is a way to automatically add...

Thank you for the quick response. The intention was for the sequence number field to identify how many trips an associate took to home slots in the warehouse before going back to the dock door for another stack of pallets. This is an abbreviated view but the results should look like this...

Hi Everyone - I am having a problem with a query I have created. I have a query called qryDockRuns that runs perfect and within seconds the records appear. However, when I use that query to create another query and add a sequence number field, the query runs unacceptably slow. I don't even...

I found a fix. I created a "Line" field with the following: Line: Val([Line#]) This worked perfect and it sorts the way I wanted it to now. Thanks again for your help, Paul. I would not have known what to look for if you hadn't told me that it was sorting "alphanumeric". :D

The field's data type is Number and the field size is Long Integer.

Thank you for the quick reply Paul! :) Here is the code for generating the line number: Private Sub Form_BeforeInsert(Cancel As Integer) Dim strWhere As String If Me.Parent.NewRecord Then Cancel = True MsgBox "Enter or select a record in the main form first." Else strWhere = "[OrderNumber]...

Hello - This question seems like it should have an easy answer but I have not been able to find it. I have a field called LineNumber that is a Long Integer. When I sort on this field, it sorts like this: 1 10 11 2 3 4 5 6 7 8 9 How do I get it to sort like this: 1 2 3 4 5 6 7 8 9 10 11...

Oh WOW!!!! You did it!! It works! Thank you so much for all your help. I worked on that myself for quite awhile before posting for help and I appreciate you taking the time to work with me and get me the results I needed. Thanks again!

I'm not sure if I did the attachment right as I have never done that before. Please let me know. Thank you.

Unfortunately I get the same results (i.e. all "Slot" stop locations being assigned a sequence of 1. :(

Yes, the record numbers are all in sequential order. The only difference I see between my table and the table you created is that the time in my field does not always increase with every record. It increases with the employee number but when a new employee number starts the time shows their...

Here you go: SELECT IIf([StopLocation]="Door",0,(SELECT Count(*) FROM qryDockRuns AS T WHERE T.EmployeeID = qryDockRuns.EmployeeID AND T.RecordNumber < qryDockRuns.RecordNumber And T.StopLocation <> "Door" And T.Time > DMax("Time", "qryDockRuns", "EmployeeID=" & T.EmployeeID & " And...

Sorry to be difficult (;)) but this one numbers each of the "slot" stop locations as 1 like this: Sequence EmployeeName Date Time ........ StopLocation 0 Jane Doe 5/18/11 7:00 Door 1 Jane Doe 5/18/11 7:03 Slot 1 Jane Doe 5/18/11 7:04 Slot 0 Jane Doe 5/18/11 7:10 Door 1 Jane Doe 5/18/11 7:12...

I tried the sql you posted and it is close. It inputs a "0" for stop locations of "Door" but it counts all the stop locations of slot. I won't include all the fields but here is an example: Sequence EmployeeName Date Time ........ StopLocation 0 Jane Doe 5/18/11 7:00 Door 1 Jane Doe 5/18/11...

Thank you so much for the quick response! There are more fields than in my example. I was trying to conserve space in the post but I see that maybe I left too much out. Below is the query I created first and was able to correctly get the sequence number working properly: SELECT (SELECT...

Hello everyone - I have looked at so many of the posts in the history but cannot find what I am looking for. I have been able to create a sequence number field but this isn't exactly what I need. What I need is for the series to start renumbering every time the word "Door" appears in the...