Search results

Thanks. Works perfectly now.

I am new to using modules so please bear with me, I am trying to write a module with some commonly used procedures in my forms to save on time coding. This is just one of them but the rest will all be similar so it should suffice to help me. The module code is: Option Compare Database...

I have been looking for a similar post to my problem for an hour now and the closest I could find is http://www.access-programmers.co.uk/...reset+rec ord I have a Form, Form1, with a sub form, Sub1, that are links threw a text field that is the primary key for both of them. Sub1 is hidden by...

Ok, I have figured out that the cause of the errors, at least as far as I can tell, is that [Jersey Type], while part of the record source, does not physically appear in the report. I have place it in the report and set is visible value to false for the time being, but is there a better way to...

Thank you Moniker. What you suggested with the Dlookup seems like it will work fine, but I am having trouble grabbing the vale on the last parameter. Following you suggestion. Txt_Jersey_Type = DLookup "[Jersey Name]","Jerseys","[Jersey ID]=" & [Jersey Type]) Gives Error 2645: Can’t find...

Ok this is a two prater. First I need to figure out how to change the background color of a txt field in a report based on its value when the report is viewed. More specifically, I have a report in witch I want to the add the functionality that if a field is blank, but they should have put...

Thank you guys, it was the missing 's, that part runs fine now. As for what your asking Lagbolt, I don't think I understand what your asking, but what the call Im doing does it to delet a record of a subreport withing a partent report. It is called from the parent report when the check box...

Ok. I had an earlier post, http://www.access-programmers.co.uk/forums/showthread.php?t=121599, asking how to get a delete query to run in a form. At that time the field being used to look up the records was a number field. Recently I relised I will need to let them put letters into the field...

Figured it out myself. Form.Parent will call the parent form if my understanding of the help documentation is correct. So Form.Parent![Field Name] will call a field in the parent form, even when there is no data in the linking field for it to use. This should always call the curent active...

Most if this is a discription for anyone trying to help that needs more then the actual question. Skip to the last paragraph for the actual problem. I have a form, Frm Art Sheet, with a sub form in it, Frm Numbers Catagory, They are linked using a unique key from the table for the main form...

Thanks. Missed the " & [Forms]![Art Sheet]![Order ID] & " part. Works fine now.

Hi, I'm trying to creat a form that will delet the related data from a sub form when the check box on the main form that controls the display of the sub form is set to false. I've had lot of exsperiance with C++ and some with Visual and C #, but this is the first access report I've writen that...