Search results for query: *

Hi everyone - I have a user who developed his own Access 2000 database. In general, he did a pretty good job. But he has a question that I haven't been able to answer. Here goes: This user has written many Select queries. He is using the resulting data grid from a select query to update...

Hi everyone - A requery command for a subform on my main form is not giving me any results. But it's also giving no error, so I'm not sure where to turn. Here's the details: I have a main form called "Tutor Hours", which contains an unbound combobox called "cboTutor", a...

Hi everyone - I'm using Access 2000, and trying to print a field in my report page header that comes from a text box that the user enters into a form. The text box in the page header of my report is called "PartialCode". The control source for this text box is set to...

Hi everyone - I am trying to store a field in an Access 2000 table that is defined as a "Short Date". I started out with a nine digit number (called CourseDate, defined as "double") that looks like this: 103021603. I stripped off the first 3 digits using: DateNum =...

Hi everyone - I have a form that displays a datasheet. When I click on a specific row of the datasheet, I want to be able to reference (with VB code) a certain column in that row that I clicked on. How would I reference the field I want? Thanks for your help... - Anita

Hi everyone - I'm working with Access 2000 and Netscape Communicator 4.77 as my email tool. I was trying to generate an email message using SendObject, and I was occasionally getting the following error: Error # 2958 , Description: "Reserved Error" Through a lot of trial and...

Hi everyone - I'm currently running Access 2000, and using Netscape Communicator 4.77 to send email messages. I'm trying to format an email message to include carriage returns, but haven't been successful. I have tried all the options you see below in the code, and all of them give me the...

I'm fairly new to Access (2000), and am stumped with a report printing problem. I have generated an Access report which is a work order, listing multiple tasks related to each specific work order (along with other info). When the user previews the report, they only need to see one work order...

I'm fairly new to Access VBA coding, and having a problem creating a recordset. I have the following code in an Access 2000 application: Dim rstResources As Recordset Dim strSQL2 As String strSQL2 = "SELECT EventID, " _ & "[quantity reserved], ReservationStartDate...

I currently have an Access form (Form1) that contains two subforms. One (SubformA) contains a number of text boxes and comboboxes. The other subform (SubformB)contains the same fields as SubformA, but in datasheet view. When a user clicks on a row of data in SubformB's datasheet, I want to...

I'm currently working on an Access subform which is displayed in datasheet view on another form. The subform contains a combobox called "cboResourceType" and a listbox called "lboResourceName" (which is dependant on cboResourceType). The "cboResourceType" combo...

I'm currently working on an Access subform which is displayed in datasheet view on another form. The subform contains a combobox called "cboResourceType" and a listbox called "lboResourceName" (which is dependant on cboResourceType). The "cboResourceType" combo...

I'm currently working on an Access subform which is displayed in datasheet view on another form. The subform contains a combobox called "cboResourceType" and a listbox called "lboResourceName", along with a few other fields. When the form displays existing data, there is one...

I'm currently working on an Access subform which is displayed in datasheet view on another form. The subform contains a combobox called "ResourceType" and a listbox called "ResourceName", along with a few other fields. When the form displays existing data, there is one row...

I would like to create a control array of frames on a form. After reading some other threads about similar subjects, it seems that, when adding the frames to my form, I should be prompted with the question "Do you want to create a control array?" However, I don't get prompted with...

I'm trying to use VB to export an Excel chart (not an embedded chart) as a .gif file. I get a "type mismatch" error when just trying to reference the chart, before the actual export step. A few samples of the code I've tried follow: Sheets(SheetName).Export FileName:=Fname...