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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. Blanch

    Cal + other

    Here is one possible solution, I hope your ready for this one: I created 2 Forms. First Form is an Auto Form of Orders w/ Details form from Northwind. Next I added 3 buttons each with a Find Icon placed next to the 3 Date fields that were generated. The example I am presenting targets only the...
  2. Blanch

    Function Running In Reverse & Only Once???

    ...reference to the form otherwise use the Me keyword or no local form designation at all. The code could be as simple as: Function ShowHide100() '***************** 'If form is some other form 'Dim frmOther as Form 'Set frmOther = Forms!frmqryECNMasterData100 ' - or - 'If form is active form...
  3. Blanch

    How do I create code for a command button that will add

    Here is a sampel of code that works fine. Private Sub cmdEmailClose_Click() With DoCmd .SendObject acSendTable, "Shippers", acFormatTXT, "jim.blanchard@tycohealthcare.com", , , "TEST", "BODY", False .Close End With End Sub...
  4. Blanch

    Micrsoft Access can't create any more controls on this form or report?

    ...logical areas and then moving some of the controls to a subform. In theory you could have one parent form with 754 - 7 = (747 controls) + (7 Forms * 754) = 6025 Controls. This is an untested theory. To handle the aspect of bound controls. I personally would use all unbound forms and...
  5. Blanch

    Micrsoft Access can't create any more controls on this form or report?

    I would look up Aceess Specifications in HELP. It will outline the limits that you might be hitting. If you are putting 754 controls on a single form, you should rethink how you intend on using the form. Jim Hope this helps! Jim
  6. Blanch

    Cal + other

    To answer the first question, I would suggest ensuring that you have properly wired-up the datasource to the control. In my example I have a calendar control named myCalendar. I want to sync it with a textbox on my form named txtOrderDate. so I write the one line of code to do this. Private Sub...
  7. Blanch

    Links when not in subforms.

    Off the top of my head 3 solutions. 1) Use the DSum() function to return the value e.g. =[Original Quantity] - DSum("Sum", "Inventory Transactions", "EquipmentID = " & [EquipmentID]) This domain function will search the "Inventory Transactions" table...
  8. Blanch

    Oracle PL/SQL calls via MS Access Pass-Through Query

    I believe the PL/SQL command is the same as Transact-SQL: try... exec procedure name within the body of the stored procedure. I will look it up and correct myself if I am wrong. Jim
  9. Blanch

    Microsoft Date & Time picker control

    Thorny, Ben's Idea is probably what most people do end up doing as a workaround. It is simple enough to pull off, by creating a small form that shows the calendar control and uses some text and or comboboxes to complete the look and feel. Sync-ing the controls and passing data requires some...
  10. Blanch

    Stick Values into ComboBox

    Nope. [nosmiley] The SQL in the comboxes isn't changing, just the recordset of the form - right? As long as those combocoxes are not bound to a field on that form - and the rowsource of the combox doesn't change dramaticallly between refreshes - it should work.
  11. Blanch

    Can I make access report diffrences between rows in a table

    I have an example, how do I get it to you.
  12. Blanch

    Stick Values into ComboBox

    I think at this point the only way that I might be able to lend any more help would be to actually see the form itself. I think it would be too much work to try and recreate the situation myself. It sounds like it should work. One last question? Are these comboboxes in the header of the form? Jim
  13. Blanch

    Microsoft Date & Time picker control

    Are you trying to redistribute this control as part of a solution? I found an Knowledgebase article out at support.microsoft.com (Microsoft Knowledge Base Article - 170692) that talks about the inability to distribute solutions containing the Calendar control without having the ODE (Office...
  14. Blanch

    Stick Values into ComboBox

    Are the combobxes bound or unbound? If they are unbound you should not have any trouble with them. If you needed to "reset" the comboboxes the best way would be to do the following: Dim strSql as string with combo1 strSql = .rowsource .rowsource = "" .requery...
  15. Blanch

    Can I make access report diffrences between rows in a table

    What version of Access are you using? I could send you a demo to learn from.
  16. Blanch

    Stick Values into ComboBox

    Without seeing the app, I might suggest a couple of things. Ensure that you have quotes around parameters that are strings in your SQL. Also you do not need to use the Goto Keyword in this case, the If Then Blocks will terminate properly. You could make all of the IF Blocks...
  17. Blanch

    Start up options for a database...lost my toolbars...help

    Just before clicking Open, press and hold down the shift key. this will disable the stratup for that one time. Then go back into the Startup properites and recheck your menus. jim
  18. Blanch

    TransferText Macro and Specification

    Ahhhhhh... The only way that I have found to view specifications (without actually looking at the system tables) is to actually try to import/link something and click the advance button on the wizard. This will bring up an area that will allow you to choose an existing specification for editing...
  19. Blanch

    Transfer Text command

    It's all a matter of preference. If the data in the text file will always be appended to the table then you could use importing, and I would follow these steps: 1. Rename your current table from tblName to tblName_old 2. Manually Import the text file into a new table named tblName. You will...
  20. Blanch

    Access table links

    I agree with the creating of the child table to support 1 Project has many categories. When you run your append query to update the categories table make one the the categories "ORIGINAL" or "ALL" this will allow the customer to search out the records they want to fix...

Part and Inventory Search

Back
Top