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 25 of 142
Search took 0.01 seconds.
Search: Posts Made By: kindler
Forum: Access October 31st, 2006, 04:12 PM
Replies: 4
Views: 1,408
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,309
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,087
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,087
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,073
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,752
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,752
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,752
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,735
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,043
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,830
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,110
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,269
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: 918
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: 6,964
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,055
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: 6,964
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: 663
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,115
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: 787
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,046
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,243
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,080
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,586
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,474
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

 


All times are GMT -4. The time now is 11:35 PM.


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