Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 14 of 14
Search took 0.01 seconds.
Search: Posts Made By: cpopham
Forum: Access VBA December 29th, 2003, 09:50 AM
Replies: 3
Views: 2,808
Posted By cpopham
Okay thanks....

Okay thanks....
Forum: Access VBA December 23rd, 2003, 12:43 PM
Replies: 2
Views: 3,670
Posted By cpopham
You will have to use a variable and pass the...

You will have to use a variable and pass the variable using Code.

I wrote this to insert a string into a table on the fly using a users input. You can adapt it for what you need. Or at least get...
Forum: Access VBA December 22nd, 2003, 10:27 AM
Replies: 3
Views: 2,808
Posted By cpopham
Form alignment

Does anyone know of a bit of code to align a form on open to the left and top of the screen?

Thanks, Chester
Forum: Access VBA December 9th, 2003, 10:27 AM
Replies: 2
Views: 13,746
Posted By cpopham
I got what I need thanks :) Example (in case...

I got what I need thanks :)

Example (in case anyone else ever needs it):
Dim strMonth As String
Dim strYear As String
Dim strMonthYear As String
strMonth = Month(Date)
strYear = Year(Date)...
Forum: Access VBA December 7th, 2003, 04:28 PM
Replies: 1
Views: 1,671
Posted By cpopham
ADO questions please help...

Okay, I am trying to connect to a Paradox table with Access 2002 and would like to use ADO to do it, but I am not to familiar with ADO and can not find many sources of very useful information on ADO....
Forum: Access VBA December 5th, 2003, 01:22 PM
Replies: 0
Views: 3,175
Posted By cpopham
ADO connecting to a Paradox 8.0 table

Can someone tell me what is wrong with my code?

Option Compare Database
Option Explicit

Dim aConn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sSql As String

Function TransferData()
Forum: Access VBA December 5th, 2003, 10:36 AM
Replies: 2
Views: 13,746
Posted By cpopham
Concatenate 2 variables into one?

I would like to know if it is possible to concatenate 2 variables into one?

Example:

Dim strTbl As String
Dim strDate As String
Dim strNewTable As String
strDate = CStr(Date)
strTbl = Tbl...
Forum: Access VBA December 4th, 2003, 04:24 PM
Replies: 8
Views: 8,753
Posted By cpopham
Okay thanks, either way, my goal is...

Okay thanks, either way, my goal is accomplished!!!:D
Forum: Access VBA December 4th, 2003, 04:15 PM
Replies: 1
Views: 4,463
Posted By cpopham
Check this site: ...

Check this site:
http://www.fontstuff.com/downloads/index.htm

He has a sample popup calender that may do just what you need!
Forum: Access VBA December 4th, 2003, 04:10 PM
Replies: 8
Views: 8,753
Posted By cpopham
Okay got the time figured out also thanks for all...

Okay got the time figured out also thanks for all the help. Somethings you think are simple and a couple of little porblems in the code will drive you nuts!!! :D
Forum: Access VBA December 4th, 2003, 03:46 PM
Replies: 8
Views: 8,753
Posted By cpopham
That worked great. Thanks for the help. :D One...

That worked great. Thanks for the help. :D One question though,
In my original code when I had the date as date() it inserted the date fine into the table, how come it worked that way, but after...
Forum: Access VBA December 4th, 2003, 02:49 PM
Replies: 8
Views: 8,753
Posted By cpopham
When I try double quotes in single quotes like...

When I try double quotes in single quotes like this;
"VALUES (Date(), '" & strSaveAs & "');"

I get this error message:
Invalid SQL Statement; 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or...
Forum: Access VBA December 4th, 2003, 11:43 AM
Replies: 8
Views: 8,753
Posted By cpopham
Thanks, I tried it that way, but the single...

Thanks,
I tried it that way, but the single quote behind the double quote made it a comment and gave me a syntax error.

I have also tried:
"VALUES (Date(), " & strSaveAs & ");"

But it still...
Forum: Access VBA December 4th, 2003, 11:32 AM
Replies: 8
Views: 8,753
Posted By cpopham
Access 2002 VBA with SQL using a variable

Hello everyone,

I am new to this forum. I can not seem to find an answer anywhere. I know that you can use a variable in vba with sql, however, this is my code:

Option Compare Database...
Showing results 1 to 14 of 14

 




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