Search results

I have managed to create dynamic controls in MS Access. the only problem that I have is that it wont work in compiled mode. I am creating a new form on the fly and then insert controls into that form before displaying it. It seems database structure will get very simple with dynamic controls. I...

I seen a code that you can add into the format section of a control to have it display required fields in red if it was empty. I can't seems to find that code. Anyone kind enought to share the code. the code look like *@* Thanks in advance Jonny

I never seen this effect before. There is no code behind it or anything. I have a combo box on a split form. I get the focus when i click on the combo box but when i click on a different control the combo box turn gray. Is in effect of a split form. Anyone able to explain this behavior. Thanks...

Here is a solution that will make nested if else statement easier to read and handled. This approach comes handy in many situation. Below is just how easy a simple control validation can look like. standard approach: if len(me.txtcontrol1 & "") = 0 then msgbox "required control1" end if if...

I just finish a project for a client and they didn't pay me. what a good method that allow them to used the database for 30 days and then disable it in case same situation happens. I just need some mechanism, it close to changing your password every 30 days or something. I know I should have...

I am new to VB.Net and have hard time understanding its events. is there a list that tells me what vb.net events is equivalent to vba events. I having problem updating values in the database. any suggestion or guidance will be highly appreciated.

Here is a sample of Treeview Main Menu that works like a switchboard. Check it out. :) I made some update to make it more robust.

I need to track a transaction of an item that could move from inventory(Table A) to a machine(Table C) or to a storage location(Table B) then later move to a machine(Table C). The problem that i face is 1-many relationship in all direction my three options are 1. Table A 1-Many Table B 2. Table...

Here is a sample of a confirm form. This form will only allow user to exit if the user click on undo or save. The usage of this form is for critical situation. use this method with dialog mode and you have full control of user actions(except when computer crash). Thinh

How do you handle Replacement item in inventory? Let me explain in details of what i mean. You have a part number that is currently scrap. that part can be re machine into different part number. I am thinking of adding new line with the new part number and delete the old part one. The problem...

Here is a sample of a live search. Please give me feedback on the design. I like the way it is design but I wonder how it will be when you have 100k records from a performance perspective. This is my contribution to the community. more to come in the future. All feedback are welcome. if you...

what event is equivalent of the ESC Keyboard. I know that it acts as a me.undo but i want to be able to capture it that event and make some changes when a user click on esc key.

How do you handle Non Active entries from the past past? Sample exemple. EmployeeID: AutoNumber EmployeeNr: Number EmployeeName: Text NotActive: Yes/No I have a combo box in one form that utilize the above table to allow user to select only active employee. my queries is select EmployeeID...

Please provide link or picture of databases that you have encounter or create that you feel fits the above description. I just want to see what creative people can do with MS Access. I will post picture of mine once i strip out all the clients information.

How do you reset a combo box to the state when you open the form? I have a few combo box that are required fields. I know it works if i set combobox = empty but that will allow user to by pass the required fields criteria. and when i set to Null it says this field cannot be null. if i enable...

I have the following code Option Compare Database Option Explicit Private dct As Dictionary Private StrTest as string Private Sub Form_Load() dim rst as DAO.Recordset set dct = new Dictionary set rst = currentdb.openrecordset("qryMenu") while Not rst.Eof dct.add rst.fields(0), rst.fields(1)...

i can create different table to hold the drop down options for different form or i can create a structure like this to do the same thing. Table: DropDown DropDownID, AutoNumber DropDownOption, Text Table: DropDownItem DropDownItemID,AutoNumber DropDownID, FK DropDown ItemNr, Number Item, Text...

I have front-end/back-end system. The front is pretty heavy as it has many pictures. What is the acceptable size of frontend application. Currently it is 10MB. What are the problem i may face if the front-end grows in the future as all the features has not been develop yet.

Would anyone be interested in Table of Contents for reports, with the number of the pages? I have create a VBA module and some table to give you a truly Table of contents. So you can combine multiple reports into a book with the correct page number. I want to get some feedback to see if it worth...

I am looking for sample database that has nice gui and nice transaction between different functions. I have current create db that uses frame so the transition between function is almost transparent but i lack a good gui design. Some suggestion and samples would be great Thanks in advance