Search results for query: *

Why is the following code skipping this section... If strPasswd = "" Or strPasswd = Empty Then MsgBox "No password entered.", vbInformation, "Password Required" Exit Sub End If When I run it if you leave txtPassword blank you receive the "Sorry, you do not have access to the...

Hi: From Access I'm opening a Word document with the following code. I want it to be Read Only without any message boxes, password boxes, etc. for the user. Just open as Read Only. Can this be done? Thanks, xeb Private Sub Command1_Click() Dim LWordDoc As String Dim oApp As Object 'Path...

I keep getting Data Type Conversion Error 3421 on the following. Debug stops on !TimeInI = Me.TimeInI.Value. Also, I don't get the error when I open the database and save the first record. It happens only when I try to save the second record. Set db = CurrentDb Set rst =...

Is there a way to lock a record after it's been accessed once so it can't be again?

Hi: I searched for an answer to this but I can't find anything. I have a query that prompts the user to enter their status number (0, 1, 2, 3, or 4). If their status is anything other than "4" they are not allowed to continue. If they do anyway (which is how it is set-up now) it won't do them...

Hi: I'm building a MS Access database for an easter egg hunt. The kids will find codes in their eggs which they will then input into the program. After they enter their code in the "Enter Paramater Value" box I now have it so it goes to a form saying they won which works fine. I wanted to use a...

Hi: I have the following two queries: SELECT Sum(IIf(Month(shDates.SchoolDays)=9,1,0)) AS September FROM shDates; SELECT First(month(shDates.SchoolDays)) As Month, Count(shDates.SchoolDays) As SchoolDays FROM shDates GROUP BY month(shdates.SchoolDays); How do I combine one of them with my...

Hi: I have a problem with a form that is running code. When the user clicks "Append Data" the data is posted okay but the date in the form is highlighted in black so my users aren't sure if the data was posted which is causng them to click "Append Data" again. What I want is for the data to...

Hi: I have the following query: SELECT Avg(D.tdValue) AS Average1, "" as Average2, "" as Average3, "" as Average4 FROM tsMain AS M INNER JOIN tsData AS D ON M.tsTsID = D.tdTSID WHERE D.tdCol In (21,22,23,24,25) and Weekday(M.tsDate) = 2 UNION SELECT "" AS Average1, Avg(D.tdValue) AS Average2...

Hi: I've been usng Access 2000 a lot on several different computers since last fall and the background color of the application has always been gray. Yesterday, Tech Support installed a new computer for us and the background color is a light blue. This is causing some of my images to have...

Hi: I have a report that is already based on two queries that needs to display about 25 values (times of the day, activities, etc.) from a table different from the ones tied into the queries. "DLookup" works great, but I was wondering if using 25 instances of it in one report is too many...

Hi: I have a report that contains a subreport. I want the subreport results to look like the rest of my report and not like query results. Is there a way to remove the column headings in the light brown shaded area and the grid in the subreport results? Thanks, xeb

Hi: I have the following query for getting averaged records by the week. SELECT [Week], WeekTotal, WeekRecords, WeekTotal/WeekRecords AS WeekAvg FROM (SELECT format([Date], "ww") AS [Week]...

I just finished eight hours of work on my database and I've got a problem. I have a report based on a table with a date field and quite a few other fields. The report produces averages on all the records in the table just fine. In order to allow my users to select a date or date range for the...

How do I have a report return calculated results for each week of the year? In other words, my table contains many records with many fields and I want the report to produce averaged results for designated fields for each week of the year. I think it's an "IIf Statement" but I'm not...

On a report, I just want to show the value (the number it contains) of a field in my table for a specific date. The expression I'm using is "=([field])" which works okay. Is that the expression to use to simply show what's in a field? Thanks

How do I put a button on a switchboard that will prompt the user for the date of the desired report and then have the report print? I've been trying to get this to work for two weeks, but I haven't been able to. I've searched "help" over and over for the answer but I can't seem to...

Is there a pocket PC that can run my Access database so I can enter data in the field and download it later? I've looked around but I can't find any. Thanks

In a report I need to display the oldest and newest dates. In other words, my table contains 45 records with dates between 9/1/03 and 10/15/03 and I need the report to display 9/1/03 and 10/15/03 and the oldest and newest dates. I've searched everywhere but I can't find the right expression...

In Access 2000, in a report, I need to calculate the average for each day of the week. In other words, I need the average of all "Monday" records, all "Tuesday" records, etc. What would the expression be?