Search results

Using Access 2000, I have a form with a simple multi select list box. The user selects items from the box and clicks a command button, which runs code based on the selection in the list box. These entries may change as a result of the command, so the list box refreshes and updates, but the...

I have a report that previews and prints perfectly, with several levels of grouping. However, when I export the report in .rtf format, the top most level of grouping is excluded totally. This top level was added to the report at a later date, not at initial creation, if that makes a difference...

Our database can send a variety of emails containing Excel attachments by clicking on the relevant form buttons. This was working fine under Access 2000. However, since installing Service Release 1, Service Pack 3 and the Outlook SP3 fix, whenever the button is clicked a pop up box with a timer...

Our office database runs via a main form and table with about 100,000 records. It was unsecured and not split, so each user was opening the actual database file from their PC across the network. The computer it is hosted on has been in place for a year. All was fine and pretty smooth, access...

Have set up database security fully and properly. What I need to do now is stop users from closing forms and editing data directly from the underlying tables. They must only be able to edit data via forms. I have set permissions for the users so that they cannot view forms in design view. I...

Taken over a database from a colleague who has since left. The main table has several Yes/No fields, and the data contained within them is in the raw form 0 or -1, not the default check box appearance. Perhaps this was because the table was created originally from a source such as Excel...

Strange one this. Apparantly random records of several Text or Memo fields in my database (of about 60,000 records) are being seen by Access as having data in them when there isnt any at all. It came to light when trying to append this and other data to a table. Although the text fields in the...

I have a form linked to a table containing stock information. When someone changes the stock amount, i want what stock item it was, when (time and date) it was changed and what it was changed to stored in another table. I got the following code to do this on an after update set MyRecords =...

I have a database with some 30,000 records in, each with a date in ranging from 01/01/2000 to today. The field is called EnrDate and it is of Short Date format. I need to update the day of each record's EnrDate to 01 whilst keeping the month and year. How can i do this in an update query or...

I have a table with 108 fields. For a given record, data will be in some fields but not all. The fields with data in changes for each record. I need to update the records so that instead of a null value there is a 0. I cannot use the default value = 0 property of the table as the data is...

I have a table containing month fields from Jan01 to Dec09 (thats 108 fields btw). The data within these fields is a monetary amount, if it matters. There is only ever 6 records in this table. What I need to do is make a report based on the table that reads ACROSS, not down. I cannot do this at...

Is it possible via VBA to remotely open a database on another computer? For example, doing maintenance on a networked (but not split) database, when complete instead of telling users that its now accessable again, automatically opening the database on other computers on the network.

We have several buttons on a form that emails data via the SendObject command, through Outlook 2000. We recently updated Outlook with the Email Security Update and now get the error "2293". Microsoft say that this is to prevent malicious code from distributing attachments. How can I overcome...

I have produced a function in a database that relies on the time of a computer on a network. However, it is checking the code against the PC's time, and as all are not synchronised it is activating at varous times of each PC. The network is based on Windows 98 machines, and all the time sync...

Ive set up a timer on a form that needs to display a message box if ANY records are present in a table. Normally the table is empty, but if one record is present i need the message box to appear. How would I do this? Treat me as a bit of a novice please.