Search results

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...

I would like to know how to get some kind of error handling that make sense to the user. On this form there are 3 boxes. I would like to have something state "hey you did not fill out txtMemo1" and I would also like to make sure people enter the date in the correct format. Access already...

I would like to remove the generic "You are about to append 1 rows" statement with something like. "Are you sure you want to add this record" then the user can click yes and it will add it or No and it will not. Here is my code. I need to know what and where to put it..I have never used...

I have checked The fields are all the same length wih the exact same data in them. For some reason Memo1 does not like data with more than 250 chars. Im am totally baffeled

I need help. I have a simple select query that I need to run. The problem is if one field has too much data in it I get the following error. "The field is to small to accept the amount of data you attemped to add. Try inserting or pasting less data." What is funny the data is already in tables...

I need help. I have a simple select query that I need to run. The problem is if one field has too much data in it I get the following error. "The field is to small to accept the amount of data you attemped to add. Try inserting or pasting less data." What is funny the data is already in...