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 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 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 have two forms, when the user has finished the data entry in the 1st form they click on a button which opens a second form, how do I save the data on the first form Onexit?

I have an ID field (Text Data Type) which has an input mask [00\-00\-0000;_ ]and a format [00-00-0000] but when I open the form the ID is displayed without the formatting. The formatting is applied only when I click the ID field on the form, how can i change this and set the formatting on the ID...

How do I reference the selection made on a drop down control? I have a drop down control with values AA,AH,AP and more If AA is selectedthen I want access to show more controls for data entry relevant to AA ANd if AH is selected then I want it to show controls relevant to AH etc, the drop...

I have two forms which include fields from a table. How do I connect the data from both forms to one table with one ID? I also have two forms that are used for data entry, how do I connect the data from both forms so they enter their data into the necessary tables?

I have a form with a product ID and subforms with other fields from the same table. I enter the ID in the main form but am not able to enter data into the fields in the subform. I get an error that the PK cannot be a null value. How do I link the subform to the form so that the ID I enter in the...

I keep getting the "Property Value is too large" when I add a description to a field in an existing table. The same error was resolved on another table by cutting four fields then saving then pasting them back into the table and saving again. I tried importing the entire DB into a new file...

can anyone tell me how do I get the ProductID value in one form to show on a different form when the second form is opened. i have two joined tables with ProductID as the PK on both. thanks

I have a string Myval and I it to be output on a form text field. How do I do it I tried [text7]= Myval but I am not getting any output in the field text7

Private Sub Paid_Click() Dim Vrbpaid As String If [Paid] = True Then Vrbpaid = 1 ElseIf [Paid] = False Then Vrbpaid = 0 End If [Paid] = Vrbpaid End Sub Can anyone tell me what the error is with this code? I keep getting Else without If error message. I have a check box...

I have two entities with aone to one relationship. Can I use 1 primary key for both tables? ie can the primary key in table a be the same (Store ID)as the primary key in table b (Store ID)? or do i need to define a unique primary key in each table

Can anyone help me? I have three forms product, customer and order. in the order form I have a combo box. I want the apropriate form to open based on the combobox selection. i.e. if customer is selected then the customer form should open and if the product is selected then the product table...

I have a list box with 5 items and need to design an option for a user to add a value that is not listed. How can I do this ? and how will the new fields be added to the table?

How do I get the YN field to return a 1 for Y (and not -1!!) and a 0 for N?