Recent content by chaufschild

I am running the following code on a form in an Office XP database in Office 2000 file format: Private Sub AccountManager_AfterUpdate() Dim strDLR As String Dim strSQL As String Dim strAcct As String Dim strDate As Date strDate = Format(Date, mm - DD - yyyy) strAcct...

I guess I am not sure of what you mean by direct inserts. If you would post that code that would be great. Chris

Do you mean if you click on an item in a listbox it will open a form with that record displayed? Chris Haufschild chaufschild@hotmail.com

I am running the following code on an Office XP database in Office 2000 file format: Private Sub AccountManager_AfterUpdate() Dim strDLR As String Dim strSQL As String Dim strAcct As String Dim strDate As String strDate = Format(Date, mm - DD - yyyy) strAcct =...

Thank you very much for your help. For clarification I am trying to make a report that other IT personnel will be able to run without editing permissions. I need this report to list all objects in the database and which users have what kind of access to each object.

I am trying to make a report on security (meaning who has access to what). In other words, I need to know what groups are associated to each user and what those groups have access to what forms, reports, etc. The first one I can get through the security menu, but the other is more difficult...

I am trying to make a report on security (meaning who has access to what). In other words, I need to know what groups are associated to each user and what those groups have access to what forms, reports, etc. The first one I can get through the security menu, but the other is more difficult...

I am currently trying to write code that will cause a report to be sent via email. I need the code to use linking criteria or filtering like in the OpenReport method but I don't know how to accomplish this using SendObject. Any help would be greatly apprecaited. Chris Haufschild...

I am currently trying to write code that will cause a report to be sent via email. I need the code to use linking criteria or filtering like in the OpenReport method but I don't know how to accomplish this using SendObject. Any help would be greatly apprecaited. Chris Haufschild

I need to send a report via email with criteria or a filter and am having trouble doing so. I don't think there is any way to do either (link criteria or applying a filter like in OpenReport) using the SendObject command. Any help would be greatly apprecaited. Chris Haufschild...

Thank you very much for your reply -- I am using forms bound to a query which uses multiple tables as its source. I find the behavior puzzling too -- could it be an issue with network packet loss or the Citrix Metraframe server instead of Access?

I think the best thing to do in your case would be to set up queries for each type of totalling that you need to do all with the same key field (reqest number). After this, make a base query that uses the totaling queries as inputs along with the tables...the totals will appear more than once...

I am currenty running an Access 2000 database under a multiuser environment via Citrix Metaframe and am experiencing odd behavior with a couple of my forms. During the data entry process in these forms the primary key value will change. This problem seems to come up randomly but it is a severe...

Sorry about that -- after reviewing it it looks like the hours equation should be this: int( int (s/60) / 60) That should work better...

It might not be the most simple way to do it but my first thought is that you could set up the query to make each part of the date separately...like the following (s being your field with the seconds): Seconds : (s/60 - int(s/60)) * 60 Minutes : (int(s/60)/60 - int(s/60/60)) * 60 Hours ...