Error message appears when multiple people Access Database

[Ginger]

Hi,
I have a date/time field being used to produce a unique Work Order number (based on creation date/time) format is set to yyyymmddhhnn

ex:200602151413
indicates that the WO was created 2/15/2006 at 2:15 pm
(2006 02 15 1413)

However, the following occurs:

20060217853 (2/17/2006 at 8:53 am) 2006 02 17 853

Is there a way to force the time to 4 digits as in 200602170853?

Thanks in advance.

[Imagineer]

Hi,
I have a database that features a subform which is set to display in form mode, and I want to be able to have the subform display with the most recent record entered. Any suggestions?

[Jerlene]

Well there is this code:

DoCmd.GoToRecord acForm, [F-MAIN].[FORM-SUB], acNewRec

and this code:

Me.Your Subform Name.SetFocus
DoCmd.GoToRecord , , acNewRec

If they don't work, try the following:

You can control this either on the RecordSource of the subform, or "on-the-fly" from the main form.

Dim strSQL as String

strSQL = "Select * From MySubFrmTable Order By MyDateField Desc"

Me.YourSubFormName.Form.RecordSource = strSQL
Me.YourSubFormName.Requery

[TonyES]

Hi Ginger,
When I use Format(now(),"yyyymmddhhnnss") I get 20060217084030.

If the field is actually a date/time field, you are always storing a value like 38765.363275463 .It doesn't make any difference what the format is when storing the value. The format is for display purposes only. I usually only set the format in places where a user will see the value such as in report or form controls.
As I stated earlier, if the field is a date field, it will not be storing the value 20060217084030. That value would be billions of years into the future (I think) since today is store as about 38766.
Cheers!

[TonyES]

Hi Imagineer,
Create a query that orders the records in the table in descending order on ID, and use the query as record source for the subform. See whether you might have clicked on the wrong place and got the wrong property page.

[Imagineer]

I want to build a pop up calendar that will show up when I try to put in a date for vacation. Now, I have 2 fields in my table...one for start date and one for end date, as this database will be used to track all dates requested off, and have built a form for the time off request. I have 2 forms build that have calendar controls on them...my problem right now is that when i (the cursor) enter the control and the calendar form pops up, it doesn't go away. I know that means i have my macro in the wrong event. And, I can't remember how to tell the control on the request form that the value that should show there is equal to the date I clicked on in the calendar pop up...I have been able to do that in the past and am totally drawing a blank as to what I did and what I am missing now...I've been staring at this and we all know how that goes... I tried using just a date and time picker, but I keep getting an error message that says it can't use what was selected if the check box property is set to false. Like I said, I am probably missing the most simple of steps, my brain is just so worn out on this Sunday night, I needed to call in the cavalry smile Any help would be greatly appreciated.

[TonyES]

Hi,
It should be possible to use only one popup form for both dates or you can put the calendar on the form itself.
Cheers!

[NewBridge]

Hi to all,
I am trying to set the value of a list box to an existing table, Where I'm not having a problem is getting the database to store the data I have selected in my list box, which allows multi-selection. The purpose of the form is to input inventory that will also have keywords stored about each item to allow for keyword searches. My inventory table has a keyword field in it...my keyword table just has all the fixed keywords that would be assigned to an inventory item...again, will have multiple keywords for one item. Any suggestions would be greatly appreciated.
With regards,
Bridge

[Hippo86]

I am trying to delete a Microsoft WordArt graphic from a form and get the error message. Any suggestions?

[Help-Desk]

Please provide the complete error message and error codes if anny.
Then you may be able to look it up.