Search results for query: *

A user completed a scheduled call, copy and paste an email body into the notes section. Now, this history entry are replicated into other contacts. Why is this happening? The user is a remote user and have sync'd to the server and I can see the history entry in other contacts as well. Any...

The DDS2 Tape drive on my IBM F50 AIX 4.3 box is broken. I have a DDS3 Tape drive that I would like to install. What is the proper way to do this? Do I need driver for AIX 4.3 to recognized the DDS3 drive? Please give detail instruction to swap out the DDS2 and install the DDS3. What...

I have Windows 2003 server with DHCP setup. Is there a way to prevent rogue devices from obtaining an IP address and get into my network? Is there some sort notification that will let me know if a rogue device is attempting to get into my network? I realized if they know my ip range, that...

How do I compare text fields to a table of specifications for a certain product? I have 6 fields on my form, time1, time2, time3, time4, product, and status. when Product A is selected, the user then input 4 test results (time1 - time4), the status field should tell the user if the tests...

Looks like we have to blow away our current Goldmine Server and GoldSync server due to all kinds of duplicated records and my VAR can't fine where the problem is, and suggested a complete reinstall of the server. The data will have to be manually cleaned up. Is there any way for me to save the...

I have just inherited Goldmine 6.0 and problems are starting to show up. I have a remote user that couldn't see any of the history. I redo his one-button sync and still nothing shows up. I was told to do a maintenance on the database and when I do that it gave me an error. Here is the error...

I have a table called UsystblbatchRecord. When the field RevNum gets updated, I would like a query to update the same field to another table called UsystblTrainRec and set the traindate, EvaluationMethods to Null. The idea is, whenever there is a new Revision number, I want to reset the...

Please help...trying to count number workdays between to dates. Using FAQ181-261, I was able to accomplished it, but now, I would like accuracy down to the number of hours. FAQ181-261 seems to round up/down a whole day. Is it possibe to calculate down to hours if the date fields have date and...

Have two tables (usystblEmployee and usystblTrainRec). When HR updates the usystblEmployee table, I would like to run a query to update the usystblTrainRec table to keep them in sync. I tried the update query posted below, but I am not getting any updated records. I do know for a fact that...

I have a table with the following fields: StartTime, EndTime, and Total. The StartTime and EndTime are formated so the Date and Time are recorded like this "10/06/03 5:45:00 AM." When the staffs starts to work, they would enter the StartTime and at the end of the shift, they would...

Is there a way to have DLookup using two fields? For example, If fieldA & fieldB existed, then msgbox "duplicates records". cancel, undo...etc. But if fieldA existed but not fieldB then it's ok to go on. What would the DLookup statement look like? This is the code I've used for...

I have a field called Description in a table. It is set as required. When a user leave this field blank in a form, a message stating that is field cannot be null pops up. What I would like is to customize this message. Is there any way to do this? TIA

How can I have a msgbox comes up if a query returns no record??

I have my form all set up to send email when the email textbox is doubleclicked. What I wanted to have done is to have it also attached an external file (a PDF file) to the email. Any ideas gurus? TIA

My primary form, frmDOCUMENTS(tblDOCUMENTS) have a subform called frmREVISIONS(tblREVISIONS). They are linked using DocNum. For each DocNum, there can be many revisions(RevNum). What I would like to have on my primary form is an unbound box displaying the latest revision number for the linked...

I have a field that store procedure numbers. The procedure numbers are in a format as such: 2.1, 2.1.2, 2.10.100 ... and so on. I've tried to set the field as a number, but it won't let me. The only option was to create the field as a text field. This works fine, except when I want to sort...

the code below works fine if the LotNum only contain numbers. I have lotnum that also contain letters. How do I change the code below so that it allows numbers and letters. ___________________________________________________ Private Sub Form_Current() If Me![LotNum] <> 0 Then...

My Access97 database have over 1300 embedded images. It is fast approaching the 1gb size limit. I need to find a way to export the images from Access and save them in a folder in my HD. I can do it individually, but is tediously time consumming. Is there a way to automate this process? TIA

Please look at this query. It works as below, but if I add a new record to the table ISORequirements and run this query, it doesn't append the new record to the Table TrainingRecords. Any idea why?? For Example.. If TrainingRecords & ISORequirements already have a record as follow. EmpNum =...

Again, I am trying to get a date without the holidays and weekends. Fields in the table, [DateFreq], [NextDueDate], and [LastMaintDate]. What I am trying to do is, when a user input the [LastMaintDate], the DB calculates the [NextDueDate] based on the [DateFreq] & [LastMaintDate]. The...