Search results

Thanks for the quick reply this is what I used... <>"2" And <>"4" And that now doesn't show them in the combo list, the above was a example not what I was actually using as data. Thanks again :cool:

Hide value from Column in Combo Box [SOLVED] Hi, Had a search and found this... http://www.access-programmers.co.uk/forums/showthread.php?t=99682&highlight=hide+combo+box Not very clear to me :( what I'm trying to do is say I have a field called "number" the the value in those fields are 1...

Hey Guys! Thanks very much for your help/suggestions, I followed this.. http://www.access-programmers.co.uk/forums/showthread.php?t=99765 Plus some additional code from this thread to give me what I'm after :)

Thanks for replying, what I'm trying to do is on a Form I have a combo box called Makes with the items as DELL, HP, IBM so on, and I have a Licence Field as tick box data type. I would like it so that the user wouldn't be able to exit the form if the Licence field was not ticked and the makes...

Hi again :) Another question if I may...If I have a Form with a Field called "Export" which is set as a "Yes/No" Data type, how would I say... If another Field called "PC" has a combo box with DELL, HP, IBM then the "Export" field would require to be set ONLY if DELL or IBM is ticked on the...

Hi All, Wondering if you can help I have a table called "example" which has field "a" "b" "c" "d"... I then create another table called "importtable" with field "a" (imported in from Excel)... I would then like to create a query which matches any and shows all the records which I imported in...

Wow many replies, Thanks to all that replied after a few hours of getting back in to access programming worked out what's needed (again big thanks to Bob exactly the sort of code I was after, and Sue thanks!) Here is the code what I used... Private Sub Label5_Click() Select Case Me.Warranty...

Hi, Thanks for the fast reply, having trouble getting it working :( I created a label called warranty and in the build menu choose code and inputted... Private Sub Label49_Click() If me.Warranty = 1 Yr Warranty then Me.message.Visible = True elseif me.[Warranty] = 2 Yr Warranty then...

Hi, Would like some help after searching and having no luck I have a report and would like to have something that if in the warranty field I have drop down list of options to select for example 1 yr / 2yr / Non warranty and then if it's 1 yr or 2yr then a message will be inputted on to form...

Lightwave...Thanks for your help... I've managed to get it to work and email selected repair number using.. Private Sub Command28_Click() On Error GoTo HandleErr If IsNull(Me![Repair No]) Then MsgBox "No Repair No Entered. . . . . Cancelling" Else DoCmd.DoMenuItem acFormBar, acRecordsMenu...

thanks for the reply, you got the first part right I'm wanting to find a Repair no then open up the report and attach to email now SendObject does this but does all of the records and attaches all records I only want to do this on 1 record Thanks again

Hi, I have searched this forum and found a few examples but cannot get them to work in Access 97, what i would like to do is email a single record by using a query for Repair No.. So i would like it to be a button, it's possible to do this via a sendOject command but that emails ALL records...

Gabriel - Thank you so much example 3 was just what I was after! Thanks again for indepth reply!!! g@v

Hi Guys, I have a form which is called test and in there a have a button box. What I want to do is Disable that Button box (its not a tick box not sure if that makes any difference) after checking it... http://www.access-programmers.co.uk/forums/showthread.php?t=81223 I have tried the above...