Search results

I just copied the code from Allen's website into an A2010 accdb. I had no trouble compiling the code. Check that you did copy the complete set of functions/ subs that Allen gave for the relationship diagram. Are you using this code in an accdb format database? If you still get the debug...

Here are the gotchas for that method. Notes: In Access 2007 and later, this utility does not draw the tables correctly if they contain complex data types (attachments or multi-value fields.) Access 2007 cannot show the relationships for an ACCDB that contains tables with calculated fields, and...

If you have the email address in the record source of the form, try like this: Private Sub email_PDF_Click() Dim strAddress As String strAddress = Me.[EmailAddressTextboxName] DoCmd.SendObject acSendReport, "rpt_print_out", acFormatPDF, strAddress End Sub

I would scrap the OpenArgs and use a where clause to open the report. Build the where clause something like this on the form where the user chooses the engagement, location and provider: Dim strWhere As String strWhere = "EngagementID = " & Me.EngagementID strWhere = strWhere & " AND...

Reports don't need (and often don't like) a complicated query like the ones you posted. Use the reports Grouping and Sorting button to set up the totals instead of doing it in the query. You can probably also take the IIf statements out of the query and put them in calculated controls -...

Copy and paste exactly the code you used for the button to email the report as a pdf.

Do you have a query as the record source for the report? Are you trying to set the report's record source using code? Post the query here for us to look at - open the query in design view, highlight the sql and copy and paste it here. We will need to see the tables used in the query, their...

If I understand your question, you want to change some values in the table/s that the query uses. To do this, use an update query.

Check out this link to see if it does what you want. http://www.allenbrowne.com/AppRelReport.html

DoCmd.OpenReport "rptResults", acViewPreview, , , acDialog, strPRC = "Me.cbo1ID|Me.cbo2ID|Me.cbo3ID" as you originally had in the open event. Then you would use the code already posted Private Sub Report_Open(Cancel As Integer) Dim varSplitString as Variant varSplitString =...

Here is a link that shows how to print the record that is currently on the screen. http://www.allenbrowne.com/casu-15.html Using A2007, there is a built-in button on the print ribbon that allows to create a .pdf. To create a button that emails a pdf of the report is a bit more work. Here is...

In design view, make the textbox just wide enough to fit on your screen. Put a vertical scroll bar on the textbox and make the textbox higher that just one line in height. Make the entire form narrower so that you can see the complete width of the form on your monitor.

In general terms, yes, it can be done. You would link to the txt file/s create the union query and search it the same way you would search a local or linked mdb/accdb table. Whether it will work for this case depends a lot on the txt files. You say that you need to record the account number...

You can put a msgbox (msgbox because you are trying to debug the runtime) in the SubExit or FunctionExit for the code that does the relinking. Once you see that msgbox you know that the relinking code has finished. Put a msgbox for the first line (after the routine's name) of the very next code...

My work was done by moving the database so that the backend was in a different folder from the front end. I found that the tables relinked fine, but then the error about 'invalid object reference' appeared as soon as the database was required to use info from a linked table. As Bob suggests...

Build a continuous form with the account number and the region as columns in the form. Put a dropdown for the region. On each row of the form the user can choose the correct region for each account. If you are new to forms, this may not be easy or straight forward. Post back with your...

You can write code to pop the Explorer window where the user can select the path. Save the user's chosen path in a variable then pass it to transfer spreadsheet. Here is a link to a sample showing how to save a file to a specific directory...

I don't see the code for the function called fRefreshLinks in the code you posted above. You should be able to find that function on the same website where you got the code that calls fRefreshLinks. I don't use that code. I use the JStreetRelinker. You can get it here if you want...

There are many people running access on Win 7 64 bit, as I am. I'm not aware of any thing in particular in a change from 32 to 64 bit that would cause this error. If you create a new database and import all into the new database does that fix it?

With the bug, the relinking to tables in the backend does its stuff without any problems. Straight after correctly relinking, the bug appears. So I suggest On your startup form call the code that does the relinking. The very next thing needed is to call the code to reset the query defs. Now I...