Search results for query: *

My application uses row level record locking in a multiuser environment. Does anyone know how to check if a row is locked for editing?

I am getting the error in the subject line when I execute the following function. I marked the line the debugger is stopping on. Public Sub ExportToExcel(rptType As Integer, _ JobID As String, _ startdate As String, _ enddate As String) On Error Resume Next 'Turn off error...

I am using a ComboBox to display time values in a DropDownList. The values get pulled from a SQL Server database. The field in the database is a datetime field and I enter the values like "6:00:00 AM" When I pull these values from the database and use them to populate the ComboBox...

I have an Access front end that gets used on multiple computers in a network. In the master file, under the Tools-->Options-->Advanced Tab, I have set the record locking scheme as follows: Default Open Mode: Shared Default Record Locking: Edited Record Open Database Using record-level locking...

I have a main form with a subform on it. The main form has a Calendar Control on it. When the main form loads, I set its recordsource and I set the date for the calendar. I then use the calendar's date to filter records in the subform. Here is what's in the load event of the main form...

I have two datasets with identical schema. Each one is filled by a separate DataAdapter. When the first dataset is filled by its DataAdapter, it contains a table with rows of values. The second dataset, after it is filled, contains an empty table (i.e. there is no data in the backend database...

I'm not sure that I understand the Merge method correctly. I have two datasets each with its own datadapter. The first: DataAdapter --> daAccess 'generates a dataset from an access dbase Dataset --> DsBillingRatesAccess1 The second: DataAdapter --> daSQL 'generates a dataset from an SQL...

I have a datagrid on a windows form that gets populated by a DataTable when a button is clicked. I am trying to use the values provided by a combobox and two DateTime Pickers to supply parameters to the SelectCommand of the DataAdapter. Whenever I click the button I keep getting this error...

I need to know in VBA how to select an entire Excel column and change its format to "Date". I haven't done much Excel VBA coding, but it seems like this should be trivial. Help is very appreciated.

I have a form with the Microsoft Calendar Control 7.0 on it. There is a subform that gets filtered by the date selected on the calendar. When the form loads, the following happens: Me.axCal.Value = FormatDateTime(Now(), vbShortDate) 'Code debugs to the line below...

I am using the very helpful macro discussed in the FAQ, http://www.tek-tips.com/faqs.cfm?spid=705&sfid=2562, which shows how to hide the Access window. One problem. I have forms that have their DefaultView and ViewsAllowed properties set to Datasheet. They have their PopUp properties set to...

I am working with this little subroutine that will enumerate certain properties of items in an Outlook Contact Folder, but it's throwing a type mismatch on a certain iteration of a For...Next loop everytime, and I have no idea why. See comments. Here's the subroutine: Sub EnumFolders()...

I am using a query embedded on a form as a SourceObject and it's a Crosstab query that's based on another query. That's why the SQL of the base query itself needs to change instead of just using a filter on the subform. I need to alter the WHERE clause of the base query when a button is...

Can anyone tell me why this code: set oConn = Server.CreateObject("ADODB.Connection") DBPATH = Server.MapPath("/") & "\subdir\dbasename.mdb;" keyarch_noDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPATH & "Persist Security...

I need to perform a text-parsing operation of the body of every message in an outlook folder. I have figured out how to access the folder's count property through the Items collection object. I can even use the GetFirst method on the Items collection to access the body of the first MailItem...

I have an Access 2000 database with multiple identical front-ends (user_name_timesheet.mdb) all linked to a common backend (master.mdb). It's basically a database that tracks employee time on various projects and it prints weekly reports (i.e. timesheets) for each employee. All of the sudden...

I have a website which uses MS Access as the backend. I am trying to use Ultradev to define a recordset. This recordset is a crosstab query, the SQL for which I've simply cut and pasted from the Design View in Access into the define recordset dialog in Ultradev. It doesn't seem to work...

I have a query that is pulling timesheet records. It calculates the total hours spent (elapsedtime) per each employee, per job. It returns results like this. jobno jobname empl elapsedtime 221 xjob1x Clay 6 221 xjob1x Jim 3.75 221 xjob1x Steve 0.5 103 xjob2x Jim 71 103 xjob2x...

I have a database which tracks employee time by project. I would like to retrieve the date corresponding to the first and last day the project has been worked on. So I established a first query, qry1. The SQL is like this: SELECT tbljobs.jobnumber, tbljobs.jobname, tbltime.dateworked FROM...

I need to use VBA to get some simple properties from the currently open MS Word 2000 document, and then export the values to an Excel Spreadsheet Template. I want to be able to do this using a Hotkey. In more specific terms: I want to press Ctrl + W. When this occurs, I want VBA to grab the...