Recent content by Jake94

Hi, I am combining fields one that has apostrophe's and the other does not. exp "if this field is null use data from this field (which does not have an apostrophe) otherwise use current field (which has apostrophe) "red" blue orange "yellow" How can I change that in the query without changing...

TJPoorman, that solved the issue. Thanks for you help!!

Please help! I am getting an error when I run this code as a whole. When I comment either the top or bottom out if works. What am I missing? Private Sub cmdSubmit_Click() If Me.cboEmployeeType <> "Managed Resource" Then DoCmd.RunCommand acCmdSaveRecord DoCmd.Close End If If...

How can I adjust my required field so that you cannot simply enter a space bar character to circumvent the requirement? Here is part of the code: If IsNull([txtRequiredReason]) Then MsgBox "The Reason field is required" DoCmd.GoToControl "txtRequiredReason" Else Thanks, Jake

I just inherited this report and I believe it is failing at this point. Does the punctuation look correct. Thanks for you help!! strSQL = "SELECT ID, [BLAST Number], [Derivative Contact Information], [RE Follow Up Date], [RE Subject To's], [Real Estate Specialist Assigned Date], "...

Relationships screen - we had a case recently where the relationships were broken. Data was lost, but recovered. The relationships have referential integrity. How can the links disappear? Is there any way to lock down or hide that screen?

Thanks for the reply! 11040077127, 8/23/11 1:56 PM, Pending, Review, Collateral Review, Bob 11040077127, 8/24/11 9:30 AM, Assigned/Reassigned, Review, Collateral Review, Bob Yes, I want to pull the next record time wise. Above is a subset of the data from my original post. At 1:56 this...

How can I return only the next line in a table? In this example if the Task is "Pending" I only want to return the next line "Assigned/Reassigned". ID Date Status Team Task Name 11040077127 8/23/11 1:38 PM Launched Fred 11040077127 8/23/11 1:55 PM Claimed Review Collateral Review Bob...

I have an issue pulling data. Hours table with a 1 to many relationship to Quantity/Complexity table. The entry on the form is a hours entry then up to 4 Quantity/Complexity entries. So, on the table i.e. there is 6 hours on the hours table and 10 Complexity 1, 20 Complexity 2, 30 Complexity 3...

Mike - Thanks for the confirmation. Yes, they are related. It is a copy of the same tables from multiple locations that are combined on the SQL server. neileg - I agree that would be a better solution. However, it involves costs. A copy of the database is in multiple locations 1000 miles apart...

I have a general question about copying tables. We have a front end / back end database. Nightly, the back end data has an automated scheduled transfer from a shared network to a SQL database. If that process fails is there any issues running the data transfer during the day when users are using...

Is there a way to write a report when a value changes over time. For example the value = X from 1/1/08 - 1/31/08 and then it changes to Y from 2/01/08 - 2/28/08. Can a report be written from 1/1/08 - 2/28/08 where it applies the value appropriately?

How can I track usage of a form?

Is there any danger of corruption copying data from another MS application and pasting it into a text box in Access?

How could I pull in someone when they do not have data? There is a name table and data table. My goal is that when I run a parameter query if someone does not have data for that time period to have that name pulled in so that eventually a report could be generated stating there is no data for...