Search results

I have a report that prints badges from a query of registrations for an event. Now I need to print bars across the bottom of the badge to denote Speaker, Sponsor, Exhibitor, etc. Some badges will have no bars, some as many as 4, varying in background color. Formerly, each badge was printed as...

After moving to Windows 10 and Microsoft Office 2019, I am getting this error message in queries and reports: Undefined function 'Nz' in expression. The error occurs if I start Access by double-clicking on the database file. If I start Access, then Open the file, the error does not occur...

Can someone tell me why this DCOUNT returns the number of records in the query without regard to the criteria? Thank you in advance. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) 'Increment iLine on each detail format Static iLine As Integer iTotal =...

In a database used for event registrations, I have a form with 2 subforms that are linked by Event ID and Attendee ID. The subforms are for the attendee pay items and event options. This worked perfectly for the first event in which we registered almost 500 attendees. For the 2nd event, I...

I have a db of contacts that includes a linking table to match contacts to the groups each is in. I need to be able to query for contacts that are in a specified group AND in another specified group. My query instead returns all contacts in [SelectGroup2]. Is there a way to make this work...

In Access, in SQL view, I modified a query to change one of the JOINS from inner to outer. I got the error message that the query couldn't be executed because of an ambiguous outer join. However, now I can't get back to SQL view to fix it. Whenever I click on SQL View, I get the error message...

In Access, I Created a Macro with: Condition: [Forms]![frmContacts]![NewRecord]=True Action: SetValue Arguments: [Forms]![frmContacts]![RecAdded],=Date() The Condition part seems to work as desired, but when it is true, the field [RecAdded] is set to...

I have a report that prints a set of fields only if a certain condition is true. However, the borders and back color are printed even when the fields are not. Is there any way to suppress that? Thanks!

I needed to create 2 subforms that look like spreadsheet: categories are rows and months are columns. I was told that I could use a crosstab query, and everything is linking well with the main form based on an ID. However, now I discover that I cannot enter data into a form that is based on...

I have created a crosstab query that I will use in a subform and a subreport. However, Access won't let me add the fields to the query that I need to link the subform to the form. Is it possible to add fields to a crosstab query? Thank you in advance!

Is it possible in Access to use an input value (text) as a field name? I want to access a field based on what the user enters. Thank you.

I have a form that has a FIND button. I want the user to enter the 3 fields that make up the primary key, then find the associated record. How can I do this in Access - not VBA? Thanks!

I am printing invoices and need to print the label in a subreport at the end of each customer only once. This is what I want it to look like: 2014 payments applied to cap: GA $8,078.00 NC $1463.00...

I have a report that uses a subreport for summary/totals information. It was working perfectly until I made a change to the format. Now, the name of the subreport (e.g. subrBalances) is printing at the top of the section. It was not doing this before. Why is this happening and how do I get...

Is it possible to add a query to an existing report? I use Access, not VBA. Thanks.

I will be using 3 rates in calculations in various queries. What is the right way to store the rates so that I am not "hard-coding" them into my calculations and can change them in one place should the need arise?

I have an invoice report this is grouped by Contractor. Within that, I group by Project, and the project header has an invoice amount (ASSESS). The detail section prints payments made on the project. I am able to create a total by project (in the project footer) which is the project ASSESS...

I have a report that is based on a query. One of the fields returned by the query is projectID. When I try to add that field to my report with "add existing fields", projectID does not show up in the list. Any ideas why or how I can get the field added?

I am creating a report that is organized by project. The detail lines are to list payments applied to the project. How can I skip the detail section (or print a single blank line) if there are no payments in the separate payment table that match the project ID? Is there a way to tell that...

Hi. I am new to Access and have completed 21 multi-hour video lessons. M y background is as a former programmer in assembly language and FORTRAN. However, I was out of the work force for 20 years, in which time technology passed me by. I have now started in an admin position which requires...