Search results

Huh?

I realize that. Doesn't mean you have to open many forms at once. just use an if statement with the colum reference like before. Set the if statement to check for different values and these values open different forms.

The file wzmain80.mde is a library database. As far as I know it only came with Access97. So the person who created that database has referenced it for some type of function. So when you try to open it in Access 2k2 it can't find the reference file.

You can still use Mile's code. The only thing you have to do different is specifiy which column you want to compare data to. DoCmd.OpenForm "MyForm",,,"mid =" & Forms!ListForm!lstBox.Column(0) DoCmd.OpenForm "MyForm2",,,"location =" & Forms!ListForm!lstBox.Column(1) And so on..... Hope this...

I know. Well they were. :D I never thought of using a tree view till you posted pics and I know a spot I can use it.

I'm not trying to put you down or anything. It's gonna look cool though.

Anyone tell me how to get data into a Tree View using the ActiveX control. I can't figure the thing out.

So really the program isn't functional yet. It's what you want it to look like in the end?

Question. How can the Last modified date be 2 days greater than today???

First thing I do is plan how you want the database set up. Don't worry about forms, reports etc. right now. Start by how you want to set up the tables and the relationships. Once you get that down the rest of it will be easy. I find the hardest part of designing a database program is how...

Hey guys. What are some cool features you have added to some of your programs. I have completed a program and want to add some interesting stuff to it but don't know what to add. It's a Planning System by the way. Anyone?

Is frmSelectContact Modal? If so make it a regular window and try it.

If you don't mind me asking where in ontario?

Off topic but where from Canada are you from?

Being a programmer myself I never really worked much with VBA. I just used Access for storage of data only not for the app itself. I prefer to work with C++ but when I got my IT Admin job everything from previous was done in Access so I had to get back into it. I knew how to program in VBA...

If you think about it I don't think you can actually print using code. I think what you have to do is create a report and have whoever view the report and print it that way.

is the system located in the company or on a host?

I have done something similar to that. To do this you will need some sort of ASP e-mail object. I recommend using ASPMail. It's server side so if you are using a web server outside your home or office hopefully they will have it. Now this code is for ASPMail What you do is after your insert...

How is the data being entered into the database?

The web page you are using is it and ASP page? If it is I can help. I created a quotes system that will e-mail the sales department when a company has uploaded a quote.