Search results for query: *

How would I do I group my records into one record for each month? SELECT Montly_Rpt_Table.REPID, Montly_Rpt_Table.Rep, Montly_Rpt_Table.MonthAbb, Montly_Rpt_Table.LostAmt, Montly_Rpt_Table.WonAmt FROM Montly_Rpt_Table WHERE (((Montly_Rpt_Table.REPID)=2)); REPID REP MonthAbb LostAmt...

Hello, I'am hoping someone in this forum can help me. I having some trouble with the syntax below. I am using MS Access 2010 and I have a form which generates an email through using Outlook.Application. When I outlook generates the email and I click on the Link the website indicates it cannot...

Hello, I have an excel file which I have imported into an access table. There is a field Called Time_Lapsed which is in Text format. Is it possible to someway to sort (rank) these from oldest first? The fields look like this: 08 day(s), 2 hour(s), 39 minute(s). 04 day(s), 13 hour(s), 6...

Hello, I need help with writing a script that will open a dat file in my temp directory and then check a specific column's field "USER_ID". if the column USER_ID field is more than 6 characters I would then need the script to trim from the RIGHT of the "USER_ID' column to be within the 6...

I need some help on ranking and hoping someone can assist. I have an EmployeeID field "EmpID" which is a number field and an Hours field which is a Text Field. I would like to create a ranking column to rank the the employee with the highest amount of hours. Is this possible to do in a query...

I am hoping this is the right forum for this question. We will be migrating to windows 7 with Office 2010 from Windows XP Office 2007 in the next few months. We have imaged one of our test machines and have found out that our MS Office products have had some restrictions placed on them through...

Hello, I need some assistance with rounding up. I have a field in which the data type is a Number and the field size is set to double. I am look for a way round up to the nearest quarter. Example: 1.32 round up 1.75 0.07 round up 0.25 48.54 round up 49.0 1.15 round up 1.25 2.21 round...

Can someone explain to me what this mean and how do correct the query? "You tried to execute a query that does not include the specified expression "Barcode Assignment" as part of the aggregate function" SELECT Test2.Barcode_Assignment, Format((Sum([...

I have an odd thing going on here with one of my Reports. The navigation bar at the bottom of the report where it allows you to navigate through pages is only visible to me only. Whatever computer I logon to it is visible to me only, but if someone else logs onto a computer the page selector...

Here is my dilemma. I have created an attendance DB which works great for single event entries. But I was approached today and was asked what if the employee takes a week off? That would mean 7 seperate entries would need to be made in the DB. Currently, users fill out a form which then...

I have a query which is pulls data from one table called "Employee_Info". Table consist of the following: EmpID Date LName The query I have displays the information like this: EmpID Date LName 2134 1/24/2013 John Doe 3443 2/14/2013 James Frank Is it possible to have the...

Help! I need to export a report in PDF format but the trick is I only need to export the first page only. Here is what I have and it works fine with the exception of the output. It outputs all the pages and I only need the first page. Could page parameters be used somewhere in this string? On...

Hello! I have a numeric field [Hours] in a table (52, 51, 50, 49...). I need to convert that to a text field to like this: 52:00:00 AM, 51:00:00 AM and so on Any ideas on how to do this? Thank you in advance for assistance you can provide!

Hello! I need to be able to trap two errors on the On Error event of my form. What I have listed is not working. Can someone assist me! If DataErr = 3201 Then MsgBox "Message 1." Response = acDataErrContinue Else If DataErr = 3022 Then MsgBox "Message 2." Response =...

Hopefully I am in the right forum for this problem. I am starting a project in Excel and I need some help. My project involves using a barcode scanner to scan boxes which contain product. For example and I will make this simple. The first barcode would scan as 1000 and the second would scan as...

I am using MS Access 2007. I have a form with a button which creates an instance of outlook. The code works great but would it be possible to modify the code so it would insert the users default mail signature from MS Outlook. Currently users are having to use the insert button in outlook to...

I need a startup script that will disable/enable com port 1 at startup. Can anyone assist in helping me put this together?

Our company is using Windows XP Professional. I need to be able to make changes to the device manager without having to have the standard user Logoff and me logging on with my admin account to make the changes. Any suggestions on how to accomplish this?

I am having a problem with the following script when I try to transfer an Excel workbook to an Access Table I recieve the following error "External Table is Not in the Expected Format". The script will only works if the excel workbook is open. I am using Access/Excel 2007 version and the...

I am having a problem with the following script when I try to transfer an Excel workbook to an Access Table I recieve the following error "External Table is Not in the Expected Format". The script will only works if the excel workbook is open. I am using Access/Excel 2007 version and the...