Search results

Hi :) I tried to link tables to an FTP site many times but always get the same error C:\My Documents\ftp:\\Test.ftp.com\users\dummy\testDB.mdb is not a valid path. maker sure that the path name is spelled correctly...and blah blah :) Has anyone got clue that how can get around this error...

Hi :) lets look at my raw data ID Score 1 2 1 3 1 2 1 1 *There could only be score from 1 to 3 From this data I want following result ID CountOfScore1 CountOfScore2 CountOfScore3 1 1 2 1...

Hi :) I have got a very simple problem but tried everything but its giving me very odd result. I am just running a simple query which insert todays date My code is Dim strDate As String strDate = Date DoCmd.RunSQL "Insert into Table1(TDate) Values (" & strDate & ");" And to most surprise I...

hope I am making sense this time Hi:) There is nothing wrong with my code of Add button and the Quantity text box is also unbound. What actually happening is that I have a tabular form and there is a add quantity text box which is unbound. Whenever I enter any quantity in the first record row...

Hi :) I have came accross to this silly problem and dont know how to get around it. I have a tabular form Where I have Patient Information and the quantity of drugs they are using. I also have an Unbound text box where user enters a quantity and then press Add button and the quantity gets...

Hi :) In my table I have a stage field and the maximum length of Stage field is 6. The stage can be like IA, IIA, IVa etc I want to export the field in an old database where they extract the field by defining the String Position. Therefore They want me to write stage in a way that if the...

Thanxx for response Thanxx Doc_Man.....I actually figured out eventually as i di smthng like this Select PriDuagId,(Select Top 1 DiagBasisId from TblPtDiagBasis Where TblPtDiagBasis.PriDiagId=TblPrimaryDiagnosis.PriDiagId),CancerID from TblPrimaryDiagnosis; Got some other directions for me...

Hi :) I have two table which look like this TblPrimaryDiagnosis ------------------- PriDiagID (primary diagnosis ID) CancerID (type of cancer) ..plus other fields TblPtDiagBasis --------------- PriDiagID (primary diagnosis ID) DiagBasisID (basis of diagnosis for primary diagnosis)...

Also help me with Export Yes ....... name of file is Temp.dbf name of folder C:\Temp I also want to reverse the process by exporting a table in my db called TblExport into a single file called TempEx.dbf I really appreciate ur efforts regarding that. Cheers! Aqif

Hi :) I am trying to import a DBaseIV *.dbf file which is sent to me from a different database. I need to import this file on monthly basis. When I tried to use import utility from File menu it worked perfectly. I just want to write a code which will do just that. I tried using Tranasfer...

cannot find it Hi :) I tried to find the Display When property but unfortunately there is no property like that. I am using Access 2000. Cheers! Aqif

Hi :) On my report there is a text box which just says: This is a print preview version. I just got a simple problem that I dont want to print that text box during printing. Can i do it with altering some property or code ? I have tried using OnPrint event but it didn't worked. Cheers! Aqif

Use List Box Hi :) One better way of doing will be using List Box or even Subform to display the data. The data or rwo source or list box or subfrom should contain query like Select Field1,Field2 from MyTable Where Field1=Forms!MainForm!SearchBox Place a Search button next to your search box...

didn't helped It didn't helped :( any more suggestions? Cheers! Aqif

Hi :) I have programmed the Not In List Event and when it does not find the values it undo the list value and opens the relative for to add another item id and then it refreshes back the form. Everything is working fine except I can't get rid of that message. "the text you entered isn't an...

Hi :) I have got a table of doctors and one table of Doctor Adresses with One to many relationship. In the doc addresses table one doctor can have many addresses. There is a Yes No field in Doctor addresses indicating Yes if that address is prefered address of not. What I want is that the user...

Any better way....? Thanks Rich: But is there any better way of doing the things which automatically distinguishes between the report is opened in preview or is actually been printed.....? Cheers! Aqif

Hi :) I am trying to capture the actual printing date. What I want that the date will be inserted only if user will press print button but nothing should happen if user opens it as preview. What even i should use. I tried useing On Print even on report header but it runs even in preview mode...

Correction Please correct the Field Name as CustLname=Forms!MyForm!TxtCustLName instead of CustLName=Forms!MyForm!TxtCustFName in the code below Nz(DLookUp("CustomerAddress","TblCustomers","CustFName= Forms!MyForm!TxtCustFName And CustLname = Forms!MyForm!TxtCustFName"),"N/A")

Hi :) I presume that you must have customer Id or any unique identity of customer. Write a code like this on AfterUpdate event of you last name text box Dim StrId, StrAddress,StrField1, StrField2 as String StrId= =Nz(DLookUp("CustomerId","TblCustomers","CustFName= Forms!MyForm!TxtCustFName...