Search results

Does anyone know why the following code would crash Microsoft Access? In order to rule out issues with the databases themselves (the calling database adn the database being opened via code), I created two new databases both containing a single module and a single function. The code below is...

Has anyone had any luck with this? I'm trying to do something similar, creating a dialog form that is used to provide criteria for forms and reports that can be created by my users. Once the report/query is ran, the form closes, but the query/report then loses focus and they are instead...

It's been so long that I'm not sure I remember exactly what the problem was. If I remember correctly, the error was not in my logic but just a general error in the code. Everything is working correctly now. I requery subB on the onCurrent event of subA. The following is an excerpt of code...

I finally figured it all out and I was overcomplicating things. I just needed to create two levels of grouping (even though the groups are the same). The last "page" of the group would be the footer section of the top level of grouping/sorter. The second level then has a header that repeats...

Than k you for your response, but I'm afraid my explanation of the issue must have been a bit vague. The report does currently show the header for each company, but I need it to display on multiple pages for each company but not all pages. For instance, if a company has 4 pages dedicated to...

I want to apologize for taking so long to respond to this thread. I did not realize that alerts were being sent to an old e-mail address that is no longer valid. I did want to let you know that I was able to fix this problem and the filtering is now working correctly. Thanks for your...

Reports have never been my strong suit, so I would really appreciate any advise on how to approach this issue. I need to print one report that actually consists of several reports that belong to separate companies meeting a specific criteria. The general format is that it shows company info...

I have what I hope is an interesting problem. I have an unbound form that houses two subforms, which are linked to each other. The first (we'll call SubA) is a continuous form, showing the set of data that my users need quick access to. The second (SubB) is a single form, which shows details...

I cannot access the second link, but the part that is really confusing me is that when I run the code from the first link, everything appears to run fine but no shortcut actually appears on the desktop. Any thoughts?

Learning how to properly create queries and/or write SQL statements is really what you need. Access has many built in tools for handling filtering, and a custom function should not be necessary except in very specific instances. I have written code that changes the source of a listbox (by...

I have created a form generator for my MS Access application that quickly allows users to create and use form e-mails, letters, and faxes. However, I need to add a hyperlink into the body of my e-mail messages and have not been able to figure out how to do this through VBA. Any help or...

Thanks for all your help. Unfortunately, even after downloading an updated copy of the cdo.dll and registering as described in the readme file, I still get an error at the following line: Set objMessage = CreateObject("CDO.Message") The error is number 429, "ActiveX component can't create...

Two questions regarding your code (this is actually something I've been looking for). First, I couldn't get it to work. I found and referenced cdo.dll, but it stops at Set objMessage = CreateObject("CDO.Message") and indicates ActiveX component can't create object. I found the following...

Unfortunately, I don't know the answer to your problem. However, I was wondering if you could help me out. I am attempting to switch our default e-mail client to Thunderbird and to send a message with attachments, I seems like I will need to figure out how to implement MAPI. I was looking for...

I want to thank both of you for your responses. ghudson, I had tried about a month ago to split this database into a fe/be; but I was met with an significant slowdown in performance and some new errors that I had not dealt with prior to the split. I ended up pulling it back together, which...

Sorry, I had wrote the code backwards, so that it would only run when the field was empty. You need to put the keyword Not before the isnull function: If Not isnull(txtboxName) Then 'Post your code here End If Assuming your code does what you want it to, you can put your code in the...

If you posted more of your code showing what you are trying to do, it would probably make it easier to assist you. I'm not familiar with GetRows, but I do know that RecordCount is not accurate until you move to the last record (rst.MoveLast). I would guess that GetRows accomplishes the same...

It's sounding like you have two tables with a one to one relationship (meaning for each record in one table you can only have one corresponding record in the other table that has the same ID). If this is the case, you should be able to create a query that joins the two tables together on the ID...

I have dabbled in object oriented programming in the past but not much. My database is getting quite complicated, so I thought I would begin to implement it to keep things from getting too cumbersome when future changes are necessary. I have created a Vendor object, which when initialized...

It's kind of hard to tell from the information you posted, but I would think a simple if statement would fix your problem: If isnull(txtBoxName) Then 'Post your code here End If The effect should be that when you exit the text box and have typed nothing in the field, nothing will happen...