Search results

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

You could just make the subform you want visible. In the click even of cmdDaily frmROrderDaily.visble= true frmROrderAnnual.visble = false In the click even of cmdAnnual frmROrderAnnual.visble = True frmROrderDaily.visble= false

I was just curious, I was going to see how you were doing that if it was automated. Anyways... In the form where you are entering in all the date I would create an if statement that would compare todays date vs the due date Dim Actual as Date Dim Reqired as Date Actual =...

Not sure if this will work but try something like this: put a text box in the detail section called txtCount, set the control source to =1 then set the running sum property to over group. Then you could write an if statement: This goes in the on format event of the detail section. If...

In the query your combo box is using to pull the information (access this by clicking on control source), under the Category field (add this field if it is not there) and under Total Row select where and add this code in the criteria row: (if you do not see the Total Row click the Sigma looking...

You could create a queires that sort the data into those categories then use each query as a sub report.