Recent content by bcallnan

Hello All- I have a large excel workbook that runs off one data sheet. Each worksheet refers back to this sheet to build graphs, pivot tables etc. In the past I have used transfer spreadsheet and it has simply overwrittem the worksheet: DoCmd.TransferSpreadsheet acExport...

Here is a screenshot, it may help.. Thanks -Brian

I am opening it from the access window - is there a way to send a screenshot inside a thread? I could show the settings.... thanks again!

Ok- I checked that and all looks right. The forms AllowEdits property is set to YES. Any other ideas? Thanks for the quick response...

Hello- I've been having trouble to get the Auto Expand function of a combobox to work on an application of mine. I have not had this problem before. I have compared the settings to applications where they do work and they seem to be the same. These are unbound controls with Limit to List and...

- One solution... - Hiya- I satisfied this post, but still think that there must be a better way. I was able to call the event by going to the control in the subform and updating its .gotfocus event to refernce the .afterupdate event. Seems a little forced. Any other ideas? -thanks in Advance

Hello All- I am trying to reference a subform's afterupdate event that is 3 forms deep and am having some trouble getting it to work. The control is a combo box and i cannot seem to trigger the afterupdate event from another subform. The control is on...

Nope- they did not- Thank you- I am able to edit them now. -- Must've missed that fact... thanks again for the fast reply! :D -Brian

Access Project will not let me edit tables I have the same problem as this user. I have not been able to update tables on SQL Server. I have checked with the dba and he states that all of my permissions have been set to owner. I am able to write and delete tables in the project but am unable...