Search results

Dear all, I have a small questionnaire for which i want to design a database. I have attached what i think is a normalised design based on the given questonnaire. My problem is that i can not figure out how to design a data entry form that looks like the questionnaire from such a normalised...

Hi everyone I have a variable that captures a maximum value How do i pass it to an update query? I am am doing the following and i am getting the pass parameter dialog box: UPDATE tbl_Table1 SET tbl_Table1.ID = lngGetMaxID; any ideas Thanks

hi all I have a question on database design concerning the hot topic of primary keys. Here is the scenario: I have two lookup tables: TABLE:tbl_Clinic------------------------these are clinic Primary Key CliniID ClinicName 1 Clinic 1 2 Clinic 2...

Hi Everyone There is something i am missing here. I have a sub form on a main form. I have set the combo on the main to filter the combo on the sub form and its working all right. code: Private Sub cboProgram_AfterUpdate() Dim strSql As String strSql = "SELECT lk_Indicator.IndicatorID...

Hi Gurus Is there a way to check if a table exists in another database without opening the database.... i am in C:\Data\Database1.mdb and i want to check if a table called Table1 exists in C:\Data\Database2.mdb without opening Database2.mdb I know i could easily do this in the current db Thanks

Hi Gurus I have a code that copies a database using the common windows dialog box to a temporal import folder from which i transfer a table to my database using: Function ImportPatients() On Error GoTo ImportPatients_Err DoCmd.TransferDatabase acImport, "Microsoft...

hi everyone. I am having a problem that is making me mad. I have the following: main form:BLP_Data1 , selected combo box:cboActivity subform:BLP_Data2, filtered combo box:cboIndicator -------------------------------------------------------------------------- in my tables many indicators belong...

Hi everyone out there I have a rather funny problem. Error handling code routines do not seem to work on my laptop. I still get the default error messages when i test. One my desktop the code works just fine and i get the custom error messages Actually i have tried five examples which are...

Hi VBA Gurus couls anyone kindly explain to me what this code does if suppliied with the following values:1,2,3,4,5 'example on passing arguments byref declaration Function test2(a As Integer) a = a - 2 If a = 0 Or a < 0 Then test2 = 2 Exit Function End If test2 = test2(a) * (a + 10) End...