Search results

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=#" &...

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...

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...

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)

Hi guys. I searched for this (probably easily solved) problem but cannot seem to find a solution. What I want to do is to send a value from a table (tbl1) to a control (ctr1) in a form (frm1) in an after update event. This is what I have so far: Private Sub Command_AfterUpdate() Me![Ctr1] =...

Easy one There's probably an easy solution to this but I have been fiddling about it for quite some time now. What I want is to reveal a textbox only when a checkbox is checked. This is what I have come up with so far. If Me![Checkbox] = 1 Then Me![Textbox].Visible = True Else...

I have a search form that enables the user to search the data in a table, and this works fine. But I would like to have the option to search between two dates as well, and this is where the problem lies (mismatch error): Private Sub cmdSearch_Click() 'Set the Dimensions of the Module...

Hi I'm trying to export a switchboard from one database to another, but when I'm trying to open the switchboard in the new database I'm receiving a compile error: User-defined type not defined. Here's the code (error line in orange): Option Compare Database Option Explicit Const...

Hi everyone I have a code that shows a message if the user tries to register 2 of the same products within one order. The code is: Private Sub Typebetegnelse_AfterUpdate() Dim IsThere As Variant IsThere = DLookup("[PID]", _ "tblKalkyleSub", _ "[KalkyleID] =...

Hi everyone I have a report which I am trying to merge into word. Everything seems to be working perfectly except the list box in my report. For some reason this comes up blank in the word document. The list box is based on a product combobox within a form. I guess my question is whether it is...

Msg Box Hi. I have a subform (frmOrderSub) which is linked with the form (frmOrderMain). In the subform I have a PoductID combobox where one line is added for every product chosen. What I need to do is set up a VBA statement that pops up a message when the subform has duplicate lines. I.e. if...

I have an order database with a with a customer lookup within it. The customer lookup results in a report. What I would like to do is for each customer listed in the report to have a link to the orders they have made. I don't know if this is possible, but how could I sove this problem (also...

Hello I have a problem with an Iif statement. I have a field which shows a percentage, and I want a message to pop up if the user enters a number lower or higher than a set integer. I have made a macro that does that actual popup, but how do I set up the Iif statement? Thanks for your time Mads

Hi! I have a subform with a combo box. The combobox has a query with a condition linked to a field in the main form. What I want is for the combo box in the subforn to show values based on the data in the main form field. As of now the combobox doen't update itself when I change the value in...

Hi I have a subform that's based on a query. In the main form I have a field that's linked to the query as a condition. My problem is that the subform doesn't update when I change the fileld in the main form. Does anybody have a solution to this? Thanks. Mads