Search results for query: *

Hello, I hope someone can help, please.... I have a ZOOM X3 Ethernet ADSL modem connected to a Belkin wireless router, hopefully to share my connection with other computers, all on XP. I have set-up the X3 modem to dial my ISP with the sign-on settings given (by AOL). This works great on it's...

Thanks Carr, I've managed to find a win95 disk and install this which fixed the problem. Thanks Again!

Hi, I have recently cleaned my hard drive by re-formating the C: drive and installing win98. The problem I am having is that the installation goes fine but when the computer restarts after the installation a message "TYPE THE NAME OF THE COMMMAND INTERPRETER (E.G. COMMAND.COM) appears. so...

Many thanks for your time.

Sorry Michael, I'm not to good at the vba procedure lark. the ones I have looked at don't seem to fit what I want. I would really appreciate any guidance. Many thanks Dave

I'm sorry, this is in Access xp. Thanks Dave

Hi, I have a query that produces a field worked out on DateDiff by hours and shows me how many hours difference there is between a DATE RECEIVED and a DATE MODIFIED fields. The only trouble is is that I want to make this function use working hours in how many hours have elapsed. An example is...

Hello, I am trying to produce a Form that shows statistics based on the values in a report. The values I am trying to pull into a text box on a Form is '# OF RECORDS', and how many records in the report have a value >3 under a Text box called 'TEXT111'. Now I've managed to do the first bit...

Hello, I am writing a report in MS Access 2000 where I have a linked table from an outlook inbox. The report is then run from a query using this table. The report lists FROM, SUBJECT, DATE RECEIVED (as DD/MM/YYYY HH:MM:SS) and DATE MODIFIED (as DD/MM/YYYY HH:MM:SS). Basically what I have done...

I'm looking to import the an inbox and a folder contained in MS Outlook 2000 into MS Access. The only problem I have is I need to do this by a macro and I cannot seem to create a macro for doing this. Could anyone offer any advise please? Thanks in advance. Dklein

My apologies, thank you for the advice.

Hello, I have a text box in a report that works out the difference in two dates in the record and gives a number of hours. What I need now is another text box that works out how many of these are >3 i.e. greater that three hours difference... I'm trying to use =Count([Elapsedtime],>3) but when...

I would really appreciate any assistance please. I have been tasked with creating a database that can be used to check the time difference in outlook from when a mail was received an when it was modified. Also list them and give a number of how many mails there are from a certain address, and...

I would really appreciate any assistance please. I have been tasked with creating a database that can be used to check the time difference in outlook from when a mail was received an when it was modified. Also list them and give a number of how many mails there are from a certain address, and...

Thanks everyone. It works now. I re-keyed the function and it works now for some reason?? I appreciate you help!!

Hello, I hope someone can help please. I have a report in Access where I have a function in a text box that calculates the difference in time between two date fields, which is great. What I need is another text box at the bottom of the report where it tells me how many of the values in the...

Thanks, I've tried to put the formula in a text box in a report DateDiff("s",[Modified],[Created]) but I get an error message saying syntax error (comma) in query expression? could you help at all. I really appreciate it!! The deadline is drawing near!! Dave

Thanks Paul, I've still got problems applying the function. at the moment the data contained in the MODIFIED and the in the RECEIVED fields are "DD/MM/YYY HH:MM:SS". I was hoping to go down to seconds level and show the difference in the two fields in a seperate field on a report...

Hello, I am importing data from MS Outlook into MS Access via the linked table funtion to ensure real-time updates of the mailbox. I then want to do a sum on the Date Received and Date modified fields to see how much time has elapsed between the two, to produce Service levels etc... but i'm...

Hello, I'd appreciate any help please as I'm stuck. I've written some code that scrapes data from an attachmate screen and writes it to a text file. I then need to send this text file to recipient using Lotus notes. I have managed to successfully create a new e-mail, add the recipient bla...