Search results

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

Hi all, I have a few sub reports on my form, I was wondering if i now place a tab control on the form - can I place these items in to it just by moving them? thanks Martin

Cheers uncle, I couldn't find his posts. I so far have this which works for the total: SELECT Sum(tbldebt.totalmanaged) AS AllTotal, nameid2 as FullName FROM tbldebt GROUP BY tbldebt.nameid2; But I would like to pick this record and then subtract the previous record's amount. The amounts are...

Hi all, I have a table with fields like: totalmanaged and ID. Now when the user clicks on the next record I would like a field to calculate the difference between the figure in totalmanaged on the ID before and the value in totalmanaged in the current ID. Is this possible? Thanks Martin

Hi, I did see that. not kind of what im after. the db will already be on and I want users to click on their name, type their AD password and then if correct go do something else. thanks

Hi all, I am after some help. I have an access DB but on the start of it I want the users to pick their name from a drop down and then type in their password. when they click on ok it then clicks the details from an AD source and then if ok lets them in. Is this possible? Thanks Martin :confused: