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?
...CommandType = 8 - adCmdUnknown
ConnectionString = DSN=BranchErrors
CursorLocations = 3 - adUseClient
CursorType = 2 - adOpenDynamic
RecordSource = **This is where I need help
When I set the Adodc1.RecordSource property with SQL, how do I pass a long integer in the sql statement. If I...
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...
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 also added an Adodc and named it Adodc2. Adodc2 is the Data Source for DataRepeater1. Adodc2 uses an ODBC, the RecordSource = SELECT * FROM tblBillingWorkTable WHERE CustomerID = '& sSearchCustID &' ORDER BY tblBillingWorkTable.BILL_Level DESC , tblBillingWorkTable.AcctToCharge...
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...
...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" before the form imports it. I can concantenate by manually opening a command prompt, then changing the root...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.