Search results

Oh yeah. That did it. If I ever run into a black-haired albino wearing an inverted KFC bucket on his head, I'll throw money. Thanks!

Nope. What should the code look like? Not sure how to use this.

Howdy all, I have a bunch of xls sheets linked to an Access db. The xls sheets have a Sent field, containing date/time in format dd/mm/yy hh:nn There is a table in the Access db called Appended containing a field called Received. I need to get the difference. Problem is Access seems to read...

Hey all, Still battling with this multi-select listbox problem. I found the following code: On Error GoTo Err_Print_ClickErr Dim vntIndex As Variant Dim strValue As String If ListBoxName.ListIndex < 0 Then MsgBox "Please select 1 or more items from the list" Exit Sub End If For...

Hi all, I've been browsing for a while now and can't figure out the solution to my problem. I have query qryStatic returning records of transactions for various staff members from a number of combined tables. The query contains field StaffID I have another table containing StaffID and...

Hey all, I'm reluctant to post such a basic question, so apologies beforehand. But I've spent a good 40mins prowling through the forum and I can't find the info I'm after. I have a table with multiple transactions per staff member. I need to create a form that has a check box for each staff...

Hey all, I have a problem with a Union Query. The problem is thus: I have approximately a dozen Excel spreadsheets updated daily by different staff members. These spreadsheets are linked to a single Access database. I have a union query (CombineAll) that, as the name suggests, combines all...

Hey all, I have an Inbox linked to an Access table. All is just peachy except for the From field; this displays whatever the sender has set up in their email settings. Sometimes the email address, most often their name. I need that field to consistently display the email address. Is there any...

Hayley, The import wizard isn't an option, since I need this database to be operated by computer illiterate staff. Otherwise it'd be perfect. In the meantime I have figured out a work around solution. 1. Link Inbox to Access. 2. Append data from live link table to new table. My biggest...

Hey all, I have a major problem with Access and Outlook at the moment. It's something of a saga, but here's the upshot of it all: I need to design a basic, basic method to transfer emails from Outlook Inbox to a table in Access and assign a Unique ID to each item. It's so simple, you say! I...

Many thanks all for your help. I didn't expect so many responses so fast! I have yet to read through and work out which one works best for my particular problem. Shall do so today. I love the forum! More resources here than I could have hoped for. I'll be back! Cheers.

Neil, Thanks for your reply. I'm not sure if you fully understand the problem. I need to calculate the difference between the Received and Sent fields. For example, Received: 25/5/3 13.15 Sent: 27/5/3 12.45 Actual Difference: 47.30 Access Calculates Difference as: 23.30 The problem I'm...

Col, Thanks again. My function now looks like this: TA Team: DateDiff("n",[Received],[Sent]) ...where [Sent] and [Received] are date/time format (dd/mm/yy hh:nn) I still can't get it to return the time in format hh:nn. Any suggestions? Cheers.

Hey Col, Thanks for your reply. I didn't expect anything so quick! Ran a search but couldn't find what I was after. Any suggestoins? Cheers. tj.

Hey all, I'm setting up a db to calculate turnaround times - time in vs time out. Both fields contain date and time inclusive, time being 24hr clock. I'm running a basic query that subtracts the Received field from the Sent field, and the result is formatted to hh:mm, 24hr clock. The problem...