Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: janetlyn
  • Content: Threads
  • Order by date
  1. janetlyn

    Report Condition (Where)

    I have a form (frm-ParentMainForm), with a subform (frm-ChildPLHours) holding a label (Label9). I would like to click on Label9, which would open a report in print preview. The report is based on a query (QRY-ProjectHrsSearch) which has a parameter asking for "What project number would you...
  2. janetlyn

    #Error

    I'm pretty sure this is a simple and stupid problem but I can't solve it so please help. I have a form, the form has a box (Text181) with: =Sum([UseHoursTrips+TtlAllow] as the formula to get data. This Text181 is in the header. If I just have the UsehoursTrips and take out the TtlAllow and...
  3. janetlyn

    Help Form

    Has anyone ever added a Help Form to their database giving definitions or how to do a certain process? I am trying to do one and not sure the best way to achieve that goal. Thanks, JL
  4. janetlyn

    Combobox Selection

    A form opens with a combobox, textbox, and label button. The combobox window drops down showing the choices available, but when someone actually clicks on a choice it does not fill in the combobox. Here is the code behind the form: Private Sub Form_Activate() DoCmd.SelectObject A_FORM...
  5. janetlyn

    Missing Files

    I just did a backup and then went in to do maintenance on my db, only when I tried to go in it gave me a "waiting for permission to log on" error. I changed the license file but now it is missing a file called charset.dbf. I tried to locate it on the original Goldmine CD and cannot. It will...
  6. janetlyn

    Can't save form changes

    I have a form (F1) with only a Tab Control on it and multiple buttons on each tab. The buttons are hyperlinks and just open other windows (popups). However, if a popup opens and it is bigger than F1, it is under F1 and if I close F1 so I can see the popup, the popup also closes. I decided...
  7. janetlyn

    Subforms

    I have not used subforms very frequently, but if I have 6 tables with the same field being the primary key in all 6 tables (i.e. Project#), Can I have one main form with 5 subforms (hidden maybe) so when I add a new project# to the main table, it automatically adds the same project# to the...
  8. janetlyn

    Form off screen and won't come back!

    I have a form that was working fine, opening maximized. Now it is about 1" off the screen to the left and 1" off the screen at the top. The only way I can see the screen properly is to use both scrollbars, except my form exactly fits my screen and I do not want scrollbars and it is annoying to...
  9. janetlyn

    List box problem?

    I have a form with a CheckMark, Number field, and Text field. If the Check is true, there should not be any values in the Number or Text fields. If the Checkmark is False, there has to a number and text. The text is what is giving me problems. I have my Row Source Type as "Value List", and...
  10. janetlyn

    Driver for old modem

    Can anyone give me or tell me where to find a driver for a Lucent Technologies modem Model #90057. All the websites I can find want to charge an arm and a leg. Any help would be much appreciated. Thanks, JL
  11. janetlyn

    Summing on a report

    I have a table that I input invoice amounts into along with the month of the invoice. There is a report using this table that adds up the invoices for each month and each line has: Month/Year $$$$$$$ (total for each month) At the end of the report is gives a total for all...
  12. janetlyn

    Access Compatibility

    Has anyone had any problems with Access and Goldmine running at the same time. When I am in Access working on my program, I will tell it to save and not always, but once in a while (every 3 days) it will say it can't save the record and then all these Goldmine messages start coming up that this...
  13. janetlyn

    If Null Error

    I have a bound date textbox and a bound checkmark on a form. If someone types in a date and then tries to put in a checkmark on the same record, a message should come up telling them they can't do that and the same if they have a checkmark in and try to add a date on the same record. My code...
  14. janetlyn

    Data Entry Problem

    I have two tables: TBL-Invoices and TBL-Hours. Both have the same primary key of ProjNo. I have two forms: FRM-Invoices and FRM-Hours to input the above information into the tables. If someone is inputting into one of these tables and it gives an error message of referential integrity like...
  15. janetlyn

    DLookup on Report

    I have a report whose control source is a query involving two tables. The Primary key in the two tables is [ProjectNo]. On this report in the header is shows the [ProjectNo]. However, I would also like it to show the ProjectNo name which is in a totally different table. So I did a DLookup...
  16. janetlyn

    Not going to new record

    I have been searching threads since 9am and cannot find an answer to my problem and am extremely embarrassed to ask for help on what I am sure is something simple; but, I'm desparate. I have a form with one bound field and three check fields. Usually, when I enter data, I type data into the...
  17. janetlyn

    Emails to "Goldmine Users"

    One of my employees said his email was not getting through until the next day. I tested it and here are the results: 1) If the recipient is chosen using "Contacts" the email goes through immediately. 2) If the recipient is chosen using "Goldmine Users" the email will not be...
  18. janetlyn

    Focus of Textfield

    I have a textfield [ProjectNo]. When the form opens I would like the textfield to have focus. I would think it has focus because that is where the cursor is when the form opens. But, I have code in the OnFocus, LostFocus, of the ProjectNo textfield and that code is not working, which is why I...
  19. janetlyn

    Adapti CD-RW

    I have a computer with Win 98, with a cdrom, not recognized by the computer and a CD-RW recognized by the computer. "The device is working properly." I think my brain went on vacation becasue I cannot figure out how to get the CD-RW to burn onto a CD. Can someone please help me...
  20. janetlyn

    If formula error

    I have 12 textboxes in a form. Box 1-8 = 77050; Box 9=77050; Box 10=77050; Box 11=77050; Box 12=77050. This is my code for these textboxes: ElseIf ((([A9] + [A10] + [A11] + [A12] + [A13] + [A15] + [A16] + [A24]) <> [A8]) Or ([A8] <> [E49]) Or ([A8] <> [E12]) Or ([A8] <> [A23])) Then...

Part and Inventory Search

Back
Top