Search results

Nevermind, managed to change dates to numerical. That made the trick. Thanks again

Thanks Guus for your reply! I've now switched the table to hold numeric values. My coding skills aren't all that good, so I havent managed to alter the code to handle numerics instead of dates. Does this require alot of recoding or is it only a couple of changes. Thanks again.

Hi Guys, I have just recently downloaded a calendar from the forum, but I have some date problems (as far as I know). The calendar form itself runs smoothly. However, when I try to enter a new appointment I get an error: Syntax error in date in query expression (([tblInput].InputDate=#" &...

Last try: Could somebody help me translate the code from DAO to ADO? Thanks again!

Looks like there's a problem with Access itself. tried to open a blank database and I'm still getting the same error. Maybe I need the dao360.dll? Nope, no joy. Downloaded a fresh copy of dao360.dll and registered it, but still the same.

The Doc: Thanks for your reply. I will try your suggestions. Not too familiar with VB though. Pbaldy: VB for applications MS Access 12.0 Object Library OLEAutomation MS Office 12.0 Access Database engine Object Library MS Excel 12.0 Object Library I'm running Access 2007

Looks like I've found the error. I did't have the reference to DAO. However, now I've got a problem with adding DAO to the references. Keep getting the error: Name conflicts with existing module, project or object library when i try to add. Any ideas?

Hi guys, I'm having some troubles passing a query to an existing .xls. Code: Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("qryTest", dbOpenDynaset) Set xlApp =...

I have a database created in MS Access 2002 - Norwegian environment, which also works great in an english environment. However when running the database in a chinese version of Access I get the following error message: <See attachement> Hope some of you guys could help me fix this. Thanks alot.

I really need some help guys. For some reason Access always asks for a login/password even if the database isn't protected. Even when I start a brand new database the prompt comes up. Any ideas as to how to get rid of this.:confused:

Hi guys, I've got 2 questions for some problems I've been pondering for quite some time now. 1. At random one of my forms get the error message 2106 - "your form has 3 errors...". And I am not able to open the form in design or regular mode. I thought it might be a cross reference problem or...

Hi guys, I just tried to copy a switchboard from one database to another, and I 'm now coming up with an error (see red font). The error msg is: Compile error: Method or data member not found ************* Private Function HandleButtonClick(intBtn As Integer) ' This function is called when a...

Thanks for all the feedback guys, It works like a charm now. However I have stumbled onto another problem. I'd like to show several records at one time, and I therefore need a continous form. The easiest way, as I see it, to overcome the date problem now is to do it through a query....which...

Dim IsThere As Variant IsThere = DLookup("[ID]", _ "YourQuery", _ "[ID] = '" & Me.ID & "'") If Not IsNull(IsThere) Then MsgBox There is no data for the information you have entered.", vbInformation, "No Records Returned." End If

Hi guys! I have a string of 8 numbers that represent a date. This is extracted through ODBC so the format is bad. October 22nd 2004 is shown as 20041022. How can i re-format this string to look like: 22.10.2004 I am mainly using the date in a form. Thanks for your help Mads

Hi guys! I have a nifty little searchform which I actually found here. It works great, but I would like to trim the results it gives. Private Sub cmdSearch_Click() 'Set the Dimensions of the Module Dim strSQL As String, strOrder As String, strWhere As String Dim dbNm As Database Dim qryDef As...

[Code] Private Sub cmdEmailJob_Click() DoCmd.SendObject cReport, "rptVinciInstructionToEngageSubCon", "RichTextFormat(*.rtf)", EMail, , , "Job No. " & Me.NameofControl, _ "Please see attached.", False DoCmd.SetWarnings False 'DoCmd.RunSQL "UPDATE tblSubConOrders SET tblSubConOrders.MailSent = -1...

Thanks Pat....Always easy when you know what to do :)

Just wondered if anybody knows how to exceed the limit for the query prosessing time. I'm trying to import data from the AS400 system to access with an ODBC call. However I'm getting this error msg: ....Estimated query processing time 179 exceeds limit 60. (#-666)

Solved the problem by using DLookup. Private Sub Command_AfterUpdate() Me![Ctr1] = DLookup("[Value1]", "tblTable1") End Sub Thanks anyways