Search results

I thought it would too, but didn't. i put it in the onclick event of the tab button

I want to replace the standard update record message with a custom one. My Code strSQL = "UPDATE tblBeds SET lngFKStatusNo = 2 WHERE autBedNo = " & Me.txtFKBedNo & ";" DoCmd.RunSQL strSQL You are about to update 1 row(s) Want to replace this with a msgbox saying "Are you sure you want to...

The Chnage Event on the Tab won't work because it requeries all the records on the form. so my combo box is wrong and the record i was on is reset. You have to use the combo box again to find the record. It's the related records on the form on my tab i want to requery. At the moment the only...

:eek: I can't seem to find one that will do what i want. I have a tabbed interface. Tab one has details about that record e.g. clients Tab two is an input form that lets you add new client Basically after i added the client i want to go back to view this record in the first tab. i can put a...

Ok If I Type in the Input Mask ? this accepts A-Z. But limits me to one char. What if I want to use unlimited chars entered?

I am wanting a text field in a table to accept only chars A - Z In my validation rule I use Like "a" Or "b" Or "c" Or "d" Or "e" Or "f" Or "g" Or "h" Or "i" Or "j" Or "k" Or "l" Or "m" Or "n" Or "o" Or "p" Or "q" Or "r" Or "s" Or "t" Or "u" Or "v" Or "w" Or "x" Or "y" Or "z" Which works :D...

It did sort of What I am asking is basically like having a CSS stylesheet in Access!!! i don't think it can be done as I have trawled through a lot of the net....

Hi I have a problem where the user has certain contraints in colour. I am trying to change all the colours of labels in the database to purple. Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also...

one solution i have found is to create a textbox Then set it's control source to =cboPenManuModelID.column(2) But this doesn't display it in the combo box. If anyone knows how to do that be very happy!!!

I am trying to display two fields when the combo box is unselected. Basically I have a table source manufacturer. This table has Manufacurer e.g. Nokia. Model No e.g. 3230. So on the combo box i want it to show Nokia 3230. Saves me linking to a subform to show the information. Can it be done???:)

Hi I have finally finished the database but i have a major report I am having trouble with. I need a report that works in stages for a property building system At the top is the property type this has a table property materials showing the materials it is made of, costing Then property...

Weird thing is, if i try reference the frm_ServiceMain it works fine. It's the third parameter!! maybe access doesn't go that far??

Hey Shane!! Yeah it is on subforms - 3 levels actually!!! Me.txtpersonBuildingNameNo = Forms![frm_OrganisationMaster]![frm_ServiceMain]![frm_Activity].Form![txtactivityBuildingNameNo] i tried this but says can't find the field frm_Activity. But it is there??? :confused:

Hi I have read through this forum and found some help on this but can't get it working. I have a subform Activity Contains a tab control with two tabs Activity Details - Persons I want to copy the address field from Activity Details tab to the Address field on persons tab Code for the on...

;) no probs. remember to think logical. keep it simple....

what a headache. i managed to find out that you can only use one select field in a select distinct. i came up with some different code that helps me do what i want. here for ref SELECT tbl_Aplaws.Level1, First(tbl_Aplaws.AplawID) AS FirstOfAplawID FROM tbl_Aplaws GROUP BY tbl_Aplaws.Level1;

hi it would probably be better if i understand correctly to create a field in the client table called something like size of property required. then come up with a list. eg small, large, mansion etc. then when you create a property give it a size of these. small, large, mansion etc. create a...

I need to select two fields in a select DISTINCT query Select tbl_Aplaws.AplawID, DISTINCT tbl_Aplaws.Level2 FROM tbl_Aplaws WHERE tbl_Aplaws.Level1 = 'Business' ORDER BY tbl_Aplaws.Level2; anyone know how to make this work?

Hi I am trying to use a query to populate a combo box. works fine as I am using one table. I want to select DISTINCT records which works. However i need the ID of that record in the select statement. Anyone know how to select two things in a select distinct query?? Select DISTINCT...

hi there! cheers for that. Im using Access 2003 and that code throws errors. saying can't find. figured it was something to do with setfocus. Anyway code below sorted it!!! Private Sub cmdFilterSelect_Click() On Error Goto ErrHandler Screen.PreviousControl.SetFocus DoCmd.RunCommand...