Recent content by Dezirous

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...

Thanks for the reply, I read your navigated approach but it says the main switchboard of database should be open, then it will capture users log. Actually, I have some different situation. If you open the front-end, it connects to back-end through ADODB connection without opening back-end...

In this case you can try to download this app... http://access.mvps.org/access/modules/mdl0055.htm

Check the attachment created using Ms Access 2003.

@hyperion If you front-end communicates to back-end using adodb connection, then you would have different situation. If you use Adodb to retrieve data from back-end into Temp folder then your back-end would never be occupied by any user and you will have opportunity for maintenance of back-end...

How the front-end and back-end connected to each other? Either linktable method, DAO or ADO method?

Hi Dear, can you please let me know the rowSource of you combo and columnWidth value? Suggestion for you Problem: Use dlookup("[Lastname]","tblName","[ID]=" & Me.cboLASTNAME & "") Like me.txtFirstName = dlookup("[Lastname]","tblName","[ID]=" & Me.cboLASTNAME & "")

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...

Thanks man.... that's really simple and helpful. Thanks a lot.... Please, can you describe the logic behind those queries.....?

One thing which is most important and I forgot to tell is that, there is no similar data in both tables. Each record in both tables are required. :banghead:

Thanks for prompt response. I didn't get the idea to change PKs of tblHistory2 records with respect to Record2Id. tblHistory2 is the only problem creating table.

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, Ok, let me see if I got your point. if you have modified your theme and want to apply this to all your form, then just open your form in design view, modify your them then go to AutoFormat dialog. In AutoFormat dialog, you can see a button 'Customize'. Click on it and you will see 3 options...

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...