Search results

The value of the [Order] field can vary depending on the user. So, say there are three records that meet the tracking criteria. What I want to happen is the lowest [Order] number of those is assigned 1 with 2 going to the next number, again based on the order field, with 3 going to the last one.

I have a continuous form that will display records if they are selected [UseForTracking] in a separate form. These records already have a number value [Order] assigned in the source table, but these values can be changed by the user to adjust the order they are displayed in. What I want to...

If anyone else happens to want to change where labels print on a report, this link should help you. It worked perfectly for me. http://support.microsoft.com/kb/q95806

I'm trying to insert a set of values into a table using SQL. Here's my code: DoCmd.RunSQL "INSERT INTO tblAuditTrail([DateTime], [UserName], [RecordID], [Action], [FieldName], [OldValue], [NewValue])VALUES (" & Now() & ", " & User & ", & Me.CSM & ", " & 'EDIT' & ", " & 'Location' & ", " &...

Instead of using an update query, so my Audit Trail will continue to update correctly, I'd like to use an input box and run a function that performs much like an update query. My problem is, only one out of 4 records updates correctly. Me.txtTranTo = InputBox("Enter Location Transferring...

Doing some digging after I posted that, pretty much solidified my answer. Thank you, though!

I am using an audit trail on my database that works perfectly. My question is, can I run an update query and still log any updates through the audit process? I suppose the update query is not a necessity, but it would be nice to retain it if possible.

Here you go.

I don't have them built in SQL, but I can. I won't be able to get to it until later today.

I have a few update queries that will check X number of items, based on what the user inputs. What I want to do (if possible), is return the number of items selected based on what they type in a message box. I have set all warnings to false for update queries. Example: User runs the...

So design-wise, is there anything that can be done to that area where the scroll bar would normally be (if it's not visible)? That little blank section is driving me crazy, I just want to be able to cover it up.

I want the scroll bar to always display.

That's the problem. I want there to always be a scroll bar displayed.

How's this?

It's just the blank space left at the right side of the form when there are less than 10 records (where the scrollbar should be).

I've searched, and searched, and searched, but no dice. I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I...

I opted to just leave it out. It wouldn't be very helpful, other than highlighting the last entry. Thanks for all of your assistance, though!

Would it be easier to say that I have a Date/Time field, that I would only need the most recent row highlighted?

After doing a bit of searching, I found that Conditional Formatting was probably the way to go, but can't seem to put my finger on the correct expression to use. Would I use DLast, or something else entirely?

I have a log of items I currently inventory. When you click on an item, it opens another form with a sub-form that lists the history of changes for said item in a continuous form display. What I want to be able to do is when that form is opened, the sub-form will highlight the last entry...