Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
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 500
Search took 0.04 seconds.
Search: Posts Made By: SerranoG
Forum: Access April 10th, 2018, 08:42 AM
Replies: 5
Views: 1,766
Posted By SerranoG
If you're talking about what to put into an...

If you're talking about what to put into an Access query, then you can express this as:

PTax: IIF(M6>40001,200,IIF(M6>25001,150,IIF(M6>15001,130,IIF(M6>10001,110,0))))
Forum: Access VBA November 18th, 2013, 09:02 AM
Replies: 6
Views: 5,560
Posted By SerranoG
Can you describe the nature of what you're trying...

Can you describe the nature of what you're trying to do in more detail?
Forum: Access VBA February 6th, 2012, 02:24 PM
Replies: 7
Views: 90,542
Posted By SerranoG
I'm not sure of what you're asking. Are you...

I'm not sure of what you're asking. Are you saying that the user selects a last name and then you want to look up and auto-populate the rest of the fields?

If so, doing it on last name only is...
Forum: Access May 18th, 2010, 04:25 PM
Replies: 1
Views: 825
Posted By SerranoG
If you're talking about fields on a report, you...

If you're talking about fields on a report, you can use their VISIBLE property to show or hide them. In the report's ON FORMAT event, use something like

Me.txtColor.Visible = Not...
Forum: Access May 18th, 2010, 04:21 PM
Replies: 6
Views: 3,225
Posted By SerranoG
The second question is quicker to answer so I'll...

The second question is quicker to answer so I'll do that first.

If you have a field, say it's called txtGender (M for Male, F for Female), you can code an afterupdate event. Suppose the next...
Forum: Access VBA May 14th, 2010, 11:11 AM
Replies: 2
Views: 965
Posted By SerranoG
I understand what it is you want, but my advice...

I understand what it is you want, but my advice is do NOT use the autonumber field "sno" for anythying. Autonumbers are generated by the computer and only have meaning behind the scenes to link a...
Forum: Access VBA May 14th, 2010, 10:52 AM
Replies: 1
Views: 961
Posted By SerranoG
If your code is chock full of DAO syntax, you'll...

If your code is chock full of DAO syntax, you'll have to "translate" them to ADO. That's not something that can be discussed here briefly. Google something like

"Microsoft Access" "DAO vs. ADO"...
Forum: Access May 14th, 2010, 10:48 AM
Replies: 2
Views: 1,179
Posted By SerranoG
I edited my reply but since they also get...

I edited my reply but since they also get e-mailed, the edit doesn't get e-mailed to you as well.
Forum: Access May 14th, 2010, 10:47 AM
Replies: 2
Views: 1,179
Posted By SerranoG
How about using something like this, for example,...

How about using something like this, for example, afterwards?

Application.FollowHyperlink "W:\edsplus\applications\0cmad\cmad_chart_spreadsh eet.xls"
Forum: Access May 14th, 2010, 10:43 AM
Replies: 1
Views: 2,417
Posted By SerranoG
Given that I don't know the "official names" of...

Given that I don't know the "official names" of everything in 2007 products (they're still relatively new to me), I'm not sure what you mean by "Navigation Pane" nor what "it collapses" means to you....
Forum: Access VBA April 12th, 2010, 08:52 AM
Replies: 3
Views: 2,148
Posted By SerranoG
You're quite welcome. Glad I could help. ...

You're quite welcome. Glad I could help.

Just as a general FYI, when writing criteria for boolean (true/false), numbers, strings, and dates, the syntax requires delimiters for strings and dates....
Forum: Access VBA April 9th, 2010, 08:33 AM
Replies: 2
Views: 774
Posted By SerranoG
Is the record number an autonumber or is it a...

Is the record number an autonumber or is it a user-defined record number?

If an autonumber, it will not appear, nor will the record become dirty, until you start typing values in the other...
Forum: Access VBA April 9th, 2010, 08:25 AM
Replies: 1
Views: 2,396
Posted By SerranoG
Instead of requerying the entire form with ...

