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 | 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 174
Search took 0.01 seconds.
Search: Posts Made By: BethMoffitt
Forum: Access VBA March 5th, 2004, 05:41 PM
Replies: 17
Views: 18,942
Posted By BethMoffitt
WOW Ben! Where have YOU *been* for the past 5...

WOW Ben! Where have YOU *been* for the past 5 months?!?! (No pun intended!) I thought this topic died eons ago?

And I still prefer ms_access_professionals on yahoo. I like the fact that not...
Forum: Access March 5th, 2004, 10:20 AM
Replies: 16
Views: 36,109
Posted By BethMoffitt
picky, picky :D

picky, picky :D
Forum: Access March 5th, 2004, 10:15 AM
Replies: 16
Views: 36,109
Posted By BethMoffitt
There is a property, just like you see for this...

There is a property, just like you see for this dialog box and word, and excel, and just about anything else, to use for aligning text Left, Right, Center or General. On the properties sheet for the...
Forum: Access VBA March 4th, 2004, 02:56 PM
Replies: 8
Views: 18,209
Posted By BethMoffitt
Go to http://rogersaccesslibrary.com/ and click...

Go to http://rogersaccesslibrary.com/ and click on his Access97/2000 samples. There is a 'cascadingcombos' example available for download.

Regards,

Beth M
Forum: Access March 4th, 2004, 02:00 PM
Replies: 3
Views: 2,395
Posted By BethMoffitt
Gaz, Naaa, I'm still just a 'grasshopper',...

Gaz,

Naaa, I'm still just a 'grasshopper', but happy to be of assistance. :D

Beth
Forum: Access VBA March 4th, 2004, 01:58 PM
Replies: 3
Views: 1,895
Posted By BethMoffitt
You might go to http://rogersaccesslibrary.com...

You might go to http://rogersaccesslibrary.com and click on Other Developers Libraries, then scroll down to Olislagers, Reinier. He has a sample db called SQLExpress which is described as follows:...
Forum: Access March 4th, 2004, 01:17 PM
Replies: 3
Views: 2,395
Posted By BethMoffitt
Modify your code as follows by first moving your...

Modify your code as follows by first moving your turning off of the warning message.


If MsgBox("Would you like to delete current record? ", vbYesNo, "Delete Record") = _
vbYes Then...
Forum: Access March 4th, 2004, 12:10 PM
Replies: 3
Views: 1,218
Posted By BethMoffitt
Unfortunately, I don't believe you can pass the...

Unfortunately, I don't believe you can pass the values used as criteria unless you first use a form which actually holds the values while the report is opened. When you close the report, you would...
Forum: Access March 4th, 2004, 10:07 AM
Replies: 10
Views: 2,143
Posted By BethMoffitt
I use the following and it works fine: If...

I use the following and it works fine:

If Len(strIDInput & vbnullstring) = 0 Then
MsgBox "My message for user and exits routine.", , "AppName"
Exit Sub
Else

Beth M
Forum: Access March 4th, 2004, 10:03 AM
Replies: 4
Views: 1,329
Posted By BethMoffitt
Before execution it would be: DoCmd.SetWarnings...

Before execution it would be:
DoCmd.SetWarnings False
and after the query use:
DoCmd.SetWarnings True

Beth M
Forum: Access March 4th, 2004, 10:00 AM
Replies: 3
Views: 1,218
Posted By BethMoffitt
Are you using a form for the user to input the...

Are you using a form for the user to input the dates? If so, leave the form open, and pass the values to the report like this in an unbound text box with the control source of:

="Between " &...
Forum: Access March 3rd, 2004, 09:46 AM
Replies: 16
Views: 36,109
Posted By BethMoffitt
If you hold your shift key and click the boxes...

If you hold your shift key and click the boxes you want to align, then right click you will get a shortcut menu which you can then select Align > Left, Right, Top, Bottom, To Grid. You can also use...
Forum: Access March 1st, 2004, 03:29 PM
Replies: 4
Views: 3,021
Posted By BethMoffitt
If you don't have any luck there, check out...

