Search results for query: *

Is there a way to un-mute and max the speaker volume from within Access? My user gets an alarm if he does not do some thing (task) every 15 minutes. Tom

Access 2000. I have several forms that have started acting wierd. When a user opens up particular forms all they see is a sliver which they cannot be resized. The forms in question are set to Auto Resize = No, Auto Center = Yes, PopUp = Yes, Modal = No, Border Style = Thin, Width = 7.5 (which...

On my Switchboard form the timer event cycles through random pictures every 5 seconds. Every time a new picture cycles, a vbCancel message box briefly appears that says: Importing C\Documents and Settings\...\ \...jpg Is there any way to keep this annoying message box from appearing? Tom

How do I refer to a control in code. I found a close answer in FAQ's but it doesn't get me there. I have multiple and specific labels I want to set a specific line height to in code. The following snippet does not work. Private Sub LineHt(ctlLabeL As Label) ctlLabeL.LineSpacing = 100 End Sub...

I work in a government environment that does not allow ActiveX files on the computers. What specifically does MSDATGRD.ocx contribute to Access. Can I run a lean database with forms and queries without having MSDATGRD.ocx. I already have the database up and running. I’m trying to figure out...

I have two tables (one-to-many relationship) and various queries that pull from these and other tables. I have an “Add Record” form that solicits basic info to create a new record. When the user clicks “OK” that triggers some DoCmd.RunSQL stuff that inserts a record in the first table and...

With Access 2000 (SP-3) why do I get a compile error that stops on, “rs.findfirst” with the “.findfirst” part highlighted. The error message is, “Compile error: Method or data member not found” Tom MCSD I Nab Terrorists

How would I change startup options via code. I don’t want to go to every computer to navigate through “TOOLS > OPTIONS… > Edit/Find to uncheck the three boxes in Confirm: Record changes; Document deletions; Action queries. I would also like to change the “Default database folder:” to C:\ via...

I have created 2 custom menus for my db. One menu activates and top-docks when a form is opened (MenuForm). The other menu activates and top-docks when a report is previewed (MenuPrint). I am having a problem with my File>Print function. When I click File>Print the whole report immediately...

How do I code my report to print in landscape mode? My users open the db on various computers and the report, regrettably, defaults to portrait mode. Many of the users are confused and do not know to click File:PageSetup:PaperSize:Landscape. I researched this question on this forum and found...

Can I use a Select Query as the control source for a text box? If so what is the syntax? I tried: =(Select blah, blah, blah;) This does not work. Currently I am using Dlookup as the control source but I assume a Select Query would be faster. The report generates about 4200 of the Dlookup...

Access 2000 I have a list of dates and data on my subform. I want to visually delineate the end of one week with the beginning of the next week. It would be nice to have the background shading alternate from week to week but I have decided that is probably not possible. What I’ve settled...

Is there a trick to get my Crosstab query to read a text box from a form. I am trying to limit the date range to a calendar month in my Crosstab query. It works fine if I hard code the dates but I am striving for dynamic. The following is a date field: Criteria...

I want to format my time to display in MILITARY TIME! That's not asking a lot. I want 8:02 AM to display as "0802". I want 10:15 PM to display as "2215". I will even accept the insertion of the colon, if I must. When I tried "Short Time" I am offered an example of "17:34" but the resulting...

Can I build a query that pulls fields from multiple records? My database schedules employees, or groups of employees, work days and off days. A simplified version of the structure of a record is: [Date](PK), [OnDuty](Yes/No), [Group](FK) I want my form to look like this. An "X" represents...

I am designing a database to assign employees to the various work positions each day. Two tables, tblPosition and tblDate are joined by the tblPositionDate table. The tblPositionDate table has a compound primary key consisting of “date” and “position”. What is the best way to auto-populate...

These folks at work have two "databases" on Microsoft Excel. I am converting this mess over to Access. The smaller database is ~100 names. Last, first, and middle name were all in one Excel "field". I got all that mess parsed into seperate fields but the issue I want to fix now is...

How do I handle nonexistent records with DLookUp? I want to verify that someone is an authorized user before the database opens. My code is: Private Sub Authenticator() If (DlookUp(“[Administrator]”, “[tblUsers]”, “[UserID] = “ & “fOSUserName()”)) = (-1) then Open a form Exit Sub End If...

Is it possible to have a dot leader on a report such as is available in Microsoft Word. I want each line to format like this: John Jones......................770.123.4567 Fred Fredricks..................404.321.7654 Sam Smith.......................678.765.4321 For reasons I won't go into it...

I want my autoexec macro to write the user name and date to a table whenever the database is opened. I fine-tuned the code with a click event: Private Sub User_Click() ...irrelevant code txtUser = fOSUserName txtDate = Now() ...irrelevant code End Sub The click event works great but I want to...