Search results for query: *

Just thought this might be a good place to post methods of how to bulletproof your database and keep users from doing unintentional (or intentional) things to it. One is to go into Tools>Startup and turn off "Display Database Window." Users should never see the database window or use...

When I tried to install an Office 2003 upgrade I got an internal machine error, Error 2755. The only references to this error were associated with networks, and they did not apply. The cause of the problem: I was a beta tester. When I installed the beta, I was given the option of installing...

I use an option group with a Print button and a Preview button to allow the user to select the different reports and whether they want to print it or just preview it. The code looks like this: Private Sub cmdPreview_Click() On Error GoTo ErrorPreview Select Case [fraPrint] Case Is = 1...

After we upgraded to Access XP, the users began getting errors anytime they updated a date field with existing data in it. It would say that the information wasn't valid for the field. This affected both database that I converted to XP and ones I left as 2000--but all used in XP. What was...

I have a database that corrupts nearly every day. I routinely go in and run Compact and Repair--sometimes this works, but I usually have to export the back end into a new database to fix. What it does: It does a whole bunch of strange things. It doesn't add records--they simply vanish. When...

I recently found several articles on htaccess files, which allow you to customize an error page (like for 404 errors). However, I also checked my web site host and found something that none of the articles mentioned ... If you're using FrontPage, modifying the htaccess files can corrupt your...

I am really new to SQL Server and am still trying to figure out how to do what is probably really, really basic stuff to meet a deadline. How do I set up a stored procedure to insert new records into two related tables (the tables are tblCategories and tblIssues, with a one (tblCategories) to...

I used this code on a combo box in an Access 2000 database (using 2002): Private Sub cboSelectAction_AfterUpdate() Dim rst As Recordset Set rst = Me.RecordsetClone rst.FindFirst "lngTaskID=" & cboSelectAction If Not rst.NoMatch Then Me.Bookmark = rst.Bookmark...

I have a keyword search in my database that uses a query to trigger a paramenter box. This is what's in the field: Like "*" & [Enter Keyword to Search For] & "*" It then opens a form that displays all the records that meet the keyword. Unfortunately, if the user types in...

This has been a recurrent problem I have never been able to resolve. I have an index in one of my tables that corrupts intermittedly. When it corrupts, it does any of the following: * Doesn't enter a record in at all * Adds new records on a linked subform (the subform goes to a table with the...

I have a report which will report on information for the last three months, counting the total number of records for that month and one that counts the total number overdue for that month. If I use DCount to count the overdue records, I have to run it off the query, which works fine, except it...

I have Microsoft Security set up on my database, using groups and permissions. I trapped the error that pops up if you click on a button to a report or form that you don't have permission to access: If Err = 2603 Then MsgBox "You do not have access to this department's...

We're working on a Web site in Front Page. In the shared border, we have a menu applet/image. On some computers--all are newer computers--when the user goes to the new page, the applet blanks. We are also in the process of converting to Windows 2000. Any thoughts on what's causing this...

For my report, I need to display statistics from the last three months. The report needs to count the number of suspenses for the each month, calculate the suspenses that were overdue for that month, and display percentage overdue. There are seven departments, and I have to do one of these...

I've been trying to do a DCount which counts the records that are greater than 0, but I keep getting a #Error. This is what I've been using: =DCount(&quot;Days Elapsed&quot;,&quot;TestReport&quot;,&quot; [Days Elapsed]<#&quot; & &quot;0&quot;) Can anyone help? This thing has been driving me...

I'm trying to select records based on the last thirty days from today's date versus the date the record was closed, but I keep getting an Error 3075 Syntax Error. This is the expression: DCount(&quot;dateClosed&quot;,&quot;qselClosedTrends&quot;,&quot;[dateClosedJ62]<#&quot; & Date()-30) I'm...

I am trying to use DCount to count the number of records checked in a checkbox field. This is what I've been using: DCount(&quot;boolFieldName&quot;,&quot;tblName&quot;,&quot;boolFieldName=True&quot;) I also tried Yes, instead of true, but both show that there are zero records. What am I...

I have a report where I calculate the percentage of items that are overdue versus the total number of items. However, when there isn't anything overdue, Access leaves the space blank. Is there a way for it to list the 0%? Linda Adams Visit my web site for writing and Microsoft Word tips...

I have an email link on a form so that the user can email the control office with any questions about a specific record. I know that in web sites you can add text for the Subject line into the email link. Can this be done for the email link, using a field from the form, like for instance, a...

I've been working on a report and a subreport that has some calculations in it. Subreport displays the records and calculates the total number. Main report takes that total, counts the overdue records and divides it to get a percentage. My user wanted to be able to pick a date criteria, so I...