Search results

Sweet pics audrey! Yeah, I was sort of bummed about the "no animation" rule. I had developed a cool logo with a guy feverishly massaging a monkey, with VBA code encircling his head, and fireworks going off in the background; but then realized I'd probably spend the next two years of my life in...

In the same spirit as donbettis... here's another submission to keep ideas coming... Jeff

Can it be an animated gif?

Thank you for your comments. The AutoExpand is on. The Limit To List is on. A query for the Rows Source is the way to reduce the down-down list items to just those meeting the criteria that the user has typed in. My query works in design mode (being based on the combobox itself...

Is it possible to update the drop-down list of a combobox as the user types within the combobox. e.g. Combobox is used to enter employee name. As user types "A", all employees who's name starts with "A" are displayed in the drop-down portion of the combo-box. Then when user types an "n", only...

I've never imported an excel spreadsheet, but other ActiveX controls I've worked with were simply Forms!MyForm!MyControl.Property HTH, Jeff

Thanks for the reply Bob. The scroll bar that I am referring to is not my own ActiveX control (in which case your answer would be very appropriate), instead I am referring to the scroll bars that Access itself supplies. I had a bit of a break-through (very small break-through) last night when...

Alexandre's response to this thread might be helpful: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30495 HTH, Jeff

My answer (if I have your question right) would be the creation of 4 Yes/No fields in the Users table indicating whether that User had required tasks during which week. You could also have a single text field and fill it with the week numbers (e.g. "124") this would demand some parsing of the...

Thanks for the reply, cogent. I think the problem was I didn't have UpdateDays defined as a PUBLIC sub. Jeff

Is it possible to determine where the scrollbar slidebar is located at any particular time. This is what I'm looking for: If slidebar is at the top of the scrollbar... form.scrollbar = 0 If slidebar is at the bottom of the scrollbar... form.scrollbar = 1000 If slidebar is exactly in the...

Got it working again. I had an error in the parameter list of a MouseDown procedure in a form not even open. Must have been throwing something off. Nice of Access to give me such a helpful error description! :p Anyways, bottom line is I'll try to complie code first when ever I meet this...

Hope someone can figure this out because I'm toast if I can't getting it working again. Code originally worked fine. I'm getting a "Method 'Item' of object 'Forms' failed" error. Program errors on this line If Forms(i).Name = sFrmName Then <--- Error occurs here. If...

I am trying to call a procedure that is located in my subform module from my main form. I keep getting Here is my set-up: Form: frmSchedule SubForm: subDetails Subroutine Name: UpdateDays This is the call from the main form: Private Sub Button1_Click()...

Was going to ask this question but found the answer here: Checkmarks for custom menu items FYI, Jeff

Thanks Alexande, The GetClientRect API was just exactly what I needed! Cheers, Jeff

I would like to create a form that completely occupies the workspace of the Access Application window but without using the maximize method. I need something like this: DoCmd.MoveSize 0,0,?,? But don't know how to find values for ? and ?. The situation is fairly complicated because 1 OR MORE...

I was going to suggest you considering using the MS Flex Grid control if all you needed was a list to select from. If the items listed need to be edittable I would not go this route. Jeff

Cosmos, Do the fields still have to be edittable or is this just a list that the user selects a particular record? Jeff

First thought is to make sure rstD![Chemical_DataID] is declared as a long integer field and not autonumber. Next if that is not the answer I would eliminate any relationships involving these two fields and see if that helps. Let us know what works.