Search results

This could also be done in a form, having the calculations in a text box, couldn't it?

It is a different form from the form name that is posted origanaly. Just trying to get it to work. I am starting to think that there may be something in the name or something that access 2003 doesn't like because other record source changes in my db do work.

Nether have I, Until now.... Thanks anyway

Thanks so much for that Miles. I have modified your code so that it is like this: Function Twenty_Ninth_Date() On Error GoTo Err_IsLeapYear Dim dteTemp As Date Dim IsLeapYear As Boolean dteTemp = DateSerial(Year(Date), 2, 29) If Day(dteTemp) = 29 Then IsLeapYear = True Err_IsLeapYear: If...

Hi all I am creating a calender in the Access Data Pages and I was wondering if there is a way to check for whether the current year is a leap year with VBA? Thanks for your help!!!

The other thing I have not told you (and I did not think it was nesercery) is that I have for each text box or combo box a keypress event call a function which in turn would call the Backup_Log_stamp function. At the time I thought that having a keypress on the form would do all combo boxes...

It all depends on what you mean by "save". when users enter data into or edit a record they are saved immediately when they go to next record, so a save button is not needed. however if you have the record restricted so that the user is only being able to edit his/her record, then a save button...

If all you want is to show the data in different ways, what is wrong with having a plain select query instead of making a heap of tables?

Two other things you are doing wrong: the first is you are missing a "end sub" after you call the Backup_Log_Stamp line. The other thing you are doing wrong is that the function must be in a module, which can be in the same module as the public variable "Previous_Time_Saved", but if you have it...

See attachment

Sorry, It's working now.

Hi all I am using the Data Access page for creating a events page in calender format. I am setting it up so that the present month, and the following month will be visible on the web with each month on a different page. I am using list boxes to display the events for each day so that more...

Thats what the problem is, you are using Access 97 and I am using access XP. Thanks for your help.

Try this: Private Sub Form_Current() Previous_Saved_Time = False End Sub Make sure that it is a public or global variable otherwise it won't work like it should.

I was wondering, would it be better for you to record the times they log on to computer for the times they start, and record the times they logoff for when they finish. This could be accomplished by having the database autostart when the workstation starts, however when the workstation is shut...

in the criteria for fields you want only with an entry do this: Is Not Null

Yes it can be done, but it would be better to just calculate the value when you need it. This is very easy to do. if you just want it in a form it is better to do it there then in a query. Just create a text box and when in design view, type in it: In a main form type...

Larry, do you want to use barcodes to find your criteria? eg a voter comes in and shows a Voter ID card, you scan it and there it is. Is this how you want it? Politics sucks.

There must be a better way, because that will cause my database to become bloatware. And all the coding would be all over the place, so I don't think that is a option. Interestingly this works: Forms!frm_Book_Entry_form!.sfrm_Book_Entry_Book_Description_Record_selected.Form.RecordSource =...

This should get you started