Search results for query: *

Many thanks Golom and MajP for fast and thorough responses.

I want to create a table of field properties for my database. One row per table field, with columns table name, field name, field type, description. I can get field properties as numbers , but having trouble translating them. Also cannot find field description programmatically. I want a more...

Thanks TheLad. That did the trick.

When I try to open a pdf file from within an application (eg outlook express attachment, turbocad help file) I get a message that no application is associated with file type .pdf. I have adobe acrobat associated with .pdf files. If I double click on a pdf file in windows explorer it opens...

Hi Pampers Thanks for your response. Sometimes I do not want to restrict records at all, so referencing the control is not suitable, or at least more complex. Have done now by having the main form get the filter details from the menu form, where I used a label to hold the wording of the...

Hi Pampers Thanks for your response. Filtering subform according to the value of a control on my menu form. I'm now trying using an on-open event on the subform to check the menu form control and hence apply the filter. It's messy because it needs code on each subform. Any better ideas?

I have used vba code to open a (unbound) form that has a subform bound to a query. I want to apply a filter to the subform. I can do it after the main form is opened, but then get many unwanted records before the filter is applied. How can I set the subform filter before the subform accesses...

Thanks Paul That did what I needed.

Hi I have set some cells in a spreadheet using xlsapp.cells(1,2) =.... I'm setting the cells using dateserial function to give day numbers then setting the cells using those integers. Now I want to format the cells (or the whole column) to show the date values of these cells. Can someone...

Hi The problem is that queries with subqueries are not updatable. Remedy by using DSum rather than subquery. If you search for "updatable" as a keyword, you'll find where I asked a similar question about 16 may and got really good replies. Good luck.

Steve101 Excellent. That's the answer I needed. Many thanks for solving my problem so quickly.

Thanks for your response Steve101. The case I am interested is in having the results of partial vertical totalling appearing on each record. I am interested in having a running total. Example: Table items (item autonmumber, name text, amount number) Query:SELECT items.item, items.name...

I want to be able to edit records on a subform, and have a running total on each record updated according to changes I make. When I add calculated fields to the underlying query, it becomes non-updatable. For a simple example, keep a table of amounts in date order, and show with each item the...

Thanks DanJR Using subquery as recordsource makes dynaset not updatable. I'll try your idea. I've resolved it sort of by using a separate subform to alter data, and then code to requery the non-updatable query's subform. I'm trying (not yet successful) to use code from keypress event on...

I am using subqueries to calculate running sums, but find that their presence makes the query not updatable, especially if the query is based on two queries with a one to many relationship. I'd like to hear what people do to overcome this problem. I'm generally interested in how to create...

Just a comment on running totals using two fields, say date and checknum. DanJR's method is OK if checks are always numbered sequentially with date. If this is not the case, then it may be better to use: where a.date < b.date or (a.date = b.date and a.checknum <=...

Thanks DanJR This is what worked (I've a new example with table &quot;items&quot; containing autonum field &quot;ID&quot; and field &quot;value&quot;) SELECT items.ID, items.value, (select sum(b.value) from items as b where b.id <= items.id) AS runningsum FROM items; The key...

Thanks contributors. I can now see how to do running sums in a form. I'd like to be able to do a query with a running sum, but I'm having trouble working out how to refer to the current record. Example I have a table &quot;monies&quot; with two fields, name and money, and want to create a...

Earlier posts were helpful (as in the need to save record) for Access97 and 2000 use RunCommand acCmdSaveRecord instead Ed