Recent content by swarv

that works now - looks like I was using createddate instead of created date. thanks for your help with this.

I have attached a screenshot - does this help? Hooefully that will answer your question? I just tried witht he []'s but still no luck - still asks.

sorry I meant createddate its not a field in the table. created date is a field but on the report its called createddate. if I take out the vba it works fine, just shows all records. Also works if I just put in the dept= bit of the code. thanks

Hi, Thanks for this. But it is now asking me for the changeddate in an input box as a parameter. This is what was happening before. Your code does make it a lot simpler though. Any ideas? thanks Martin

Just a quick one: I have this now: Code: Text2.SetFocus Dim txtdept As String Dim txtdept2 As String txtdept = Text2.Text txtdept2 = "dept='" & txtdept & "'" dt0 = DTPicker0.Value fromdate = "'CreatedDate > #" & DTPicker0 & "#'" todate = "'CreatedDate < #" & DTPicker1 & "#'" strr = txtdept2...

now that will come in use. I never knew that. thanks

also I must look up the Nz bit. Not sure what it means yet. I'll try that aswell. Thanks for this

sorted. I forgot the ' 's. thanks

Hi all, I have this: Text2.SetFocus Dim txtdept As String Dim txtdept2 As String txtdept = Text2.Text txtdept2 = "dept=" + txtdept DoCmd.OpenReport "Copy of inventory transactions - Choose Dept", acViewPreview, , txtdept2 but when I run it a enter parameter box appears asking for a dept...

Hi all, Is there any reason why this doesn't work? Private Sub Report_Load() Dim s As String Dim d As String Dim str As String Dim datestr As String s = InputBox("Enter the dept", "Inventory") d = InputBox("Enter the date from", "Inventory") str = "dept = '" & s & "'" datestr =...

Hi all, I have this: Private Sub Report_Load() Dim s As String Dim str As String s = InputBox("Enter the dept", vbOKCancel) str = "dept = " & s DoCmd.ApplyFilter , str End Sub It asks me twice for a value. All I want to do is enter a dept and then the report show with the filter as for...

excellent thats it. cheers for that.

Hi all, I am trying to use =sum([price]) in the control source box in my report to add up a list of numbers in the report. the text box that has the amount in is called price. It doesn't seem to be working. I know its a simple fix but how can I do this? thanks Martin :confused:

Hi, I have to create a new table in access which is fine. But i want it linked to the SQL database. My other tables are. When I copy one of the other tables and then paste as a new name it doesn't show on the SQL server. How can I get this to show? Thanks Martin

Hi, I have to create a new table in access which is fine. But i want it linked to the SQL database. My other tables are. When I copy one of the other tables and then paste as a new name it doesn't show on the SQL server. How can I get this to show? Thanks Martin