Search results for query: *

Every time I try to print out a list of my user and group accounts from the security menu, I get the error message "The search key was not found in any record". It has been this way for a while and everything else has seemed to work. But I just created a new workgroup and a new...

Every time i try to print out a list of my user and group accounts from the security menu, I get the error message "The search key was not found in any record". It has been this way for a while and everything else has seemed to work. But I just created a new workgroup and a new...

I am trying to establish a read only link into an oracle table and pass the user name and password through so the user never sees it. I have a system DNS set up for this but it has no place to set a password. I am down to using a query when the db opens and it works except for the fact that it...

I want to eliminate the Access logon using the Win2000 logon by putting it in my shortcut command line. I can get the username but can't figure out how to get it into the command line. It seems like most of the posts here deal with setting up your own security tables and not using Access built...

I am trying to link to an Oracle table with a memo field from Access 2000. When I insert the field in my form, I get an error message that a unicode text field must contain an even number of bytes. I am not permitted to make any changes to the Oracle table. Anyone know the cause of this and...

Is there any way to slant form labels like there is in Excel?

I get this message anytime I try to print out users and groups on my secure db. I tried replacing my system file with a backup copy but it did not work. Then I tried importing my db into a new db but it did not work either. Can anybody tell me how to fix this error? Is it in the system db or...

If nobody knows this, then is there a way I can copy many fields from one table into a new table with just one field so I can run a report grouping on that field?

I have a table with 36 fields that may contain a value from a 20 item code list or be null. I need a report that tells how many times each code appears in all fields on a monthly basis. Any ideas on how I should go about this?

I finally got it to work by using now() in the onload event and changing my date format to general instead of short date. I don't understand why date won't work except that it wont keep the () after date and it will after now like it does not recognize date as a keyword.

It still does not do anything. Here is the code for the on load event of the form. It defaults to the date on the first record. Option Compare Database Private Sub ActiveXCtl128_Click() [Date] = [ActiveXCtl128].[Value] End Sub Private Sub ActiveXCtl128_Updated(Code As Integer) End Sub...

My calendar works fine except for defaulting to today's date. I have tried the recommendations from this board but still am having trouble. If I set the control source to current date, it defaults fine but cannot be changed. I have tried using the onload and on open events for the form and...

I get this error when trying to import tables and forms. Both db's were created under the same workgroup. I am afraid I am going to have to wipe out my workgroup and start over since I get the same error when I try to print out a list of users and groups. If anyone has a fix for this, it would...

I currently have 3 shortcuts to 3 different secured databases. The shortcuts contain the command line parameters: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\my documents\database files\database front end\production1.mdb" /Wrkgrp "c:\my...

I would like to create a front end that users could link to to several databases or Excel spreadsheets, etc. I am currently using shortcuts that specify the workgroup for secure db's. I tried to make a Word document but the hyperlinks don't seem to want to accept the parameters to specify the...

How do I calculate the difference between the same date field from record to record. I have an employee job classification table and want to know how long they were in each position using the current record date as the start date and the next record date as the end date.

I have an employee training database set up with one main form for employee name, number, etc. I have subforms in it that contain training and pay raise info. It worked fine for a while, then all of a sudden the data entered in two of the subforms would disappear when the form was closed or...

I am using conditional formatting to make fields change color according their value. Sometimes it works and sometimes it doesn't. I currently have a date field that I want to turn red if it is 6 months old. In the conditional formatting box, I set it to datefield-less than or equal...

Nope, no extra brackets.

I made a form with the combo box that looks up the date field and it will list the dates in the table. I put the combo box name [Forms]![datechoice]![datechoice] in place of the parameter in the query but all it does is show the name of the combo box as the prompt in the parameter.