Search results for query: *

Ya, not impressed with this new format. I can't locate the MS Access forum!! Arrrrgh.

Skip, Do you see how simple this was? You were making this sound so complicated. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim f As Range If Not Intersect(Target, Range("C:C")) Is Nothing Then Cancel = True Set f = Range(Cells(Target.Row...

Skip, If you don't understand what i'm after, or if you have no idea how to accomplish it, then kindly, don't respond. I feel I have clearly outlined my goal. The code would be the same no matter what the name of the rep is - if there were 2 reps, then there would be 2 GROUPS instead of just...

This is EXACTLY what i'm looking to do: See attached. Do you see the "+" or "-" sign on the left of column A? That's what i mean by grouping. I didn't know there was another grouping function in Excel. I want to GROUP all ROWS that contain the same data in column C when i double-click on a...

Skip, I already know what i want to accomplish. i am simply looking for a bit of guidance to perform a repetitive task. i don't need to modify the spreadsheet and i'm not going to start messing with pivot tables, etc. This is a spreadsheet provided to me by the company i work for and i'm not...

Skip, see attached. I want to be able to double-click cell C2 and automatically GROUP rows 2-39 (actually 2-38 because row 39 would be visible) because they all have the same data in Column C.https://files.engineering.com/getfile.aspx?folder=323bd55c-059e-4ca3-ba30-c51c81700bb5&file=Sample.xlsx

Skip: I never said i CANNOT filter by sales rep. i said i DO use filters. But i WANT to be able to double-click on the rep's name in column C and have VBA automatically GROUP all the rows immediately below with the same rep name (whether it be 40 rows or 100 rows). i just don't want to...

i do use filters but i want to group them by rep names so the when i filter a specific territory, i can see all reps on one screen (there may be 6-10 reps in each territory and up to 100 customers per rep). Not looking to group by territory, just reps because the spreadsheet isn't sorted by...

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

Thank you very much jrbarnett and kjv1611 for your suggestions. I will look at each of those methods and will figure something out.

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

AWESOME fneily!!!! Thank you soooo much for that!! i've been trying to figure this out for MONTHS!!! i owe you a beer!! thanks again.

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?

anyone have any suggestions?