Search results

Quite puzzling... There are 6 separate occurrences of the line of code that generates error #5. In all cases, the error is handled and execution is resumed. If I remove the error handler and instead duplicate that code in each of those 6 locations, I get an error about a key value already...

Actually, I didn't write this piece of code. It was written by a previous employee. The code works with a collection, something I have no experience working with, so I don't know how to fix the error 5 problem. This is what the error handler is doing: CDJJobCount_Error: If Err.Number =...

Thanks for your replies... The problem is that I need the error handler to process and handle error number 5 and then resume running. If I break on all errors or disable the error handling, it never gets to the error that I'm trying to fix. So there is no way to do this.... If Err.Number=5...

Hey guys, I have a piece of VBA code that handles certain errors and then resumes execution. Lately it is giving me an error and because of the error handling routine, I can't rely on the standard access error dialog with the debug button to direct me to the source of the error. Step...

Actually I did already toy around with the page margins and that didn't change the position of the text boxes. I used stretch for the picture size mode property in order to fill the page because the image is larger than the report. When I reduced the size of the image (pixels) to 100 dpi and...

I designed a report that auto-fills fields in a tax form. For the background picture of the report I'm using a scanned image of the form which works fine. The problem is that any text boxes I place on the report are out of alignment with the picture when I preview the report. The image below...

Many of the text fields within this database are varchar type. It was probably the upsizing wizard that is responsible for the ntext data type because the DB originally did not have a SQL server back end. I did not originally install or design the DB. I will definitely reference this if I run...

This is an MDB... I think it's SQL Sever 2000 because it was installed in late 2001. The data type of this field is 'ntext'. I gave up trying to figure it out and ended up completely deleting the record. Then I re-entered the information from scratch and now it doesn't give me any more...

I know this topic has been covered in a number of threads but what is happening here is very strange. I have an Access 2000 front end with a SQL Server back end and there is a problem with just one field in only one record that is triggering a write conflict. I can go into Enterprise Manager...

I have a custom toolbar button that points to a public function. Is it possible to find the name of the current open report (the one with the focus when the button is clicked) from this function? Thanks

Just make sure you step down to the next row when adding criteria for an additional field (the one labeled Or:) That way it will return the query results if field 1 matches criteria 1 OR field 2 matches criteria 2. If you put them on the same row, both criteria would have to be met for the...

Yes, just use the above-mentioned query as the record source for your pre-made form and then open the form when the search button is clicked.

I thought there was an Autocorrect option somewhere but I had been looking for it in the Tools>Options dialog....I found it in the right place now......problem fixed! I do have Name Autocorrect turned off as well....had problems with that before.... Thanks for your help.

Is there a way to prevent Access from "auto-correcting" certain characters? Example: If I enter "DEJA VU" into a table Access changes it to "DÉJÀ VU" with the strange É and À characters. I don't want this to happen. There must be a way around it. Thanks for your help.

You can use nested IIf expressions to convert the military time settings into the 3 categories: IIf([MyTimeField]>2259 Or [MyTimeField]<700, "NIGHT", IIf([MyTimeField]>659 And [MyTimeField]<1400, "AM", IIf([MyTimeField]>1399 And [MyTimeField]<2300, "PM", ""))) Or you can create 3 separate...

You're missing a reference to the CustID field in the WHERE clause... Select CustID From Cust Where CustID Not In (SELECT CustID FROM CustOrder WHERE OrderDate > DateAdd("m", -3, Date())) Also, you are referencing 2 table names: Select CustID From Cust Where CustID Not In (SELECT CustID FROM...

You'll want to create a query to use as the record source for your report. For the criteria under the customer name: Not In (SELECT CustomerName FROM MyTable WHERE OrderDate > DateAdd("m", -3, Date())) (Of course, change the field and table names to match your database) What this is doing is...

I do have the Access Developers Handbook Enterprise Edition so I will check that out. Had no idea about the .mdw file. Thanks.

I am using DoCmd.TransferDatabase to transfer 2 tables from one database to another. This works fine, however, the user permissions for those tables do not carry over with the table and I have to go into the database and set them as they were in the original database. Simply, I want to allow...

Repaint did the trick. Thanks!