Search results for query: *

Beautiful! Thank you!

I am attempting to calculate many time durations and then sum them. The durations can be 4 seconds to 2080 hours. Cool Function, and if I understand it correctly it determines the difference between (2) dates and displays the results. I am needing to determine the difference between (2)...

Ok, I give. I've tried to incorporate several Time Calculation Tips and now I've confused myself to the point of not knowing if I'm way off track or almost there. Below is what I want to do and what I have done thus far. Is this the best way? I am working in Windows 2000, in Microsoft...

Thank you for the feedback. I think the lesson I've learned (from other sources as well) is to limit my use of the adodc control. I usually access the databases with ado with sql in the code - but wanted to allow the user to easily scroll through records on a particular form thus the adodc...

Thank you for your responses! I tried them out and here are the solutions I settled on to allow the user to type the code, auto expand and limit to list: To allow for a Drop Down - this was provided by thread222-953023: On Form: Private Sub cboErrorCode_KeyDown(KeyCode As Integer, Shift As...

When I change the style, the user is no longer able to type the value manually. They are entering errors codes which are only 4 digits so I want to allow them to quickly type the code in if they know it but select from the list if they don't. Is this possible?

Is there a property in VB for a combobox similar to MS Access where you can select LimitToList or does one need to write code to validate what was entered in the combobox on a particular event?

I am working with an Adodc in VB with Access as the Back End. There is an ODBC Driver called "BranchErrors". Here are the settings on the adodc1.property page: CommandType = 8 - adCmdUnknown ConnectionString = DSN=BranchErrors CursorLocations = 3 - adUseClient CursorType = 2 - adOpenDynamic...

OS: 2000 Front End: MS Access 2000 Back End: SQL Server For over two years, one a month we have imported monthly billing data from SQL Server tables into Access tables via many queries which do many things to the data as it is imported - including counting field widths. I only mention this...

Thank you for your response - it worked! I was missing the syntax in bold. Please forgive me - the subreports are indeed linked via CustomerID - I was thinking linked meant something else so I went and looked up what it meant. subreport formula: whileprintingrecords; shared numbervar...

Crystal 8 Microsoft Access I have a Main report displaying CustomerIDs. For each CustomerID there are (3) unlinked subreports - one is displaying AccountIDs, one is displaying SiteIDs and one is displaying ScannerIDs. I would like to have a grand total at the bottom of the Main report...

Your "CurrentRecordChanged event" Workaround works beautifully! Many Thanks!!! Michelle

The workaround does work, but it consists of adding a button to the form that the user must click after modifying data on EACH record :( Takes away from the essense of the control. Is there any other control that works similarly (displays data in columns that can be updated)? Thank you for...

Bob, thank you for your response. I'm off to a class today but will try the workaround first thing in the morning and let you know how it goes. Michelle

I'm working in VB6 with MS Access 2000. I have a data repeater control that is displaying properly, but it is not updating the underlying table with new values entered by the user. I built an ActiveX data repeater control, pubCtl.ctl, and saved it in a project called controlPrj.vbp. In a...

Gotcha! Thank you. Thought you were just referring to the 2 and True questions - didn't realize it was new code. All is good. Thank you, Michelle

I need he VBA to pause, but I am getting a compile error. What am I doing wrong? This code works - but I need a pause: CreateObject("WScript.Shell").Run ("%COMSPEC% /c copy " & sSourceFiles & " " & sDestinationFile) This code yields compile error as noted above...

CreateObject("WScript.Shell").Run ("%COMSPEC% /C copy " & sSourceFiles & " " & sDestinationFile, 2,True) The above syntax yields the following Compile Error "Expected: =". I removed the last part of the syntax, ",2, True)", to get past it and ran it SUCCESSFULLY!! Is this syntax required and...

Thank you for your quick response PHV, I have been unsuccessful in getting this to work so I thought I would send you my code - I'm sure I am leaving something out. It looks like the command window flashes on the screen, but too quickly for me to see what it says and the new file does not get...

Is there a way to programatically call a command prompt and execute commands from an on_Click event from an MS Access Form? What I am wanting to do, (unless there is another way to do it), is allow the user to click a button which will concantenate several "*.file" files into a single ".file"...