Search results for query: *

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

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

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

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

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!

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

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

Hello, Thanks in advance for your help! My application contain a number of forms that overlap. I am not crazy about the look. I want a tabbed interface so multiple forms can be opened at once. I would like each form to have a separate tab so users can easily see the available forms and...

Hello, I do not understand why I am getting the run-time error "2450", when the form is open. The code the is bold is getting the error. Your expert advise is truly appreciated: If CurrentProject.AllForms("frmclientmailschedule").IsLoaded Then If...

When trying to access my database(code, forms, functions, etc). I received the following message of which I mistakenly clicked the "OK" button. My code is removed. Is there anyway I can recover my code. Message: The database cannot be opened because the VBA project contained in it cannot be...

Hello, I am trying to alter the size of a form. In the Load event I have the following code, but nothing happens, the form opens to it usual size: DoCmd.MoveSize , , 1440 * 8, 1440 * 6 Am I missing something. Could there be a property set, that disables the movesize method. Please note...

Hello, I have a query that when executed in the access form gets run-time error 3075. But the same query works on the back end SQL Server database when tested. Please see sql statement: What am I missing? select clientname, mailschedule.jobnumber, mailername...

Hello Thanks in advance for your help. When trying to access the sql server database thru SSMS, I am getting the following message "The database SMSProductionSQL is not accessible. (ObjectExplorer)". Yet, I am able to INSERT/UPDATE/DELETE the database using an ACCESS frontend application. I...

Hello What is the best way to import EXCEL data into an existing table in SQL Server? Thanks in advance for your help!

Hi I am trying to import an access table to sql server 2008 express database using the import wizard. I am getting the error: DB_SEC_E_AUTH_FAILED(0x80040E4D). Any suggestions on where to look first. I suspect it is a permissions issue. Thanks for you guidance in advance.

Hello I uncorrectly exported an access table using Access Upsizing Wizard to the System Database/Master database in SQLServer 2008 Express. I deleted the table. Now when try to use the Upsizing Wizard I am getting error "ODBC - Call Failed". Because of incorrectly exporting a table, what...

Hello I am getting a runtime error on the highlighted (bold) code. I have been looking at it too long..any idea of what I am doing wrong? Thanks in advance for your help! Private Sub Colors_AfterUpdate() If Me.Colors = "Yes" Then Dim strOtherValue As String strOtherValue...

Hello, I have just installed SQL Server 2008 Express. I will be upsizing from ACCESS 2007. I want to use the Access Upsizing Wizard to upsize to SQL Server 2008, however I cannot connect to it thru Access. What did I miss, when I installed SQL Server 2008? Thank you for your help!