Search results

Opening a table is not recommended, instead build a form based on that table (create a query on the table and use the query as the record source for the form) and open the form instead. Forms offer many possibilities to allow editing of data that tables lack.

In a report, you set the word wrap in a different way. Choose the textboxes in the report and set their Can Grow and Can Shrink properties to suit.

You can create a form based on the Inspection table and set its Allow Additions to True. Put a button back on the form with tabs with code like this: ----------- start code DoCmd.OpenForm “InspectionFormName”, , , , , acDialog When user clicks the close button on the Inspection form, your code...

Re: Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007 I don't know of any quick way to fix this. I suggest that you make a copy of the form and the subforms for testing. Try testing with only one subform at a time in the main form - see if you can get it working...

I can't see anything obviously wrong, so suggest you trouble shoot it like this: Create a new report but change the ship to address to just one field - Companies.CompanyName - and get it working with just one field. Then add one more field and get it working with just those 2 fields. Continue...

The code for the email pdf button was missing from the code behind the form. I copied and pasted the code from the previous version (version 1). Here it is.

The button on the subform will have code like this: DoCmd.OpenForm "Clients", , , "ClientID = " & Me.ClientID

I have a report where I want to change which subform is visible. I use the report load event to do this. Here is my code Code start------------------ Private Sub Report_Load() If Me.IsMarketingInvoice = True Then Me.rsubOrchard.Visible = False Me.rsubMarketing.Visible = True...

See if this is acceptable. Attached database.

I will need some more information before I can do that. - What is the name of the primary key field in the subform where user will do the double click. Is it a long integer or a text field? - What is the name of the primary key field in the form that user will open by doing the double click...

I have a similar report with 2 subreports. One of the subreports is hidden by code when the report opens in print preview - depending on a value in the form that opens the report. I just tested printing and the report prints correctly with the correct and visible subreport each time. This is...

Do you have some textboxes on the report that have fields from the query as their control source? Post the code you have on the click event of the button that opens the report.

A hyperlink is not the best thing to use here. Usually we would use either a button ( can be at the far left or far right of each row of the subform), or we would use the double click event of the text boxes in the subform. You could also use just a single button in the header of the subform...

Here is the amended code Private Sub email_PDF_Click() On Error GoTo Err_Handler Dim strSubject As String strSubject = Me.[Patient's Name] DoCmd.SendObject acSendReport, "rpt_print_out", acFormatPDF, , , , strSubject Exit_Handler: Exit Sub Err_Handler: Select Case Err.Number Case 2501...

Private Sub email_PDF_Click() On Error GoTo Err_Handler Dim strSubject As String strSubject = Me.[TextboxName] DoCmd.SendObject acSendReport, "rpt_print_out", acFormatPDF, , , , "strSubject" Exit_Handler: Exit Sub Err_Handler: Select Case Err.Number Case 2501 'cancelled, ignore...

The code I suggested is made to pick up the primary key relationships between tables as you see when you open the relationships window in access. It will not show the temporary relationships created in queries. I'm sorry this has been such a frustrating exercise - as we have found - what I...

The code skips over any tables that are not in a relationship with any other tables. I looked at your screenshot and I am not surprised that those tables were skipped. They are not the usual tables we include in relationships. Do you have any tables in the database that are related to other...

Try this. Make a copy of your database. Working on the copy, delete the linked excels and text files. Do a compact and repair. Do a compile. Run the relshp code. If still getting the debug error, try the code in a brand new database. In the brand new database, import just the access tables...

I can't reproduce the error you are getting. It all works fine for me. When you get the debug error, that means that the code is not compiling (just for the record <smile>). To find what references are set, in the code module, select Tools | References. The references set will show at the top...

Try this: Private Sub email_PDF_Click() Dim strContent As String strContent = Me.[TextboxName] DoCmd.SendObject acSendReport, "rpt_print_out", acFormatPDF, , , , , strContent End Sub