Search results

How can you differentiate append from update query? I was wondering how to update two databases, if it is proper to use append or update query?

while Replication or synchronization is not available in Access 2007, so how does one should synchronize records between two or more databases? My idea would be to have it done manually through query. any other ideas?

definitely synchronization is very helpful to update records between two or more databases. I have googled and researched about what code and if can be used in any version. And I have found these codes as attached: I am not very good at coding so maybe for the benefit of all, maybe someone...

is mysql administrator the same with mysqladmin? if not, where can I download mysqladmin, I cant seem to get mysqladmin in mysql.com is that is the right name.

me.textbox1.value=me.combox.column(2) will this code set the value of textbox1 to the value of column 2 of the combox ? is this proper?

yes I have tried to use that but nothing happened. I use that on OnPrint event. I have this code: Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) If Me.TT.Value = 1 Then Me.Detail.Visible = False End If End Sub I am correct to use the onprint event of the detail section?

good day! I would like to ask how to hide certain row record in the detail section of the report form if for example the value of the textbox is zero. I have not done this before so I have no idea. I have also googled it before I asked here but I cannot find exact information.

in access 2003 I can change the application background color to what I want. but it is not working in access 2007. the color is stuck in black, silver and blue.

ofcourse I have checked everything. actually I did not created the backend yet to eliminate possible error in the backend. the field is bound on the date field in the table I have not actually setup the mask type in the table so that it will acquire the format of the field in the form.

it says something about incorrect format. i dont remember the whole paragraph.

ok. but what about the error that appears after I input the date?

Hi, I have a question. my default format of date is base on the regional settings that is for example the regional setting for shortdate format is m/d/yyyy, then date would appear as for example 6/5/2009 but what I need was the format should be mm/dd/yy such as 06/05/09. yes we can set the...

it his choice. but as have been said, it is most advisable to modify his design inside his project and set aside the task manager idea.

Private Sub Form_load() If isnull([Date_Diarised])=true Then Add_Date.Enabled = False Else Add_Date.Enabled = True End If End Sub

I agree with atomic shrimp smd7m. you should change probably your design in your application. maybe there is some code that can be written for that but I dont. I dont discourage you. I have same question like this before in my mind when I design how to setup my project expiry date that will...

I think one of his reason would be, he wouldn't want anyone to shutdown the access program abruptly because he want that the access project that he have to be close procedurally because maybe there is a code behind to be executed before quitting ms access.

actually he or she doesnt know what he or she wants. basically it is possible to make the form float like an executable file and just hide the access application. its here in the forum somewhere i just dont remember where. :)

stay cool grandpa, it might not be best for your health if you burst your emotions to much.

NigelShaw what is that installer that you say?

windows folder permission? I have no idea? is it a software? or where can I find it? Please kindly direct me.