Search results

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

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

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

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

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

Ok, so here is my situation...(and bear with me, I don't have that much experience with VBA for Access) I want to make a form that gives my client the ability to select from a bunch of 'check boxes' and when the client hits a command button "Run Query" it will filter a master Query (named...

I have tried my hand at the VBA code to fix this, but I admit I am a novice in VBA. Hopefully one of you can help me out. Here is what I want to do: I have a form that only has command buttons that represent pieces of equipment in a laboratory floor plan layout (i.e. one button represents one...