Search results for query: *

I have a fairly large spreadsheet to list customer details which is sorted by sales reps (about 40 reps). I want to be able to double click on a rep's name and have VBA automatically group the rows with his name; then double click on the next rep and group, etc. The reps' names are always in...

I'm using the "round" function in my form to do tax calculations but when the result is 3 decimal places and ending in a 5, the "round" function rounds it DOWN. Is the something I could do to make it round UP if the result is half a cent? Gross = me.GrossAmount (from the form) CommissionRate...

I'm using the "round" function in my form to do tax calculations but when the result is 3 decimal places and ending in a 5, the "round" function rounds it DOWN. Is the something I could do to make it round UP if the result is half a cent? Gross = me.GrossAmount (from the form) CommissionRate =...

using Tigerlili3's advice in thread702-1137528, "You can have a field in the table which I'll call Attachment for this example. The data type needs to be OLE Object. On your form you need to have a bound object frame which I'll call tvwAttach for this example. You can have a button on the...

I have a button on a form that, when clicked, will open an explorer winder to a specific directory where I have PDF files stored. Private Sub ViewPDFFiles_Click() Dim OpenPDFfolder As Variant, myPath As String myPath = "C:\Documents and Settings\myPDFfolder" If Dir(myPath, vbDirectory) <> ""...

I am considering replicating my database for a multi-user environment. I have tested it a few times and the only issue that I have with replication is that in each of my tables, I have a primary key field that is an incrementing autonumber and after I create the replica, every single one of...

How can i create a custom menu to pop up when i right click my mouse button on a form?

I have a form with numerous Command Buttons which are set to each display/view a particular report. I am trying to set another command button for each report to print instead of view (so i have the option to view the report OR print the report). The problem is, i would like the PRINT DIALOG...

I'm trying to use Lebans coding to disable my mouse wheel (thread181-1370483) but when i do the recommended steps and then open my form, i get an error "Variable not defined" - which is referring to the "blRet". Any suggestions as to what i might be overlooking?

I am trying to get a Control to sort on dbl click either Ascending or Descending depending on the current state of the records - which would be in one of three conditions: if unsorted then sort as Asc; if sorted as Asc then re-sort as Desc; if sorted as Desc then re-sort as Asc. This will be a...

I have a form with a toggle button - the triplestate property is YES. I am trying to perform different code for each state but it seems like the triplestate value is not updating on click. This is the start of it all - i have left out other code to keep this simple. The fact remains that the...

I have a form with a "save" command button. After I enter data in the form, I click the "save". The current record is saved, a few calculations run, and the form is requeried. It runs fine, but after the requery, it goes to the first record. What code would I need in the "save" for it to...

Howdy experts!! I have a form which, using one of a few buttons, i can apply different queries to the form. Such as "All Transactions", "Reconciled", and "Unreconciled". My problem is that when i select the query on the form, i would also like it to requery the Report that i can generate from...

How can I set the maximum # of records in a table? I have a table and I only want the user to be able to create 70 records maximum.

I have a subform called [frm Debts] located on the main form [frm Clients] and within the subform, i have 2 controls: Debt (which is a currency) and Percent. I have a control in the form footer which sums the Debt. The subform is displayed as continuous. The percent control should calculate the...

I have a form with "ClientName" and "SpouseName" fields. If I have John in "ClientName" & Mary in "SpouseName", can a Combobox be populated with the results of "ClientName", "SpouseName" and the text "Joint" only? Meaning when I pull down the combobox, the only 3 selections for the combobox...

I have a form for my Client table that has a combo box that selects a "creditor" from the Creditor table. I then have another combo box that selects a "contact" from the Contact table. There is a relationship built between the Creditor & Contact tables (creditorID). As it is, when I drop down...

I am having some problems setting a default value. The form is simple, i have a field "StartingAmount", and another field "ConfirmedAmount". I want "ConfirmedAmount" to default the same as "StartingAmount" but i also need the ability to alter "confirmedamount". I've tried a few different things...