Search results

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

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

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

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

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

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

Hello. I'm connecting to MySQL through ODBC 5.1. I'm using MS-Access 2007 as the front end to access the DB. Trying to insert rows to some of the tables, yields an error: ODBC - insert on a linked table failed. The tables that won't allow me to insert records are the "one" tables of a...

Hello. Might you know how can I access a field that is part of the underlying query of a form, from another control on that form? I have a "Comments" field that is part of formA underlying query, but is not visible on formA (not bound to any control!). I would like to retrieve and update that...

Hello all, I have a frmMain with two peer subforms: sfrmSupplements and sfrmProducts. sfrmProducts shows the "many" records per the "one" current record selected in sfrmSupplement. In order to establish this relationship, I have the following event code of sfrmSupplements: Private Sub...