Search results for query: *

Having some trouble on a module and cannot figure out why it won’t work, the error I am getting is, if you have a chance could you take a look and see what I did wrong, it has been a while since I played with VBA: The error: "Syntax error in query expression 'SELECT Issues.IssueID'. 3075"...

I have searched all over the internet and still have not figured out why once I split my database that the AddFromOutlook command will no longer work. All I have seen is that it has something to do with the linked tables. Any ideas??? Code: Private Sub cmdAddFromOutlook_Click()...

Hello, I am trying to remember how to put the Month Name on a report using a text box formula, what I need is for the report to show at the top "Report for the Month of & (previous month's Name)" I know I need to use the MonthName function but after that I am lost, it has been a while since I...

I am trying to find invalid dates entered into a field within our database. The field is called ObsValue, which can be anything, it is in a general table that houses all observations entered, from text, dates, numbers and so on. I have approximately 150 of these various terms that are entered...

I have a report where I only one the first record for each patient and then the report is grouped by provider, patient but I am still getting both records instead of one, this is what I am using in the Group Selection: {DOCUMENT.CLINICALDATE} = Maximum ({DOCUMENT.CLINICALDATE}...

I have a very large memo field in a oracle database that I need to search for the "Imported By:" and extract the name from the field. I have tried numerous formulas but nothing seems to work right. Here is a sample of the field: {\rtf1\ansi\ftnbj{\fonttbl{\f0 \fmodern Courier New;}{\f1...

Need a little help, I have been searching for a couple of hours and cannot find anything even close to this problem. I have created a cross tab report in CRystal XI, for three months back, a set of data for each month. I used simple formulas to determine the month Name for the column header...

I have this report that is run from a cmd button. The click event contains code that is suppose to determine whether or not the sentence is concurrent or consecutive. If concurrent sets the TotalYears to the largest number of years. If there are also consecutive sentences it needs to the...

Need a little help figuring where my error is in this code. Please take a look, I can't see it. this code finds the case that matches the criteria, then determines if the charge sentence is to run concurrently or consecutively, if concurrent give me the highest sentence of all the sentences...