Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 66
Search took 0.02 seconds.
Search: Posts Made By: DavidCantor
Forum: Queries 10-01-2013, 09:40 AM
Replies: 1
Views: 357
Posted By DavidCantor
How to convert date format using SQL

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.
Forum: ASP and ASP.NET 01-28-2013, 12:22 PM
Replies: 0
Views: 5,179
Posted By DavidCantor
C#.net help

http://eileenslounge.com/images/spacer.gifhttp://eileenslounge.com/download/file.php?id=9252


when i run this code I get an error on line :


private void Form1_load(object sender,EventArgs...
Forum: General 12-01-2012, 04:01 PM
Replies: 8
Views: 4,287
Posted By DavidCantor
Re: decrypt access 2010 database

I have the password that encrypted the db, the problem is that it will not let me decrypt the db!
Forum: General 11-29-2012, 01:51 PM
Replies: 8
Views: 4,287
Posted By DavidCantor
Re: decrypt access 2010 database

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...
Forum: General 11-29-2012, 01:46 PM
Replies: 8
Views: 4,287
Posted By DavidCantor
Re: decrypt access 2010 database

the decrypt database does not show in the info window, there is only an encrypt button.
Forum: General 11-29-2012, 01:34 PM
Replies: 8
Views: 4,287
Posted By DavidCantor
decrypt access 2010 database

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...
Forum: Tables 11-26-2012, 08:14 AM
Replies: 1
Views: 533
Posted By DavidCantor
Data Validation using excel spreadsheet

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...
Forum: Forms 11-20-2012, 10:57 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Re: Y/N/Cancel message box

I am running 2010, I am unable to post db because the data is sensitive
Forum: Forms 11-20-2012, 10:52 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Re: Y/N/Cancel message box

I did a decompile now i get an error on this line:
error '438'
MsgBox Err.Descripton, vbExclamation, "Error #: " & Err.Number
Forum: Forms 11-20-2012, 10:07 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Forum: Forms 11-20-2012, 09:37 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Re: Y/N/Cancel message box

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
...
Forum: Forms 11-20-2012, 09:29 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Re: Y/N/Cancel message box

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
Forum: Forms 11-20-2012, 09:10 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
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...
Forum: Forms 11-20-2012, 09:04 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Re: Y/N/Cancel message box

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...
Forum: Forms 11-20-2012, 09:01 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
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
Forum: Forms 11-14-2012, 11:52 AM
Replies: 16
Views: 1,126
Posted By DavidCantor
Y/N/Cancel message box

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
...
Forum: Forms 11-14-2012, 09:26 AM
Replies: 5
Views: 801
Posted By DavidCantor
Re: Field value formating not showing on form

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
Forum: Forms 11-14-2012, 08:31 AM
Replies: 5
Views: 801
Posted By DavidCantor
Re: Field value formating not showing on form

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

That doesn't work
Forum: Forms 11-14-2012, 06:44 AM
Replies: 5
Views: 510
Posted By DavidCantor
Re: Update form on click

[QUOTE=Trevor G;1208169]If the data is on the first form is to be saved then when the form is closed it should automatically save to a table if the form is using the source control to that table, and...
Forum: Forms 11-14-2012, 06:43 AM
Replies: 5
Views: 510
Posted By DavidCantor
Re: Update form on click

what is the syntax to save the data?
Forum: Forms 11-14-2012, 06:38 AM
Replies: 5
Views: 510
Posted By DavidCantor
Update form on click

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?
Forum: Forms 11-13-2012, 10:14 AM
Replies: 5
Views: 801
Posted By DavidCantor
Field value formating not showing on form

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...
Forum: Forms 11-08-2012, 10:54 AM
Replies: 15
Views: 625
Posted By DavidCantor
Re: Drop Down list

This is what I have and it is not working for me
Private Sub ListSymbolSelect_Click()
Dim varFieldName As Variant

For i = 0 To Me.ListSymbolSelect.ListCount - 1
If...
Forum: Forms 11-08-2012, 10:04 AM
Replies: 15
Views: 625
Posted By DavidCantor
Re: Drop Down list

ok great,

Now I want Access to display only the controls that are relevant to the values selected by setting their visble property to true


can I just enter


dim varFieldname as...
Forum: Forms 11-08-2012, 09:48 AM
Replies: 15
Views: 625
Posted By DavidCantor
Re: Drop Down list

thanks,
how do I reference the values that are selected if there is more than one value?
Showing results 1 to 25 of 66

 
Forum Jump



All times are GMT -8. The time now is 01:54 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World