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 25 of 126
Search took 0.02 seconds.
Search: Posts Made By: lryckman
Forum: Access VBA November 3rd, 2010, 04:13 PM
Replies: 0
Views: 1,132
Posted By lryckman
Select records & insert to a table

Hi all!

Here is what I want to do. I have an unbound form with fields for the user to list filter requirements. Then I want to open a form displaying the results of the filter. The...
Forum: Access VBA October 16th, 2009, 02:22 PM
Replies: 1
Views: 1,026
Posted By lryckman
Adding many records of e-mail addresses to an e-mail

UGH! I am having a time with this one. Any help would be much appreciated.

I am working on a Supplier Address book that will contain 300+ contacts and be utilized for mass mailings.

End Goal:...
Forum: Access VBA October 12th, 2009, 08:52 AM
Replies: 3
Views: 1,695
Posted By lryckman
Red face lol! I went back and looked after reading your...

lol! I went back and looked after reading your reply and sure enough, I was missing quotes in my select statement of the query using the Concatenate function!

Thanks!!!
Forum: Access VBA October 9th, 2009, 04:28 PM
Replies: 3
Views: 1,695
Posted By lryckman
Concatenate help

Hello!
I have the below code that I am getting an error
"Run-time error '-2147217904 (80040e10)':
No value given for one ore more required parameters."

I use this same code in another...
Forum: Access VBA April 21st, 2009, 11:36 AM
Replies: 9
Views: 2,061
Posted By lryckman
I have tried all three...I get the same error on...

I have tried all three...I get the same error on each of them. Then I tried the following:

