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 142
Search took 0.02 seconds.
Search: Posts Made By: kindler
Forum: Access October 31st, 2006, 04:12 PM
Replies: 4
Views: 1,502
Posted By kindler
From the look of it, you're duplicating data from...

From the look of it, you're duplicating data from the two tables Master Review & Master Account - Coverage by creating this Master Data Table. If you want my advice, get rid of that table entirely,...
Forum: Access October 31st, 2006, 04:05 PM
Replies: 7
Views: 1,405
Posted By kindler
Is there a general pattern to the registration...

Is there a general pattern to the registration numbers (and the rest of the data) that can be used to recognize one from the other? If you open the table that the un-normalized entries are in, and...
Forum: Access October 4th, 2006, 12:28 PM
Replies: 5
Views: 1,194
Posted By kindler
You should be able to prevent duplicate entries...

You should be able to prevent duplicate entries by setting your primary key to Subject & Subject2 in the table design area.
Forum: Access October 3rd, 2006, 12:13 PM
Replies: 5
Views: 1,194
Posted By kindler
I assume that there is some kind of action taken...

I assume that there is some kind of action taken once the Subject 1 & Subject 2 fields are selected, probably the display of a record somewhere? If so, what you do is set a Combobox for Subject 2 to...
Forum: Access September 12th, 2006, 09:01 AM
Replies: 2
Views: 1,189
Posted By kindler
Case sensitivity exists by default I think, if...

Case sensitivity exists by default I think, if you want to ignore it, use the UPPER() or LOWER() functions when doing comparisons.
Forum: Access August 30th, 2006, 03:11 PM
Replies: 7
Views: 1,909
Posted By kindler
You seem to have it pretty well under control. ...

You seem to have it pretty well under control. The code for the AfterUpdate on the 2nd event would be similar to:

strSection = Me.cboSection.Value
strQuestion = Me.cboQuestion.Value...
Forum: Access August 30th, 2006, 11:25 AM
Replies: 7
Views: 1,909
Posted By kindler
You can't use child/parent links to connect to a...

You can't use child/parent links to connect to a subform in that manner. You'd need to change the AfterUpdate event on the second combo box to change the RecordSource for the subform to a SQL string...
Forum: Access August 29th, 2006, 04:32 PM
Replies: 7
Views: 1,909
Posted By kindler
Assuming you have the info in one table with...

Assuming you have the info in one table with fields along the lines of Section | Question, set the After Update event on the ComboBox for Section to [Event Procedure], click the "..." button to the...
Forum: Access VBA August 25th, 2006, 10:22 AM
Replies: 1
Views: 2,840
Posted By kindler
Set up an "After Update" event in the text box...

Set up an "After Update" event in the text box properties to [Event Procedure], and click the ... button. The code you want in the procedure would be something like this, with the correct names...
Forum: Access August 22nd, 2006, 12:53 PM
Replies: 6
Views: 1,153
Posted By kindler
You might be better off using a ListBox.

You might be better off using a ListBox.
Forum: Access August 17th, 2006, 01:58 PM
Replies: 9
Views: 2,953
Posted By kindler
You could have the front end store just a text...

You could have the front end store just a text string as a Global containing the name. I don't know how you'd access the App Title though, so this would just be a hardcoded workaround assuming...
Forum: Access August 7th, 2006, 03:23 PM
Replies: 2
Views: 1,196
Posted By kindler
You'll need a table associating job types with...

You'll need a table associating job types with their prices, and then to use the DLookup function to pull that price into the form you're using. The examples here:...
Forum: Access VBA August 4th, 2006, 12:41 PM
Replies: 1
Sum
Views: 1,357
Posted By kindler
Could you post the table structure you're using?...

Could you post the table structure you're using? I'm not sure I quite understand how you're storing the data. Would I be right in assuming it's something akin to:

Claim:
ClaimId
Customer...
Forum: Access August 1st, 2006, 01:57 PM
Replies: 4
Views: 1,002
Posted By kindler
You need to either shrink the size of the forms...

You need to either shrink the size of the forms or increase your monitor's resolution.
Forum: Access July 21st, 2006, 12:16 PM
Replies: 13
Views: 7,184
Posted By kindler
It prevents the user from modifying the design of...

It prevents the user from modifying the design of the database or altering any code.
Forum: Access July 20th, 2006, 09:36 AM
Replies: 3
Views: 3,490
Posted By kindler
Now returns the time as well as the date. I...

Now returns the time as well as the date. I believe what you want is DatePart(Now) - 1.
Forum: Access July 20th, 2006, 09:35 AM
Replies: 13
Views: 7,184
Posted By kindler
"You cannot convert an Access MDB to an EXE...

"You cannot convert an Access MDB to an EXE directly. The best you can do is create an MDE file."
Forum: Access July 20th, 2006, 09:34 AM
Replies: 2
Views: 729
Posted By kindler
Put a hyperlink field in the table with the...

Put a hyperlink field in the table with the address of the paper
Forum: Access July 18th, 2006, 12:16 PM
Replies: 6
Views: 1,228
Posted By kindler
Set your criteria to: LIKE '*keyword*' ...

Set your criteria to:

LIKE '*keyword*'

and it should work.
Forum: Access July 17th, 2006, 02:41 PM
Replies: 3
Views: 875
Posted By kindler
You can use VBA to pull the value of the form...

You can use VBA to pull the value of the form textboxes into variables (i.e. dteStart, dteEnd) and create a query such as:

"SELECT * " & _
"FROM tbl " & _
"WHERE tbl.TimeStamp >= #" & dteStart &...
Forum: Access July 13th, 2006, 09:37 AM
Replies: 2
Views: 1,121
Posted By kindler
1. Create a text box and command button,...

1.
Create a text box and command button, Command button on-click event should be set to save the value in the text box to a variable, say srchstr, and then generate a query with the following...
Forum: Access VBA July 11th, 2006, 10:56 AM
Replies: 1
Views: 1,373
Posted By kindler
You should be able to do it by using...

You should be able to do it by using LibraryName.MethodName
Forum: Access July 6th, 2006, 10:36 AM
Replies: 1
Views: 1,159
Posted By kindler
Use a Combobox as your means of entering the...

Use a Combobox as your means of entering the search criteria, set Auto Expand to yes, and the RecordSource to be a query listing the values the search is checking.
Forum: Access July 5th, 2006, 12:17 PM
Replies: 13
Views: 3,818
Posted By kindler
PresumingEd: I'm not sure I understand your...

PresumingEd: I'm not sure I understand your problem.
Forum: Access VBA June 27th, 2006, 04:00 PM
Replies: 3
Views: 1,582
Posted By kindler
I don't have all the code syntax down, but an...

I don't have all the code syntax down, but an algorithm such as the following would do the trick for you:

Dim dteCOB As Date
Dim dteSOB As Date
Dim HoursPerDate = 12
Elapsed = 0
If...
Showing results 1 to 25 of 142

 




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