Search results

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?

If I understand your problem correctly... From the master Product screen, you can open another form that will take the Product ID as an argument. For example, if you will use a command button to open the form, you will have something like : DoCmd.OpenForm "nextform", , , , , , Me![productid]...

You know, you are right! But then I decided to just stop worrying about it. My users are fine with the long urls (anyway, they were the ones who decided to do it that way earlier :)) I just thought of it since they kind of realized that the report doesn't exactly look nice with the verrry...

Thanks for the idea. I just used the .com as an example. Maybe once I make it work with .com, I can do something to make it work with the others too.

I have a field that displays url in a report like this: http://www.webaite.com/personal/page_title.jsp In some records, this field tend to be very long. I am just wondering if the URLs can be trimmed without editing each one. Is there a way that would tell Access to show only a part of text...

Rich, that's exactly what happens with me, too. DBL, I'm using A97. There isn't a condiitonal formatting wizard in A97 but I was able to do a work around by selecting the controls (multiple selection) and then just put in the function name in the enter/exit events. I found a code that works...