Search results

Any time I try to open the module, it gives me an error stating "You can't import, export, create, modify, or rename any forms, reports, pages or modules in an ACCDe, MDE or ADE database"

I use the code cited below to get a listing of active users who have a DB open. It follows this Microsoft guide. However, this only works for an .ACCDB database. It doesn't work for a .ACCDE. Any suggestions on how to see active users within a ACCDE database? Sub ShowUserRosterMultipleUsers()...

This is a bit of a forms, reports, and VBA question. I have a form that is used to filter down a report. It lets the user select a date range, etc. I was curious if there's a way to allow the form to change the sorting of the report as well. For instance, right now, the report is automatically...

That is correct. The above solutions are only counting days where problems occur. I'm looking simply a total count of all days from January 1 to today.

So I tried your first suggestion and its preventing edits. But when I go to a record not marked 'closed', it is locked as well. Below is the code I added to the on current event. Any suggestions? If Status = "Closed" Then Me.AllowEdits = False End If

I have a DB of IT tickets and a form which looks at each individually. There's a combo box in the form which allows the user to indicate if the ticket is 'open' or 'closed'. I was wondering if there's a way to lock all the fields on a record if the combo box is marked as 'closed'. And then the...

Gotcha. However, step one isn't working for me. I think it's because my date field also includes the time. It's formatted like: mm/dd/yyyy 00:00am/pm

We would be counting

So I have a report with a simple bar graph. The bar pulls data from a table and shows how many complaints have been submitted on 3 different employees. I'm wondering if a form could be used to filter this data. For instance, can I have a form with a combo box containing the 3 employees' names to...

I have a query of complaints YTD. On a report, I'm trying to code a field to show the average daily number of complaints? Any suggestions on how to code that? I'm having a brain fart on how to do that tbh

Yup, that worked. What a brain fart. Thanks so much!!

In the control source of a field, I am hoping to look up a field in a separate table. Essentially, it's a manager field. I have a table full of manager names and their locations. If the location on the report matches the location in the table, I want that managers name to show up on the report...

This worked!!Thanks so much!!

So I have a form that I use to filter a report. It works well and I have two date fields to let the user filter between two dates. I would also really like to include (if possible) a combo box which has preset date filters that the user could select instead of using the date pickers (i.e. "year...

That worked! Thank you

So without going into the specifics, I have a query with two fields which show two different date fields as Month Numbers. What I'm trying to do is if a record's field2 does not have the same MonthNumber as field1, then I want that record to be excluded from the query. Any suggestions on how...

Yes I'm certain. I see what you're saying about the name fields, but it isn't that. The way the data is captured is silly (not my department) and it should just be one field.

So how do I go about using an append query to do that? Any suggestions?

I see what you're saying. The issue is the way that the data comes into the DB. Without getting into the details, the raw data from an outside source has two fields that really should always be one and I can't change the way the data is originally captured (its captured via an online form). If...

I'm wondering if an append query can take two different fields (same data type), combine them and then append them into one single field in a different table Thanks