Search results

I need to convert the date format October 10th, 2013 to 10/01/2013 in a field using sql in access 2010, I know it has to be an update query but dont know how to start writing the query.

when i run this code I get an error on line : private void Form1_load(object sender,EventArgs e) error is on void Expected class, delegate, enum, interface or struct what does this mean?

I have the password that encrypted the db, the problem is that it will not let me decrypt the db!

I encrypted the database, I know this because previous versions of the database have the decrypt option in the info window. the newer version only has encrypt and when I type a new password I get an error not a valid password.

the decrypt database does not show in the info window, there is only an encrypt button.

I encrypted a access 2010 database and want to remove the encryption, I open the database in exclusive mode and enter the old password but there is no option to decrypt database. Please can anyone help me?

How can I validate data using an excel spreadsheet? i have a table with Product information, I want only the ProductId that are in the spreadsheet to be used in the database. How can I check the ProductID entered in the form actually exists in the excel spreadsheet?

I am running 2010, I am unable to post db because the data is sensitive

I did a decompile now i get an error on this line: error '438' MsgBox Err.Descripton, vbExclamation, "Error #: " & Err.Number

none at all!!!

Private Sub BtnStartAgain_Click() ' Make sure that there is a Product_ID If IsNull(Me.Product_ID) Then MsgBox "Please create a new record in this form first!", vbExclamation Exit Sub End If 'Save current record if necessary If Me.Dirty Then...

I get error Run Time Error '438' - Object doesnt support this property or method Debug takes me to thie line: MsgBox Err.Descripton, vbExclamation, "Error #: " & Err.Number

Re: Y N Cancel message box help i get an error on this line : Private Sub BtnGoToSymbol2_Click() ' Make sure that there is a Product_ID If IsNull(Me.Product_ID) Then MsgBox "Please create a new record in this form first!", vbExclamation Exit Sub End If...

this is what the error is referencing Private Sub BtnGoToSymbol2_Click() ' Make sure that there is a Product_ID If IsNull(Me.Product_ID) Then MsgBox "Please create a new record in this form first!", vbExclamation Exit Sub End If 'Save current record if...

Y N Cancel message box help Does anyone know how I can get a generic YNCAncel message box? I have seen a generic Y N message box on the microsoft website that works in any form, but I need a Y N Cancel thanks

I am trying to code a y/n/cancel message box, the yn works but the cancel gives me an error Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim iResponse As Integer ' Specify the message to display. strMsg = "Do you wish to save the changes?" & Chr(10)...

I created a label and the caption is the ID but the caption doesnot show the mask it just shows the numbers without the formatting

when you say at the end of my code you mean like this? Forms!frmProductIcon2!LblpID.Caption 00\-00\-0000;_? That doesn't work

what is the syntax to save the data?