Recent content by alcifer_c

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!