Search results

I also tried another approach, but I can't get it to work either. Code: -------------------------------------------------------------------------------- Private Sub btnAdminCalendar_Click() Dim strForm As String, strSQL As String Dim strFilter As String, strWhere As String strForm =...

I have command button on one form that opens a second form that I want information to be filtered by UserID. I've tried several ways to use filters, but I can't seem to get them to work. Below is my latest attempt to link the forms with a filter. The information displayed on the second form...

I made a function to insert a record from one table into another table. Sometimes some of the fields are blank; so I included the Nz() function to deal with null fields. After eliminating the null errors with the Nz() statements, the function no longer inserts the record from one table to the...

... linking to Outlook() slows down my program significantly.

Actually I need more than the names from the Outlook() Global Address List (GAL). I also use several levels of the company's organization to insert into the records. The GAL also has the user id's that I use for the audit tracking table. I get the impression that the GAL is different from the...

I tried to use the Access Help to figure out the import command, but I need help to get it to work. Code: -------------------------------------------------------------------------------- DoCmd.TransferText acImportDelim, , "Global Address List", "Outlook()", -1...

I see your screen capture, but does mummy have an example to post that doesn't have reams of code like Dev Ashish's and works just like his does? Has anyone told Dev yet? Does mummy's code handle reports? I tried your commands: Docmd.SelectObject acTable, , True Docmd.RunCommand...

I could be the terminology that I used in my original question. Instead of stating it as Hide/Show DbWindow, I should have stated it as Hide/Show Access Window. The function that I used hides the Access Window. The routine that trucktime suggested will hide the DbWindow and not the Access...

Rather than manually draw vertical lines on my forms, I'm looking for a way to generate vertical lines using VBA code. Has anyone done this? Thanks, pc

Reports from form designs looks a little strange when in form view, because Page Header and Page Footer don't appear until I printout a hardcopy. I can still get page numbering in the Page Footer. I found out that I can print out the correct number of pages using the DoCmd.PrintOut...

Thanks guys for the suggestions. I'll test those out. Since the forms work so well when hiding the application window, my first impression was to start making "reports" with forms instead of reports. Is that confusing? It was starting to work fairly well, except the "reports' from form...

I've been trying to utilize the API module to Manipulate the Access Window as provided by Dev Ashish from the MVPS website http://www.mvps.org/access/api/api0019.htm. I've been able to work with forms successfully, but when I try to generate reports the program looses control. Does anyone have...

Thank you for your suggestion; however the record source for listbox and the subform are different from the record source for the mainform; so the Master/Child links are not compatable. I need to make a link between the listbox and the subform, not between the mainform and the subform.

That's a good point. Maybe I should link them by the [ProgramID] field?

I have a form "frmMAINEntry" with a tabcontrol with several pages. The form's Record Source is a query "qryMainData"; however, on two of the pages there's a difference. On the page "Program List" I have a listbox that has a Row Source to table "tsubProgramList" and on the page "Program Details"...

Here's a code that I use in my application. I changed my source and destination paths to yours. I have a command button on my form that calls the function on the "On Click" event using "=BackUpAccess()". Module Code: ====================================== Option Compare Database Public...

Below are links to two sample databases that I think might meet your request. One is JMail that has a dll file that needs to be registered on your system and the other db appears to work directly with winsock. The third link is to a db with modules only for mapi email. It has nothing else...

I have this code from a db of a previous version of access to archive a database, but I'm using A2K and it doesn't seem to work. It creates archival copies of all objects in the current database into a new database. This procedure uses the DAO CreateDatabase method to create a new empty...

I have a database audit form module that takes a few seconds to search through a linked table and then insert the information into the main db table. I've seen a lot of newsgroup discussions on progress bars and I have a few examples, but they either use a timer or counting records. I'll...

That's a good point. Thanks for mentioning it. Sounds like you mean that the userID and FullName be linked through a relationship in a query. When I need to make a printed report of activities in the database, I can use a report based on that query. Do I understand you correctly? PC