Search results

Don't think it's related to the html...but?? The code I use is this: strolbody = strolbody & "<tr> <td>Ticket Text</td><td>" & me.notes & "</td>" It's the me.notes that needs to retain the formatting. Sorry the tags you suggested didn't change anything. I'm no tagger though, not sure what...

Memo field data like this: this person on this day said: blah blah this other person on this day said: so on and so on I have created an email that takes the memo field and puts it into a table. In my table the memo field removes all formatting and displays as one block of information. Ie...

Found the answer in another post: DAO uses * as a wildcard, ADO (and SQL server) uses % as a wildcard. I didn't want to have to go through ever darn module everywhere and change * to a % so I've used aLike with % which should (so I'm hoping) stop that problem, I think. I changed my code to use...

strsqlim2 = "SELECT tempq1.CLLI, tempq1.alarm_desc, Sum(tempq1.SumOfCountOfmicro) AS SumOfSumOfCountOfmicro FROM tempq1 GROUP BY tempq1.CLLI, tempq1.alarm_desc HAVING (((tempq1.CLLI)=" & "'" & strclli & "'" & ") AND ((tempq1.alarm_desc) like " & """*host to m*""" & "))" Debug.Print...

Hi, I have developed a couple of database applications. This started as a small thing but now is growing to the point where I've got to make some decisions and would appreciate some guidance. Presently: Front end: 4 Different GUI's as local front ends. Back end: Intranet network share on...

Hello, The problem might be with the data. Maybe one machine has different settings for date or something? In your sql, try formatting the date to the format that you want, just to make sure. Al

Hello, I have created a table that has a list of routines that need to be run on daily/weekly etc basis. main fields are: routine_description, last_run, repetition Last run is the date that routine was performed and repetition is how many days before it has to run again. When the routine is...

Compile the code then do a compact and repair. After having my hard drive replaced and certain files recovered, I ended up with two sets of settings for Access and actually all Office applications. This was causing all kinds of weird behaviour. Same symptoms you describe. You can check if...

Any idea what parameter would be missing? I created the query using the QBE grid. When the string is compiled, it looks identical to the sql view of the QBE query that I created. I would like to see all of the "calls" logged yesterday before 12:00. If I take out the part with the time, the...

References okay; same on both computers too I thought of that too... references are the same on both computers. DAO is selected too.

hello, This problem is driving me crazy! Dim db As dao.Database Dim qdf As dao.QueryDef Set db = CurrentDb Set qdf = db.CreateQueryDef("hello", "select * from cctv_sites") DoCmd.OutputTo acOutputQuery, "hello", acFormatHTML I am getting an invalid argument...

zero length string What's the difference and how does one check for that?

If Not IsNull(Me.Callers1!ContactFirstName) Then MsgBox Me.Callers1!ContactFirstName.Value Generating error message: You entered an expression that has no value. The form is open and has no value... but the isnull should take care of this, no?

Thanks! You bet... if only I had all the right answers at the right time, I'd be all set!

Who would've thunk it... I've got three different fields with similar names. Two are linked and one is not. You're reply got me to look and make sure. Turns out the one I wanted to change to numeric is indeed numeric but isn't the right field to link to. Thanks!

yes, it definitely is. Within the informix database, these two fields are linked.

I am using the funtion: Clng([text field]) to convert a text field into a number so that I can link in a query. Because it is an informix database, I cannot change the underlying table format. When I run the query, the data is showing "Error". I tried changing the other table to text and...

Thank you all Right([YourField],Len([yourfield])-InStrRev([YourField],"-")) does exactly what I was looking for. my .02 ... whatever works, works BUT there is an eloquence to simplicity.

Eureka!! Thank you, thank you... works like a charm, and I actually understand it too.

Not giving the right data As suggested, I used: Right([mydata], InStrRev([Mydata], "-")) but this doesn't work... just seems to randomly cut off the data without rhyme or reason (can't figure out a pattern). I tried Left([mydata], InStrRev([Mydata], "-")) and it shows the data that I want...