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

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

The Add query works perfect. I would like to duplicate this query and change it to an Update query but I can not get it to work. Can anyone please HELP!!! I have an update query that works fine but access will not allow me to update any characters over 1024. Private Sub cmdAdd_Click()...

I cannot figure out what is wrong with the code below. The first text box txtProjectName is NOT a date. I know the # sign does not belong there but I borrowed this code from a working form and modified the field names hoping it would work. Any Suggestions. HELP!!!!!!!!!!!!!! DoCmd.RunSQL...

Does anyone know how to get a list box to word wrap or a way to make the Column widths more that 22' to accomidate a lengthy entry.

I have a form that I want to pull data from 2 tables when a value is selected from the cboProjectName drop down box. Both tables have the field ProjectName in them and I want all the boxes on the form to display the data that correlates to the valule in the Combo box. The code is listed below...

I need help. I have a simple form with 1 combo box and 2 text boxes. The combo box is populating from tbl_Projects. I want to select a value from this box and insert a record into a new table with data I populate in the 2 text files (Im using the combo so users cant type in values wrong and...