I'm getting a run-time error '13' with this line of code:
Private Sub VendorID_DblClick(Cancel As Integer)
DoCmd.OpenForm FRM_Expenses2, acFormDS, , , "vendorid=" & Me.VendorID
End Sub

Seems as if there are many questions about the ActiveX calendar control and
many warnings on not to use them.  I have used them with some success, but
some issues just make me scratch my head.  I am currently using it to have
the user select a start date and an end date to run a ...

Is it possible to have chart controls on the form?
I would like to have Excel chart like bare, pie, line chart on the form base
on the data in the table.
Is it possible to do this?

Is changing the background color of the command button possible? I know i
can change the FOREcolor (the font color) of the type in there but i want to
change the background of that command button using VBA.  
Please let me know!

I'm new to access and was wondering if anyone knew how I could input data on
a form...close the form (clicking saving) and later going back and viewing
the data?  I did those steps but when I go back the data isn't there...it
goes back to showing 1 record and it being a blank ...

I have a form that outputs the results to an Excel workbook.  I would like to
upon opening of the excel workbook to create a Macro that uses the
information and creates a Pivot Table then formats the Pivot table.  
I am not sure how to do this.  I have tried creating a Marco in ...

I'm using the MouseHook.dll file from the Lebans website and all is working
as it should.  The problem I have is that my company is putting the database
on our Intranet site, and the database is unable to locate the dll file as a
url.  Any ideas for where to put the dll file?  Is ...

I have developed a budgeting application in  Access 2003. It's been steadily
growing when it comes to forms/sub forms etc. I have a main form with a
"page" object with some 8 pages. In each page there is at least one sub
form. I need values from different sub forms to be updated ...

I'm trying to have a text field default to a mainframe date format which is
text YYYYMM. If the current month is 3/1/2008 than the default MF date would
be 200802, if the current month is 4/1/2008, than the default date would be
200803, and so on. My table is just two fields: one ...

Ok, after a few weeks of trying to figure this out i've finally decided to
ask the pros.
I created a tracking database that allowed for exporting to excel (this is
done and works fine). I also was able to format that same exported excel

I have a form that user can minimise once they have select filter
information for a report.
My problem is when the form is minimised it obscures the page select
controls of the report.

I have a form that has a combo box 1 (Product) that reads a the Product
table and has a unique id attached to each product (RO#). There is a second
combo box 2 that is RO#. Now what I would like to do is when a user selects a
Product in combo box 1, the system should lookup the ...

I am trying to be clever with an object on my form.  It is  a picture of a
van and its position is determined by a field called status;
I have done this by using
Me.Brady_Van.Top = 2438.1

I have a table which is in effect a FIFO queue. I need to retrieve then
delete the first record added. I'm assuming I cannot rely on the autonumber
key to do this and will need a timestamp column.
How can I ensure that different users don't grab the same record since this

I have a continuous form that I am using to display a bunch of text to a
user, so they can easily scroll through the records.  I'm looking for a
function which I can run that will tell me whether the text in the textbox is
completely visible or not.