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 | Calendar | 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 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,751
Posted By cpopham
Okay thanks....

Okay thanks....
Forum: Access VBA December 23rd, 2003, 12:43 PM
Replies: 2
Views: 3,554
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,751
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,316
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,485
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,078
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,316
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,403
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,385
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,403
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,403
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,403
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,403
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,403
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

 


All times are GMT -4. The time now is 05:59 AM.


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