Recent content by mwn1218

Create a module called Public Variables and place the variable in there.

Store the text in a public variable and pass it to the report using OpenArgs DoCmd.OpenReport "Your Report", OpenArgs:=strWhateverYourStringIs then set the text box = Me.OpenArgs

Link is not working

You can use OpenArgs to pass a filter from the form to the report

Thanks for the reply. I ended up using this: DoCmd.RunSQL "UPDATE Staff SET [Room #]=Mid(RMID,5) WHERE Len(RMID)>4"

I am trying to clean up some data that a client gave us. Right now the Building and Room # are in the same field and I want to split them apart. The Room number always beigns after the first 4 characters. I was trying to write a module to do this automatically. When I run the module I get a...

That would be helpful.

I use this: =IIf(IsError([field]),0,[field]) put this in the control source of your sext box

If tried this putting the code in the afterupadte event of a combo box. So once i selected a record then it check to see it was null. I tried this for a text box and not an ole object so hopefully it will work you. if Not isNull (me.olename) then me.label.visible = false else...

Could try this Dim strLinkCriteria As String strLinkCriteria = "[FieldName] = Forms![FormName]![FieldName]" DoCmd.OpenForm strDocName, , strrLinkCriteria Hope that helps

I have a string (strFilter) that is used to store a filter for a report. It is created from a list box (containing project numbers) on a form and when the user prints the report it ask them to save it and it stores strFilter in a table. What I need to do is when the user selects an existing...

You should not be linking two Promary Keys together. It should look like this tblBooking BookingID (PK) tblBookingExtra BookingExtraID (PK) [I]BookingID (FK)[/I BookingID should be a foriegn key in table tblBookingExtra

Is there a way where you can hide the menues from the users but be able to access the menus by using hot keys (any of the 'F' keys)?

Not sure if this will work but. Try creating a form that all it does is ask for a password and then takes you back to the other form. Then when they click the button it pops up and checks to see if the password is valid. Public strPassword As String 'Click Event of button where you want to...

Thanks for the clarification