Search results

Ok i believe I found the problem, and it is bizzare. I was using a split form, but hiding the form detail using the split view bar, by dragging the horizontal bar. I now resized it so that a tiny bit of the form detail is showing and... it now works! I don't know why this would cause a...

Any ideas? I'm racking my brain with this one.

Hi I have a database i have been working on (access 2007). In the past I have been using a list box to select records. Now I would like to use the datasheet view or split form view. Everything seemed fine until I moved to linked tables. My problem is, with the same query, the listbox is...

ssteinke, this was exactly the one I was looking for! Thanks very much :)

Found the answer, and I guess ADP's can't use the currentdb object.

To further elaborate, I am trying to get around all the code and queries required to be able to sort each column.

I am trying to access the CurrentDb.QueryDefs collection, but the CurrentDb object is nothing! Here is my simple code= debug.print CurrentDb.QueryDefs.Count I get the "Object variable or With block variable not set" error message. Is this because I am using an Access Database Project, and...

Yes I know this is not vb.net The list box control in vb.net is far superior. There is a way to use it.

I could swear there was an example on this site for using the system.windows.forms.listbox control in access. Can't seem to find it though, can anyone point me to an example? Is there any reason why I SHOULDN'T use it?

Thanks for the reply, I can upgrade to Access 2007. PDF printer will not wok as the application forms area already in PDF format and need to have data inserted into their text fields.

Hello, I need to be able to take information from a table in access, use this information to populate a PDF file, and then save the PDF file. i.e. I have leads in a database and I want to pre-fill in application forms (PDF) for the clients. I did some searching pertaining PDF, but didn't find...

Worked beautifully!

I took a look at it recently and it needs a ton of polishing up before I can provide it as a sample. Its been so long since I used it, and I didn't put any comments in the code! Also most of the features don't work anymore because the programs it works with are internal to the company I use to...

Ah thank you, forgot about the split function. I will give it a try.

Thank you for the reply. I know these string functions, but what I don't know is how to grab the first line of a text box and put that into a string. And then grab the next line in a text box etc...

I get emails every day with leads. Usually I cut and paste each field into a form in access, but this has become very time consuming. I want to be able to just paste the lead into a text box and have access parse the content and add the lead to the database. Leads come in the following...

thank you, works perfectly

I use this class a lot in vb.net but I cannot access it through VBA. Is there a way to do this? My VBA is a little rusty. It is in the system.text namespace.

I have an access database that I developed while working for tech support at earthlink a while ago. If anyone is interested, I'd be happy to clean it up and post it in the examples. Some of it's features include: Tabbed Browsing Posting and manipulating web forms HTML Scraping Injecting...