I have been using Ms Access database for a long time and I have migrated my data to a MySql database. My data needs to be distributed to various locations and data entry can take place on slave sites or on the master. Is there a way a slave can upload data to a master without using mysql Cluster?
Garudzo
Garudzo
Last Activity: May 12 '12, 01:11 PM
Joined: May 23 '07
Location:
-
uploading data from a Msql slave to its Master
-
Garudzo started a topic Programatically setting the controlsource property of a summary field in a reportin AccessProgramatically setting the controlsource property of a summary field in a report
Hi all
I am dynamically creating a report in Access using a dynamic query. I use a record set to get the field names of a resulting query to set the controlsource property fields of the report fields and it works fine untill I wand to do the same for summary fields which are field4 and field5. These are displaying error in the report fields themeselves and not when I run the code any suggestions
...Code:If Not rs.EOF
-
How do I export an Access report to excel with its format.
When I export the labels are removed and the names of the texboxes are exported -
Listview control problem in Access 2007
I have a listview control on a form in office 2003 format. When I try to run the same form in 0ffice 2007 it does not run. After removing some declarations it runs but some propeties are not being accepted. The view property is refusing to display items in a report view
Please help -
I discovered that my back end database was sitting on a Machine with NTFS system it was a matter of setting the necessary permissions
Thanks for the support
Garudzo -
Record not updatable
I have split my access application into a back end and front end and installed the back end on a file server. When I connect to the backend and want to edit and update my files I get a message saying records are not updtatble. The shared folder on the server has permissions set to full control for everyone. -
Vertical text in Html
Hi out there
I want my column headers to be written vertically. I am using Visual Web Developer 2008 and when I tried to use the CSS priperty Writing-mode=tb-rl I get an error that says its not a CSS 2.1 valid property. Any suggestions -
Adding gridveiw row values
I am developing an application using the gridview. the last column is a total column I want to compare the typed in value to the sum of values in the rest of the cells. I tried to use custom validation but the textboxes that contain the values are not seen by the application below is my validation code
...Code:Protected Sub validateTotals(ByVal source As Object, _ ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) -
After filligng my datest called dsenrol I have the following code.
I have edited the grid colums and specified the fields I want to show in the grid....Code:GridView1.DataSource = DsEnrol GridView1.AutoGenerateColumns = "False" GridView1.DataKeyNames = New String() {"Institution_id", "Year_id", "field1"} GridView1.DataBind()Leave a comment:
-
Newvalues in a gridview
Hi Gurus
I have created a small application to load data into a gridview from a dataset. Now I want to update the data set but when I try to use the keys() and the newvalues() arrays they all do not contain any data. I am biding the gridview in code. How do I enable my gridview to populate the keys() and the newvalues collections in a gridview that i set properties programmaticall y. I am using vb.net -
Thanks for the advice but this assumes that I am doing the binding in code. In this case I just draged the control to a formview and set the databound property. Cant I do it without using code?Leave a comment:
-
Binding a Radiobuttonlist to a Database
I am binding a radiobuttonlist to a data field in a database. If the field has a null value my application produces an error maybe because the null value wont be an item in the radio button list. What I want is the radiobuttonlist not to check any value if it is not in the list Please Help -
After researching I have managed to find some code to locate the checkbox list control using the findcotrol method. However the control is only found when I load the form for the first time. If i switch between view and edit mode the control is not found. I am also not able to find similar checkboxlist controls in the edit and the insert templates of the formview control. I have posted another question with code and more details of what I intend...Leave a comment:
-
Find control problem
I am developing an application where I have identification details of a school and the education levels offered. All the other details go into one table and the levels go into another one. I have created a web form with a formview to view edit and insert data in these two tables. In form view I have bound all the controls with data that go into the details table and I have a I have three checkboxlist controls in each in the Itemtemplate, edittemplate... -
Programming the checkboxlist control
I am using the checkbox list control in an ASP.Net application. I have placed it in a formview itemtemplate. Now I want to reference it to load it with values from a database. In my aspx.vb code I am not able to reference this control. Any Idea on how I can do this? -
The echo [PHP]odbc_num_rows($ r) [/PHP] gives -1...Leave a comment:
-
It is not giving an error. Infact it was giving an error when I used double quotes to enclose my variables. I corrected that and put single quotes then its not giving any error and it does not give the correct result...Leave a comment:
-
Problems with ODBC_exec
I am connecting to a Microsoft Access via ODBC and I am connecting successfully. When I try to query a table using the SQL statement illustrated in my code I get no results even for values that are in the table. If I echo my query statement $q and put it in MS office IDE it gives me some results can anyone help?
[php]
$conn=ODBC_conn ect('Msc', 'user', 'password');
if ($conn)
{
$q = "
... -
Listview control Selected Items
Hi all
I am developning a small application in MS Access 2003 on a windows XP platform. I am using windows treeview and Listview controls. I have discovered that I can do a multi select of listview items but I cannot iterate through all selected items. the listview only has a selectedItem property and not selectedItems.
How do i iterate through the selected listview items?
Garudzo -
Iterating through nodes in a treeview in Ms Access 2003
Hi
I am trying to use the Windows treeview in a MS Access application. I want to iterate through child nodes of a particular node but i am failing to figure out how to do it. I have even tried the entire nodes using the following code but am getting an error
For Each objNode In Me.TreeView0.No des()
objTree.Nodes.A dd objNode.Key, tvwChild, "a" & Genkey, "Define...
No activity results to display
Leave a comment: