Recent content by morsagmon

Thank you guys! Bob, I adopted your strategy - much better :) Thanks!

I have a report that is based on a query with many parameters (e.g. [piEnterDate]). On the Report_Open event, after I have collected values for all of the query parameters and stored them in public variables, all I need to do now is to assign these values to the query's parameters. What is the...

Hey Bob. I'm using Access 2007 What file format is the runtime expecting? how do I create it? Thanks!

This is embarrassing, but I couldn't find any hint on this basic task. I have created my first application - I have tables, queries, forms and reports. Now, I need to build some sort of end-user MENUS that activate forms and reports. How do I do that? I know one option is to build a launching...

Bob, No, the form I'm calling this sub from is bound to a different table. Thanks!

Rookie, The SupplementStock data type: Public Type SupplementStock UnitsInStock As Integer StockDate As Date End TypeThe called SumSupplementStock function: Public Function SumSupplementStock(strSupplement As String) As SupplementStock Dim dbs As DAO.Database Dim rst As...

Hello. In the below code, the rst.Update method fails with the following error: I restarted the DB and Access machine - I'm sure there's no other process addressing this table, except for this subroutine! Any ideas? Public Sub UpdateSupplementsStock() Dim dbs As DAO.Database Dim rst As...

ByteMyzer, Works like a charm. Thanks! Mor

That's what I figured, darbid. Thanks!

ByteMyzer, Thanks for your idea - I'll give it a try. darbid, I'm fully with you on this, and I don't have any issue with the user hitting the "send" button. I'm not using Outlook, though. I'm sending this email through a Gmail account using smtp (see here an example, only I had to change port...

Hello. I have a module in which I construct a STRING holding an email body in HTML format (contains HTML tags, such as <BR> and nbsp's). Before I send out the email I'd like to present to user with the email content as it will arrive for approval, and based on his choice (OK or Cancel) - stop...

Bill, Thank you for this. It is a good design practice for a normalized DB, and typically that's what I do. At times, given logic/storage tradeoffs, I opt to divert from this practice and store redundant data so that a lot of logic work is saved. However, giving it a second thought, in...

Bill, form A shows all order headers: OrderNo, Customer, Total Naturally, these are stored in a DB table called tblOrders. The Total field above is the bound control we're talking about. form B shows the records from tblOrderLines. When the user changes the quantity (for example) of an order...

Getting the result I want to be displayed in an unbound textbox is not a problem. I got that already. The point is, the target of this calculated value is a BOUND control. In other words, manipulations of subform B needs to update a field in the underlying source of subform A, and immediatelly...

I don't have a MainForm and a SubForm. I have two PEER forms, placed within two neighbouring form controls, on a blank empty form. (I access one subform from the other by me.parent.sfrmX...). Your suggestion, if I understand correctly, is to update the Orders row through a DB update (update...