Search results

Hi ! Have come back after a long time....need help ! Require help as follows: My form should display 5 records per page (in Textbox; something like 'continuous form'). Would click 'NEXT' to go/see the next 5 records and likewise... Once they are displayed I would like to edit the records of my...

Hi, I have developed an application using MS-Access 2002 for my client. It has front-end (forms+macros+queries+reports, etc) and back-end (with db). Same front-end will be used by multiple users. The client computers do not have MS-Access 2002 and they do not wish to install it either. They only...

Hi, I would like to know the code to find if ".zip" file is password protected. Pls help. PS: I already have code (for msOutlook) to ensure all attachments send are zipped. Now, need to ensure that the users who send ".zip"-file as attachments in e-mail (msOutlook) are all password protected...

hi, i hope this is the right forum to ask my query as it relates to windows. i would like to use windows-2000 phone dialer to dial and record phone calls to my PC. How do i do that. any help is appreciated. regards, prodigy.

Dear all, have tried searching many sites but of no help. hope this is the right place to ask my query. I would like to develop an application with the help of which I can make phone calls through my PC (windows 2000) and record calls as required. I have come to know that TAPI is the technology...

Hi, I have an unbound form that is based on a query. On the Load-event I have populated textboxes with the underlying records (it works fine). The underlying query is based on 2 tables that are joined on (PrimaryKey) Table1.ID = Table2.ID (ForeignKey). The Form has one Add-CmdButton. When the...

Dear friend, I have been looking all over this forum for a topic like "form-subform". I was trying to catch up with the idea if a form-subform can be made to work programmatically. I know on how to make a "form-subform" work when they are bound but what if they are unbound. 1) I have an unbound...

Dear friend, I have a question if anyone can help me out. I have as assignment to do for a small firm. Dataentry application primarily with few search and edit functions. This will be used by multi-user. I am yet to decide whether to make the form and the database linked or unlinked. What I mean...

Hi, I know how to create master-details form based on table and query (and it works). I want to create the same thing programmatically with unbound forms. I have an unbound form that displays records (in textbox) writing VBA code. I have written code for adding, saving, updating, deleting...

Hi, Its good to be back after a long time. Hope everyones fine. I have a query and would appreciate any help. I have a master-table (tblM) and two related tables (tbl1, tbl2) with one-to-one relation. Relation1 : tblM.ID (autonumber) related to tbl1.caseID (number;LongInteger) Relation2 ...

Hi, I am facing an issue as described in the following: Scenario: I have an assignment where the client requires to store its customer detail electronically (ie In soft copy). (e.g Last 5 years data are in hard copy/hard Form format). They require an application that will help them to enter...

I am using ms-access2000 project: Backend: SQL-server 2000 Frontend: MS-Access 2000 Want code on this: I have tried outputting View (thats stored in the sql server) to MS-Excel and its working fine. myCode:<DoCmd.OutputTo acOutputServerView, "e_CRM_MIS", acFormatXLS, , False> I want to...

I am learning ASP.NET and am following SAMS 21 days ASP.NET. The book tells me about the technology and VB.NET and how to write everything without using any editor just simple notepad. It becomes difficult to develop and debug an application without a proper environment/editor (this is how I...

I have created 2 tables in sql server 2000 and they have Relation between them: (1) tblCustomer columns: custid (PK); custname (2) tblOrder columns: orderid; customer_id (FK); order I want to write the sql statement (INSERT) to insert a record with all fields. I dont want to inculde the...

All these days I have been developing small applications in Access2000. Now, I want to extend my skillset to SqlServer 2000. small sample: In Access I had created 2 tables <tbl_customer (columns='custid' ; 'custname') and tbl_report (columns='reportid' ; 'custid' ; 'grade')> Relationship...

Am a newbie to sql server2000. Have just started learning. I have created two tables in sql server2000 <tblemployee> and <tbldept>. They are linked by (prim key) tblemployee.empid = tbldept.employeeid (foreign key) used in relationship properties: <enforce relationship for INSERT and UPDATE>...

I have developed a MS-Access application for a small call-center (20 users).with approx 1500 customer-records to call everyday. What I have done: There are 20 front-ends residing at the Telecallers desktop and 1 database@server. Presently I am allocating 1500 records (clients send 1500 data...

hi, am trying to create an application for a company that has a small call-center (strength 20). the db is in the central server and each caller sits with frontend on their computer. the central DB is shared on the network which these 20 PCs are accessing. The frontend: 1 Form only which is...

Hi, I have secured my db with password. I want to know the technique/technology so that i can read my password. Access must be storing the password in an encrypted form in any password file. My idea is that if I know the file where its stored and in what form then I hope it can be retrieved. I...

Hi, Am not sure if its possible with access but have a hunch that it might not be something very difficult. I have developed an access FE/BE application (in the network). The front-end users run query and view the results fine. They copy (ctrl-C) the data from the query datasheet and paste...