Search results

I often output reports as a PDF. I also use SendObject to send emails from my application. But is there a way to send a PDF as an attachment with SendObject? Perhaps not, as the PDF would not be within my application? Robert

The database I am working with suddenly says that is ready only, and I cannot make changes! How can I make it not read only? Robert

On my development application, I am getting the error message 'The visual basic for applications project in the database is corrupt'. The main switchboard does not display correctly, and Compact and Repair Database will not run. This is a split data front/back end system and I have run...

Thank you. I didn't know about that! Robert

Thank you, that is most helpful. However, the 'Use Windows themed controls on forms' is checked, and on the button itself, 'Use Themes' is checked. But I still have plain rectangular buttons. Is there anywhere else that I can check? Robert

When I add a button to a form, I used to get buttons with nice rounded corners. Now I get buttons that are just plain rectangles. What has happened? Is there somewhere that I can change the format of the buttons? Robert

OK, mystery solved. I made a new query and it worked fine. I have seen that before. A query does not work and I can't solve it. I make a new query exactly the same and it works! Robert

Thank you. That is very strange. When I use "*" or '*' I get all the records. When I add a single quote outside the asterisk I get no records. Robert

Yes, I am sure that the entry is accepted. I am using a test form with just two controls, and always tab to the second control before running the query. The query returns nothing. I have Googled this and all the examples I see use a pair of double quotes "*", and not a single quote as well...

Thanks. I tried that and it didn't work. It returned nothing. So put a single quote before the first asterisk and after the second asterisk? I can't get that to work. Am I missing something? Robert

I am trying to get a wildcard search to work with a form. I have a query, in which the criteria is: Like "*" & [Enter a word] & "*" That works fine. I enter a word, and I get the few records in which the word appears. But if I try to replace [Enter a word] with a word entered on a control on...

How do I design a query to return a result in a wildcard format? So that I could enter a part of a name, and it returns all the names that include that part of name? Robert

When I send an email from Access with SendObject, how does it determine the user name, the 'from' name. Is it just the user's Outlook name? Do I have any control over that? Robert

I have a link to a table in an SQL database. When I run a query to append records to that SQL table, it runs very slowly. What would take a few seconds to update an Access accdb takes 20 minutes to run! Is there anything I can do to correct this? Robert

I have an email program that sends several emails, each one requiring a query. But the query is visible as the email is sent, and has to be closed manually. Is there a way to run the query without it being visible? I am using OpenQuery. Alternatively, is there a way to close an open query to...

I did try that. Didn't work. I think the problem is with the totals subform. When the subform was displayed (showing the wrong totals), I manually ran the query that drives that subform, and it showed the correct totals! So I think I need to requery the totals subform when the tab is...

Which form should I requery? The one that writes the records or the one that calculates the totals? I assume the one that calculates the totals. I did try that, but where do I put the requery? On Open? It almost seems as though all the tabs are queried at the start, and not when you open an...

I have a form with a tabbed area, each tab containing a subform. One of these subforms adds records to a table. Another subform shows the totals from that table. But when I add records, the totals tab is not updated with the new quantities unless I close the form completely and go back in. I...

I have a main form with several tabs. One of the tabs is a subform with just one number control, driven by a select query. The control shows a number, and you can type in a new number, which then updates the field in the table. BUT, the control then shows a zero, it has moved to a blank...

I have a query with three sub queries, all returning a number from different tables. But when any one of the sub queries returns a blank, the entire main query is blank. How do I stop this from happening? I have tried NZ() on the sub queries and on the main query, but the blank still...