Recent content by ddcessex

I used to really like this site and regularly recommended it to colleagues. There are some really selfless and dedicated helpers on here offering a wealth of know and helping us all alone when we most need it. But now with unsolicited advertising on EVERY POST it has just made it unbearable...

So you use the Linked Table Manager to map all the tables to "Z:\project\db_be.accdb" and use the mapping from each pc on the network to point to that drive letter Z: and the filename. Sweet - thank you buddy

From one Newbie to another.... Your topic is about Data Entry Validation and the method that you are using is fraught with danger of the user being stuck within an infinite loop such as the one that you highlight. Other Gotchas await you when the user is kept being put into one textbox when...

From one Newbie to another .... Assuming that you are editing a Rental Record and that each rental stores details such as Colour that is selected from a lookup list of Colours (in the colour table) then the Notes about that rental colour should be stored in the Rental Record and not the Lookup...

Scenario: The database has been split into Data and Code modules The Database Module resides on the Server in C:\Project The Code Module can reside anywhere on the user's local hard drive. Because the location of the Code Module as well as the user's mapping to the server can change between one...

Thank you! Thanks to your mention of size I discovered that the form was too big and that this caused the issue. Can't see the wood from the trees sometimes!

Well, we're all in suspense! We're all interested in successful solutions so what was yours?

OK got the Navigation Control up and running - real cool gadget this! Some Header / Detail Forms display ok within the sub form but the top section is hidden and you need to use the vertical scroll bar on the displayed form to scroll up to reveal the whole form. Any help would be appreciated...

Just a short note to thank you guys for tirelessly helping others. I have been developing for some 16 years and never known how helpful your responses are. A BIG THANK YOU on behalf of myself and all others who are busy learning and don't have the time with thanks

You made my day! Thank you so much!

OMG It worked! Thank you so much. Can I include an ORDER BY argument in .Filter?

I setup a blank, unbound Main Form and created a Sub Form into which I pasted a previously created datasheet view form. This works fine On the the Main form I put some command buttons that, when clicked, call procedure that is written in the Main Form's Module. This is where the problem...

That is so useful, thank you very much. Is there any way to get rid of the layout cells in the main form? I'm finding them a real pain.

Just like! I'm sick! Been trying to do this for over a week! Thank you so much! :):):):)

In the middle of a steep learning curve here.... So have become familiar with the Datasheet View and I like many of its features. Because I found no way of adding command buttons to a Datasheet Form I was encouraged to adopt the Continuous Form which can expose the Header and Footer for adding...