Search results

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

:D Sorry mile, I managed to do a typo. Guess it's a little bit early in the day for me. Thanks again.

Thanks for your reply mile, but now I'm getting a runtime error 13 - Type mismatch. Any ideas?

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

Well, it's not the date format that screws up, I've tried with every possible format now, and it still comes up empty (but only when i try dates?). Maybe I should do the search form the hard way through queries :(

Thanks Mile, I don't get the error message anymore, but now the search comes up empty when I run it with dates. Could it be bacuse of the date format? I am using (dd.mm.yyyy). Mads

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

Thanks Mile, works like a charm now.

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

Thanks for your reply travis. Is a newbie to access programming I was hoping you could tell me how to do something like this:) Thanks again Mads

Take a look at this thread as well :)

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

Thanks Wayne, Worked like a charm Merry Xmas Mads

Wayne, Here's my code Private Sub Typebetegnelse_AfterUpdate() Me![Pris] = Me![Typebetegnelse].Column(4) Me![PID] = Me![Typebetegnelse].Column(1) Dim IsThere As Variant IsThere = DLookup("[Typebetegnelse]", _ "tblKalkSub", _ "[KalkyleID] = " &...

Thanks for you reply wayne. I think I'm very close now, but I keep getting RunTime Error 3075 (Operator missing) Do you know what's causing this? Could it be because I have multiple columns in my combo? Thanks again. Mads

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

Thanks for your reply Baxter. I probably should have mentioned this is the first topic but my database is linked (ODBC) and I'm having problems setting a key for the ODBC link. Therefore I cannot make any references between the tables. Do you know how to get around this problem? Thanks. Mads

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

I'll do just that. Thanks for your help. Mads