General

Calculating Time difference
How do I calculate the difference betwenn a time range. I have defined my startTime and endTime as follows, and I need to calculate the difference between the two time period. startTime = Format(Time, "hh:mm AM/PM") endTime = Format(Time, "hh:mm AM/PM") Me.txtTotalTime = Format(endTime - startTime, "hh:mm AM... 1 Jul 2008 04:08

Problem with report containing photos
I have successfully imported links to 6600 photos and can display 1, but when I try to do a whole report, even for a few hundred, it takes forever. Is this generally a problem with Access? Do I need to make the pictures smaller? Before I start endless hours of trying different things, I thought I'd ask the q... 1 Jul 2008 07:11

Search record
Hi, I have a small master table with fund and processer as two diff fields. Fund Processor abcd JOhn pitd Kevin aw88 Steve All i need is to track which fund was processed by whom. I am looking for a form with two text box. I write the fund nam... 1 Jul 2008 05:09

View form, but lock editting
I have a huge table of contact information. I would like the user to be able to be able to open the form and immediately make a new entry and I would also like them to be able to browse the previous entries. So far, this is MSAccess' default. However, I would like to modify the form so that, when a use ris b... 3 Jul 2008 17:40

xc
asFDasf ... 30 Jun 2008 13:45

Why you have email account if you call
... 30 Jun 2008 13:45

Form/subForm nuance
Hello again, I have FormA and FormB. FormA is my main form and FormB contains information that I want to ALWAYS related to an entry in FormA. As a result, FormA is my main form and FormB is my subform. (FormA is a contact directory and FormB is a voicemail log. Where there is an entry in the voicemail lo... 2 Jul 2008 13:57

pop up forms
My question is two fold and I will try to explain it as best as I can. I have a sub form that I would like to have pop up when an event happens, like when I press my toggle button I have on the screen. Here's what happens. When I press the toggle button it does pop up, but the information like last name does ... 30 Jun 2008 13:45

Default Value
I have a main form with just a date field on it and then on my subform I have fields where the users can log members in. The problem I'm having is when I set the default date in the date field to the current date and then create a new record it will not save that record even if I enter data on my subform. But w... 1 Jul 2008 13:22

Scroll Wheel within Access
Is there a way of disabling scroll wheels within Access as it is causing me problems. When a user accidentally uses a scroll wheel and goes to a new/blank record, access creates a new record with automated references etc (this is because I have some VB which needs to run on entering a record/form)..Thanks ... 30 Jun 2008 12:44