Search results

I was hoping somebody could explain how bitwise comparisons work? The following subroutine (written by somebody else!) sets up a shortcut menu. I'm ok with all of this, except the comparison - i.e. (showoption And 1) I do not understand how this could return the true/false value needed to set...

I have several reports which are e-mailed, in snapshot format, to various people on a weekly basis. I am having problems with one of the reports not being displayed correctly when the recipient opens it in the snapshot viewer. The report in question is landscape but always opens in portrait...

I have a database which when compacted produced the MSysCompactError table. This is supposed to hold the table and record id of the records causing the error, but all it held was the table name - MSysObjects. I spent some time going through the table, and eventually found the error. There is...

I have a large FE/BE set up, and part of the FE is a post register. There are two subforms, one for entering post, the other for viewing outstanding post. A user was in this part of the database, although not active (i.e. using other applications). The following error message suddenly...

"Cannot find the file '\\......' (or one of its components). Make sure the path and filename are correct and that all required libraries are available." Some of our users are intermittently (sp?) getting the above error message. The database is there and is fine (other users can see it no...

I want to include some fairly basic formatting (bold and underlined text) within an e-mail. Having searched through various posts here, it seems I have to use the .HTMLBody property. The problem with this it that you have to have some idea of HTML (which I don't!). If somebody could give me a...

Mile-O, Saw your response to one of ColinEssex' posts, and your comments regarding an error trapping subroutine to write all of the details to a table. I'm fine to create the code to do it, but was wondering how you dealt with subroutines and functions that are called from many places. i.e...

Is this possible? I'm using the code from rogers access library that allows you to automatically kick users out of a DB. It works on the on_timer event, and in my case opens a form telling them to get out (which closes after 30 seconds), and then exits them after 3 minutes. This works fine...

I used some code to run through all the Table Defs and print the name in the debug window. Included in the list were the hidden system tables (i.e. MSysAccessObjects), but when I go to options and make them visible, there is one from the list that does not appear: MSysCompactError I am having...

I have a database performing various tidy up/admin routines, which is scheduled and run very early in the morning (6am). I wanted it to fire off an e-mail to a few people to confirm when the routines had successfully run, but ran into problems with Outlook opening up a security message ("A...

I have a list of transactions processed on insurance policies, and am running an aggregate query to find the total amount on a policy for each client/underwriter. Each transaction has a created_by field, identifying who deals with it. I can obviously get the aggregate query to give me the min...

I have a tab control which has many pages, most of which have subforms on. I have removed the tabs and control the page-change by using command buttons on the first page. The source objects of the subforms are set and requeried as part of a Select Case statement within the on_change event of...