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

    How do I move a selected record to the top of the Datasheet after returning from another form?

    Hi MajP Thank you so much for your help. I am a bit confused. I am not working with a record set. The forms Record Source property is: SELECT * FROM dbo_view_invoicejobslist ORDER BY dbo_view_invoicejobslist.jobnumber DESC , dbo_view_invoicejobslist.drop; When the called subform is...
  2. smsmail

    How do I move a selected record to the top of the Datasheet after returning from another form?

    Hello, I have a subform, that displays in datasheet view. The datasheet displays a list of records from a SQL view. On the datasheet I have a Job Number field (along with other fields). When the Job Number is double-clicked, another form is then opened that contains detailed information...
  3. smsmail

    Access Report - Assignning a value to text field on a report

    Hello, How do I assign a value to a text field on a report? Can this be done. I have run into problem trying to do so. The RecordSource of the report have columns that contain numeric values that actually represent textual values of another table. I would like to the textual values to...
  4. smsmail

    View Permission question - Please help

    Thank you Dhulbert for your help. I do have a ODBC connection set up. According to the VIEW connection properties in sql server the Authentication Method is Windows Authentication, and Username is me. Is that why the view can not be seen by others?
  5. smsmail

    View Permission question - Please help

    Hello, I have an application, the front end is Access and the back end is sql server 2008 express. The application does not display the view on a user's machine. Do I have to grant permission for the user, in order for the view to display? I have tried granting permission, but I am doing...
  6. smsmail

    How to? A form with a tab control have generic command buttons

    Hello, Is it possible to have generic command buttons in the form header of a form that have a multi-page tab control? I have a form that have a tab control with four unbound pages. Instead of each page having its own command buttons, I would like to have generic command buttons on the form...
  7. smsmail

    Run-time Error 2004 (not enough memory) on OpenForm command

    Thanks Duane and MajP. You guys are very much appreciated by persons like myself. I have definitely learned a lot by way of this site. Duane: What I mean by "I execute the rowsource query in the On Click and Got Focus events and it works just fine." In the GotFocus event of the Client ID...
  8. smsmail

    Run-time Error 2004 (not enough memory) on OpenForm command

    Good morning Duane, Now I understand what you are saying. DUH! The 12 subforms, each have two controls that are lookup fields (combo boxes). The controls are "Client Name" and "Job Number". 1. The client name rowsource query result in 1317 rows selected. 2. The job number control...
  9. smsmail

    Run-time Error 2004 (not enough memory) on OpenForm command

    Reducing the record/row sources? Does this mean that I want to make sure all record source objects are closed after execution?
  10. smsmail

    Run-time Error 2004 (not enough memory) on OpenForm command

    Hi Dhookom That is a possibility. How would I prevent the error from occuring? Need advice...still somewhat new at Access.
  11. smsmail

    Run-time Error 2004 (not enough memory) on OpenForm command

    Hello, I am getting run-time error 2004: "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again" The form is a tab control form containing 12 subforms. I suspect that the possible problem exist in a subform that I last made modifications to...
  12. smsmail

    Opening a Foxpro DBF file from Access

    Hi Dhookom, I am not familiar with the External Data functionality. Will this allow me to programmatically get a dbf file within Access. I have a form that displays in a text box, a path name of of a file. The user can view that data by clicking a "view data" button. If the file is a .XLS...
  13. smsmail

    Opening a Foxpro DBF file from Access

    Hello All, Can I open an Foxpro DBF file from Access? If so, can you please supply an example of the code. Thanking you in advance!
  14. smsmail

    How do I adjust the Width and Height of Tab Control Page

    Thank you Missinglinq and PWise. I have 10 subforms in the tab control. I adjusted the size of the subforms of each page. Also in the Resize_Event of the form, I used the DoCmd.MoveSize to adjust the form. Thanks so much for you help! I really do appreciate your expertise. I am still...
  15. smsmail

    How do I adjust the Width and Height of Tab Control Page

    Hello, This probably is simple, but I cannot figure it out. How do I adjust the width and height of the main (i.e.parent) tab control page. When opening the program, the tab control page opens partially and all the tabs are not displayed. Thanks so much for your help!
  16. smsmail

    Tab control: How do I navigate from to a subform to another subform

    Hello, I have a tab control, the first page of the tab control is a menu, all other pages of the tab control are bound subforms. From within a tab/subform, I want to be able to navigate to another tab/subform of a tab control in the onclick event of a button on the subform. I have tried...
  17. smsmail

    How do I reference a control on a subform in a tab control? Get error

    Dhookom, You are right. I had some code in an event, that caused the controls to be blank. Thanks again for your help! More questions may follow.
  18. smsmail

    How do I reference a control on a subform in a tab control? Get error

    Hi dhookom, I am referencing the control from within the subform itself. I was able to get it to work using: rs1.Open "select * from client where clientname = """ & Me!ClientName & """;" Another question, when I navigate to another page/subform in the tab control and go back to the...
  19. smsmail

    How do I reference a control on a subform in a tab control? Get error

    Hi AceMan1 I tried your suggestion rs1.Open "select * from client where clientname = """ & [Client].Form!ClientName & """;" and got a runtime error '2465': Jobtrack can't find the field '|' referred to in your expresssion. I then tried, and it worked: rs1.Open "select * from client where...
  20. smsmail

    How do I reference a control on a subform in a tab control? Get error

    Hello all, I am trying to reference a control on a subform that is in a tab control. Below are the hierarchy of controls. The parent form is unbound, it is just a menu to the other pages in the tab control. Parent form - Production Page - Page2 Subform - Client Control - ClientName How would...

Part and Inventory Search

Back
Top