Search results for query: *

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

...Number to the top of the datasheet, followed by jobs that are listed after. The Datasheet form Record Source property is a sql statement: SELECT * FROM dbo_view_invoicejobslist ORDER BY dbo_view_invoicejobslist.jobnumber DESC , dbo_view_invoicejobslist.drop; The user do not want to...

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

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?

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

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

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

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

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

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

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

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

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!

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

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!

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

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.

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

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

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