Recent content by usermj

I designed a combox and also set the property of 'limited to list' to yes. I also declared the function NotInList with my own message box. But, the MS-Access default warning message box still comes up after displaying my one. If I turned the property of 'limited to list' to no, it can trigger...

Include Option Explicit Compile your work Don’t use names as supplied by the wizards Try to remove the bang '!' from your code and use the dot '.' instead Try to remove Public variables where possible Use Me rather than the Form name where possible If using the Forms collection try using...

I designed a Data Entry interface. I wish the system can automatically clear all the values of controls in the form after users click the 'save' button. Is there any good solution instead of manually setting each control's value to null? I tried Undo method, but it didn't work on either...

The following code is only for testing the usage of control variable. I want to use set statement to assign the textbox object reference to the varialbe myControl. When I clicked the button, the system always tells me 'the object reference missing'. It seems the set statement doesn't work...

Hi there, Recently I'm designing a Data Entry interface, which contains more than 10 textbox (fields). Instead of asking users to move cursor manually after each data entry, I want the system can automatically move the cursor to the next textbox. I tried to use keyUp Event set for each...

Hi guys, please give me some directions. Recently I designed a form with several controls including both TextBox and Combox. Before I submit data by clicking the button, I use VBA to validate the values of those controls (textbox and combox). If the value is not valid, the system will eject...

Thanks guys.. As I can't anticipate how many columns users will choose, how many textboxes I should create in the report ? thanks

I just looked some previous posts. I know it may work if sets visible property of textbox to 'true' to those columns which have been chosen by users. But I'm desirable to see whether any other solution can make the layout of report more nice and well-organized. Thanks

Could you create a form-based interface for users to enter the value? Then you can open the report by using filter condition as: DoCmd.OpenReport "WkShopReport", acViewPreview, , DateFilterStrirng. Maybe in this way, DCount () can work properly

Only display the 5 latest updated fields.. I wonder whether you need to create a new table column/field to track the time when users made changes on the database. Afterwards, you can ascend the stack column and use for loop to read the last 5 records. Just a thought, hope it can work.

Hope the following is useful for you. You can create two buttons: 1 button for viewing reporto on the screen, 2nd button for printing the report. 2nd button is only visiblable or enable for certain people due to the database login name. The VBA code as the following: ' print the report...

HI there, Recently one of my clients asked me to design a user-interface, which allows them to choose the columns listed in the final report by ticking relevant fields. We usually bind TextBox objects with table fields in the report design view. In this case, as we can't anticipate which table...

Could anyone of you give me some sugguestions on designing a nice/efficent Data Entry interface (Form design) for adding new records?: I have bound a Form with a table and linked all the textbox with the relevant fields in the table. I created a add new record button through the wizard...

Recently I'm helping a friend to convert his MS-Excel spreadsheet into MS-Access. I met a problem and need some help on defining the table fields. In one of spreadsheets, he gets 3 columns, the 3rd column values is calcuated by a formula based on the previous two entries as the followinf: D3=...

Hi there, I designed a form which contains a combox and SubForm (in DataSheet view). The combox allows users to select the number of record they want to append. The subform (in DataSheet view) will automatically control the number of records users can entry. Normally, in DataSheet view, if...