Search results

Did you get the chance to look at the Dsum issue? Works fine in the normal report but I get a #name on teh subreport? Thanks, M

Thanks so much! All working a treat! Mandy

ah.... on thje main form and the sub report.... so I'll remove from the main report one then and cross my fingers and toes.... Thank you.

Well...... being a complete "subreport" virgin, I read the microsoft advice pages and I didn't want the mainform to bound to anything to be honest.... i just want it to contain my two sub reports... I want a summary report that counts the numbers of employees per region and then a detail...

Phew... took a while but I think this db will have the bits in needed. The main report works fine, the report name with sub at the end does not... as you can see it has 3 rows of data and it duplicates 3x... Also, I cannot get the DSum to work within a subreport.... Today has not been a...

I dont really know how to do this, or more importantly, if IT dept allow us to do this..... I guess I could partially upload the db? How do I do that?

it is a cross tab query..... I have tried moving the subform from the detail page, to the pge header etc... Its strange that all 14 tables are EXACTLY the same, and for 14 rows of data... This is my first subform attempt so its probably a schoolboy error. The sub form is not related to the...

I have 14 rows of data in my subform, and its duplicating the table 14 times?!?! Any idea why it would do this? Thanks, Mandy

Hi all, Is there a way to stop users from accessing the data tables by pressing F11? Thanks, Mandy

Wow... thanks! I've just been landed with a heap of work, but will have a play with this hopefully beginning of next week and let you know how I get on. Looks great thow, exactly what I was after doing. Thank you, Have a nice weekend. Mand.

Does anyone have any thoughts on how to do the following: I currently have code that loops through all of the fields on my form and sets them to enabled or diabled. I would prefer to hold this logic in a seperate table and loop through the table. All field names will be in the table and an...

great stuff.... That makes me much more confident..... I think I hear the pub calling.....! Have a good one! Mandy

Thanks Ken, For some unknown reason the following seems to be working.... I had this code originally so a user could cancel any changes they had made within the form and exit. However it seems to cancel adding a new record also..... Im still not 100% certain its bullet prof so Im testing and...

Mmmm... Is there any way to have a seperate Button for Cancel? I cant think how I would be able to incorporate this logic. I have predefined validation fields so if the user cant populate those then I want them to be able to exit? Otherwise I want them to be able to save the record as usual...

Hi all, I have a form which if the user selects "Add new" takes them to a data entry form which will populate an underlying table. I wanted a "Cancel" button, so that if the user selected "add new" and changed their mind they could cancel without populating a blank row of data into the...

Ah ok.... You learn sumthing new every day! Thanks, Mandy

Hi all, I have 2x tables: Tbl_Main_Staff_Details Tbl_MAIN_Staff_Details_HISTORY The "history" table has 1 more column than the "Details" table (its the 1st column where I need the dummy field) How can I dummy a column (called New_ID) within the sql so that I can union them? Other than...

Hi Rich, I have no idea how to check this, I looked at Control Panel and then REgional and Language Options and I have English(United Kingdon) if thats what you mean? Regards Mandy

Thanks for this RuralGuy. I actually cheated and just changed everything to be a "medium date" e.g. 01-Mar-08 and so far I haven't had anymore problems. If I get any I'll give your code a whirl however! Thanks again for looking at this for me, Regards Mandy

ah-ha... changed to: If txt_Last_Name_from_combo.Value <> "" Then and works great! Many thanks, Mandy