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

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?

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

Is there an easy way to use a combo box with a parameter so the user does not have to type in the parameter? I would like to run a report using a date field for the parameter and would like to give the user a list of dates to pick from.

I have my database on a server now, split it, removed the admin user from admins group,removed user permissions, changed the db owner to myself by importing to a new db,have all accounts and permissions set, and a shortcut to include the new system.mdw. I have done everything (I think)but...

I created a database, imported it to change ownership, split it and secured it. It is on a network server running win 2000. I created a new workgroup and stored the system.mdw on the server also. I created a shortcut to use the new system.mdw. So far, everything works fine until I log on as...