Search results

I just left for a week vacation with only phone and iPad. I’ll have to look at this in a week or so. Is there a good reason why there activity yes and activity no fields rather than a single field?

Can you provide more information about your tables and relationships? Are you wanting to open a filtered form or report? Have you created the form/report?

Try Crystal Longs tutorials.

You can create joins with like although the join can't be represented in design view. I created a small table [tblCompanyNameParts] with a short text field [CompanyPart] and added a couple records with values "co" and "ow". I then created a query: SELECT Companies.CompanyID...

Why couldn’t you mention your requirements in your first post?

So, did the suggested code work or not?

The code depends on the name of your subform control. It might be something like Me.[your subform].Form.Requery

Having 12 queries with basically the same SQL and only a slight difference in criteria raises questions. I can't figure out what you are attempting to do. I rarely if ever use tempvars and global variables and when I do, they are documented. They all make any troubleshooting very troublesome...

Without looking at the report or data source, I assume the issue is with duplicate data or an improperly constructed data source.

Use the search 🔍 with “how to close a thread”

Access should never have “issues with too many rows”. There is a limit to the number of columns in a query which matches the limit of fields in a table. Twelve queries for twelve weeks sounds like a poor design but I can’t tell since I’m replying from my iPad.

If you add a Null value to any other value, it will Null the result. For instance Null + 8 = Null. I expect you could just add another row heading like:

Are you viewing Report View or Print Preview?

So, your file name is shifkey.txt not shiftkey.txt?

Does your actual file name match your code but when file “shifkey.txt”?

Which "when I load the form"? Do you actually mean the report "rptNonStandardActionsByPlanWeek" The report errors but if you open the report in design view and display the record source in datasheet, you get Is that what you expected? I found the last report I looked at worked if some the...

I took MajP's code and paste it into a module named modStrings (from the new Northwinds template). I then opened the debug window by pressing Ctrl+G. From there you can test the functions with different values including Null.

I think the logic is complex enough that I would create a small user defined function that would accept the fields as arguments and return the properly formed greeting. This would allow you to use the function everywhere in your application. Functions can include comments regarding the logic as...

I would change the table structures but it's difficult without some basic specifications. To start, I would use an autonumber primary key in all of my tables. There should be a Sites table with the SiteID and Site_Name. Then your current Sites table would become a junction table of SiteID and...

There is a threshold of 100 posts before you can post links. You have a way to go.