Search results

I'm trying to find a way to replace special characters (<, >, &, ', ") in my description field with the escape sequences, so I can use the newString in a string, that is later on use to generate a xml file. Const SpecialCharacters As String = "<,>,',&" 'modify as needed Dim myString As String...

Hi all, I have an issue regarding encoding in a XML file. I'm using czech letters like "Č, á, í"... inside a body tag of an XML and the error seems to occur whenever there are letters with acute or circumflex. I'm actually printing some text content into an xml file. Snippet of the code Dim...

Hello, I would like to export a XML file, on click event via button. When it exports I would like to show a pop up window, where to save the file to. Same when you want to save a file a picture online, it's shows you the file explorer. Is it possible with the ExportXML method? Here is how my...

Hello, is it possible to change the name of my table tag when I'm exporting an XML file through VBA? Exported file looks like this -<tbl_xm_ct> <ID>44</ID> <desc>pol 3</desc> <phone>111155</phone> </tbl_xm_ct> I want this -<xml_contacts> <ID>44</ID> <desc>pol 3</desc>...

Hello, so I'm trying to find a way to show data records from one table in my form List, but when the user changes something (e.g. adds or deletes a record) in that form, the changes (records) would be made in a different table and the first table would be without changes. Data in first table...

Hello, I have this problem in screenview when viewing my report. Sometimes when I scroll down and then scroll back up, the report header suddenly disappears or gets stuck in the middle (like just upper half of the report header is missing). THe report is showing lines with IDs from a query and...

Hello, I have this problem with my report, that opens a form when i choose a line. The form is later opened but at some point (randomly) it switches back to my report. The report has a time interval set and also a procedure event on timer. The procedure just has a me.requery in it. Can it be...

Hello, I have a form (form_student) with student's information where I want to create a button with "on click" event and it should delete the record of this student from my table (that's called tb_student). Snippet of my code If MsgBox("Delete this student?", vbYesNo + vbCritical +...

Hi, so I have this form, where I can choose from the option buttons and input date in textfields after that I click on the button "Show data" and it opens a query based on the filter I made on my form. Except after I get the data I can't go back to the previous form in the accde version...

Hello, I've searched this problem everywhere, but couldnt find any solution, that would help my case... I have a form, where in a frame with the option boxes i can choose either out or in data, by choosing the selected option i then click on a button, that has a code to export the data to...

Hello everybody! I'm new to Accessworld. My name is Tea and I'm beginner in programming, also working on projects in Access, but still getting to know access. Hope to learn few tricks and get more knowledge in Access here.:)

Hello, I'm trying to solve this problemfor a quite a while and still can't find solution for this. I have a form where in details are checkboxes (fixed, not fixed, in process,... ) placed that should be editable, but can't check any of them. Check boxes are Enabled and aren't locked. Edits are...