If you don't have any luck there, check out www.rogersaccesslibrary.com and go to Other Developers Libraries. Then look for Whittle, Jerry and his extensive paper on corrupted databases.

HTH,
...
Forum: Access March 1st, 2004, 03:24 PM
Replies: 8
Views: 3,018
Posted By BethMoffitt
I usually put the code behind the command button...

I usually put the code behind the command button to save. In my error handling I use something similar to the following:
The first two lines go within the dim statements:

Const DUPLICATEKEY =...
Forum: Access March 1st, 2004, 02:00 PM
Replies: 8
Views: 3,018
Posted By BethMoffitt
Greg, Actually, if you have a required field...

Greg,

Actually, if you have a required field that is being left blank, you can trap any and all on the Before_Update of the form, the click of a Save command button, Form's on error event, or each...
Forum: Access March 1st, 2004, 01:11 PM
Replies: 8
Views: 3,018
Posted By BethMoffitt
Trap it on the Form's On Error event. To...

Trap it on the Form's On Error event. To determine an error number, use this in the error handler routine:

MsgBox "Error #:" & err.number & chr(13) & chr(10) & "Description: " &...
Forum: Access February 28th, 2004, 09:12 AM
Replies: 12
Views: 2,930
Posted By BethMoffitt
Regarding Northwind sample database: Then: ...

Regarding Northwind sample database:
Then:
[s]

So, is it for you? Or for a 'friend'? Not that it matters to me because I wouldn't assist under these circumstances anyway, but from the looks of...
Forum: Access February 27th, 2004, 05:04 PM
Replies: 12
Views: 2,930
Posted By BethMoffitt
Even tho I have samples, and know where several...

Even tho I have samples, and know where several are, I wouldn't point you in the right direction as I don't think it's morally (or ethically as a programmer) right to take credit for someone else's...
Forum: Access February 27th, 2004, 05:02 PM
Replies: 7
Views: 1,490
Posted By BethMoffitt
If you have it as an autonumber in table1, then...

If you have it as an autonumber in table1, then in related table2 it cannot be an autonumber field. Specify it as a number field and it will update accoridingly when you run your update query (or...
Forum: Access VBA February 25th, 2004, 02:27 PM
Replies: 8
Views: 18,209
Posted By BethMoffitt
The DIM statements CAN go before the PUBLIC...

The DIM statements CAN go before the PUBLIC statement if this is to be used globably. But like Greg, I'm unsure of your statement "Set mcboRecSel.AfterUpdate = "[Event Procedure]""

Beth M
Forum: Access VBA February 25th, 2004, 09:43 AM
Replies: 5
Views: 2,495
Posted By BethMoffitt
Access should by default find the Utility.mda. ...

Access should by default find the Utility.mda. As Sal said, sometimes when you have more than one version loaded on a pc, things get a little screwed up. On the pc where this doesn't work, open...
Forum: Access February 23rd, 2004, 09:57 AM
Replies: 3
Views: 1,489
Posted By BethMoffitt
My pleasure :)

My pleasure :)
Forum: Access February 22nd, 2004, 09:13 PM
Replies: 3
Views: 1,489
Posted By BethMoffitt
Well, since you didn't give any field names, you...

Well, since you didn't give any field names, you will have to change it to whatever is applicable. Use the left function like the following:

Left([Fieldname],3)

Regards,

Beth M
Forum: Access February 19th, 2004, 09:44 AM
Replies: 6
Views: 3,560
Posted By BethMoffitt
go to...

go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and then click on Tejpal, A.D. He has a sample database called InputMask_Dynamic.mdb with the following description:
This sample db...
Forum: Access VBA February 18th, 2004, 10:12 AM
Replies: 3
Views: 1,177
Posted By BethMoffitt
My pleasure :)

My pleasure :)
Showing results 1 to 25 of 174

 


All times are GMT -4. The time now is 09:42 AM.


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