Search results

Thanks for the info Yes that helps alot. I am so rusty on this as I have other areas of responsbility here at work and this is the first time I have dealt with access question in probably close to a year. I will have to find some tutorials and refresh myself.

I follow it somewhat What does nz mean in the lookup and what is the purpose of the three fields in the table. Thanks for the help.

I am very rusty I have not done access work here for a while so I am ruther rusty on the syntax. Can you give me the general syntax for both parts? It would be much appreciated.

Hi Bob That seem to work. I think the user is going to probably is going to want what is on the previous record in the event name to show up the first time they go to the new issue blank record. Right now I have to enter something the first time for it to show on the second blank record. Is...

Here is the zipped up file The form in question is the Issues Form

Ok I tried to but it said the attachment was invalid. I don't think I can upload it if that is the case. I was also trying the following support article I found but its putting quotes around my default value: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136127

I have attached a screenshot Its in the VBA code window

here is what I have here is the code I have: Me.Title.DefaultValue = Me.Title The name of the textbox is Title but the Control Source is Event Name

I get this when I put the code in This is what I get in the field : #Name?

Hi, I have a user who would like the value from the last entry into the form's title field text box to show as the default value when he clicks on enter new issue button to bring up a new record. I do not know if this is possible but I thought I would check for him.

help Can someone help me?

update I did some searching and one user had done this in his database in a query. Round((table1.Endtime-table1.Starttime)*24,2) which displays in hours Should be easy enough to based the form on the query. Question is how would I total the times on a report in a footer because I want to...

I have been trying to help a user calculate elapsed time. I referenced the GetElapsedTime from the following Microsoft article http://support.microsoft.com/kb/210604/ It displays ok on a form or inserting on the detail in a report like it suggests but the user would also like to total up the...

Answer? MyString = (CStr(Forms!HumanResourcesForm3!Assessment1)) MyArray = Split(MyString, vbCrLf, -1, 1) ArraySize = UBound(MyArray) Its declared as an integer but it holds text.

Hi all, This a general question but how much can each element(cell) of an array hold. I use them for VBA and word automation and I parse per carriage return and noticed that a paragraph's last three sentences got lopped off by the array cell when the data was put into Word. It was a pretty long...

One more question This code only does one user a time correct? I am saying maybe two or three may be in the database at a time.

It works Hi Chris, Don't know why it want to decompile but the good news it seems to work. Thanks for the help.

Password The password is ahworld

Copy of database You must be in Australia or New Zeland one. Thanks for taking a look. its pretty blank so fill free to mess around in it. The word report buttons won't work of course.

How do I post a demo for the problem? Hi Chris, I know where the problem lies but I don't know if I can correct it. So how do I post a demo?