Search results for query: *

Thanks for the advice JerryKlmns. [thumbsup2]I'll work on the implemention this weekend and see how it goes. Appreciate it!

My trouble with leaving the admin connection is that there are several levels of users that will be using these forms and not all have admin rights. To your second response, I am the admin, but I need to check it programmatically so as to create the dummy user with the same rights. Sorry if...

JerryKlmns, Thanks for the speedy response and info. I was able to use my own cridentials but then everyone would have admin rights. So, I was thinking about trying to build a dummy user but I'm not sure how to get the current users rights or group. Is there a function to extract that...

Hi All, I'm coding with ADO and have run into a problem. Does anyone anyone know of a way to connect to a backend database using the frontend databases currently open security connection? I can connect fine using my Admin user id and password but I was hoping to use the currently logged in...

Thanks PH!! That got me moving in the right direction. I was able to bind the recordset to the form using the info in the article. The section "Opening a Separate ADO Connection" was particularly useful since my database is split. I'm still struggling with the datasheet view though. If I open...

I'm new to ADO and having trouble getting my recordset to populate a form in datasheet mode. Does anyone have any suggestions? Thanks!

Hey All, I'm trying to connect to a mdb file that has user level security using ADO. I've found a lot on how to connect to SQL Server but can seem to find anything on mdb files. My database doesn't have a shared-level security password only user-level security. Any help would be greatly...

Thanks M8KWR your code really helped me! I looked all over for a simple explination of how to programmatically manipulate the tab control and couldn't find any. I had 2 tab controls that I wanted to setup to interact with each other. I modified your code and placed it within a select case...

Hmmm? I found the oncurrent event and placed the code in it. However, I'm still having the same problem. I use the refresh command on my main form to cause a field "ScheduleNewHours" to set it's date value with the default property with the value of the "CurrentDate" field from my calendar...

Thanks for responding KenReay. I don't see an oncurrent event in either the hours field or the subform properties window. Do you know, is that an event available in Access 2000? Thanks Dan G [ponder]

I've spent 4 days trying to find a work around this problem. I have 2 subforms and 1 main form. In one subform I have a calendar control and a text field named "CurrentDate". In the other subform I have a query with three fields to display a persons scheduled vacation days by date, hours and...

Thanks Edski that got me going in the right direction. The MouseHook.dll just needs to be in the same folder as the database. Thanks for your help!

Would I have to install the .dll file on every users computer or just mine?

Help! When my form is open, if the mouse scroller is moved it changes my current record to the next in the set. I had the same problem with the tab key but was able to fix it by setting the cycle property to Current Record. Is there a way to stop the form from moving to the next record when the...

There is another possibility. Create a new table and call it something like documents. Then create 3 fields in the table: AutoNumber, ClientKey and Documents. AutoNumber = AutoNumber ClientKey = Related key in Client table Documents = A field with a Data Type of OLE Object Once the table is...

I built an access data page which displays a pivot table. It worked fine for the first 3 months of the year. After working fine for that time something happened and now the page will only display data through 7/8/03. If I run the source query seperate form the ADP it runs fine and returns all...

Wow!! This is an incredible tip! I have been working on a form that has multiple subforms and queries and the fastest I could get it to run was 1 min 15 sec. This tip increase the performance to 9 sec. You are the man jgoodman! Thanks for the help! :o)