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 strongm 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: Patentinv
  • Content: Threads
  • Order by date
  1. Patentinv

    Forms will not print in color

    Hi, I have 5 forms that I print, 3 print in color and 2 do not. I can not figure why the 2 won't print in color. I'm using a macro (printscreen) in the on click procedure of a command button, which is the same macro for all five forms. Any suggestions on why this is, would be greatly...
  2. Patentinv

    Need code to run when the databse is opened

    Hi, I have some code that is suppose to run when the database is opened, I'm hoping it will copy a form from the database that is opened into an existing database on a clients machine, It will over write there form with this new form both forms have the same name. I don't know where to place...
  3. Patentinv

    adding forms into a remote runtime version access 2003

    Hi, I have an access 2003 program that I’m currently working on that I intend to place on the Internet for sale. I plan on selling it with the option of upgrades / add-on forms My question is what would be the best way to insert these upgrade/add-in forms into their remote database. One of the...
  4. Patentinv

    Can I place an MS Word .doc document into an access 2003 form?

    Hi, Can I place an MS Word .doc document into an access 2003 form? If so please explain how? Thanks--I appreciate all help.
  5. Patentinv

    Can a Filter By Form Macro be converted to a Module

    Hi, Can a Filter By Form Macro be converted to a VB Module code and then the converted code be placed in onclick event procedure of command button in place of where the macro was that was working fine and have it work like the macro did, in Access 2003 Reg mode, Not Runtime mode? If so I sure...
  6. Patentinv

    Error handling converting Macro to a VB Module

    Hi, I'm testing my database in runtime mode, I came a cross a macro that gave an error so I converted it to a module heres the code it generated= Function Find_Applicant() On Error GoTo Find_Applicant_Err DoCmd.Echo False, "Please Stand By" DoCmd.Hourglass True DoCmd.RunCommand...
  7. Patentinv

    Access 2003 developer extensions (Startup Wizard)

    Hi, I've finally opened the Visual studio for MS Office systems tools box and found the access 2003 developer extension CD and loaded it, I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case. Sure enough I was...
  8. Patentinv

    Text box calculation sum needs to be a fixed number.

    Hi, I have a combo box that has a calculation in its after update event procedure that reads = ([TOTFLDSQ] / 4) + 0.4 and it places the sum in a text box called [feltrolls] Let’s say [TOTFLDSQ] = 33.88 / 4 = 8.47 + 0.4 = 8.87 The [TOTFLDSQ] text box is dynamic per estimate has a different value...
  9. Patentinv

    New query will not show values in the popup form,

    Hi, I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running...
  10. Patentinv

    With a calculation in a text box's control source, how can I bind it t

    Hi, I have a text box called (TOTFLDSQ) in its control source I have a calculation =[txtfld]+[Xtrasqrs], Is there a way to have the sum of this total be saved in a field in the forms bound table? If the calculation was not in the control source I could bind this text box to a field in the forms...
  11. Patentinv

    Write Conflict error when closing 1 form and opening another

    Hi, I'm getting a (write conflict error) stating this record has been changed, asking me if I want to save this record, when I’m closing a form called labor and opening another form called primaryBid_Master. If I click save, it saves it and every thing is OK. Is there any way to stop access...
  12. Patentinv

    Need data in a text box's that is on a different form

    Hi, I have a form in access 2003 we'll call the master form that has a macro in a command button to popup form. On this popup form I have a few text boxes that have numbers in them that I need to use in the master form. Since each form is bound to a different table the master form can not see...
  13. Patentinv

    Inserting or moving a record to a different position in the table

    Hi, With a table in open view can a record be moved to a different position, i'm using access 2003. Also is there any way to sort besides ascending or descending? I've got a lot of tables to make and if I forget a single column/field and have to add it later (like I have done all ready...
  14. Patentinv

    Variable for holding a calculation for a text box

    Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...
  15. Patentinv

    Query to make text boxes visible/not visible

    Hello, In my program I have the text boxes in the form header set for invisible or visible = no, then on the combo boxes I have an on click event procedure that makes the text boxes visible. Each combo box relates to a specific text box. You’ll understand why as you read on. Now when I close...
  16. Patentinv

    Text boxes control source = calculation can't save sum

    Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...
  17. Patentinv

    Refresh combobox's when form opens

    Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...
  18. Patentinv

    Can 1 combo box have 2 after update procedures in it

    Hello, Can 1 combo box have 2 different after update procedures in it? If so can you describe how? Thanks--Any help will be much appreciated.
  19. Patentinv

    Figuring different calculations per choice in combo box

    Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text...
  20. Patentinv

    Can i set my form default to last entered record

    Hello, I have a program/database that I'm building in Access 2003, It has new client/bid entry form that has many text boxes for instance: Client, address, Phone number, Date etc. These text boxes are actually populating the same text fields in the PrimaryBid_Master form. My question is every...

Part and Inventory Search

Back
Top