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 18 of 18
Search took 0.01 seconds.
Search: Posts Made By: pkaptein1
Forum: Access June 7th, 2005, 09:07 PM
Replies: 1
Views: 4,073
Posted By pkaptein1
Dynamic Datasheet Form Field Headings Wrong

In my parent form, I have two child subforms as follows: 1 is the subform employee header; it defaults to single form view. The second is the subform hours; it defaults to datasheet view and contains...
Forum: Access June 1st, 2005, 04:27 PM
Replies: 2
Views: 4,248
Posted By pkaptein1
Hi RU1, Thanks for your response! Just to...

Hi RU1, Thanks for your response! Just to clarify, the parent form does not change; it acts merely as a way to link the two subforms together via an employeeID field. The change should occur in the...
Forum: Access June 1st, 2005, 02:40 PM
Replies: 2
Views: 4,248
Posted By pkaptein1
Refresh datasheet-view subform’s column headings f

In my parent form, I have two child subforms as follows: 1 is the subform employee header; it defaults to single form view. The second is the subform hours; it defaults to datasheet view and...
Forum: Access May 31st, 2005, 08:08 AM
Replies: 2
Views: 2,135
Posted By pkaptein1
Dear mmcdonal, This was a reply; I deleted my...

Dear mmcdonal, This was a reply; I deleted my question as I found the solution but the below person must have seen the question before I deleted it. The issue is resolved. Thank you.
Forum: Access May 28th, 2005, 09:49 AM
Replies: 5
Views: 7,605
Posted By pkaptein1
Thanks rjweers aka Randall! I'll try this...

Thanks rjweers aka Randall! I'll try this solution now; you've really been saving my skin on this project which is obviously way over my skill level and which I'd never survive without generous...
Forum: Access May 26th, 2005, 09:08 AM
Replies: 5
Views: 7,605
Posted By pkaptein1
Hi rjweers, If you have a moment, I've responded...

Hi rjweers, If you have a moment, I've responded to some of your comments (my responses are in bold) and would be interested in your follow-up thoughts.

"Perhaps you could use the WhereCondition...
Forum: Access May 25th, 2005, 11:21 PM
Replies: 5
Views: 7,605
Posted By pkaptein1
GoToRecord Error using VBA tied to Command Button

The below vba code successfully duplicates records in a table and properly refreshes the subform tied to the table via query) with the dup records in the requested alpha order. However, it errors at...
Forum: Access May 25th, 2005, 11:34 AM
Replies: 7
Views: 4,141
Posted By pkaptein1
Again, thanks rjweers for the solution that is...

Again, thanks rjweers for the solution that is now actually working! I resolved the minor vba error I received just now, so all is well, at least for now!

Regards,
Patty:D
Forum: Access May 25th, 2005, 10:15 AM
Replies: 7
Views: 4,141
Posted By pkaptein1
Thanks rjweers, aka Randall. I'm using your...

Thanks rjweers, aka Randall. I'm using your solution again. I've run across a new, related issue and if you have a chance to comment on that one, I'd appreciate it greatly! So far, you've been a...
Forum: Access May 10th, 2005, 12:57 PM
Replies: 1
Views: 873
Posted By pkaptein1
Automate assigning the values from one table’s tex

I have a table called Codes where one field contains codes and the second field contains the code descriptions:

Table Name: tblCodes
Fields:

CODE: string aka char aka text
CODE_DESCRIPTION: ...
Forum: Access May 10th, 2005, 12:42 PM
Replies: 7
Views: 4,141
Posted By pkaptein1
hi mmcdonal or anyone else who might want to...

hi mmcdonal or anyone else who might want to tackle this monster: first, thank you so much for trying to help so far!! Please pardon my newbie confusion but I don't know what you mean (mmcdonal)...
Forum: Access May 4th, 2005, 05:02 PM
Replies: 3
Views: 2,010
Posted By pkaptein1
What is the table structure behind the...

What is the table structure behind the form/subform?

There is a Parent Form, a child subform, and a second child subform. The parent form is only there to tie together the two children and...
Forum: Access May 4th, 2005, 04:45 PM
Replies: 7
Views: 4,141
Posted By pkaptein1
mmcdonal, Thank you for your response. ...

mmcdonal,

Thank you for your response.

Just to clarify, the users are not using datasheet view the way you might think. They are using form view but in properties under the format tab, their...
Forum: Access May 4th, 2005, 05:36 AM
Replies: 7
Views: 4,141
Posted By pkaptein1
Subform allows end-user to make duplicate record

I have a subform that will appear to the end-user in a datasheet view
so that she may hide/unhide columns at will. When opened, this form
will contain over 800 records appearing alphabetically by...
Forum: Access May 4th, 2005, 04:32 AM
Replies: 3
Views: 2,010
Posted By pkaptein1
Form's combo text box selection drives pull of a s

I have a subform that must default to a datasheet view so that the end-user may hide and un-hide columns at will. The structure of this subform should be that when the form opens, there is no actual...
Forum: Access May 3rd, 2005, 11:56 AM
Replies: 6
Views: 5,067
Posted By pkaptein1
To rjweers aka Randall: After spending an entire...

To rjweers aka Randall: After spending an entire weekend trying to find a solution to this problem, with very complex advice from many experienced programmers, I think you solved it for me :) with a...
Forum: Access May 1st, 2005, 03:03 PM
Replies: 6
Views: 5,067
Posted By pkaptein1
Randall, Thank you for this solution and at one...

Randall, Thank you for this solution and at one point I had been thinking along those lines; however, this dynamic form will also have a subform in it which must be viewed in form view rather than...
Forum: Access April 30th, 2005, 08:36 PM
Replies: 6
Views: 5,067
Posted By pkaptein1
Create Dynamic Form; end-user adds/drops columns

In forms I've customized for clients in the past, I've always placed each static field label in the form's header with corresponding variable table data in the form's detail. A current client...
Showing results 1 to 18 of 18

 


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


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