Replies

Thanks for the help. This is supposed to just prompt the user for the Project Name so they don’t forget to input it, and then use it for the new page. It’s not to be stored anywhere else. I pasted your code into a new page, but I if I try to go into Design view I get “The editor is unable to switch to Design view because there is unquoted ASP script in a attribute value or inside a tag.

When I switch to Quick View it looks like ” method=”post”>Enter the Project Name [an input box] [a submit button] Technical Documentation [a clear value button]. If I press one of the buttons it goes to the “The Page Cannot Be Found” screen.

I appreciate your help — I think that the best way to figure this out is to keep stumbling around in it. I am having fun doing it.

Thanks,

Randy

Thanks for all of the help!

John, thanks for the reply. When I try rst!(“Record Number”) it focuses on rst! and gives me a compile error: Type-declaration character does not match declared data type. When I try rst!([Record Number]) it focuses on [Record Number] and I get a compile error: External name not defined. I do have the Microsoft DAO 3.6 Object Library referenced.

Function GetTheRecords()
Dim db As DAO.database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset(“Exceptions”)
MsgBox rst!(“Record Number”)
End Function

I’m doing this to try to salvage records from a corrupt table with about 44,000 records. Usually I can identify the corrupt record(s) by appending chunks of records and seeing where it crashes. In this case, although I can see the data in the records, I can’t append any records – not even one without the “Invalid Argument” error.

Thanks,

Randy

I tried to access just one record that I was able to tab through and the message still comes up. This is the worse corrupt record that I’ve encountered. Any other thoughts will be very welcomed.

Thanks,

Randy

Thanks guys… I like that – pictures and all!

Randy

Francois,

Thank you very much for this valuable information.

Randy

Another good reason to assign meaningful names to your controls

Thanks for all of the replies. It looks like I shouldn’t need to create any dummy table, just add the extra fields to the queries and create a union query on them. I appreciate all of the help.

Randy

Hans –

I sure spent a lot of time going around in circles with this. I took your advice and used
With [subSearchResults].Form
.Filter = stLinkCriteria
.FilterOn = True
End With

and it now works fine.

Thank you very much for your help with this. Maybe now my hair can start to grow back.

Randy

Thanks Hans – now I want to display the name of the control in a MsbBox. How would I access the name? Also, what would be a good source to learn all of the properties that I can access and use? For instance, I don’t see TypeOf anywhere in Help.

Thanks again!

Thanks Charlotte, but there is no subform. Perhaps I will compare all of the properties to another form that works correctly. Also, I’ve checked to make sure that its not anything in any property events.

Randy

Mark,

Thanks, but it’s not that – I don’t have a tab control. I cant see where the focus is when it opens, but if I tab or back tab it doesn’t ever return to it’s unknown location – it toggles between the first and last fields. It’s no big deal, I used the SendKeys {Tab} to keep moving forward, but I’m still curious -although it may be one of those ‘unsolved mysteries’.

Randy

Thanks for all of the replies. The tab stop is zero for the first field and it’s TabStop is set to “Yes”. It’s not that the cursor appears in the incorrect field when the form opens… it doesn’t appear at all. None of the other controls (such as buttons) are Tab Stops. I’ve looked carefully for what has the focus when the form opens, but can’t find anything. Once I Tab or press Enter, the cursor moves into the first field (Tab 0). It’s not a crucial thing for me to figure out since I can get it to do what I want, so I don’t want to waste everyone’s time, but if someone can shed some light on this, it would be interesting to know.

Thanks again.

Randy

Francois,

I thought you had something there, since I was testing it on an old database, but I checked it and it was an Access 97 database that I had already converted to Access 2000. I created a new, empty Access 2000 database using the same name and password — it still prompted me for the password. At least it is sending the objects into the destination database. The transferdatabase method also prompted for the password, but the objects never made it to the destination database.

I just thought of something – the database that I’m running this from was converted from Access 97 – I’ll try the function in a ‘virgin’ Access 2000 database going to an Access 2000 database and see if that has any effect, although I don’t know why it would.

Thanks,

Randy

Tim,

Thanks for the reply and code sample. I was wondering if this is used by multiple users simultaneously, and if so, have you ever had a problem with duplicate case numbers?

Randy