Search results

Why not just Requery the main form? (See the Requery function).

Changing toolbar button setting from "Default Style" to "Image and Text" in VBA Hi, I want to be able to show or hide the caption on a toolbar button according to the state of my program. I can't find a property of CommandBarControl that does the job. I can't just set the caption to empty...

Hi Aaron, No, I'm not a teacher, but thanks for the compliment! I'm quite new to Access but I've been in IT for a long time so I've been through the learning curve myself. I enjoy developing software, maybe you will too if you get the chance. If you are responsible for developing or maintaining...

Write a query on the table with an expression OrderNr & '/' & Client. Should do the trick... Keith.

Hi, I have a form with one control, an ActiveX TreeView (MIcrosoft Treeview Control, Version 6.0). I trap the CTRL-F4 event to prevent the user closing the form. However, this leads to a problem. Whatever node is selected in the treeview, the highlighting is lost. I've established the Selected...

Hi Stephen, Thanks for that, yes it gets a bit more complex, you need to allow ASCII characters 8, 9, 10 and 13. I'm also validating for decimals, depending on other factors I require only integers or allow up to 2 decimal places. Its working OK now, but far from elegant coding! Keith.

Hi Tim, Sorry for not replying sooner, I don't seem to have got the email notifying that you had replied. Your solution does what I need, thank you! I got the original description wrong, I want to allow the application to close (e.g. ALT-F4) but not close the form leaving the application...

Hi Rich, The value does not need to be stored in the database. I use it to generate values to populate other fields, which are bound to the database. So I don't understand how I could use a bound field. Thanks, Keith.

Hi Aaron, Please don't get disheartened, you are just coming up against some design challenges, and if you work through it systematically rather than getting overwhelmed with the details, you will find its not only possible, but satisfying, and hey, maybe fun! I ran your database but...

Hi Aaron, Here's one approach to consider. Create a Leave table: EmployeeId (Integer) FirstDayOfLeave (Date) LastDayOfLeave (Date) Create a form to allow the user to add, delete and amend records. Assuming the employees' leave entitlement is for a calendar year, you can write a global...

Hi Stephen, Thanks for the reply. However, General Number doesn't really give the behaviour I want. It allows the user to key in alpha characters, and only validates when they tab away. Also I put 2 in decimal places but it ignores this, and allows a value with more than 2 d.p. to be stored...

Hi, I have an unbound text field named [Text_TargetTotalUpdateable]. To validate it, I added a validation rule: IsNumeric([Text_TargetTotalUpdateable]) However, this does not accept any value, even an integer. How can I validate this unbound field to require it to be numeric. Can I give it a...

Hi Milothicus, To jump to a record when the user clicks on a row in the datasheet, you will need to write code in the On Click event of each column in the datasheet, I think. To avoid duplicating code, write a sub for the form to open the record you want based on the values in the current...

Thanks Rich, I'll give that a try. Shame there isn't an "application closing" status you can check in Access... Keith.

Rich, Are you suggesting I open a hidden form after the form I want to keep open, then check whether it is still open when my form_unload event fires? Can I rely on Access closing the hidden form before my always-open form, even when I compile to an MDE file? Thanks, Keith.

Hi Milothicus, OK, got it. Because you have included the Industry Sector column as part of the row source for a listbox, Access has not used the lookup properties defined in the Input table definition. You need to amend the query you used as the row source for your listbox as follows, to join...

Use "True" instead of "1" in your first condition.

I presume you have defined the lookup property of Industry_Sector in Input to reference tblIndSec. Perhaps the lookup property is simply not used to determine the display of a listbox and you need to include tblIndSec in the query that populates the listbox. I'm still confused and could do with...

Hi, Are you expecting that Input.Industry_Sector will display the text description from tblIndSec? I'm confused. Is the database small enough to include as an attachment? Or can you create a cut-down version that illustrates the problem, that you could attach? Sorry, I can't understand the...

Hi Milothicus, I've looked at the thread you linked to, and I'm not exactly sure what problem you are having. Would you post the SQL from your query, and describe what you see in form view, and what is not working. Thanks, Keith.