Recent content by Steve_b

Thanks for all the suggestions which I will try tonight. What is strange on the one computer is when I get that error then open the database and bypass that form, I opened up the form is design mode and executed the NZ function as written in the immediate window. It worked. I re-load the form...

I have three computers, all running Windows 10 Pro, Office 2016, 32 bit. All three have the same Access library references checked. Two computers run the access database with no issues. The third errors on the opening form which uses the Nz function. Error is Nz not defined. When I disable...

Thanks for the reference. After studying it, I had no luck. Here is the SQL code from this query and what the resulting query looks like. I am trying to sum the fields 2019-2020 and 2019-2020 which derive from a form field, so the name will change based on the year span selected. I can...

I have a form that is based on a query that contains data created by a crosstab query. In the detail section I can create a calculated field using the form fields. When I use the footer to sum the same fields I get an ERROR. I am using the sum function, =sum([formfield1]) which a numeric...

Re: Trying to limit crosstab with "where" statement using form field parameter Thank you both. The Browne article was helpful. I have it working.;)

I am attempting to develop a cross tab query that limits the years to a parameter that is stored in a form. Currently, the query creates a column for every year in the table. I am not quite sure how to proceed as the query does not recognize the form reference. Thanks for a push in the right...

All I can tell you is that I had consistent problems with dlookup not refreshing. Only reboots would solve the issue. I believe I even applied a patch from Microsoft to fix this (Ms Access 2010). I can add that this has happened on Windows 7, 8 and 10 on different computers. I have not had...

SOLVED Re: Dlookup problems I came across this function replacement for dlookup which has solved my problems. It uses a recordset to populate data. Thanks to developer Allen Browne. http://allenbrowne.com/ser-42.html

I am populating my form with a name from another table in a format similar to a datasheet view. I am not visualizing how a combo would help.

I have a form that uses dlookup to populate names that come from another table. Often times the dlookup does not refresh. Hitting the f9 refresh will only refresh what is visible on the screen. Only a reboot solves this. I have seen numerous posts on this and it does not appear to be fixed...

I have implemented your solution and it working fine. However, I have to come up with a design change. I need an efficient way to multi select illness reasons. Most reports will list all but some require just a few out of a total of 20. With my previous design I could easily do this as the...

Thank you! Your solution works beautifully. I greatly appreciate you taking the time to look at this. Steve

I have a report that has two levels of grouping. It first groups by company location. For each location the report calculates the number of different absences by days. What I am trying to do is to create a calculation that will give me for each type of absence type the percentage for that...

I ending up using a self join query which I was not aware I could do.

Hi All: I could use some direction in coding the following: I have a table that has three fields that make a unique record, school, organization and year. This is what I want to accomplish For every record in the table where year = 2011 and fieldx= "yes" locate the corresponding record for...