Search results

Just an update: I got it working the way I needed it by renaming all those columns that had "First" preceding the correct column names by using "FieldName: FieldName". For all my fields that had expressions in them, I set those to "Expression" instead of "First" in the aggregate function row...

I think I just need to play with it. It worked, but then put a "First" infront of some of my fields in the query. Thanks for the help though, I think it just takes some code cleanup to get it the rest of the way. I wish Access just had a feature to remove duplicates based on one...

That cleared up that error message, thanks. So I got it working using the 'First' method you suggested and I verified that everything is showing up. The only thing is that I had to click through a bunch of "OK"s on parameter input dialog boxes that pop up when I run the query for my query...

The aggregate method seems to conflict with some 'IIf' statements I have in the query design that I'm using to parse that TAG_NUMBER out between the hyphens. I tried making a separate query with just "TAG_" and using the "Unique Values" set to Yes. That does filter out the duplicate TAG_...

I'd be fine with the first record Access gets to being the one that shows, so the one with "..._AR" in the suffix part. That field tells us what engineering drawing that particular TAG_NUMBER is associated with, and it doesn't really matter which one of those two choices it shows.

Here is the SQL around the field I want to suppress duplicates: SELECT DISTINCT [Components-Process Lines].TAG_ AS TAG_NUMBER, Basically I am renaming "TAG_" to "TAG_NUMBER" and want to hide duplicates around just that field. I thought I could add a WHERE statement in there to make...

I have a query where I need to hide all duplicates for just one field. There are a few duplicates in this field, but the duplicate records contain different data in the other fields in the query, so the setting the "Unique Values" property to "Yes" doesn't work. Is there some SQL code or some...

Well I figured out how to tell it to run through my records and do the update for all of them in one command button click. I had to use the DoCmd.GoToRecord commands and create a loop for it. When it ran out of records to go to, I put in the On Error GoTo Err_End statement to eliminate any...

I am trying to make a button for a form to update all the records it shows from its query with one command button, to avoid having to click on each record and click my "Update" button to auto-fill a field. Basically I have an 'if' statement based on whether a checkbox is Yes/No and if it is...

I figured it out. I had to have my stLinkCriteria statement as: stLinkCriteria = "[Unique Tag] Like 'GB*'" & "Or [Unique Tag] LIke 'OF*'"

I have a form that prompts the user to select criteria so they can run their own custom queries. On that form is a button that allows them to launch a data entry form on just the records that they queried for. I'm trying to write 'stLinkCriteria' statement so that the form to be opened will be...

Wow, I can't believe I forgot to put in the "=" before each one of the fields linked to an unbound form control. It fixed it for sure. Thanks!

Well my 'subform' is actually just a main form that is launched via a command button with additional fields to be filled out so it technically isn't a subform, I just have it named like that.

Here is what I'm trying to do: I have a report that is using a query as its record source for some information to be populated in the report. I also have some additional report fields that will be populated by a data entry form that is unbound to a record source. On my report design, I have...

Wow, that did the trick...no error messages and my Audit table updated correctly. Thanks! Are there many little things like this that pop up when you convert from .mdb to .aacdb? Also, what does the "DAO" distinction mean?

Can anyone help me out try to debug this code? I have a SubFunction that tracks changes made in some data entry forms by recording what was changed, the user that made the change, dates, etc. It all worked fine in the ".mdb" version of my database but when I converted to the new ".aacdb"...

Basically I have one huge Query with data from multiple tables and other queries as sources that covers pretty much all the data for the database. This is the query that I want to be able to let users filter information out of so they can find specific things if they need to. This database has...

That looks like it could work. What do I need to put into the query criteria line to get it to use that VBA code? "LabCriteria(sLabCriteria)"?

You basically guessed what I am doing. I have an unbound form full of check boxes to let a user click whatever boxes he wants and then he runs this query from the form and depending on what check boxes where checked (equal to -1) the data the query shows is filtered. The function of all the...

I have some pretty length criteria entered into a query as IIf() statements and I am running out of room on the first Criteria line for some of my fields. I'd rather not use multiple criteria lines for query parameters so is there a way to tell the query to look up its criteria from a VBA...