Search results

Please post the SQL. GumbyD

Try using first instead of min. If you have any other fields that are not groupby or where what are they set to? GumbyD

Check your datatypes. You may have a field with an datatype of integer. If you try to insert a value greater than around 32000 it will fail. Change the datatype to a long integer. GumbyD

To answer the first part of the question - you need to add more &s in the format. Like I said this is not a great way to handle this code would be better- but you would need to be hitting the e-mail addresses from a form. As for the other part of your question - you may want to start a...

AN60 - It is really only a problem if you are referencing the fields in code or in a later object. If the name of the field has changed then you have to make sure you are using the correct name and if there are spaces you have to put brackets around the field name. If you just want it to...

If the error comes up right away it may be a permissions issue; however, if it comes up after the compact process seems to be complete than the file is corrupted. Your best bet might be to go to a back up copy and redo any data entry that was lost. You might also try creating another database...

It sounds to me like the database is corrupted. Can you run a repair on it? GumbyD

If you are doing this in a table and clicking on the address to send the e-mail directly from the table you could add a format to the field. The below works as long as the address is not longer than the number of &'s. "mailto: "&&&&&&&&&&&&&&&&&&&&&&&&&&&& Kind of goofy - maybe someone has a...

OK - different issue then! How are your keys step up on your table? How are you currently determining available entry dates? Do you have a table of entry dates or it is just "anything not currently in the table but after a certain date?" If you had a table of valid entry dates for the combo...

I agree too - I was just giving him a possible solution. GumbyD

Odd - I would not have expected auto-correct to be related to captions. I guess you learn something new everyday! Thanks for info Pat! GumbyD

If your are on Access 2000 or later, in the form properties find the On Timer event and select [Event Procedure]. In the Timer Interval property type 1. In the event procedure code for the On timer event put the following: Private Sub Form_Timer() Text0.Requery End Sub You will need to...

Take a look at the attached and this should work for your situation. GumbyD

Damie - Send it over to me!

That is very odd. I just tried what you did in both Access 2000 and Access 97 and both times the caption changed when I changed it at the table level. Is it possible that you have captions set at the query level as well? If so that would explain it since it would over-ride the table caption...

Matt - First and the new fields, FirstName and LastName, to your table (I will use Table1 as my table name). Create a new query and bring in Table1 from the show table window. Close the show table window. From the box in the upper part of the screen (that has table1 in the heading) find your...

Tidman - Is there a common key or keys between the two tables? You may be able to put both the tables into a query and use the query as the form record source. If the query is updatable then when you save the data on the form both of the tables will get the updates. If that is not what you...

Matt - Add the new fields FirstName and LastName to your table then create an update query. I am assuming that the names are currently "First Last" No middle initials or names. To get the first name use: Left([NameField],InStr([NameField]," ")-1) To get the Last Name use...

Damie - I just did a bit of poking around in a database. It appears that in the table properties you define a child and master link and the subdatasheet Name. Try going into the table in design view right click for the properties and see what if anything is set in those properites. You may...

Sure - you can use this: Between [Enter Date Value] and date() GumbyD