Search results

Thanks, that's getting me close. Is there any way for me to determine what the character code is for a particular offending character? I added a couple lines of code (shown below) but a particular character is not being removed and still causing me problems. I've also attached a screen shot...

I think this snippet of VB.NET will do it, is anyone better than I am at converting to VBA? Public Shared Function RemoveIllegalXMLCharacters(ByVal Content As String) As String 'Used to hold the output. Dim textOut As New StringBuilder() 'Used to reference the...

The illegal character appears to be a  (a small box, not sure how to otherwise describe it). I'm still trying to track down an effective way of eliminating these characters. Ideally, perhaps a function that takes an xml file as input, finds an offending xml character and replaces it with a...

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

That led me to where I want to be. Thank you!

I don't think I'm trying to do any of those things. I simply want to see a list of both fields in both tables in the same simple query (maybe an append query, but I don't want to necessarily create a new table). So, for example, if there are 5 records in table 1 and 5 records in table 2 my...

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?

Maybe I'm misunderstanding. For Each individualcontact In contactlist gives me a type mismatch.

I am using: For Each item In individualcontact For Each phonenumber In individualcontactnumber ............. Next Next It is returning each contact (as I expect) and each number for the first contact but it returns the phonenumbers for the first contact for every contact, it's...

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.

Would there be any reason not to do what I'm trying to do with a form as opposed to a report? I copied all the controls and pasted them on to a new form and everything I'm trying to do in a report works just fine. I'm not sure I want to mess around trying to get this report to work if I can...

If I set the control source of text box 1 to "=DLookup("Description", "Self_Directed_Activity_Table", "ActivityCode=" & (DLookup("SD1", "District_Priority_Table", "Beat='" & Left([Beat].Value, 2) & "'")) & "")" the value of text box 1 is what I expect. If I then switch up my select case from...

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

Thanks Bob, That works perfectly. Andy

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

Perfect. Thank you DK!