Recent content by violentjay25

How do I do a report with a dynamic field name such as date. I have a cross tab query that uses a Date - 1, Date -2 and so on. The problem is the Dates in the query will change everyday which is expected. I need to know how to do a report with a field name that changes everyday...any help...

I have a form that looks up data through a query. The form works but after it queries and displays the data I get this error "424 Object Required" What does this mean. Here is my code if need be Me.txtSPR = DLookup("[SPRNum]", "[qry_FIX]", "[projectname]= [cboProjectName]")...

I got it to work Thank you for your help

Oh God Well yes I suppose that would be helpful to let you know Im using a SQL backend. My brain is fried at this point. Sorry for the confusion andI appreciate all the help you have give me

Do you know whats wrong? IF you know exactly whats wrong could you please just tell me. I suck at coding and need to get this done by the End of the Day. I would really appreciate it

No Dice This did not work. The record will still not update

I am trying to update records. Access says its updated but the changes never take. Can anyone see an issue with my code DoCmd.RunSQL "UPDATE tbl_Projects " & _ "SET ProjectName = "" & Me.cboProjectName & "", " & _ " SystemsImpacted = "" & Me.TxtSystemsImpacted & "", " & _ " SPRNum...

Its the last 2 statements I know its the last 2 statments that may be the issue

That almost worked I changed my code but now it tells me it will not append the row due to Key violations. Here is my code now DoCmd.RunSQL "UPDATE tbl_Projects " & _ "SET ProjectName = "" & Me.cboProjectName & "", " & _ " SystemsImpacted = "" & Me.TxtSystemsImpacted & "", " & _ "...

Thank you This worked like a charm. Thank you

This update is unable to use apostraphes and commas when updating. My insert into statement works just fine. If I do not use apostraphes or commas the update works. What am I doing wrong DoCmd.RunSQL "UPDATE tbl_Projects " & _ "SET ProjectName = '" & Me.cboProjectName & "', " & _ "...

This code works just fine DoCmd.RunSQL "Insert into tbl_Updates (Date1, Memo1, ProjectName) " & _ "Values (#" & Me.txtDate1 & "#, """ & _ Me.txtMemo1 & """, '" & _ Me.cboProjectName & "')" But when I want to use this same...

I am having an issue when I use Apostrophe's or commas. If I do not use this punctuation it works fine. Please Advise. Private Sub cmdAdd_Click() DoCmd.RunSQL "Insert into tbl_Projects (ProjectName, SystemsImpacted, SPRNum,ReleaseDate, Status, CSIPM, BPM, Implemented, StakeHolder, IBR1...

I have a question. I am using Access as a frontend and the backend is a SQL server. I have used the code below in order to put more that 256 characthers into the txtMemo1 field. This was the only way I could get it to work. The problem occurs when on the form if you use a comma or apostraphe I...

I have a question. I am using Access as a frontend and the backend is a SQL server. I have used the code below in order to put more that 256 characthers into the txtMemo1 field. This was the only way I could get it to work. The problem occurs when on the form if you use a comma or apostraphe...