Search results

I have been able to isolate the problem to the fact that the macro that populates the table during the On_Load portion of the form. When populating the table prior to loading, the problem does not exist. I am still working on exactly why this happens but if anyone can shed some light on it and...

I have a combo box on a subform that is based on a table that is cleared every time the form is closed. The table is repopulated each time the form opens with information from a webpage. Note: the subform is not linked to the main form. The reason behind it not being linked has no bearing on...

OK. The quote issue solved my first problem but the 'No Current Record' error still remains on the subform combo box. I realized it could well be because it defaulted to the Me! reference which does not work on subforms. I have tried to get the syntax right to reference the subform...

I have two combo boxes, one on a main form and one on a subform. The two forms are not linked but are used to select to data records in two separate tables that you want linked. The linking is done by code behind a button. That works fine. What doesn't always work are the two combo boxes. The...

I figured it out myself. For anyone else who may be wondering, there is an ActiveX control called Microsoft Internet Transfer Control that facilitates this feature. Thanks to all.

Got it working. Thanks for the help!! I figured it was something simple.

I have a field with data in it that is imported from an external source. I'm trying to trim the data down to the first 9-12 characters. The data will look something like this: 345623985#http:blah blah blah...... What I want is the number at the beginning. Problem is, this number may vary in...

Graham, Thanks for the code. I did exactly what you suggested (even named the field in the table strWebsite). Now when the form opens I'm getting an 'Object required' error in the line that specifies the web addresses (even the second one). The value in the field shows as being the web address...

Basically, the control goes on the form just fine but I'm not sure how to set it up to invoke the browser when the form is opened. I realize that this is probably a real newby questions but I've just recently started using ActiveX controls. Thanks for any and all help. Tim, Thanks for the...

I'm having trouble getting the WebBrowser ActiveX control to work on a form. Can anyone point me to a resource that would be helpful??

My company is getting ready to convert over to Access 2002 and although I am not responsible for the conversion it will affect a large number of databases I've designed and I was wondering what kind of compatibility/conversion issues that other have encountered between the two versions. Is 2002...

Does anyone know if it is possible from within Access to capture information off of a specific web page?:confused:

PROBLEM SOLVED! SORTA The Tab Control thing really through the proverbial wrench in the works so I just created a hidden subform based on a query that gave me the fields I wanted. Just for everyone's info...according to the Microsoft website (and it works), the correct reference is...

OK I figured out part of the problem but I'm not sure where to go from here. The subforms that I refer to are part of a Tab Control. Now I'm really not sure how to refer to it.

I removed that field reference and now the same error comes up for the next subform control reference. It does not seem to occur for the control references on the main form.

Somebody please help!! I'm trying to set a button up on a form to send an e-mail. The code below in in the On Click property. I keep getting an error message 'Microsoft Access cannot find the field 'l' referred to in your expression'. The line of code that the debugger takes me to is the first...

I know that in code to reference a field on your form you use the Me! prefix. But how do you reference a subform within that form?

I don't know if this has anything to do with it but the form that the search is being done on has subforms although the search is done on fields in the main form. I created a simple dummy form with a query behind it and it works for that so there must be something else going on. Any ideas?

By canned search function I was referring to the search feature already built in to Microsoft Access. I simply assigned a button to bring up the search screen. Unfortunately the database this refers to is on my home computer so I won't be able to provide a code sample until late today. I would...

The database could potentially have hundreds of records, making a combo box impractical. Any other ideas?