Search results

Not following this - are you referring to Unhide Fields? I agree however that "Access does not save well". I always click Save in the Quick access tool bar to be sure(er).

Hey CJ, I had tried earlier what you suggest (click and drag the column heading) but all that does is highlight the column clicked on followed by highlighting the adjacent columns as the cursor is moved left or right. However, I have just noticed that, in Form View, placing the cursor at the...

I'm getting no-where with this and am hoping someone can help. I have a subform in which I display a table in Datasheet View. The problem is, I cannot figure out how to place the columns in the order (i.e. from left to right) I want. For some reason, right-clicking on a column header in Form...

Nah, I'm not a dare-devil. In my searching for AutoUpdaters BTW, I noticed other relevant comments on the topic such as network glitches pooching an un-split shared database. I thank you for your words of caution and will act as advised. :)

Data corruption?? Well, wasn't expecting that. I realize one can cancel another's record modifications if both are modifying the same record at the same time but I suspect you are referring to other types of corruption(?) as I still get the same Write Conflict warning message when the front...

The single back end on the shared drive I understand but not sure why the user machines each need to have a copy of the front end except that it will (may?) reduce network traffic load. I was thinking of going with a split database so that the users could access a .accde front end and thereby...

OK, ran Linked Table manager on the user computer and it worked. Many thanks for the assistance...

Yes, I did not specify any path to the backend - it came as is. Will look into how to relink the tables (I've not worked with split databases before so this is all new to me). Thank you for the help. :) Still not clear though on why the path to the back end should be different than to the...

I have recently been experimenting with adding an Access database to a shared folder (in a network HomeGroup) and have it working on two networked PCs. Then tried the same with the database split but I get a path error on the PC joined to the HomeGroup (where the database resides) whenever the...

Thank you for the suggestion spike. As it happens, I did have both office 2013 and 2010 installed at the same time but I uninstalled 2013 as my Access 2010 programs had issues with it. Noticed now however that I have a Microsoft Office folder in both the Program Files and Program Files(x86)...

Hello all, have just tried experimenting with placing a Chart control within a form (Access 2010). Although the chart ultimately seems to work (based on my one simple example), I'm getting an Error 1907 (Could not register font.......) each time I launch the database or reload or edit the form...

OK, tried Unhide & Close but no cigar. Then tried Freeze Fields and it worked. Thanks for pointing me in the right direction! But one other question if I could - is there any way of persisting the monitor view when switching back and forth between Form View and Design View? All that...

Hello all (haven't been here for a while). I have recently added a subform to a form and wish to display the subform in Datasheet view. Whilst I can get the proper data and headings to display, I cannot figure out how to get the column widths to persist. I can adjust the column widths while...

No problem really. Conditional formatting can set to bold when "has focus" which is what I want but it also resets the font weight property to normal for some reason (so font appears as "normal" when hasn't got focus which I don't want). Therefore had to set font weight property(s) back to...

Yes, used that as well (to set font weight when control has focus).

OK, I see why the confusion. If I select Conditional Formatting from the ribbon as you show above, multiple controls can be formatted at once. What I was doing was selecting multiple controls and then right-clicking on one of them. When you do that, the Conditional Formatting choice in the...

Nope, select two combo boxes or two text boxes or a combo box & a text box etc. and no Conditional Formatting.

I sometimes find that just programming Access is autoflagellation in itself. :)

That would be a good solution (and one I would have used from the outset) but if you highlight more than one control, Conditional Formatting no longer appears as an option (at least in 2010). Don't know why that should be...

Doc Man, if I understand you correctly, the suggested GotFocus/LostFocus code would have to be separately entered for each text or combo box on the form. The issue I would have there is that I have about 100 boxes on the form in question so it was v advantageous to have a single code module...