Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 24 of 24
Search took 0.01 seconds.
Search: Posts Made By: SunnySide
Forum: Access October 2nd, 2012, 09:51 AM
Replies: 0
Views: 6,865
Posted By SunnySide
Talking Run Time Error 2683 "There is no Object in this Control"

I have a group that upgraded to 2010. This code has never been an issue until now. They have a database that uses date functions, and we are getting this error. Run Time Error 2683 "There is no...
Forum: Access February 10th, 2012, 03:32 PM
Replies: 10
Views: 1,759
Posted By SunnySide
Just wanted to let you know I was able to get...

Just wanted to let you know I was able to get this working...There's not a good answer to put as to why. I played with the code for quite some time, and its working. Wish I could have had a better...
Forum: SharePoint Development January 31st, 2012, 01:25 PM
Replies: 0
Views: 1,582
Posted By SunnySide
linking and exporting to sharepoint

Can anyone help on an issue I'm having with the link of a table from MS Access to Sharepoint. Continue running into the issue where the autopopulated number in sharepoint duplicates the records. Has...
Forum: Access January 27th, 2012, 02:03 PM
Replies: 10
Views: 1,759
Posted By SunnySide
I just wanted to let you know I was pulled off of...

I just wanted to let you know I was pulled off of this for now. I'll come back to it as soon as I can.
Forum: Access January 23rd, 2012, 02:51 PM
Replies: 10
Views: 1,759
Posted By SunnySide
When it errors it highlights the "db.Execute...

When it errors it highlights the "db.Execute mySQL, dbFailonError"


My understanding is the immediate window provides the code it's questioning and places a correct version. I copy pasted the...
Forum: Access January 19th, 2012, 01:51 PM
Replies: 10
Views: 1,759
Posted By SunnySide
I did and everything is still the same. No...

I did and everything is still the same. No difference.
Forum: Access January 18th, 2012, 10:42 AM
Replies: 10
Views: 1,759
Posted By SunnySide
Okay I see where you added spaces.....I've added...

Okay I see where you added spaces.....I've added your code to the VBA Module (I know it says SQL, but it's VBA in Access) and it errors on db.Execute mySQL, dbFailonError

And when I look at the...
Forum: Access January 17th, 2012, 01:19 PM
Replies: 10
Views: 1,759
Posted By SunnySide
Could someone help with a RunTime Error

I'm trying to write new code. I have to admit I've never been in traditional training...can you tell me what I'm doing wrong?

thanks!


Function AppendCBNR()
On Error GoTo m_Err
Dim mySQL As...
Forum: Access January 12th, 2012, 04:46 PM
Replies: 1
Views: 1,660
Posted By SunnySide
RunTime Error 3075 - Invalid use of '.' , '!', '()'

I have looked this over and over and couldn't seem to find anything....can someone else take a look at this and let me know if you see anything that shines light on why I'm getting this Error?

...
Forum: Access January 10th, 2012, 10:59 AM
Replies: 0
Views: 854
Posted By SunnySide
Error Data Source object is Already Intialized

--------------------------------------------------------------------------------

The code to the error is -2147217838(80040e52) Not sure if that gives you any additional information.

It...
Forum: Access January 10th, 2012, 10:45 AM
Replies: 0
Views: 656
Posted By SunnySide
Error Data Source object is Already Intialized

--------------------------------------------------------------------------------

The code to the error is -2147217838(80040e52) Not sure if that gives you any additional information.

It...
Forum: Access VBA January 10th, 2012, 10:01 AM
Replies: 0
Views: 882
Posted By SunnySide
Has anyone worked with an Error Data source object is already intialized?

The code to the error is -2147217838(80040e52) Not sure if that gives you any additional information.

It happening on a comand.
The VBA that's highlighted to debug is Active connection =...
Forum: Access VBA November 17th, 2011, 03:40 PM
Replies: 0
Views: 1,443
Posted By SunnySide
Run Time Error - 3052

I have a module that is creating a Run Time Error.



Public Sub TrimZeroesPayments()

Dim rec As DAO.Recordset
Dim lngLoop As Long
Dim lngCount As Long
Dim strData As String
Forum: Access VBA November 17th, 2011, 11:20 AM
Replies: 2
Views: 1,204
Posted By SunnySide
That works!!!! Thanks so much!

That works!!!! Thanks so much!
Forum: Access VBA November 16th, 2011, 03:29 PM
Replies: 2
Views: 1,204
Posted By SunnySide
How to keep a path unbroken in VBA?

I have the Code:
Dim stAppName As String

stAppName = ("C:\Program Files\Microsoft Office\Office12\EXCEL") & " " & "\\Directory\Finance\filename\Database" & " " & "Tools\Drop" & " " &...
Forum: Access VBA November 15th, 2011, 02:39 PM
Replies: 13
Views: 1,843
Posted By SunnySide
Okay....I think I figured out why this wasn't...

Okay....I think I figured out why this wasn't working.

I entered a Default Value - Now(), but when I created a second column in the MonthDate table and entered Dates in there it worked. I believe...
Forum: Access VBA November 15th, 2011, 02:19 PM
Replies: 13
Views: 1,843
Posted By SunnySide
I'm sorry I can see why your confused. I am not...

I'm sorry I can see why your confused. I am not using SQL, only VBA in Access. I have a new database with one table that has the current date in a cell.

I created a table named MonthDate took off...
Forum: Access VBA November 15th, 2011, 01:48 PM
Replies: 13
Views: 1,843
Posted By SunnySide
How do I find " DAO or ADO libraries in VBA...

How do I find " DAO or ADO libraries in VBA "?
Forum: Access VBA November 15th, 2011, 01:45 PM
Replies: 13
Views: 1,843
Posted By SunnySide
What do you mean by "specific VBA Code"? would it...

What do you mean by "specific VBA Code"? would it be different than the code I gave?
Forum: Access VBA November 15th, 2011, 01:35 PM
Replies: 13
Views: 1,843
Posted By SunnySide
I tryied to paste the table in, but it wouldn't...

I tryied to paste the table in, but it wouldn't copy over. The first column is CurrMonth with the date provided in that column, the second column is PriorMonth with nothing in the row.
Forum: Access VBA November 15th, 2011, 01:33 PM
Replies: 13
Views: 1,843
Posted By SunnySide
I'm sorry to confuse things. I put those slashes...

I'm sorry to confuse things. I put those slashes in when I typed the message. It doesnt' have them in the code. I am running a query. When I execute the query the value brings back:
CurrMonth ...
Forum: Access VBA November 15th, 2011, 12:51 PM
Replies: 13
Views: 1,843
Posted By SunnySide
I just wanted to let you know I will get a date...

I just wanted to let you know I will get a date for the CurrMonth Field, which comes from anther table. I don't get anything back on the formula in the PriorDate Field.
Forum: Access VBA November 15th, 2011, 12:47 PM
Replies: 13
Views: 1,843
Posted By SunnySide
That would be great. Thanks. the actual VBA...

That would be great. Thanks.

the actual VBA that I am trying to run is more complicated, so I wanted to simplify it as much as possible to see if I was doing something wrong. So this is what I...
Forum: Access VBA November 15th, 2011, 12:31 PM
Replies: 13
Views: 1,843
Posted By SunnySide
New employee: Access qry won't bring back value?

i just started working for another company, and I have learned Access from using it. This has stumped me.

I am trying to do a simple formula: Month(Date).
But the value won't show. I was...
Showing results 1 to 24 of 24

 


All times are GMT -4. The time now is 11:04 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.