Recent content by bobjames

Your gonna have to tell what DB you gonna open the report in. In other words what DB has this report in it. And I'm not sure if you can use Access specific constants like acPreview from VB. You may have to pass the actual value of the constant.

No there is no such function in Access/VBA. But you could go in to the .MDW file that is being used with the App and use a query to return all the Groups a user belongs to. I suppose you could write a fuction that does this for the current user.

Do you want to do this through Notes or Access/VBA? If your doing this through Notes then why don't you create a field on the Documents that your importing that you can use as an flag. Then create an scheduled agent in Notes that deletes those documents that have that flag set. Then run your...

just use the Shell command to issue your dos copy statement.

The hidden property doesn't take away access to the object. You would have to use security to take away permissions not allow user access. If you wanted to you could secure tables and the create queries that your reports could be based on but these queries could inherit the owner's permissions...

How would users be able to create reports if the they didn't have access to the tables or queries? I don't think they can.

I think you need to split your database. Have all the code, query, forms & reports in one database(your code DB) and all your tables in another your (data DB). Then Attach/Link all the tables in your Data DB to your Code DB. Now when you create your runtime Access database it will be based on...

the column number refers to the column of fields with in the recordsource of the combo box itself. For example if the combo box's recordsource was a table called "Table1" and Table1 had 3 fields the Combo1.column(0) would be the 1st field in the table and Combo1.column(1) would be the 2nd field...

Try inserting this code before you set your object varibles to Nothing: Dim x As Integer For x = 0 To rst.Fields.Count - 1 objSht.Cells(1, x + 1) = rst(x).Name Next x I'd appreciate it if you would let know if this code works for you. Bob

What's the problem with Adobe? I really think PDF is the way to go for distributing reports online and I don't think it's that hard. Plus they look great. How are you exporting to word anyway? are you exporting to a Text file? Have you tried RTF (Rich Text Format)? In my experience it's hard to...

Emma I have a solution for you if you still want it 1. Step up a report base on your table Box/Object table. 2. In the Report create a grouping on the Box field, with group footer set to yes. 3. View the code of the report and type: Dim BoxContents As String 4. Go back to the detail...

Do you want to show a detail section for ALL dates within the range selected? And for those dates where you do have data and the correct bolean value, display it but for dates where there is no matching data and the incorrect bolean, display the message? If that's the case then you may want...

You need the same fields in your SELECT that are in your group by. In your SELECT you should include "(Year([Dates])*12 + Month([Dates])-1)AS Expr1 " and Get rid of "[dates]". Of course, these result will not show [Dates], but I'm not sure if that's important. [This message has been edited by...

the code is up there. it starts with the Dim statement

1. The input mask on the Date/time field would be ”09:00:00;0;_” 2 Then if you wanted to display the sum, then the format “hh\.nn\.ss” would be used. Of course this will only make sense if the total is always less than 24hrs. 3.The totals for a given month is gonna be a little harder. You’ll...