Recent content by billcam

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...