SELECT DISTINCT s1.CCNNumber, STUFF
((SELECT ',' + s2.PartNumber
...
Forum: Access VBA April 21st, 2009, 11:20 AM
Replies: 9
Views: 2,061
Posted By lryckman
Ok...getting closer! I tried creating a view...

Ok...getting closer!
I tried creating a view using the top example and it was automatically changed (formatted) to this:

SELECT DISTINCT s1.CCNNumber, STUFF
((SELECT...
Forum: Access VBA April 21st, 2009, 10:43 AM
Replies: 9
Views: 2,061
Posted By lryckman
Ok...I got the results I wanted (thank...

Ok...I got the results I wanted (thank you!)...but how do I get that linked to Access or as a view in the database? When I tried to save the query, it does not let me save it within the database on...
Forum: Access VBA April 21st, 2009, 09:57 AM
Replies: 9
Views: 2,061
Posted By lryckman
I want to put this into a view on our SQL Server...

I want to put this into a view on our SQL Server 2005 database. Then I link the views to Access as a linked table. The Query Designer that I'm using looks similar to the design view of a query in...
Forum: Access VBA April 21st, 2009, 08:31 AM
Replies: 9
Views: 2,061
Posted By lryckman
Creating a view (Access Front end/SQL Back end)

Hello!
I posted this on the SQL Server 2005 forum too, but the reply was a link to another website that was WAY above my head! [:o]

I am trying to create a view using the Query Designer in...
Forum: SQL Server 2005 April 20th, 2009, 02:23 PM
Replies: 1
Views: 685
Posted By lryckman
Query Designer Help

Hello!
I am trying to create a view using the Query Designer in Microsoft SQL Server Management Studio Express and do not know how to accomplish it. I need it based off of another view with columns...
Forum: Access VBA April 14th, 2009, 04:39 PM
Replies: 5
Views: 4,989
Posted By lryckman
Yes, the CAN SHRINK & CAN GROW properties are set...

Yes, the CAN SHRINK & CAN GROW properties are set to 'Yes' in both the subreport and report.
Forum: Access VBA April 14th, 2009, 04:04 PM
Replies: 5
Views: 4,989
Posted By lryckman
No, unfortunatly it will not shrink that section...

No, unfortunatly it will not shrink that section even though the can shrink setting is 'Yes'.
BTW...the subreport is the only item in the footer of a grouping on the report. Would that matter?
Forum: Access VBA April 13th, 2009, 02:26 PM
Replies: 5
Views: 4,989
Posted By lryckman
report with growing sub-report

I have a report that contains a continuous subreport. The property of the subreport is set as 'yes' for can grow...but is it possible to specify a limit on growth? I do not want a big empty space if...
Forum: Access VBA April 9th, 2009, 08:12 AM
Replies: 7
Views: 1,380
Posted By lryckman
Everyone's help is much appreciated. This is...

Everyone's help is much appreciated. This is working correctly now allowing the user to cancel out of the loop.

Thank you!
Laura
Forum: Access VBA April 7th, 2009, 04:50 PM
Replies: 7
Views: 1,380
Posted By lryckman
InputBox with Loop issue

Hello!
I have a slight issue...I have the code below, but if the user clicks on the cancel button, it will not cancel out of the loop...I can't remember how to fix this...any ideas?


Dim...
Forum: Access May 2nd, 2008, 07:47 AM
Replies: 5
Views: 359
Posted By lryckman
Hello all! I have similar issues, but no...

Hello all!

I have similar issues, but no resolution for them. Mine has progressed to printing issues across all office programs on my PC, but other users only face this within Access. Ours is...
Forum: Access February 25th, 2008, 09:04 AM
Replies: 4
Views: 1,260
Posted By lryckman
mmcdonal, Thank you so much for this...

mmcdonal,
Thank you so much for this information! I'll give this a try this week and let you know if I have any issues.


Regards,
Laura

FYI...My user id has changed. My old id was...
Forum: Access February 22nd, 2008, 12:22 PM
Replies: 4
Views: 1,260
Posted By lryckman
Mmcdonal, That is a good idea...Thanks! Do you...

Mmcdonal,
That is a good idea...Thanks! Do you happen to know if there is a line of code that will check the system files to see what Country or time zone their PC is set up as? That way I can use...
Forum: Access February 20th, 2008, 11:24 AM
Replies: 4
Views: 1,260
Posted By lryckman
Report print set-up

Hello all!
I have a report that automatically prints for the user. The problem is that our group in Europe uses a different size of paper. Is there a way to customize the Docmd.OpenReport command...
Forum: Access January 22nd, 2008, 08:11 AM
Replies: 1
Views: 1,115
Posted By lryckman
Eventhough this was a very odd issue...I am no...

Eventhough this was a very odd issue...I am no longer experiencing these problems. An update that I installed yesterday must have eliminated this. Incase anyone else looks for help on this same...
Forum: Access January 17th, 2008, 05:09 PM
Replies: 1
Views: 1,115
Posted By lryckman
Outlook contacts to Access

Hello all!

I have linked the Contacts from Outlook to an Access table...but the e-mail addresses do not show up. The e-mail addresses show up fine from Outlook, and I have gone back and forth...
Forum: Access January 8th, 2008, 10:31 AM
Replies: 11
Views: 2,749
Posted By lryckman
Mateen, I don't know if this will help...I have...

Mateen,
I don't know if this will help...I have not used Vista or MS Office 2007...but I guess anything is worth a try when working on newer software and operating systems.

(I obtained this...
Forum: Access January 7th, 2008, 04:41 PM
Replies: 7
Views: 1,537
Posted By lryckman
I have set the object permissions...but I don't...

I have set the object permissions...but I don't think I can actually do what I am wanting with out placing an exception in the code. Here is the On Load event code...


Private Sub Form_Load()
...
Forum: Access January 7th, 2008, 04:23 PM
Replies: 7
Views: 1,537
Posted By lryckman
I'm not sure that I understand how the wizard...

I'm not sure that I understand how the wizard will help me. I already have the .mdw file created and all the user accounts and groups are created already too. All the accounts have been assigned as...
Forum: Access January 7th, 2008, 03:40 PM
Replies: 7
Views: 1,537
Posted By lryckman
Sorry...I should have explained it a little...

Sorry...I should have explained it a little better.
It is the User-level workgroup .mdw file.
I have Access telling me the user ID for the Windows log in and for the workgroup file user log in, but...
Showing results 1 to 25 of 126

 




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