Recent content by qwkslvr1999

Thank you very much for all the inputs!!! You're a life saver!

I need to know how I can find how many seasons have lapsed between two dates. It's fairly easy if the 2 dates fall within the same year but I cannot figure out how to do it if they fall in different years. Following is how seasons are defined: season 1: 12/20-3/19; season 2:3/20-6/19; season...

I have a text box that accepts special characters. In order to type these characters, I have to use key combinations (from 2 -5 key combinations), for example, ALT + 1234. IS there any way that I can create a 2 key combination/shortcut for this? For example, instead of typing ALT + 1234, is...

Thanks! I actually did that before but it slowed down the database sooo much.

I have a database that used to be on a network drive but I was always getting a disk error (the other users as well) everytime the database is left open and not do anything. To isolate the problem, I decided to transfer it to my local drive. I haven't been getting any errors and the db seems...

I have a form that contains 2 subforms, 2 command buttons,an unbound text box and another text box , testid=[subform1].[Form]![datesid]. Subform1 is linked to Main Form by the unbound text box and subform2 is linked to main form by text box testid. both subforms are in datasheet view. table1...

This actually happened to me when I was about 13: On our way to a concert: Me: Do I look pretty? Uncle: That's not the right way to ask. You should say, "How do I look?" Me:Ok...How do I look uncle? Uncle: Good, let's go!

I was thinking that the MySQL database will be repopulated and just be queried by some sort of a web form. I think that it might involve a lot of work if we would try to recreate all the forms we already have in Access. So, with that idea,would something like ASP( vbscript or jscript?) be...

I have an Access97 database which will be converted into a MySQL db. I know it is possible to convert the backend db into a MYSQL db and that the Access db frontend can be linked to the MySQL server through ODBC. My question is, what would be the process if the db needs to be accessed from...

You might want to try this: http://www.mvps.org/access/forms/frm0024.htm

Another option would be to add an after update event to the lastname control. This way your text(lastname) will not be limited to the number of Ls you have in your input mask. Put this in lastname after update event: Private Sub lastname_AfterUpdate()...

Is the ProductId in the second form(table) autonumbered too? If Yes, this should be set to Long Int. If this doesn't work out, can you send me a copy of your db?

How about a union query?

Yes, that is right.

Can you post your query?