Search results

Cracked it! Right, it would appear that I did need to modify the underlying query some more. I added the individual tables that are used as lookup sources for the master table i.e one for location, one department etc I made sure that the sources on the query fields reflected the indiviudal...

Jal, thanks for spending time on it. You are correct, I don't believe you are supposed to put text in a field designated as numeric. However, when you use the lookup wizard in table design it automatically defines the field as numeric after you finish it, but displays the values (text or...

ah ok. They are numeric as they are lookup's from other tables. I maintain a table of 'hazards' and a table of 'BusinessName' separately which are used in the main table. Thanks for checking it out. Shall I just edit my underlying query so it references the individual tables for Hazard...

ok, here we go... the offending forms are 'frmFilter' and 'frmFilterJSA'

Jal, I have five fields. The one that works is 'Surname'. I use this on the rowsource for that combo: SELECT DISTINCT qryEmployeeDetails2.Surname FROM qryEmployeeDetails2 ORDER BY qryEmployeeDetails2.Surname; Then this one (BusinessName) that doesn't work on the form: SELECT DISTINCT...

I still haven't cracked this. I thought I had followed this perfectly and have just tried setting it up again with the same problem. http://support.microsoft.com/default.aspx?scid=kb;en-us;208529&Product=acc I have setup an unbound form with unbound combos. I have setup a query which joins...

Hmm, may as simple as it gets. I deleted a few fields, including the offending ones and then added them again. This time they worked. I had originally creaed the report using the wizard and then modified it. Not sure why it didn't work until I added the same field again.

Fantastic, I was getting there. Thanks a million Mike, that has worked perfectly. Keeps things tidier, which is great. Bob, thanks for the pointers too, I changed 'acSaveYes' to 'acSaveNo'

Tony, thanks. Smashing videos by the way, solved another minor annoyance I had but not this one I'm afraid. It must be relationships. I'm having a similar problem with a form to filter a report as well. If I had any hair left I would be tearing it out about now.

Yes, I need the combo to display the text column, not the ID column. 3 our of 4 display the ID column but when I set column count to 2 for these and set the widths I then get nothing showing in the combo. I am definitely bound to column 1 on them all, as it should be. I just can't make sense...

Guts, thanks very much for your responses. Very much appreciated. However, I'm still doing something wrong. The form I want to keep open is my main Switchboard, called 'Switchboard'. So on another form, I assigned the code Lagbolt suggested to a button's on click event first: Private Sub...

Hi, I'm trying to keep my database clutter free for the user and thought that it would be good to try and have forms close when the user clicks 'home' and jumps back to the main menu/switchboard. I have tried this with a macro but I can only seem to be able to set it to close one form and...

I setup a form with unbound filters on (as per MS example) to open a report in full page and then filter the results. I have set my rowsource details for the relevant combo boxes and bound to column 1 in properties. When I load the query for that combo and run it it reports the list of combo...

I have a sub-report which pulls data from a query. I have one combo box source which refuses to display the value, onlythe numerical reference. When I run the query within query builder it displays the text but in the report it only displays the numerical value. The reports field is bound to...

dk, once again you have come through. Works a treat (once I modified the references for my DB). Thanks very much. F

Hi, I would like to be able to open a report form a button on a form. The user would press this button and this would open the report but the report would open filtered on whatever record the user was viewing on the original form. I am browsing 'frmProfile' I click 'Print report' button which...

Ok, I appear to have been successful except I managed it without using your code. Not intentionally, I kind of fell into it as I was resetting the tables and relationships. I had gone back through each step, rechecked my relationships and created another intermediate table. Then linked the...

Thanks for you responses guys. I was working it last night and after much messing around went back to basics and tried to retrace my steps and try again in smaller chunks. I have setup up the nested subform properly now i.e. I have multiple hazards linked to one profile, that works. So now I...

Well I'm clearly doing something wrong as I'm not really getting what I want. I either have a problem in that my fields won't link, or if I fix that in my relationships then I can't create a nested subform of many hazards on one profile due to the change in relationships. I can't seem to have...

Hi, I'm just trying to pick this up again after the holidays. Still haven't got it fully functional. Would anyone be able to assist me, especially with dkinley's last suggestion: Thanks