Trouble creating an mde file 1

[Bill4tektips]

I am trying to create an mde file from a database but I keep getting the message "Microsoft was unable to create an MDE database" I have looked at FAQ181-91 and followed the instructions on there but I still get the same error message. Any help will be greatly appreciated.

 

[mp9]

Possibly your VBA doesn't compile properly.

Open a module in code view and click Debugm Compile YourProjectName to find where the VBA prob lies...

http://www22.brinkster.com/accessory/

 

[Bill4tektips]

Thanks mp9. I tried that but got the following error
Private Sub DatePresented_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
' Note which combo box called the calendar
Set cboOriginator = DatePresented
' Unhide the calendar and give it the focus
ocxCalendar.Visible = True
ocxCalendar.SetFocus
' Match calendar date to existing date if present or today's date
If Not IsNull(cboOriginator) Then
ocxCalendar.Value = cboOriginator.Value
Else
ocxCalendar.Value = Date
End If
End Sub
The error is showing at
Set cboOriginator = DatePresented
The DatePresented is highlighted when I run the debug.
I have defined "Dim cboOriginator As ComboBox"
Any ideas?

 

[PHV]

Any chance you could post the whole error message ?
What about this ?
Set cboOriginator = Me.Controls("DatePresented")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bill4tektips]

PHV Thanks for that, changing it to your piece of code cleared that problem however I now get a new error in
Private Sub DateReportIssued_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

' Note which combo box called the calendar
Set cboOriginator = DateReportIssued
' Unhide the calendar and give it the focus
ocxCalendar.Visible = True
ocxCalendar.SetFocus
' Match calendar date to existing date if present or today's date
If Not IsNull(cboOriginator) Then
ocxCalendar.Value = cboOriginator.Value
Else
ocxCalendar.Value = Date
End If
End Sub

Where ocxCalendar.Visible = True
the "ocxCalendar" is highlighted
The error message is: "Compile Error: Variable not defined"
It all works within the database.

 

[TheTomCat]

Are you POSSIBLY trying to create an .mde with an Access 2000 file, using Access 2002?

If so, you can't use 2002 (XP) to make an /mde out of an Access 2000 file.

You would need to go back to 2000, make the .mde, then take it back to 2002.




Thomas Bailey
a/k/a TomCat

http://www.reportcop.com

 

[Bill4tektips]

TheTomCat: No I am definately using Access 2000

 

[jkl0]

You may be experiencing the same problem that I am.
If you imported any forms into your DB that has code behind it then you might be experiencing code corruption and may have to decompile or go to a last known good backup and recreate the form.
Also see faq705-2529