Search results

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

Both are continuous forms. I don't mind that the whole recordset is requeried and refreshed upon each change of the relevant field in sfrmOrderLines. I couldn't get it to work. What unbound textbox are you referring to? I know how to make an unbound textbox reflect such changes. The problem is...

Hello all! I have two peer subforms on a main form: sfrmOrders, sfrmOrderLines. The sfrmOrders has a control (as part of the "Detail" area) bound to a table field: Total_Before_Discount. In this way, the user can see each line of order-header with its total. sfrmOrderLines has two bound fields...

Steve, I changed the code to follow your logic, and the error message disappeared. Problem solved! Many thanks!!

jdraw, Adding the single quotes causes a data type mismatch error. The way it is written is working great - in this function and in another one. The function is called for each record. The only time it fails is on the first time, when the subforms are loaded before their parent, in which case I...

I have this code with an "On Error Resume Next" statement that is not trapping the error. Public Function FetchSupplementUnits2() As String 'Fetch supplement units description for Supplements Intake of Treatment On Error GoTo FormNotLoaded_Exit If...