Search results

This part is easy .... Go into design in your "Order Details" Table, Click on the Order status field and at the bottom change Required to YES and Allow Zero Length to NO It will then be impossible to create an order without filling in the status I'll have a look at your other requirement later...

You should be able to do some of what you want with conditional formatting, however we need a bit more information before we can effectively help you...... What version of access are you using? What is the structure of the orders table? What constitutes a back order compared to a regular order...

I sometimes talk to myself, now I'm typing to myself!

Some useful bits of code there emorris1000 Thanks

There is an automated method suggested here ..... http://www.access-programmers.co.uk/forums/showthread.php?t=138795

You could start with your largest table and run a series of append queries ... http://office.microsoft.com/en-us/access-help/adding-rows-by-using-an-append-query-HA001186063.aspx This should make one big table, leaving your originals intact. Read this for info on how to import froms from one...

Thanks Ari, I've never created a property before. I'll give it a try and report back. Could you post the code you are using Doc_Man. Thanks

Hi Jon, A Typo In Your "About Me" .... Occupation - Access Word Owner

Try using the query as the row source for a combo. If you can't upload the file because your post count is <10 just zip it and upload

You have do the following from the VBA editor Debug > Compile and then create the accde file See the last post here ... http://www.pcreview.co.uk/forums/vba-code-does-not-work-using-accde-file-t3636317.html

Hi DocMan, It's not an end user button. I use it for the quick viewing of a full screen form after a design or vb change. Unfortunately it doesn't always work. I can't figure what causes the error (described in my OP) ... perhaps I should have a save all built into it.

It's always best to base a form on a query rather that a table ... even if you are only using one table. Assuming that your relationships are set up ...create a blank query. This will be SELECT by default which is what you want. Add the tables that you want, then drag the fields that you need...

Go to the home page of this website and click on video tutorials. This one may give you a headstart ... Creating a main Form and sub Form using the Form Wizard

There is a freely available inventory db available for download on this site. I can't give the link as my post count is <10 Go to page 2 of "Sample Databases" and look for "Inventory Control". Have a look at it ... it may give you a few ideas. If you hunt through the rest of the sample...

I'm using this code to show and hide the ribbon & navigation pane from within a form. I'm using a regular command button as a toggle. It works fine in normal daily use, but not always, after coming out of design mode. Sometimes the form I'm designing closes and sometimes the nav pane shows and...

Which side of a sheep has the most hair ? . . . . . . . . the outside!

That works very nicely CJ. Many thanks.

I'm using this stardard piece of code on a button that deletes a record from a simple continuous contact form. If MsgBox("Do You Want To Delete This Record?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand...

Here is the link to the runtime version of Access 2010. The link isn't complete or clickable as this is only my second post. microsoft dot com/en-us/download/details.aspx?id=10910 Here is the 2013 version microsoft dot com/en-us/download/details.aspx?id=39358

Multiple searches kept bringing me back to this website. It seems like one of the best Access resorces on the net. I'm looking forward to increasing my Access knowledge and helping out when I can.