Search results

Wow, that's quite a collection of help files! Have you considered zipping them and posting them all?

I tried to tack the code that tracks modified time/date right after the code for the audit trail and it didn't work. Maybe I messed it up when I combined them. I'll retry it and see what happens.

Thanks for the assistance, I'll be sure to implement the fix. I thought I was going crazy at first!

I have a set of code to keep an audit trail that calls a module: Private Sub Form_BeforeUpdate(Cancel As Integer) Call AuditTrail(Me, CurrentCYIDPK) End Sub Calls Option Compare Database Const cDQ As String = """" Sub AuditTrail(frm As Form, recordid As Control) 'Track changes to data...

I'm using this search form. I have never had issues with it until today. When I type the letter "i" as the first letter in the 'Search For' box, I get the following error: "Microsoft Office Access can't move the focus to the control SearchResults" Also, when I type "i", it shows up in the...

The title is probably confusing and/or weird because I couldn't figure out how to say it. I have a report that I'm going to use to make labels for a folder; it's a list of Manifests under a Delivery Order. Here's the breakdown of data hierarchy: One Delivery Order can have multiple Manifests...

Yes. So I was finally able to get my brain in gear and search using the proper terminology. This is what I used to fix my requery problem: [Forms]![MainFormName]![SubFormName].[Form]![ControlName].Requery I don't understand the differences between "!" and "."

I know this is basic, but I can't seem to figure it out for the life of me. I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out. Form 1 subform 1 > button to open pop up form subform 2 subform 3 I'm trying to requery a combo box (inside of...

For me, I like having fewer things in the left toolbar. I try to build queries inside the forms if possible.

Ok, so I found the join that, if left as INNER JOIN, will limit the number of records the query will produce (I previously made all the tables INNER JOINs). Is there a problem with making all the joins INNER? When I initially researched my problem I figured it was a problem with the way the...

I am using a cartesian query to create multiple copies of a record to use for printing labels. Here's my query that produces the cartesian result: This works just fine in creating the desired result - EXCEPT I don't get all the records. When I remove the 'cartesian table', and right join...

Okay, I got the cartesian result mostly working, along with the "1 of 2" text. I'm having a problem with the query not showing all the results as soon as I introduce an inner or outer join. The query previously was working correctly and broke as soon as I introduced the cartesian-effect. Is...

Thanks. I'll see what I can patch together with these resources.

Thanks. Some reason, I didn't get notified that you had posted. I'll take a look and see if I can figure it out. If no, I'll be back.

Here is the code behind the button that opens the form that contains all of the manifest information. Private Sub Command_75_Click() On Error GoTo Err_Command75_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmManifestInformation" stLinkCriteria...

I have a navigation form with a combo box. The combo box has a running list of manifest numbers. I select a manifest number, then click a button that brings up a new form with data related to the selected manifest. However, I have to click and unclick the 'Toggle Filter' button on the new...

[/LIST] Thanks for this suggestion! Very handy.

I see. I believe that mostly makes sense in my brain. Thanks for your assistance!

Yeah, I did a google search but it didn't clear much up for me. Where I'm confused is that it seems a range and array are essentially the same things - a list of data that is more than 1 cell.

Yeah, I saw the Trim and Substitute additions to the If formula and the last line of the code which I assume is designed for this spreadsheet.