Search results

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

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

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

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

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

Hi All: I am always amazed at the little things that hang me up when developing. I have a simple form and I used the combo box wizard to create combo box to search for records underlying the form. I have tried very idea I can think of to make the resulting drop down list unique. The wizard...

Greetings All I am a public school administrator in the US (Buffalo, New York). I don't consider myself a professional programmer by trade but I have developed some fairly sophisticated applications using Access and relying on the help of others on occasion. I got my start with Access 97 and...