Search results for query: *

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

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

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

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

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

I am working in MS Access 2000 and XP (Users are being updated in stages so I am looking for a solution that will work in both versions). From a form, the user needs to import a text file they have selected into a table (the table will then populate several text boxes on the form for the user...

I initially created a listbox with 2 columns with a click event to populate a form based on the CustomerID highlighted when the clicked. The listbox populates correctly when I initially load the form, but when I ADD or DELETE a record - the listbox won't display the new record or delete the...

Is there a way to position the cursor within a textbox? For instance, when a user clicks the "Add" button, a textbox is auto populated with the first 9 characters of an ID; the user enters the remaining 4. But the cursor is positioned at the left of the text in the textbox instead of the right...

We are experiencing an "ODBC-- CALL Failed" error while trying to "query on" or "open" a linked table, named "PTI", via ODBC; the other 7 tables linked by the same ODBC query/import fine. From Access 2000, we call an ODBC linking to tables on a Tandem box. According to our IT Source, "the...

I am trying to send a particular report in two formats, .snp and .rtf (.rtf for those recipients on older OS of Windows). At this point in the code, I have determined who can get which format. The first report will send, but the second doCmd.SendObject will not execute. (it goes through each...

I am sending a report in SnapshotFormat(*.snd) to a long list of email recipients (via Outlook). Many of the email recipients have responded saying they are unable to open the report; they get the following error: "Error 1706 no valid source could be found for MS Office 2000". I searched...

I am sending a report from a form in Access via email to a distribution list that will be built each time the report is run based on the data of the report - the distribution list can exceed over 100 email addresses. I am using MS Outlook 9.0 from MS Access 2000. My first question is: Is...

I have a Crystal Report that has several Cross-tabs based on a date range and grouped by OperatorID from data in SQL tables. I've condensed a sample below: 12/01/04 - 12/10/04 Operator Operator Operator Operator 10001 10003 10008 Total Processing...

I have a form, frmBarcodeScan, that allows the user to populate a text box, barcode, manually or via a barcode reader. (The barcode is always 8 digits). Included in the AfterUpdate event for the barcode textbox is a command to set the focus to another text box, txtRoute, on the same form. The...

Is there a way to translate a number such as "536.22" to "Five Hundred Thirty-Six and 22/100"? Thank you, Michelle

I have a form with a text box entry field which allows the user to enter paragraph(s) of data which is used to build a SQL string to ultimately be saved to a memo field in the table. Before the record is saved, it is spell checked. But when executing the SQL statement with the data from the...

The Force New Page property for my header is working correctly when printing one sided, but how can I tell Access 2000 to Force a New Page AND begin printing on an "Odd" page number so that when the user DUPLEX prints, the new section does not start on the back side of the previous...

The Force New Page property for my header is working correctly when printing one sided, but how can I tell Access 2000 to Force a New Page AND begin printing on an "Odd" page number so that when the user DUPLEX prints, the new section does not start on the back side of the previous...