Search results

Unfortunately that is not going to change. Limited computer resources, and skill sets. A Supervisor is responsible for gathering the paper forms and entering into their laptop. Non-Supervisors have no access to computers.

Gemma: Thanks for the reply. I"m starting to believe I can't accomplish the data entry method I'm seeking within Access. After many hours attempting to achieve the desired data entry behavior in Access, it looks like I"m back to including an .xltm file with the solution. The business...

Thank you for the reply. I've played with your idea, I see the merit in storing just the date/time in one field. I can always use DATEVALUE and TIMEVALUE to extract what I need later. However, I'm still not seeing how to give myself the ability to input data in one horizontal row for multiple...

If using XL2007 or greater, read up on SUMIFS. =SUMIFS(I2:I576,H2:H576,">1/1/2009",H2:H576,"<6/30/2009") if prior to XL2007, you can achieve this result with SUMPRODUCT like this: =SUMPRODUCT(--(H2:H576)>1/1/2009,--(H2:H576)<30/6/2009,I2:I576) great tutorial on SUMPRODUCT here...

Pulling my hair out here. I'm guessing it's something simple. Fresh eyes most welcome. I"m attempting to facilitate data entry in a manner that is aligned with an existing paper form's layout. Of course, it was done on a spreadsheet. It's a basic time entry situation, for an employee's...

Gemma: Thanks for the response.... Yes, I'm filling an Unbound Listbox with that procedure. The Data filled into the listbox is the result of a VBA function using several input variables pulled from a different Form, some of which were planted there by a query, others by the User in Unbound...

I'm attempting to utilize a Static Variable to retain a value while filling a listbox with a UDF, in hopes of gaining some performance increases in the creation of a cumulative sum. I'm using code adapted from the example here: http://msdn.microsoft.com/en-us/library/bb242937.aspx as pointed...

Your first lines of code: If ListBox1.Value = "New Event" Then 'these two lines seem to be necessary to prevent the InputBox 'from showing twice, and causing "NewEvent" to be added to the list twice. ListBox1.RemoveItem (ListBox1.ListIndex) ListBox1.AddItem "New Event" would...

Are you doing this in Excel? Or Access? Application.Screenupdating = False Screenupdating is a property of the Excel's Application Object, not Access'. To accomplish similar task in Access, try application.echo false The "Selected" method I referred to in my previous post is not a...

To get the "Blue Highlighted" row to appear you need to Select the row. A statement in your code such as this will Select the Row indicated. Of course you have to know which row you wish to select. me.lboxMyList.selected(1)=true If the item you just added is at the end of the list you might...

I can't seem to successfully deal with this error. The scenario is as follows. I click a button which launches an email with an attachment, with the option of having the User see it first. That works fine. If the user chooses to not send the email however, and hits the email's close button...

Jal: Thanks for that insight. I hadn't thought about redefining the range name when I put the sheet away. I was trying to rely on Excel doing it automatically for me with a dynamic range definition as I usually do when just using Excel. This is my first attempt at using an Excel sheet to...

I have a line of code similar to thisDoCmd.TransferSpreadsheet acImport, 8, _ "OldSched", strFileName, True, "OldScheduleFixed" that works fine IF the Range name in Excel is defined as a predetermined number of cells. For example, if "OldScheduleFixed" is a named range defined as...

Thanks Bob, Glad I wasn't missing something easy. I played around with it a little more. It appears that the order in which the fields appear is a function of the Tab Order for the controls on the form. I hadn't spent time on my evolving form to set these as they should be. After doing...

Is it possible to have the Field values in the Builder window, appear alphabetically? I have a Form with many fields, labels etc, that I frequently refer to with the Builder's dialog when creating ControlSource references for other fields. Inevitably, I spend time scrolling around looking for...

I'm wondering if there would be a way to have an email generated by Access's sendObject method for example, that could use the non-default email account in your Outlook setup. I have a button that launches an email with a PDF attachment with the following line of code: DoCmd.SendObject...

Re: UPDATE to Textbox based on UDF(subform value) Problem The undesired #Error result seems to only appear when the main form is requeried. For clairification: Mainform tied to Client Info Subform1 displays "Projects" for that client Subform2 displays "Contracts" for the Project selected in...

I'm not getting this one... I have a main form with two subforms, and various bound textboxes on the mainform. I'm having a problem with using a User Defined VBA Function (UDF) as the control source in a text box on my main form. When I initially open the form it works as intended. Upon...

You can also get at all the page's form control names with code. Load up the page, then grab all the objects of the type you want in a previously Dim'd HTML Collection with a statement similar to this... Set myHTMLColl = ieDoc.all.getelementsbytagname("the kind you want") eg. "the kind you...

Here's some snippets... Public Sub IE() 'Requires Reference to the HTML Object Library Dim IEapp As Object Dim IEdoc As Object Dim URL As String Dim myPageHtml As HTMLDocument Dim Htables As IHTMLElementCollection Dim myTable As IHTMLTable Set IEapp = New InternetExplorer '...