Search results for query: *

I am looking for a web development tool that allows me to use the same basic layout as used in programs I have created in Access. I have researched Dreamweaver and other such programs and have not found anything that allows the use of combo boxes or provides the ability to link data between main...

Works great! Thank you.

I am still receiving the same run time error.

Unfortunately that didn't work. Nothing happened when I clicked the button. Thanks though.

I am trying to run a Word document when clicking a button on an Access form. The code I am using is: ________________________________________________________ Private Sub Command16_Click() Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc =...

I'm trying to export tasks from Outlook into Access as well as import tasks from Access to Outlook. This will be used via a network by at least 100 different users. Any ideas on how this can be done?

How would that be done programmatically in the RunningTotal column? I would need to differentiate between the 4/1 row and the 4/2 row and so on, but I don't know how to do so per row, only per column with an infinite number such as this. Any ideas?

I don't understand what you mean, exactly. Can you elaborate?

Actually, the exact expression is: Net Wt: Sum(([gross wt]-[empty wt])/56) So, [net wt] comes from the first query (as shown in the expression above). [Silo] is from a table, [actual bu usage] is from a table, both populated earlier in the process and brought together through the query. Does...

I am trying to figure out a net bushel weight per silo per date taking into account usage and new receipts. So, this is what I'm doing. First Query: Figures bushel weight per silo per day net weight: =([gross wt]-[empty wt]/56) Second Query: Figures actual bushel usage per silo Third...

How would I go about filtering out "fyi"?

Total is a field not seen in the subform where the calculation is taking place. That is where I've tried excluding the "fyi". As for including the specific syntax, I mapped the form and subform exactly, and it returned the error.

In response to the e-mail previous to the last, I didn't use "NameOfQuery" I actually used the name given to the form and/or query. Second, I've never had that be an issue before, using the same name on a control as the controlsource. Upon making changes, it doesn't appear to change the outcome.

There is no reason why these formulas aren't working, but for some they aren't. I even replaced "fyi" with the id for that role, "4", but it didn't work either.

In the prior tries it was just saying Error in the box, with your formula I am getting #Name? in the box. I tried the formula you listed and got the return #Error. I also altered the formula. The "NameofQuery" was changed to the name of the main form to see if that would perhaps work, it...

That unfortunately didn't work. I'm assuming because the actual field name is Role. This is possible isn't it? I've been working on it for over a week now and nothing is working. There has to be some way.

I am pretty sure I don't understand. This is the way the roles table is laid out ID Role ----------- 1 Leader 2 Sponsor 3 Team Leader 4 FYI I have tried replacing the "fyi" with the actual ID (4) but that isn't working either. Is that what you are suggesting I do, or...

The form is actually completely set up, I'm just trying to add this one little feature. The reason it is based on a table is because the "fyi" field is a lookup. There are a number of different titles that may be selected. However, "fyi" is the only title I want excluded. So the way it is...

I tried the second suggestion which produced an error. I'm not sure I understand how to the first suggestion. Any more ideas?

I'm trying to average a group of numbers in a field named [your priority number]. The form is in database view. The form includes the following fields: Your Name Role Your Priority Number Which in form view could look like this: Your Name Role Your Priority Number Jaime...