Recent content by jvhazelbaker

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...