Search results

what works better? wireless USB or a wireless adapter. I just made a new desktop and need a WiFi card. Historically I've used a wireless adapter in the past, I've never used a wireless USB, so I don't know how good they are.

In access 2003 I used PrintOut in the Macros, although this is not available in Access 2007. I have no clue why not, but has anyone heard about this? Is there a work around. I can't even find this problem on google!

Whats the code to print a query from VBA or even in a Macro? Can't find the solution on google. I put this in the VBA section but no one seemed to know.

delet edelt etasdfasdf asd

I'm looking to buy a desktop for less than $400.. I've been looking at cyber power PC's and the HP Slimline. I'll do minimal gaming and just school stuff. I mainly want to use this computer to get more familiar with Server 2003. I am A+ certified so I can also make a computer, but I'm...

I need to calculate average time!! I'm having a lot of problems doing this. I have a field that I'm trying to average that shows up as for example, 00:20:45 which is 20 min and 45 seconds, which is the amount of time a user has been in our facility. I want to average this field by week, but...

After I run this code my object query get completly wiped out (as in the SQL gets deleted). I have no clue why this happens, Here is my code... help! Private Sub Print_Click() If IsNull(MachineBox) Then MsgBox "Please select a machine" Else DoCmd.OutputTo acQuery, "MachinePrintOut"...

I have a macro that sends out e-mails and when the e-mails are sent out there is a warning that says something like "a prgram is trying to automatically send an e-mail on your behalf. Do you want to allow this?"... I want to use redemption to make this stop. can anyone provide the modules/code...

I have outlook 2007. are there any other programs out there other than ClickYes and Redemption to stop the e-mail confirmation message?

I have an IIF field 'Inbound : IIf([Dwell Start Event]="RMFC",Yes,No)' that outputs -1 or 0 depending if the value is Yes or No. How can I make is so the result will say Y if it's -1 and N if it's 0? I tried changing the Yes and No to Y and N, but it didn't work.

I want to sort my query by Month then by Day. I have month sorted 01, 02, 03, etc. Although my days are listed as Monday, Tuesday, Wed... So when I sort it'll sort in alpha order. Friday, Monday... This is my field Day: Format([Date],'dddd') What is the best way to get it to sort in the...

I have to run a query where the criteria is specific time ranges. The column is formatted as date/time (ie. 7/12/2008 06:28:02). I need the criteria to give me data for specific time ranges on each individual day for a year. So for the data set of 7/01/2007-12/31/2007 I need the specific data...

I finished making my Access database, but I'm not to fond of the aesthetics of it. I've never been a very artsy person and I'm not too satisfied with the way my forms look. I work for a pretty big corporation, so I want my form to look professional, but sleek. If you think you have a nice...

I'm looking for the best solution for this problem, any suggestions on how to tackle this would be great. My database runs reports off of two tables,'dataPY' and 'dataCY' (PY = previous year 2007, CY = current year 2008). When the year changes say it's 2009, the Database Admin will take the CY...

My database imports data from an Access e-mail. Everything works fine, but the subject part of the email which goes into a memo field of my table drops off bullets that are in the e-mail. I think it's because they aren't characters, they are symbols. Is there anything I can do to make Access...

I have this code where it will find unread e-mail and store it to an Access table. Option Explicit Option Compare Binary Private Sub ReadMail_Click() Dim Olapp As Outlook.Application Dim Olmapi As Outlook.NameSpace Dim Olfolder As Outlook.MAPIFolder Dim OlAccept As...

Sorry if this has been discussed! I have Access 2007 and I hate how the object window (view tables, queries, forms, reports, etc) is one single column. I have databases that have 20 tables and 20 queries and it's pretty hard to find what I'm looking for sometimes. I'm sure some of you have...

I'm not sure if this is a query or report problem, so it is in both areas. let me know and i'll delete one of the postS! I have this query: SELECT Owner, lgtn, Count( lgtn) AS Cnt, States FROM [bare chassis BRIO] GROUP BY Owner, lgtn, States HAVING ((( CountOwner) Is Not Null)) ORDER BY...

I have this query: SELECT Owner, lgtn, Count( lgtn) AS Cnt, States FROM [bare chassis BRIO] GROUP BY Owner, lgtn, States HAVING ((( CountOwner) Is Not Null)) ORDER BY Owner, lgtn, States; Which will output this report: Owner__length__Cnt__States flex__20________4__ Virginia...

Every week my boss asks his employees (about 6 people) to write a Weekly Summary report about what they did that week. They are to include What they did and an estimate of the time it took for each task. All of the employees email their Weekly Summary in a different format, and my boss has to...