Search results

Another Question This works perfectly, however the column widths on the tabs do not seem to correlate to the column widths in the query results (or any other logical sequence i can find). Is there a way to format this or dictate column widths (or anything that would prevent me having to send...

i will do that. Thanks!

i have a query that lists data for all employees lumped together. The query sends out in .xls format. Management would like to separate out the data for each employee on a separate tab. Can this be done systematically through Access VBA, or does it require exporting to Excel and running Excel...

Thanks again!

By storing the bucket data in queries and using a Union between the queries (instead of tables), should it not update whenever the union query is run?

i'm not sure i follow you. The bucket labels themselves shouldn't really change over time (they will always be "0-10 business days", "11-20 business days", etc), unless of course someone decides to change the time frames from business days to months or something the way they changed it from...

i am attempting to help a coworker to update some old queries which were written very much in spaghetti code. The queries were used to lump backorders into groups from 0-30 days old, 30-60 days old, 60-90, and >90. One of the queries' recipients would like to see this in 0-10 business days old...

Here's a question i've been wondering about for some time. i can work around it, but it isn't very efficient. Say that i want to calculate a field, or just rename one, and then use it in a further column in a calculated field in Design View. For example, i have a table that lists the number...

Ah, well, i suppose vampires do come from the dark side. Watch for my fangs.

Yay! My first successful response. Now maybe i won't feel like such a vampire, sucking the answers out of the rest of you. i don't think you will need to put the variable name in "" if you put the string in quotes above. You should be able to do the first 4 lines as written but have the last...

You could create variables for the two CatCode strings (which should be eligible for wrapping if still too wide) and use the variables in the If statement.

Sorry I can't give you what you want, but realistically you're not going to find a true "Enabled=False" in a stand-alone label because a label does not have any actions associated with it. "Enabled=False" means that the action associated with that object is turned off. A command button is not...

Could you perhaps resize the image first, then save the image with the SavePicture property to your hard drive, then change the Picture property of the image to the new filename? Just a thought.

To resize the actual image size (and thus file size) on the hard drive or server from within Access? I don't know a way. Perhaps someone else can help, if there is a way.

I'm kind of stuck again because I'm not sure how to both use a field's value in a query and change that field's value. In this case, i don't know how to look at the flag field to determine if the flag is already set, then determine through the logic if the flag needs to be turned on (if it's...

You can use the Height and Width properties of the image control in code, so that on an event it sets Me.Picture.Height=2.08" and Me.Picture.Width=2.08". (There are 72 pixels in an inch, so 150 pixels would be 2.08").

Thanks, everyone. i will give it a try!

Apoligies in advance that this is long. This is to assess a penalty to our suppliers if they send us overages or shortages. If they send us 5 or more different parts each month for two consecutive months with incorrect amounts, we assess a penalty to them that month and each month that they...

i have a set of criteria where the flag is checked if five or more things happen two consecutive months. In order for the flag to be unchecked, two consecutive months need to pass with less than five things happening. At the moment, i have a query that looks at the previous 4 months, but it...

Shame you don't have an option for something like: "I believe in God but I do not believe His way is the only way."