Search results

Yes, of course it's not Form_Load(). Silly me! I'm having trouble accessing the value of the text box. Me.textbox.Value doesn't work (error is "You entered an expression that has no value"). Me.textbox.Text doesn't work (error is "You can't access the property or method for a control unless...

i am recreating an existing Excel spreadsheet report into Access. Everything is perfect except for one thing. i have 3 places that are colored white, bluish gray, and a darker bluish gray (neither of them are standard pull-down colors). i need these three areas to be formatted like the rest...

Well, CAN i, or will it ever happen? CAN i? Yes, in theory, but the red tape is horrid so it's not likely to happen. Such a shame because it could help so many. i've got something working for now; thanks for all your suggestions!

I have data from a .txt file which is a report from a mainframe system. I have no control over the format of this data, and it is not something that will make a priority list for the mainframe people to change, so I'm stuck with it. The report is by product line, approximately 10 items per...

We access MS Access through a Citrix server, primarily for speed. I've been searching for a solution to the Security Warning and found the code located here: http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning, which works in a test database through...

Also, if this were the problem, why would none of the controls be visible in the form at all? I can understand why fields would be blank/grayed out/etc, but there is nothing visible whatsoever except the background. It's very confusing. Even after I import a form from an older version that...

The form refers directly to one single table (no query), and it is set to allow additions and edits. There are records in the table. Thanks!

There is data in the table and it is set to allow additions. I have even found an older version of the database where the form opens correctly and everything is viewable, and imported it into the current database, and it is invisible after the import. Is it possible there is some database...

i have a form that is giving me trouble, and has been for ages. Everything looks good in design view, and the Properties for all fields and items are set to Visible? Yes and Display When? Always. However, when I open the form in form view, it appears to be blank. Only the background can be...

i don't see how a single pivotcrosstab would do it or i would have implemented this first. Could you please explain more what you mean? Using sales data by month obtained from a previous crosstab query for several items, I need to come up with an average monthly sales figure. This is...

I'm sorry; I don't understand this?

It should be creatmonth + 1 because items are added all through the month, so i only want to include the first complete month of sales instead of having a perhaps incomplete month in the average. I am excluding the creatmonth and previous months from the 12-month sales average because it will...

I am writing code to determine the average sales over a 12-month period, with one field per month (derived via crosstab). However, some items were only made available for sale at some point inside the 12-month period, and thus we only have a few months of sales data for those items. We don't...

Thanks for the help all. i was able to manage it by running a DLookup from the Module. Very slow and ugly, but at least it accomplishes the mission.

How does this pass the value of the duo back to the query? The end result of all this in the function will be one field that is part of the enormous query. i'm probably missing something...

True. The values at the different buildings were calculated from data from 4 different crosstab queries. i would have no idea how to go back in and normalize it from here.

i appreciate your help, but i still don't know what you mean.

Hmmm... okay, some background. The query is enormous, not a lot of rows but many, many columns. Basically we have 9 applicable buildings around the country and each building has a value. i want to know first of all if any value at a building exceeds a target number. If it does, great, stop...

i guess i don't know what you mean?

i have a query that i need to send 38 different field names to a module function. The module is set up where the passed fields go into an array and are used in the function. (The function determines the name of the field that contains a value equal to that of the first passed). But i get an...