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 217
Search took 0.01 seconds.
Search: Posts Made By: Loralee
Forum: Access March 20th, 2008, 10:45 PM
Replies: 2
Views: 1,793
Posted By Loralee
Welcome, BJ Please post a bit more information:...

Welcome, BJ
Please post a bit more information:
A few things to check:
1) Is the form Read-only? If so, that is Access's behavior with unpopulated subforms.
2) Check the property sheet to...
Forum: Access December 19th, 2007, 10:26 PM
Replies: 1
Views: 706
Posted By Loralee
Hi Brendan, You can build a dialog form where...

Hi Brendan,
You can build a dialog form where the user chooses which report they want to open. (Such as using radio buttons).
Example:
1. OPtion 1 could be "View Client Report" (if selected the...
Forum: Access November 23rd, 2007, 12:51 AM
Replies: 1
Views: 2,173
Posted By Loralee
Welcome to P2P Mike- I assume that cboList's...

Welcome to P2P Mike-

I assume that cboList's data type is text. If so, concatenate another single quote into the first string and one after [cboList].
...
Forum: Access November 12th, 2007, 07:41 PM
Replies: 3
Views: 5,783
Posted By Loralee
When you say "index key" I am assuming you want...

When you say "index key" I am assuming you want to add a new field and make it the primary key. To do so, open the database window, click on "tables" (on the left of the window) and select the...
Forum: Access November 12th, 2007, 04:32 PM
Replies: 3
Views: 5,783
Posted By Loralee
Welcome to the Forum, Paul, What version of...

Welcome to the Forum, Paul,

What version of Access is your inventory written in?
Forum: Access October 30th, 2007, 11:48 PM
Replies: 2
Views: 1,992
Posted By Loralee
Did you try the On Open event for the subreport? ...

Did you try the On Open event for the subreport? (Go to the Report Property Sheet for the Subreport. The first time you click on the subreport in design view you get the subreport properties, the...
Forum: Access October 26th, 2007, 12:10 PM
Replies: 2
Views: 1,915
Posted By Loralee
Lisa, I tried looking up the order of events...

Lisa,
I tried looking up the order of events for a subreport but could not find when the subreport loads in relation to the main report. If it were a form, the subform loads before the main form. ...
Forum: Access October 24th, 2007, 07:38 PM
Replies: 5
Views: 8,315
Posted By Loralee
Lisa, Are you using a dialog form to capture...

Lisa,

Are you using a dialog form to capture the user's parameter? You could try capturing their selection (to capture PHACode- probably from a combo box), drop that into a variable (ie:...
Forum: Access September 2nd, 2007, 01:58 PM
Replies: 5
Views: 11,903
Posted By Loralee
Hi Enas: Do you have an opening screen or...

Hi Enas:

Do you have an opening screen or splash screen for your app? You could put the calling code in it's load event.
(Dim blRet As Boolean

blRet = MouseWheelOFF)

If you have an...
Forum: Access August 30th, 2007, 10:02 PM
Replies: 3
Views: 1,250
Posted By Loralee
OOps- hit the tab key! Welcome, Don, ...

OOps- hit the tab key!

Welcome, Don,

Here is an example from Thomson's New Perspectives in Access:

1) code example to change the bypass key is available in Access VBA help. Search for...
Forum: Access August 30th, 2007, 09:34 PM
Replies: 3
Views: 1,250
Posted By Loralee
Welcome, Don, Here is an example from...

Welcome, Don,

Here is an example from Thomson's New Perspectives in Access:
1) code example to change the bypass key is available in Access VBA help. Search for "allowbypasskey property"
2) ...
Forum: Access August 9th, 2007, 08:58 PM
Replies: 1
Views: 8,158
Posted By Loralee
I have had the same issue come up with 2K. When...

I have had the same issue come up with 2K. When I am using my system with Office Development Edition, I can add the DateTime Picker control and use it. When I work on a machine (Same file) and add...
Forum: Access August 6th, 2007, 10:30 AM
Replies: 4
Views: 1,306
Posted By Loralee
Are ALL the user's running a full copy of Access...

