Search results for query: *

I have searched the posts and have not found an answer to my particular problem. I have several subforms on a form. For performance reasons I would like to have one unbound subform control that I can change the source of with the click of a button (well, really several buttons). I don't want...

We have a paging program that sends pages to certain people via email. When the page is sent (via Outlook) Outlook's pesky "A program is trying to access....." comes up. Is there a way to configure Outlook to allow just the paging program around that check? Sending the email directly from...

I am working on a membership database for a Rod and Gun Club that records member information, along with their interests. I have the following relevant tables: Members MemberID (PK) Name...... InterestCategories InterestCatID (PK) InterestCatDesc Interests InterestID (PK) InterestCatID (FK)...

Using Outlook 2003, Windows XP - User is looking to automatically accept all meeting requests. We are not using shared calendars and the requests are not coming from a resource manager. Is it possible, is so, how?

I have a DB that tracks OT worked by each employee during the FY. Just 2 tables (tblOverTime (OT_ID, WorkDate, WorkEmployee, WorkHours) and tblEmployeeData (EmployeeID, Name, Rank, Seniority, Phone)). This is used to decide who gets called for the next available OT shift. On July 1st of each...

I have an unbound (with all unbound controls) startup form. On that form I would like a label's caption equal a field from a query. I tried setting the label.caption property but I can't seem to make it work. Then I tried to use a text box on the form and point it to the query field, but I...

I have searched the forums and tried various solutions posted. I am having a problem getting earliest date in my table. The field is called LastAssigned and is formatted as a General Date (since I may have more than one entry on each date). I have tried using SELECT MIN(LastAssigned) FROM...

I am using Word 2003, SP3. I have a dropdown list in a document that I want to control the text in a field later in the document. I inserted an IF field from the Document Automation list and set the parameters. My problem is that I want the IF field to update as soon as the change is made to...

In Access 2000 I have an app. that sends an email (report in .rtf) when certain criteria are met in a new record. If the user doesn't have Outlook (our only email client) open it, as it should, opens the email with all the appropriate information. However, once the email is sent it doesn't...

I am trying to use the code, however it produces the following error: The command or action 'Zoom100%' isn't available now. Anyone have an idea on what it means or how to make it work. I checked MS KB w/no results...... ---- Access 2002 on a mixed Windows OS network.

I have a field (control) for hours worked and need to be able to limit it to 1/4, 1/2 and 3/4 hour increments. For example 8.0, 8.25 (for 15 minutes, which some users can't figure out and still put .15), 8.5 or 8.75 are accepted, but 8.15 is not.....I thought about an If statement but 7.25, 7.5...

Is there a way to limit the number of records that will show in a list box? The data source of my list box will show many more records, but I want to limit it to the 5 or 10 most recent entries.

I am trying to build a function that will return the "ordinal value" of the day in the fiscal year. I have that part ok, but I don't want to have to change the dates every year. I have tried formatting a date in VBA excluding the year, but have no luck. If I don't specify a year in the date...

I am trying to toggle some controls on a form from visible = True to Visible = False when a use clicks a button. The routine checks to see if the control is currently visible, if so, makes it invisible, and vice versa with the others. I tried to use a For Each loop, but when it gets to the...

Is it possible to pass a variable to DCount? =DCount("[CountMe]", "data source", "[Critera] = variable")

I have a report I want to print just page 1 of. I tried using the DoCmd.PrintOut command, but haven't figured out where to put it. I want the user to still be able to hit the print button that is on the tool bar by default, but then have it print just page 1. Thanks in advance for any help...

This DB that I have inherited has several Yes/No fields in one table. Each record has some information then 5 or so Yes/No. RecNo recDate Chk1 Chk2 Chk3...... 1 1/1/01 Yes No No 2 1/1/01 No Yes Yes 3 1/2/01 Yes No Yes I need to write...

I have 2 fields (Last_Name and First_Name). I need to create a field that will have the initials. I think I need to use RTRIM but I don't know how to tell it to get just first letter of each field. On line help hasn't been very. Thanks in advance for your help. ---- Access 2002 on a mixed...

I have to build a machine inspection database. Right now I have: Table 1: Machine_Info MachineID(PK) SerialNo Make Model Type Location Table 2: Components CompID(PK) Machine_Make (looked up from Machine_Info) Machince_Model (looked up from Machine_Info) Comp_Group Comp_Item Table 3...

I have to build a machine inspection database. Right now I have: Table 1: Machine_Info MachineID(PK) SerialNo Make Model Type Location Table 2: Components: CompID(PK) Machine_Make (looked up from Machine_Info) Machince_Model (looked up from Machine_Info) Comp_Group Comp_Item Table 3...