Search results

Where are you storing the attributes you are setting for the category Chapter Member?

Have you tried using the Package and Deployment Wizard included w/ Office 2K Dev Tools? I've used it only a couple of times with pretty good success, although I know some people have reservations about it. The package and deployment wiz might solve some of your missing ref probs. As far as the...

There are several ways to do this in VBA. What specifically are you trying to do? One function to look into is Dlookup. js

Thanks Chris! I think I must have had a typo somewhere b/c I was able to do something similar on a different form. I guess I was having a moment b/c I just couldn't see the typo. Thanks again for your comments. js

I have a db that has multiple levels of users from supervisors, down to data entry people. On some of the common forms, I would like to lock certain fields from being editted based on the user's security. I've put tags on these fields and am running the following code when the form opens to...

DLookup... hadn't thought of that. I'll give that a try thanks! Unfortunately, I'm pulling reports out of a 3rd party db, so I don't have the option to modify the tables, but I agree with you. The best way to solve this problem is to include the month and year in the sales table. Apparently an...

At the risk of sounding like I haven't "done my homework," I'll post this question. I'm using a crosstab query to produce a sales report that breaks out monthly revenue for the year. The query works great, but there's a hitch. The way our sales dept "works," a sales month doesn't correspond...

Actually, while what you are trying to do isn't all that difficult, there's a few small details that can get tricky, so don't feel bad! There's a couple of things that could be going wrong. First let me ask where does the Status combo get it's values? Did you enter them in for the control or...

I'm not aware of anyway to do this with a Listbox. However, Mike Gurman recently posted a response to a similar question about conditional formatting of a form which you might find helpful... see: http://www.access-programmers.co.uk/ubb/Forum4/HTML/003719.html Perhaps you could build a...

Wow Mike... that's cool! You learn something new every day. Thanks for sharing that... I will have to add that to my "bag of tricks!" jamie

Try using the Dcount function on your query. Like: Dcount("FieldName","QueryName") Dcount counts the number of instances of the field specified by FieldName. It's best to use your Primary Key in FieldName so you know it will always have data otherwise Dcount will not return an accurate count...

See my reply in General group...

See reply in General group... you should probably not post the same question in multiple groups. It just eats up valuable space.

Unfortunately, I haven't found conditional formatting to be an easy thing in Access. In fact, depending on the situation, it's sometimes not available at all on a per record basis. For example, you can write some vba code to do conditional formatting on a Single Form, but NOT on a Continuous...

I've used JPG's before w/out any problems, but you have to have a filter installed for that. If nothing else, a BMP will work. The problem COULD be the stretch, zoom or clip properties. Those properties handle what access does w/ the image if it doesn't fit quite right on your form. If the...

Yes... scan your preprinted and set it as the background image for access form. From the Form Properties window its FORMAT -> PICTURE. You can then draw your textboxs, etc. right on the image to line them up where they need to be. jamie

An easy way to do it would be: instead of calling the macro directly from the button, have the button open a second form that has a textbox (we'll call it txtPwd) and a button (btnGO; label it GO). Label the text box "Password" and put a password Input Mask on it (set from the Properties ->...

I did a quick test on a form that should also work for a report. Basically, I have a form and a subform linked by a key value. I then created a query that said select the Top 3 records based on the key value displayed on the form and used that query to populate the subform. Worked like a...

Sure... A quick, easy way to do it would be to use the OnChange event. When the user changed the data in one of the controls, you could use: Me!FirstName.Undo MsgBox "Use the button to set this value" That would undo their changes to the textbox and pop up the msgbox telling them to set the...

John, I wonder if you have some sort of problem with your Access installation. The code snippet I gave you yesterday when called from the AfterUpdate event caused the LastName value to be copied into ChildLastName as soon as I tabbed off the field, which is what it's supposed to do. Here's what...