Instead of requerying the entire form with

Me.ClientAssets.Form.Requery

just update the combo with

Me.AssetType.Requery

This will also keep the focus where you last left it... I hope.
Forum: Access VBA April 9th, 2010, 08:21 AM
Replies: 3
Views: 2,148
Posted By SerranoG
txtTotalForSelectedItems = DSum("([Cost] +...

txtTotalForSelectedItems = DSum("([Cost] + ([Cost] * [TaxRate]) + [DeliveryCost])", "tblItemInfo", "[Category] = '" & Me.cboSelectCategory & "'")
Forum: Access April 9th, 2010, 08:17 AM
Replies: 2
Views: 1,474
Posted By SerranoG
The subform should not contain a query of the...

The subform should not contain a query of the same table as the main form. There should be two tables with primary and foreign keys (PK and FK) linking the two in a (usually) one-to-many...
Forum: Access April 9th, 2010, 08:07 AM
Replies: 1
Views: 766
Posted By SerranoG
By looking at your code, I see a lot of potential...

By looking at your code, I see a lot of potential problems.

First, where is this code located? It looks like it's a button on your form called Delete_Claim_CMD. It also looks like the code is...
Forum: Access VBA March 5th, 2010, 09:08 AM
Replies: 5
Views: 1,560
Posted By SerranoG
Rod, just a thought. If you ever need to...

Rod, just a thought.

If you ever need to get any of those back, you will be messed up by deleting them. If you ever decide you don't need a record anymore, don't delete it. Instead, tag it as...
Forum: Access VBA February 9th, 2010, 10:27 AM
Replies: 7
Views: 4,960
Posted By SerranoG
Oh, and replace Page1 and Page2 in my code for...

Oh, and replace Page1 and Page2 in my code for your real form names.

Forms.Your_Real_Form_Name_Here.Form.Activate
Forum: Access VBA February 9th, 2010, 10:25 AM
Replies: 7
Views: 4,960
Posted By SerranoG
Open Pages 1 & 2 at the same time but make Page 1...

Open Pages 1 & 2 at the same time but make Page 1 open second so that it's on top of Page 2. Don't close either.

When on Page 1, the button just activates Page 2 and vice-versa
...
Forum: Access VBA February 9th, 2010, 08:47 AM
Replies: 7
Views: 4,960
Posted By SerranoG
Bear with me as I understand your switchboard. ...

Bear with me as I understand your switchboard.

Is your switchboard one form that scrolls down to two halves? Are your switchboards two sepearate forms that open? If they are two forms, are they...
Forum: Access VBA February 8th, 2010, 06:00 PM
Replies: 6
Views: 5,560
Posted By SerranoG
Don't use the control source as the DLookUp...

Don't use the control source as the DLookUp function. Put that into a hidden textbox that retreives the data, and then assign the retreived info into the real textbox thas is bound to the control...
Forum: Access VBA February 8th, 2010, 05:56 PM
Replies: 7
Views: 4,960
Posted By SerranoG
What would you like it to do instead?

What would you like it to do instead?
Forum: Access February 8th, 2010, 05:54 PM
Replies: 1
Views: 927
Posted By SerranoG
What happens when you try to import into an...

What happens when you try to import into an existing table? Does it give you an error message? If so, what does it say?
Forum: Access February 8th, 2010, 05:52 PM
Replies: 1
Views: 920
Posted By SerranoG
Well, you can either export it as an Outlook...

Well, you can either export it as an Outlook calendar object or create a report that is formatted like a calendar with textboxes holding calendar days, months, year, and data in the grid you create. ...
Forum: Access VBA January 29th, 2010, 11:53 AM
Replies: 8
Views: 1,631
Posted By SerranoG
The object type should be image, not bound or...

The object type should be image, not bound or unbound object frame (OLE). To leave it unbound in the design view, you do not assign a file name in its Picture property in design view. You assign it...
Showing results 1 to 25 of 500

 


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


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