Search results for query: *

Hi all, I just passed CCNA with 912 score. I would like to start CCNP preparation. I am rather blank about the study material required for the various papers. Grateful if any one can suggest which material is most suitable for the 4 papers in CCNP and also any ideas about the preferable order in...

Hi all, I am preparing for CCNA. I am having a hard time trying to understand the exact concept behind using Ip address and Default gateway address for a 2950 Switch. I want to use one of the ports as trunk to be connected to a router for connecting multi vlans. Grateful if any one can explain...

Hi all, I am just trying to copy some scanned pages (jpeg) of some contract documents in a form. But I find that with just 5 pages added in the form (using tab control option ), the size of the Access file has gone up by 20 Mb. Glad if anyone can say whether this is normal or is there any...

Hi, I am facing a very bizarre problem in my Access 2000 database. I have a form with a subform. After entering data in Main form,I have seen in very rare cases, a window opens asking whether to save the record or save to clipboard. If I choose "save record" then in some cases, data...

Hi, First of all let me wish everyone in this greatest computer forum in the net a very Happy and prosperous New Year. I have a report which produces list of items sent for repair and not yet received. I am getting the report with the field "date sent for repairs" in descending order...

I have a Form "Form1" with an command button having following on click code : DoCmd.OpenForm "Form2", acNormal, , , acFormEdit, acWindowNormal, CARD.Value On Form2, I have following code on "OnOpen" function and I get the value of "card" on...

Hi, I just want to know if there is any way by which we can open a form and reset values of check box of all records to False. I want to do this because I have another form which opens with a new record and I am having the afterupdate function run an append query to append the record just...

I have a query where I would like to use DSUM to get the total qty of each item under various reasons shown in "reason" field. Though the query gives a result, answers are absurd. Following is the sql-- SELECT DISTINCTROW Table8.item...

I have a report made from 2 tables tblone and tbltwo which are in one to many relationship. There is a sl no field in tbltwo which is put in ascending order in the underlying query and I have also put this field as the leftmost field in the query. But still I find that when the report is run...

I have a form which opens with a new record and the user makes entries. Now for safety reasons, I have made an append query ( which starts on afterupdate of the form) to append this new record to a backup Table on the same db. Now as there is no primary index in the table on which the form is...

I am totally confused by this check box problem that I am facing. I have a a Main form with a continous subform. I have a check box on the sub form which has on after update following code : Private Sub BOX_AfterUpdate() Dim sMsgReturn sMsgReturn = MsgBox("CLICK YES IF YOU WANT TO SHIFT...

I am having a msg box in after update event with following code : MsgBox "Units transferred " & Me!qty & Me!order & Me!item, vbOKOnly + vbInformation This message works fine but ideally I want the message like this : MsgBox Me!qty "nos of" & Me!item "transferred...

I have a form which is opened through a macro whenever a fault is to be entered for a particular hardware. Now due to security reasons, when the form is closed, an append query starts and appends the information on the form to a backup table. My problem is that I am unable to identify the...

Hi, I have an interesting problem regarding the correct code for expression. I have a form with fields "type","item","order". To ensure that all the fields are filled by the user, there is a small code in the before update as : If Len(Me!type & "") = 0...

I have a continous form say Form1 (read only) with fields "field1","field2","field3". I have a command button in the form which opens up another form say Form2 with a new record containing the same fields. Now I want field1 which is chosen in Form1 to be displayed...

I have a continous form say Form1 having fields field1,field2,field3 and also has a command button that opens up Form2 with a new record. Now Form2 has a bound combo box (bound to field1) whose Row source property is based on value of field1 in Form1. My problem os that when Form2 opens, the...

I have a form say "form1" with 2 command buttons running macro1 and macro2 with each macro running various append/delete queries. I want to keep only 1 command button which on clicking should generate either a "Option1" or "Option2" message box so that user can...

I am facing a very peculiar problem. I am using Office 2000 Access on Windows 98.Recetly I saw that no system messages are being generated when duplicates are being entered for example on a primary index field. But when the table was opened again, it was seen that the duplicate records had not...

I have a form (Form1) with a subform (subform1) having text fields text1,text2,text3 etc. When I open the form, I would like to choose a record and then via command button,start a append query that copies exactly this record to another table. Now my problem is that the append query picks up...

Hi, I have a cross tab query "Table1" which is started by a macro which is followed by a message box. I am trying to put a condition in the message box in the macro which will pop up when one field in the query for example is null. But I find that this conditional statement works...