Search results

Afternoon all and sundry, I have a problem which is causing me no little grief. I have six fields in a form linked to a table. 1. Date In 2. Time In 3. Date Agent 4. Time Agent 5. Date Out 6. Time Out In the form, I have validation formulas set up on field 4 and 6, which say, for example...

Greetings and Salutations all! I have a question here that, whilst being DateDiff related, isn't like anything else I can find in the forums. If it's already been answered and I missed it, my apologies. Otherwise, here it is: Four fields: Date In (dd/mm/yy) Time In (hh:nn) Date Out (dd/mm/yy)...

Howdy boys and girls, It's been a little while since I've been on, and I've missed you all more than you can know! But I'm back with a brand new problem. Actually, it's a reoccuring problem. I finish building a db from scratch, put in the finishing touches, and when I click, for example, a...

Hiya all, Another gratuitous question for the group! I'm running a time stamp for a group of staff. I want to have it resemble something along the lines of the Windows taskbar. Landscape format, very narrow, etc. But here's the catch. I want it to remain permanently on top. Always visible. Is...

Hullo folks, I have a call times log set up. TimeIn, TimeOut, Duration. I want to set up a graph that looks like this: X-Axis = TimeIn per hour Y-Axis = Count of Calls (TimeIn will suffice) per hour This is the first time I've seen Graph in Access, and I'm rather lost. Thanks.

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...

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...

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...