Search results

Thanks. Well, the thing is it won't allow the user to enter Print Setup at all...so I wouldn't want to just handle that error, I'd like to fix it so the user can use the print window as normal. So if I understand this correctly, to trap that error and see what precisely it is I should modify...

Thanks, Simon...that was exactly what I was trying to do for #1 :)

Hello, I searched this forum and Google looking for a way to do this, but everyone's situation I found was unique enough for it not to work for me. I have forms that will need to be printed by the user at times. I have used VBA code behind a "Print" button on the form. Here is my code...

Right, like I said it doesn't apply them, just apparently saves them. Well ok if I run into any problems with this (hopefully not!) I'll post it on this thread. Thanks!

Thanks, I have tried: Private Sub Form_Load() Me.Filter = "" Me.FilterOn = False Me.OrderBy = "" Me.OrderByOn = False End Sub However it still saves the last Filter and Order By under those respective categories in the Property Sheet (although it doesn't apply them). Does this have...

Hi, Users of my database have requested a version of the main table that can be viewed, filtered, and sorted A to Z just like the real table, but an uneditable version. I've created this via a subform, datasheet view, with Allow Edits, Allow Deletions, and Allow Additions set to "No," Allow...

I'm revisiting this issue as I had a million other things to do in between...okay, so 1st thank you SO much for your help, esp. namliam, whom I apparently can't leave any more reputation for until I "spread some more around"... Here's the deal. I need the query to treat combo boxes where...

Thank you!

Because, as I said, I don't understand what you meant by "against an in-line subquery." I wasn't second-guessing whether or not it would work; I didn't fully understand it. I was also in the process of saving the grouping query I thought of over lunch when I received the notification that...

Wow...that's really technical. What do you mean "against an in-line subquery?" I was thinking about this over lunch and was going to try just basing the crosstab query off of another query that groups all of those categories (Dept_Name, Phase, Status, Description). I think it would count...

Hi! I have a crosstab query that does the following: Dept_Name (Row Heading) -> Group By Phase (Row Heading) -> Group By Status (Column Heading) -> Group By Description (Value) -> Count What it's doing is counting every description under the Phase and Dept I've specified, etc. But I want...

Perfect! Thank you so much!!

Will that do the same thing? If so, that would work perfectly! I've never used nz before. As for the missing If parenthesis, I actually just typed that in, I didn't copy it from the code as I had it put in since I have since wiped it out since I couldn't get it to work yesterday. I'm...

Hi! I have the following VBA code that records an audit trail (it looks long but a quick scroll through will give you the gist of it: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs =...

Hmm. So I won't be able to get into my own code? I don't like the sound of that! Well, I do keep a constant backup of the database for just in case situations...also there are a variety of people that may access the database from time to time but only in sense of viewing reports. As far as...

I followed the instructions here and split the database per your suggestion. I also went in and made the tables hidden and the database window not appear on Startup. However, if the user goes and figures out how to redisplay the hidden parts, tables that are now supposed to be "back-end" still...

There is a main table that users are not supposed to go into at all - there are forms for that purpose - and yet someone keeps going in there. Obviously I am afraid of the worst. There is a huge amount of data that could be lost if this person hits a wrong key, somehow causes an irreperable...

Not sure how to change this thread to solved? but I've finally fixed this. Thank you so much jzwp22 (and others) for your suggestions. Because there aren't any fields that will never change (except primary key/index RecordID), I ended up doing the following: -Changed the tblDatabaseChanges...

There are other fields in the tables besides these, but this should paint an easier picture as well: tblEquipmentDatabase contains: RecordID Item_Qty Unit_Cost Ext_Cost Manufacturer Model ECR_No Last_Edited_by Reason_for_Change tblDatabaseChanges contains: DateofChange RecordID Item_Qty_Old...

Do you think I could incorporate it somehow into tblDatabaseChanges? What would be the best way to either do that or create a new table for it and still incorporate all that's been done already? I'm assuming an update query would be involved... In short, it's currently like this...