Recent content by motscotland

Thx m8. It works a treat!! A nice way to end the week. Cheers, Myles :D

Thanks. I have spent a long while this morning 'playing' with the function......AAARGH!!! It doesn't work! I don't know how to relate the two together. Function Public Function JoinType(strJoinType As Long) 'Check for the controls to give AND/OR type If JoinType() = 1 Then...

After searching the forums and some serious head scratching I now have this: 'Check for the controls to give AND/OR type Dim strJoinType As String Const conMAXCONTROLS = 9 For i = 1 To conMAXCONTROLS - 1 If Me("optClause" & i) = 1 Then strJoinType = "AND"...

Thx! This forum always has the answer! Merry seasonals to all. Cheers, Myles :D

Thx FoFa, The idea of the search form is to find appropriate people for upcoming contracts from our current database of candidates. So, I am attempting to make the form as versatile as possible. Ideally I need to give the option to bracket certain criteria as you mentioned FoFa - ie- (Qual -...

Hi, I have a search form that takes values from 7 combo boxes and builds an SQL query which then outputs a filtered list. The code is : Private Sub cmdOK_Click() ' Pointer to error handler On Error GoTo cmdOK_Click_err ' Declare variables Dim db As DAO.Database Dim qdf As...

Thanks for that Neil! However, apologies for my ignorance but HOW do I refer to the value in a formula? The code builder dialog is new to me and my knowledge of VB code is very limited! I can set the value to appear in a list box which can then be 'copied' to the ref field by selecting it BUT...

Hi. I am looking for a way to look up the latest reference code of a record, increment it by 1 and then store this new value on the main data entry form - this ref and other newly added data (entered on entry form) then to be added as a new record to the main data table. Main table is cvlist...

PROBLEMS!!! 1) I have tried to convert db to A97 - it won't do it. I get a Field Type Mismatch. 2) Even after db is split and zipped the bits are db - 203Kb db-be - 176kb As file limit is 100kb I cannot post it here. Am I ever going to get to the other side?? :eek: Cheers again, Myles :(...

Thx for reply neileg. Yes - I have compacted and repaired! The db was about 14Mb and it reduced to just over 2!! There are various 'test' tables/forms that I have removed as well but even then it is still just over 2mb after C & R. I have tried to follow examples in other threads regarding two...

Hi all. Over the last couple of weeks I have had some excellent help from the guys in this forum which has meant my DB is very much getting to where it should be. It has to be presented in draft form on Wednesday!! :eek: :eek: :eek: However, I am now at a stage where I require assistance to...

Really getting there now!! Cheers m8! Myles :D :cool: :D

Thx - making headway now!! Cheers, MoT :(

Hi, I am trying to make a sub form that will show ALL the qualifications for an employee on the main Employees details form. The qual details are held in seperate tables. I can make a subform that shows each record singly but it doesnt tally with the record showing on the main form. How do I a)...

OK - I have done much reading about normalisation and the like. I have downloaded and examined the dbArtists example. I couldn't really follow what it was doing at all, or how it relates to what I am trying to do. I am not getting this to work at all!! The 'junction' table shows blank!! Not a...