Search results

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

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

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

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

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?

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

Okay, I figured out that I can use the instrrev function to look at data from right to left. I used this function: Right([mydata], InStrRev(1, [Mydata], "-")) in a query in an attempt to get all data right of the "-". When I run my query, I get "error" instead of the data I was expecting...

Hello, I have data that looks like this: blahblah-need blah-aneed blahblahblah-aaneed I would like to have everything right of the dash to get: need aneed aaneed I have used mid and instr to get the left hand stuff. I've tried to modify to get the data to the right of the dash and I am...

Is this even possible? I've been looking for info but have come up empty. If not possible, anyone have experience using ADO and have example code to share? Much appreciated, Al

Good day, Here's a functionality I'd really like, but cannot find much in the way info about it... My database is almost always open by someone (7/24 support operation). I'd like to generate and run reports on a nightly and weekly basis without any intervention by end users. Are there...

Good day, Need to use something along the lines of date-1 on a linked ODBC table. Problem is that the date is a numeric format displaying: yyyymmdd. The fact that it is numeric makes it easy for calculations, but not if I want to compare to date() as it is in access. Thanks for any...

I'm trying to move to a new record in a subform... I haven't been able to get it going, so I put a command button on the main form with the following code attached for testing purposes... Me.frmsubfrmSiteanalysis.SetFocus DoCmd.GoToRecord acDataForm, "Me.frmsubfrmSiteanalysis.Form", acNewRec...

Yes it is complicated... Ok, I have a form which displays some records in a multi select listbox. User will select the records they want, click a button and the records are transfered to a subform's subform. The relationship is that one selection from the main form will be one entry in the...

Good day, Need some help in structuring a VB function that will loop through records using the specific value of one field in each record as the criteria in a seperate recordset. I have created a SQL statement that gets the records that I need via an ODBC link (for the sake of example, lets...

date(), desktop settings, need something robust Good day, I have an access application with a few command buttons, used by staff to log calls. The default value for the date field is "Date()" For the past 6 months, the app has worked flawlessly. Recently, their machines were upgraded to...

Good day, I recently split my database to be a front end/back end application. I noticed that my relationships didn't seem to be done correctly. If I load the back end, I can see all of the relationships as I set them up, however on the front end, they weren't there. So...I set them up again...

Help with this is much appreciated as I have been working on it for hours! What I want to do: I have set up a form with 4 different tabs. Using the value of a control within the form, I wish to change which page of the...