Search results

Hi all, what i want is,, when i close a form a particular form is refreshed anybody know how?

Hi, I have a list of four options and i want the user to be only able to click one option and not have multiple options ticked, so once one option is clicked the others cant be clicked whilst that one is clicked in other words you have to untick your option to pick a differnt one

its not a problem of querying the data, its that if there is data in two of the search boxes, then it will only bring up recruits with matching criteria for both, not if theres 1 or each

Right what im after sounds complicated but its quite simple. I have a client database, in this database each client has 3 skill fields, i also have a form with a listbox and an unbound textboxes that are linked to the query so when the textbox is typed in the listbox updates. Now ive sorted...

you can order the forms by any fields ascending or descending in the form wizard, or change the properties somewhere i think

create a two forms one named 'frmaddwhatever' one named 'frmeditwhatever', then click the properties of the add form go to data and change data entry to 'yes'. then use a swtichboard to open the two diff forms

Heres an image Heres the sql view SELECT TblRecruits.cl_fname, TblRecruits.cl_sname, TblRecSkill.[Primary Skill], TblRecruits.rec_id, TblRecSkill.[Secondary Skill], TblRecSkill.[Specialist Skill] FROM TblRecruits INNER JOIN TblRecSkill ON TblRecruits.rec_id = TblRecSkill.Rec_ID WHERE...

I have a query that gets data from a table now not all fields are filled in, in this table, and the query only shows data that has all fields filled and i need it to show them all

im no expert either, but this is what i use and it works great Set rs = Me.Recordset.Clone DoCmd.OpenForm "Form Name Here", , , "[ID Here] = " & Me.List Box Name here If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Hi All Does anybody have or know how to make a field so when its clicked it will enter todays date, the default value =date() is not an option either. Thanks for any help

where do i find this? basically im trying to make this work http://home.bendbroadband.com/conrad...dfaq.html#back

Below is some code on a form for a button to work and when i run the form it says i '' user define type, not defines and highlights the DAO.Database part. The tutorial that i got that from says i need to set the DAO but i dont know what that is. Can someone help me out? Private Sub...

thanks there just what i wanted, ive done wht it said to do but what do i put for this bit A Reference must be set to the DAO Object Library as well. (from the site) (from the form) Private Sub FillOptions() On Error GoTo ErrorPoint ' Fill in the options for this switchboard page Dim...

Hi all i was wondering what i have to put into a label so that when you fill in text from your parameter query the text is displayed on the report

my knowledge of vb is almost none existant, if you an could you give me an example db pleasse?

what if you dont have 8 items in every swtichboard?

i dont know what you mean. do i add this to the event [control].SelStart and [control].SelLength?

That is how i have it set up now, but the people im creating the db for want a button in the bottom right of the switchboard to go back instead. They say its confusing having it in the list as they may end up clicking it by accident. I know its finikey but its what there after

but im trying to use this button on a switchboard. so it wouldnt work on sub-sub switchboards if you know what i mean. Im after a button that will go the the previous switchboard

go into the form propertes go to data and change data entry to add