Search results

Hi Where to begin! I'm so pissed off now that i want to get this to work even though the calculation method would work,face, nose, spite, cut off!. There was one field that was set to Yes so i removed that. I unbound the textbox and on the afterupdate event of the combobox filled the textbox...

Hi Fizz At what point does the form afterupdate event fire? I am wondering if the problem is that i have field validation in the tables and this is in some way preventing the data from being created until all of the fields are complete?? If you look at the pic you can see what i'm trying to...

Hi Rich TBL_Y does have a pk and that is the data i am trying to store in TBL_Z, and yes it is the bound column, but it's not the data i am trying to display to the user, that is the second column of TBL_Y Like Select data from TBL_X to display in Cmbo_X 0cm,2.5cm = 1(bound), "Before"...

Hi I am trying to use a combobox to create 2 entries is a table. The first entry is simply the selected item from the combobox, the second is created as follows Private Sub CMBO_OPERATOR1_AfterUpdate() Dim rst As DAO.Recordset Set rst = Me.RecordsetClone Me.Bookmark = rst.Bookmark If...

Hi Rich Not sure what you mean by store. I need the values selected to be entered into the table, which is what happens. The data just doesn't display correctly on the form. Can you explain further pls. Thanks Chris

Hi Fizz That's just what i hoped you weren't going to say:D !. I guessed as much from how it was behaving but you can never be sure. Well i guess i'll go with the single form option for now. Thanks for explaining it so clearly. Cheers Chris PS i did mean continououou... i just could stop...

Hi Not sure what's going on here. I have a tabular form with 2 comboxes CmboX and CmboY. CmboX gets its row source from TBL_X and CmboY from Tbl_Y. In the rowsource query for the CmboY i have put the criteria that if the value in cmboX is <=3 then display only records 1,2 and 3 from...

No worries

Hi Have you tried using the name of the table as a prefix i.e [tbl_A].[Price]*[tbl_B].[Price] Chris

Hi I haven't a Scooby i'm afraid. But as long as you've got the answer it's not to bad. I must admit i don't like doing something if i don't know why, i've searched MS knowledge base and a couple of other forums and can't find anything. Good Luck Chris

Hi Found this. http://www.good-stuff.co.uk/useful/postcode.php. May be some help. Chris

Hi Just a possibility but have you mis-named the label lblO1? Have you used a zero intstead? Chris

Hi It appears that one of the forms has become corrupted. I don't know about anyone else but this seems to be a perennial problem for me. I've been using access for nearly 4 years now and i can honestly say that have had only 1 db that hasn't fallen foul of some corruption or other regarding...

Hi I've copied it to a new db and it still does it. I've converted it to 97 and it works but when i convert that back to 2000 or 2002 it doesn't. I've used an microsoft ado ext 2.7 for dll and security and microsoft activex data objects 2.1 library so maybe they are causing some problem??. I...

Hi I've got to deliver a db tomorrow. I was just doing some tiding up extra comments etc when i started to get the error message when opening the main form. Microsoft access can't find the tool bar '60' As it turns out one of my subforms wouldn't display as well, so i tried adding it again...

Hi I had checked and it said you could only do it in design view, however as you can in VB5 etc i wondered if there was a work around. Chris

Hi Does anyone know if you can create a control, say an textbox, on a form without it being in design view. i.e if i click a button on a form the textbox is created. Cheers Chris

No worries Chris

Hi I just had a look at the outputto macro procedure and under autostart select no that stops the report opening up in word. Chris

Hi This code outputs the report without showing the document. Private Sub Command6_Click() On Error GoTo Err_Command6_Click Dim stDocName As String stDocName = "FORUM_BADWORDS" DoCmd.OutputTo acReport, stDocName, ".rtf", stDocName & ".rtf", False Exit_Command6_Click: Exit...