Search results

In VB6, we can assign value in textbox or Listbox or combobox as a default value, and whenever we run our program, it shows the same value we provided during design time. My question is that, can we assign different default values during runtime? Purpose: I have a txt file with some values...

Hi Experts, I have a shared front-end application being used by more then 50 users (appx. 10 users simultaneously at a time). Front-end placed font-end application on a shared server and created a VB6 based Login window for user to access on it. VB login window logs the user data into back-end...

Hi fellows, Situation: I have 2 main tables (tblRecords1 and tblRecords2) with sub tables (tblHistory1 and tblHistory2). Both main tables have same structure (means same fields) and same condition with sub tables. Requirement: I just want to merge both main tables into one i.e. tblRecords...

Hi Experts, Situation: I have a project with tblNumber on my network folder. Only I am allowed to access that folder. Now I want to create another project with its own forms and reports and want to use ADODB connection linked with tblNumber on network. Question: Is it possible to give access...

Hi eXperts........ I've a select query with criteria = department, when I select any one department at a time from my combo box, it shows records from that department. Now I want to insert "All Department" option in combo box to show records from all department, not specific department. I...

Hi Experts, I want to ask that what is the difference using if I use form or report using form properties dialog box to configure its caption, source, permissions of add, edit, delete etc OR using source code to set source with SELECT command. Does this improve the efficiency of form or...

Hello Experts, I've a main form with sub form in it. Main form is a single form while sub form is a continues form as Access default setting applies. the sub form contains related transaction of Main form and sub form has record selector enabled. Question: Is there a way to open a particular...

Hi Experts, My question is that is there any way to use Compact & Repair tool using Button in form, when ever I press that button, it should call main Compact & Repair tool directly because if I disable the FULL Toolbar option in my project, it also blocks the tool menu and Compact & Repair...

Hi Experts, I am not certified Access developer but have passion to learn it... I made this project any how (unprofessional style), now I hanged around in one situation, this project is just like any calculator that calculates Time & salary of each employee with complex units system and working...

Hi Experts, DESCRIPTION: I am working on a database form with some bound text boxes like HOURS (57), PUNITS (170), SUNITS (49), TUNITS (14), MUNITS, FUNITS, PERUNIT, SALARY, INCOME, SUMFUNITS; Where MUNITS = (HOURS - 48) * 3 & i.e...

Hello All Experts; I have a bound form with a query. In this form, there is a bound text box with data type (Date/Time). Now I want Calendar in this field like VB Date picker combo box. Is it possible in Access...? or any idea about fastest date selection rather then typing...!

Respected Experts, I have a small database with 1 table "tblDocuments" containing 3 fields "ID" (autonumber), "DocNo" (NumberField) & "DocTitle" (TextField). With all these, I've a form including all these fields and a textbox "txtSearch" (unbound) and a button "btnSearch". Now I want that...

I've made a project in Ms Access with Admin rights in XP, now I created another account with limited rights and assigned some rights of adding records using MS Access Security, but whenever I open that project with limited account, a message says, "database is readonly", and all control text...