Search results

What are the data sources for the fields? They should be undefined to accept the VBA values assigned or hold the equasions you are using as their data source.

You equasion should reflect what percentage you are looking for. See the examples below: A = 12345 B = 7890 (A/B)-1 = .56 A is 56% higher than B B/A = .64 B is 64 % of A (a-b)/a = .36 The difference between A and B = 36% (I have 36% more in received rent than held rent)

Try this instead: UPDATE Funds INNER JOIN Classes ON (Funds.Fund_Name = Classes.Fund_Name) AND (Funds.Fund_Name = Classes.Fund_Name) SET Funds.Active = Yes WHERE (((Funds.Active)=No) AND ((Classes.[Open/Closed])="Open")); This bypasses the count issue. It will result in duplication of...

If you have a query like this to count the open Items: Query: closed_count SELECT Classes.fund_name, Count(Classes.[Open/Closed]) AS [CountOfOpen/Closed] FROM Classes GROUP BY Classes.fund_name HAVING (((Count(Classes.[Open/Closed]))="open")); You would create an update query like this...

Use a query or DCount statement to count the "Open/Closed" field for values of "open". If the count >0 then use an update query to set the active field to yes, filtering those that are already Yes to begin with. Example: Dim intCount as Integer intcount =...

@mdlueck: Thank you very much for your response. I am using 32-bit Access 2007 to develop on another machine and using Access 2007 32 bit Runtime for the clients. I am not using Windows XP mode to run this application because I am using that to run Access 2000 legacy apps required for...

SOLUTION: I was using the ODBC connection manager through Administrative Tools which by default creates 64-bit ODBC connections. This cannot work on a 32 bit application. I uninstalled the 64 bit Oracle Client and installed the 32 bit Client. Then per...

Check the relationships on the oracle database to ensure you have all foreign keys accounted for. I have found that I have to add the master record for certain inserts before I can add the child data. Example: ONe table lists the profile numbers. Another holds the profile data. Without the...

The following code works when employed on Windows XP clients. I am upgrading to Windows 7 Professional 64 bit. I have verified the ODBC connection is working properly through the ODBC management. I get Error 3151 Private Sub Form_Load() Dim DB As DAO.Database Dim TDF As DAO.TableDef...

Improvement made to OnOpenObject. This new method allows you to open the object in its current state rather than opening it to a default state. Public Sub OnOpenObject(Control As IRibbonControl) Dim strType As String Dim strName As String strType = Right(Control.tag...

Define the relationship between the master and child tables using the cascade delete option. Then all you have to do is delete the master record, the database engine will handle the child records for you. Read this first...

DoCmd.OpenReport "rptByFlightMembers", acViewPreview, , "tblPeople.HG_Flight = '" & Me.cboWhichFlight & "'"

If each author has a unique id associated with them, use that field in your combo box as the Bound Column and reference that ID in your filter. So if the rowsource = Select ID, (LastName & ", " & FirstName) As Name from Authors you would set the bound column to 1. For display purposes, I...

1. Have the person log into the database and store that value somewhere on a form. Ususally a hidden text box on the main form / menu. Read that textbox from within the query you use to create the list. From the query designer use the builder to find the field on the form or use...

If your form is creating a new record when it is opened, it is in data entry mode. Change that property to false on the form.

I have been looking for a way to build a dynamic menu item on a ribbon that shows whatever happens to be open a the time to make it easier for the users to switch between open forms and reports. I found the following that gets the job done with a few additions / considerations: The majority of...

1. Is AEC a unique identifier for the shipments? 2. Are the Transshipment(1-8) fields in a single record or individual records related to each other? I think you need to see all shipments that have left in the last 60 days and will dock somewhere in the next 20 days. You also want to see...

SQL _______________SQL2 AEC _______________AEC Shipper _______________ Shipper Carrier _______________ Carrier Line _______________ Line Equipment _______________ Equipment Event Description _______________Event Description Sailing Date _______________ Date of Arrival Days _______________ Days...

Now that I see the SQL I see the problem. The fields you are joining in the UNION query don't match. Although they may have similar data they do not have the same field names. Your Order by clauses don't agree either. SQLSQL2AECAECShipperShipperCarriercarrierLinelineEquipmentequipmentEvent...

1. Try strSQLSelect1 & " " & strSQLWhere & vbnewline & "UNION" &vbNewLine & strSQLSelect2 & " " & strSQLWhere ..... In essence you are building a long string that will be used with the DoCmd.RunSQL (string) command. I have found that adding the spaces between strings is needed to separate...