Search results

Thanks for the resource

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

Thanks to all I did not include the date field for simplicity... I just wanted to get your opinions on the choice between natural keys and surrogate keys. I have spent the whole day researching on this topic and my conclusion is as follows: It makes design good practice to have a meaningless...

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

found solution Hi ALL I got the solution: Went for option 2 http://www.accessmonster.com/Uwe/Forum.aspx/access-forms/54923/Filtering-subform-combo-from-main-form-combo#88d124f3016a4uwe thanks

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

Thanks for the response I have tried this but somehow the error is not trapped. the code goes straight to DoCmd.TransferDatabase statement and the error still pops up

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

thanks a million

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

thanks gurus Bat17 I like the f8 mouse hoover technique. it really shows what is happening. thanks gemma-the-husky for the explanation it reminds me of the days when i was cracking maths sequences and the like thanks a million i am trying to go for Access VBA power programming status thanks...

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