Search results

Thank you. Simple.

In my query I compute the wait time for each customer ([TimeIn]-[TimeOut]), using the Short Time format. Works fine. In my report, in the Details footer, I computer the average wait time Avg([waittime]). Works fine. In my Report footer, I want the average waittime for the report period...

window meaning form (sorry)

This seems easy but I cannot figure it out. I have a window (Popup No; Modal No) maximized. I simply want to write a line in the On Open event to restore down to window size. I tried to maximize then restore ... no luck (I don't want the application. Any help would be appreciated.

Print preview options are locked (cannot print). However, if I minimize the report, then maximize the report, the print preview options are unlocked. Any ideas on how to fix my problem?

I'm still having problems. The print preview options are locked (cannot print). However, if I minimize the report, then maximize the report, the print preview options are unlocked. Any ideas on how to fix my problem?

Table 1: Contains two fields: (1) Abbreviated name of a unit; (2) Long name of a unit Table 2: Contains a field with the long name of the unit How do I change the long name field in Table 2 to reflect the abbreviated unit name? Is this logical? Connect the tables (ID) then create a query?

I can't unlock the toolbar. I reworked the code as suggested but it's not working. Any help please. Should be a way to turn on/turn off. Option Compare Database '''' ' Start Code ' '''' Private Declare Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long Dim dwReturn As Long...

I'm trying to get a form to open at a certain size initially. When using DoCmd.RunCommand acCmdSizeToFitForm I'm getting the error that "size to fit" isn't available right now. What could be causing this error?

I'm using the Hide The Access Window module ... http://www.tek-tips.com/faqs.cfm?fid=2562 I love the look and feel of the windows. I simply cannot print my reports. The print toolbar (print, pdf, etc.) is locked. I added the mcrRestore to each report but nothing I seem to do unlocks the...

I have a hidden form that's opened when the user opens the database and remains open. It was created so I can log off users in the event I need to work on the backend. No problem ... works fine. I can open the form from the design mode and log off users but I want to be able open the form...

I have a simple form. In the form I have a field =Count([LName]) which is used to count the number of people in the record source (query). I also change the format for the field to General Number. This works fine. The problem I'm having is using a timer event. I cannot recall the result in...

I have a small alert form. I have the following procedure on timer (750). How can I get the count NOT to blink when the count is zero. The blink occurs regardless of the count (blinks when the requery is run). Thanks DoCmd.Requery If Me.CountQueue >= 1 Then With Me.Label241...

Thanks. The guidance is clear, easy to follow and works great!

I'm not sure how to ask this question but I'll try. When I open Access, I only want to show one form 5"x5." I know how to set the size of the form but Access fills the screen and the form is shown inside a blank area. I can maximize the form then resize the Access application but this isn't...

Thanks but the criteria is still not being solicited from the user. Any other ideas?

I want to send an e-mail to a select group of people. I narrow the group based on a query. When the query is run, the user is asked to provide a counselor’s name (criteria in the query [Provide Counselor’s Name]). That works fine. However, when I add the query to a recordset, the criteria...

Thank you ... but still getting a syntax error =DLookup("[OfficialEmail]", "tblAlphaRoster", "Supervisor = '" & me.SupvrName & "'")

I have a name of a supervisor on my form. I want to use DLookup to retrieve the supervisor's email from another table. I tried ... =DLookup("[OfficialEmail]", "tblAlphaRoster", "Supervisor = SupvrName") I want to Look up [OfficialEmail] from tblAlphaRoster in which a field from...

I have a training event form. I have a subform listing the attendees of the training event. The table of attendees has an Inactive field (Y/N), to identify current or past employees. When I add a new event, I want the subform to list only current employees but it lists ALL employees in the...