Search results

There are no warnings about missing references and I've checked the list manually. If it were a missing dll, I would imagine that we would see other errors - but this is just focused on the one procedure. My own web searches have turned up a number of similar sounding incidents -- but no...

Thanks, did your googling suggest that there were any work arounds? Is it worth upgrading the db file version? Good catch on the extra space -- I was hopeful for a minute -- but the procedure itself does not have that space. I'm really stumped. I've checked two other machines running Access...

Hi - I have a form used to enter criteria for display of records on a subform. There is a refresh procedure that is used to update the subform. This procedure is called on load as well as after changing any of the criteria. This has worked fine on multiple computers running both Access 02...

Feel free, Jeff.

Hi - I'm trying to set the recordsource of a subform from VBA. In Access 2002, I used syntax like this - Me.frmsubSubname.Form.RecordSource = strSQL This worked fine. However, in 2003 I now get an error - "2455: You entered an expression that has an invalid reference to the property...

Sorry for the delay - 1. Unfortunately, I don't have a way to save this as a 97 db. 2. As for usage instructions, it would depend a lot on what you want to do. Best suggestion is to post a new thread in the Forms section, referring to this example. - g

Sorry for the delay - 1. Adding btnSearch_Click to the end of the btnClear procedure is certainly a reasonable step. There was no particular reason why I did not include this. 2. The version is 2002 (10.0) 3. To send the results to a report, call the report and use the same WHERE filter...

Neil has a good point - if you can set up a combo box with the most commonly used titles, then you can offer the user a painless way to select something meaningful. You can trap the Not in List event and do additional work to try to validate the title. -g

Hi - My first guess is that you have some sort of syntax error or need parentheses somewhere in your WHERE statement. I always find in very helpful to break queries apart and test each piece and then combine once I know that the individual parts work. A slightly different approach might work...

Hi - Just a few thoughts. 1. Try creating one basic subform and putting a copy on each tab. Use the same Record Source for each but use different filters for each tab to display the dates. Haven't tried it to see if this would work, but seems like it offers some good flexibility and ease of...

Hi - Update queries by their nature change records. If you just what to calculate a value, you can use a calculated expression in an regular (Select) query. If you subtract two time variables, the result is the difference between the two time, but the result is in days. So you would need to...

Hi - Welcome! Do you need to restrict the choices of data in a drop down combo box? Or do you need to actually go modify a second table? For the first, searching the web for "cascading combo boxes". This is usually used when one combo box affects the choices in another combo box. But you...

Hi Kamala - Welcome! Sounds like this could get complicated in a hurry. I have some knowledge but am no expert so I may not be able to help. On the other hand, I may know enough to get you into trouble - so please take care and do plenty of backups before modifing any part of your database...

Here is a link that I found very helpful in designing an import routine: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=377419&Main=377419 hth, -g

It looks like you are just assigning the value of Comments to an internal variable in the procedure. You should be assigning the value to a field on the form that is bound to the table. E.g. Me.txtComments = Forms![Payroll History]![Comments].Column(0). Also, use MsgBox to display the value...

Step 1 - Make a backup!! Yes, I would think that an update query would work. I would first try to do a practice query to see if you can successfully convert the part numbers. E.g. make a query with OldPartNumber and a NewPartNumber field and verify that they all convert as you expect. If the...

Hi Ben - Not exactly sure what is going on but a few things to check 1. Looks like the name of the field in the Album table is actually "Album Title" not "Album Name". Make sure you are using the right version on the form. 2. Are you enforcing any referential integrity between the tables...

Now I remember... This is possible by generating a rank for each record. E.g. Table1 ------- ItemID, AutoNumber, PK DateField, Date Then the query is SELECT tbl1.ItemID, tbl1.DateField, (Select Count(*) from Table1 Where [Date] < [tbl1].[DateField]+1; ) AS Rank FROM Table1 AS tbl1 ORDER BY...

Hi - Not quite sure what you mean by "this" Monday, but... This will give you the Monday before Date1 Date1 - (7 + DatePart("w", Date1) - vbMonday) Mod 7 And this will give you the next Monday after (unless the day is a Monday) Date1 + (7 + vbMonday - DatePart("w", Date1 ))...

Hi - Not quite sure what aspect of this is generating your question. My basic approach would be to write a loop to read each of the key words and check to see if the keywords are in the title. You can use the InStr function to check for the presence of one string within another (Quote from...