Search results

Dor some reason it was showing all the records but what you wrote worked. Many Thanks

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have. I would like a column to be hidden for a certain group of users and have tried the following. On the subform opening event i have if vlevel = "engineer"...

I have a field that stores the date in. I would like to query the records that show only the those that are less than one day old. e.g. Only show those that are for today and yesterday. I have tried = Date()-1 but didnt seem to work. Any Ideas

That would work if i was replicating the buttons for my own, and put in a new label, but all i wont to do is just change the embedded navigation button's label. I know some people may suggest to create my own buttons, but they aren't visible if the subform is in datasheet view.

I have a subform in datasheet view. Would it be possible to change the text 'record' to 'Line'? If so how?

Its ok i manage to solve it by saying that if it was null set the .picture to "" However How can i trim or shrink the image to fit into the size of the image control?

I have created a form that with an image control called imageview with the following code. Private Sub Form_Current() Me.ImageView.Picture = Me.AlbumCover End Sub Albumcover is a text field containing the path of the bitmap. All is fine unless i move to a new record in which i get an...

Ok i did it using an array =SUM((B1:B6=True)*(C1:C6=1)*A1:A6) To Enter the array press Ctrl Shift Enter when leaving the cell. Hope this helps anyone who came across the same problem.

i have =SUMIF(B1:B6,TRUE,A1:A6) But how do i add the second criteria

I would like to move sum A1:A6 If the B cell is = True and another cell is = 1. I have an attachment that shows the layout. Therefore Total = 76.7 Does that make sense? If so how could i work out the formula?

If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like...

sorry SJ you replied as i did Allan's worked

thats the one!!! thanks alot

I would like the users to enter values of day 2.5 however it always rounds up to 3 i have checked the propeties of the field in the table and i have set it to 2 decimal places. I have also checked the property of the field on the form and done the same. There must be something i am missing...

No unfortunately that didnt work. I just need to some get it to run teh after update code. but because it doesnt detect the mouse cusor entering or leaving the field it doesnt know its been updated. I guess i could write a public function that it runs after giving the field its value.

I have a form that has a combo box, once a user selects the required entry it the form performs several tasks after update. If the required entry isnt listed the user clicks on the add button which opens a form to fill in the necessary details for that entry. Once complete the user clicks on...

ok so now its detecting it what i would like to do is setup so that the it highlights the ones that are empty... If IsNull(Me.field1) Then MsgBox "You have not fully completed this form" Me.field1_Label.ForeColor = 255 But what if i have several fields that i would like to check...

cool it worked thanks

I have some fields on a form that are update once a cmbo box is updated. They are updated by dlookups. However the fields that it looks up maybe empty so nothing is entered. So the user can enter the information themselves. On exit i would like to check to see if the field on the form is empty...

I have a form with a button to print of the contents of the form in a report. I have set it that when the user close the form they can no longer access what they have entered. Therefore on close of the form i would like to check to see if the user has printed the report and is happy to make...