Search results

Sometimes the dates are incomplete--i.e., 10/2010 or 2010.

I separated my date field into three number fields for Month, Day, and Year. My query no longer works that I used to get the Max date for EventDate when it was one field. Below is the query: SELECT Event.CompanyID, Max(Event.EventDate) AS [End Date] FROM Event GROUP BY Event.CompanyID; How...

I am having trouble with this db because I want to throw everything into one table because of the one-to-one relationship with Event table. I’ve been taught that every subject should have its own table. The purpose of this db is to keep track of all the media, applications, release forms, and...

I am using Access 2007. That's it. Thanks pbaldy!!!

I'm not following you here. I tried using an unbound hidden Date/Time field with Day, Month, and Year control source equals, but not working. My mind is spinning--give it to me real basic.

Some of the dates are incomplete—such as, 12/2010 or just 1999; therefore, I had to change from using a Date/Time datatype to using three separate number fields—that is, Month, Day, Year. The problem is they want the fields to default to the current date, but still be able to change the date...

Got it, I used: Month: DatePart("m",[EventDate])

What's the quickest way to get Dates already in db in put them in to 3 separate fields?

Got it. Used: Expr1: IIf(IsNull([EventMonth_n]),"mm",Format([EventMonth_n],"00")) & "/" & IIf(IsNull([EventDay_n]),"dd",Format([EventDay_n],"00")) & "/" & IIf(IsNull([EventYear_n]),"yyyy",([EventYear_n]))

LIke: DateSerial(Nz(year, "___"), Nz(month, "__"), Nz(day, "__"))

If you're missing the day or month or year, how do you tell it to display what you have or say "incomplete date"?

Yep, sure did. And, the left side of wizard is always blank.

Using Access 2007 It's been done, but I did it again and got: The specified path has already been added to your Trusted location.

Macro is not working in this db. I am trying to create a command button using the wizard to open another form. (I know all of this can be done using VBA DoCmd.OpenForm…, but I am trying to see what’s causing my forms in this database to not work...) I did the following: 1. fmainCompany is...

I am not understanding what you mean by "...logging from a logging routine..." Basically, in my database my EventNote memo field is in a separate table—that is, EventNote table has three fields: 1) EventNoteID – AutoNumber (primary key) 2) EventID – Number (event related to) 3)...

Using Access 2007 I have an EventNote table with three fields: 1) EventNoteID - AutoNumber 2) EventID - Number 3) EventNoteData – Memo The EventDetail form has a button to click to add notes, which will open to EventNoteData field (in Popup, Modal). I found out if you have more than one...

I tried that already--does not work. I get another error. And, this db is displaying one form. When I display "just" the memo form, I am able to save too. Anyway, I tried both the examples given in the db, and I just get a whole new set of errors.

Access 2007 Also, I do not get an error if the Memo field contains less than 2k characters. Or, if the form is the only form opened. Or, if I go directly into tables and save the data, I don't get an error.

I tried it just in case, but it did not do nothing. I found out that this is a know problem. My research of the web showed many, many are having this same problem. The error number for this problem is Error 3188. When I open the memo field form by itself and save it, it works. If I have...

I didn't see a reason to create a query because it is only one field using from this table and I will not be sorting or anything. I'm just keeping the memo field separate. EventNoteID = Autonumber EventNote = Memo