Search results

This seems like such a novice problem, but for the life of me I can't figure it out. I've created a switchboard with the switchboard manager and made the form a pop up. I'd like to reduce the form height but only see a width property for the form. How can I reduce the height of the switchboard?

I have a form with 2 buttons. One button is an "exit" button with no customization. The other button is a "search" button that runs a bit of code. Until recently, everything worked fine. I think they only thing I've changed in my db is that I selected "compact on close." Now every time I...

I have a report that includes last name and citation number in the detail section and sorts by last name. My problem is that there are occasionally duplicate citation numbers (data entry issue). I would like to flag the records on the report that have duplicate values (so if citation number...

I've written several successful queries but this one continues to trouble me. SELECT [CMSJUVQ].[JVKEY] AS INCIDENT, [CMSCHRG].[CRCIT#] AS CITATION, [CMSCOURT].[CCTIME] AS TIME FROM ((([CMSJUVQ] left join [CMSCHRG] on (([CMSJUVQ].[JVKEY] = [CMSCHRG].[CARRKY]) and ([CMSJUVQ].[JVSEQ#] =...

I'm trying to write an access report using data in a SQL table. One of the fields in the SQL table is a blob field that contains text. I'm wondering if anyone has any suggestions on where to start to get this information to display on my report?

I've been trying to import an xml file (access 07) and get an import error saying " ...has encountered an error processing the XML schema in file 'Report.xml'. Illegal xml character." I'm trying to track down a function that might take an xml file as input, remove any invalid characters and...

Say I have 2 tables both with a field [A] and a field [B]. Can I do I simple query that basically appends [A] and [B] from both tables (as opposed to an append query resulting in a new table)? What might the expression have to look like to do this?

I am trying to parse names and phone numbers from an xml file. I can get the names just fine but I can't get the phone numbers worked out. I am able to get all the phone numbers for the first name, but the same numbers are returned for all the other names (I'm not incrementing to the phone...

I have a textbox on a report and have set its control source equal to a value returned by a Dlookup. I run the report and it works fine. I would like to use the value returned in the text box to determine the control source for another text box. I've placed a select case in the print event of...

Is there any straightforward way of having report elements align vertically rather than horizontally? For example, I would like each record in my details section to be a "column" as opposed to a "row." I guess I'd consider any not so straightforward suggestions as well. Thanks for any thoughts.

I have 2 text boxes on a report. I am using a DLookup on the first text box to get a value. I would like to consider this value when determining the control source for the second text box. I thought I would do a select case on the first text box, in the report open event, to do this but get...

I'm not sure how exactly to ask this, but here goes... I have a data entry form that I would like to populate with text boxes based on information from a table. Basically if there is a value in the field in the table I would like to add text box to a form, if no value don't add a text box. So...

I am trying to group addresses on a report. I have a few addresses that have apartment numbers so I'm trying to concatenate the apartment number to the address so each apartment is grouped separately on the report. I am using "=[ADDRESS] & " " & [APTNUM]" as the control source but everything...

I am trying to count the number of occurrences of particular values for a specific year. I was thinking of trying something such as: 2008: Count([TYPE]) WHERE [YEAR] = 2008 Obviously, WHERE isn't available to me. I've been trying to do this with DLookUp but I just can't seem to get it...

Is there a way to allow an Enter in a textbox as opposed to an enter tabbing to the next control? I'm hoping for Ctl + Enter functionality with just the Enter.

I have a query that includes [NAME], [INCIDENT] and [CLASS]. Can anyone show me an example of doing a query that would give me a count of unique incidents by unique name? For example, my data might look like this: NAME INCIDENT CLASS TIM 1 x...

I have a 2 queries set up each with identical field names, one that returns 110 records and the other that returns 207 records. I have set up a 3rd union query that looks like "SELECT * FROM Query1 UNION SELECT * FROM Query2;". This query return 315 records when I'm expecting 110 + 207. Is...

Pardon me if this is a simple question. I have a report that shows each occurrence for an address and I'm doing a count([address]) to get the total number of occurrences for each address. How can I filter the report so that it only shows the addresses and occurrences where the count > 1 (I...