Are ALL the user's running a full copy of Access or are some running under a runtime license?

Are ALL running Access 2003?
Forum: Access July 16th, 2007, 07:05 PM
Replies: 3
Views: 2,430
Posted By Loralee
Office Development Edition comes with a Package...

Office Development Edition comes with a Package and Deployment wizard that allows you to create an installation package that contains your MDB and any dependent files. Once you run the Wizard you can...
Forum: Access July 14th, 2007, 10:42 AM
Replies: 3
Views: 2,430
Posted By Loralee
You cannot make an .exe from an Access MDB. ...

You cannot make an .exe from an Access MDB.

("Compile" for VBA code does not create an .exe.)

If you want to distribute your MDB to users who do not have a full copy of Access on their systems...
Forum: Access May 2nd, 2007, 08:05 PM
Replies: 2
Views: 4,344
Posted By Loralee
When it blows up has the user populated...

When it blows up has the user populated cmbManOrVol with either Man or Vol?
Forum: Access April 30th, 2007, 08:04 PM
Replies: 7
Views: 1,194
Posted By Loralee
Bryan, A few thoughts: "just figured that it...

Bryan,
A few thoughts:
"just figured that it could also be done through the main form where most information / all information will be done. That's why I wanted it to double-click, open the...
Forum: Access April 29th, 2007, 11:14 AM
Replies: 7
Views: 1,194
Posted By Loralee
Bryan, Another thought that adds on a means...

Bryan,

Another thought that adds on a means of handling new contacts to what I described: You could add a "New" button that would open a frmContact (to populate tblContact with firstname,...
Forum: Access April 28th, 2007, 07:14 PM
Replies: 7
Views: 1,194
Posted By Loralee
Bryan, So you want to record which contact...

Bryan,

So you want to record which contact person for each Task? How about if you make that Contact text box a combobox that is populated with the contact names? This eliminates a few of the...
Forum: Access April 18th, 2007, 08:56 PM
Replies: 3
Views: 844
Posted By Loralee
Bryan, One way to do this: You could make the...

Bryan,
One way to do this: You could make the form unbound. Then, give the user a button to "Save" their entries. When the record saves, your autonumber field will increment and populate. You...
Forum: Access April 13th, 2007, 03:27 PM
Replies: 5
Views: 1,026
Posted By Loralee
Sorry Paul, I missread what you said. ...

Sorry Paul, I missread what you said.

Taking a quick look at your SQL it looks like the parenthesis are all there. Can you confirm item by item that each field is spelled correctly and exists...
Forum: Access April 13th, 2007, 02:41 PM
Replies: 5
Views: 1,026
Posted By Loralee
Yeh, SOMETHING is probably misspelled or missing...

Yeh, SOMETHING is probably misspelled or missing in here then. It can't find it so your combo box then WILL be empty.

How did you make your combo box?

What are T_SetupSheetCombinationsDetail,...
Forum: Access April 13th, 2007, 02:22 PM
Replies: 5
Views: 1,026
Posted By Loralee
Paul, What is the record source for the...

Paul,

What is the record source for the combobox? (Go to the Data Tab on Properties)?
Forum: Access April 6th, 2007, 10:08 AM
Replies: 3
Views: 991
Posted By Loralee
Bob, Not exactly what you are asking for, but...

Bob,
Not exactly what you are asking for, but Lebans has an add in that will allow you to change the color of the ACTIVE TAB only. Find it here:

http://www.lebans.com/tabcolors.htm

HTH,...
Forum: Access March 2nd, 2007, 11:43 AM
Replies: 4
Views: 1,328
Posted By Loralee
What is the relationship between tblMain and...

What is the relationship between tblMain and tblWorked? Is Referential Integrity with cascade deletes and cascade updates enforced? If so, try deleting from the child table (suspect it's tblWorked)...
Showing results 1 to 25 of 217

 




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