Search results for query: *

I'm pretty new to access - I have a report that links to my query and the layout is simple: Service #Pkgs % to Total My query gives me the service type and number of packages that are associated with each service - NOW, how do I add on the column that shows for each service, what's the...

Is there a way for a query to recognize a text field as a date? My query: DateDiff("s","ExpectedDeliverDate","ActualDeliverDate") error: data type mismatch

My data is as follows: ShipDate: 2005-04-01 00:00:00.000 OrigZipCode 054 DestZipCode 054 ExpectedDeliverDate 2005-04-04 23:59:59.000 ActualDeliverDate 2005-04-05 12:15:00.000 I need some major help. I need to figure out what type of product is being shipped based on ship date and...

Private Sub deleteimport() Dim strDelete As String strDelete = "DELETE Service FROM [UPS COM]WHERE ([Service] Is Null Or [Service] Like 'Tot';)" DoCmd.RunSQL strDelete End Sub I cannot get this module to run - It says "syntax error in expression". If the Service column is null...

I am currently asking the user for the file path location using the following code: Private Sub OpenOrders_Click() Dim strWhere As String strWhere = InputBox("Enter path and file name") DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", strWhere, True, "UPS COM Data!" End Sub Is there...

I am trying to import an Excel worksheet; however, if the tab has a space in the word, it won't pull in. If I adjust the tab word, it will pull in: Private Sub OpenOrders_Click() DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", "D:\Amy\ontime.xls", True, "UPS COM Data!" End Sub...

I am pretty new to VBA, in fact, I don't know it at all. I am creating a front-end database for the people I report to. I want them to be able to import a spreadsheet we receive annually with volume data. I want a form with a button (when clicked) allows the user to choose where the Excel...

How do I set up a table with the past 3 years and future 3 years of Saturday dates?

I need help with creating a query which produces how many minutes or days difference there is between dates formatted as follows: I need a query (no vba, etc.) 2003-10-07 10:30:00

Is there a way to "lock" the table to the slide? When trying to paste another table into the same slide, the previous table resizes itself to accomidate the new table and I don't want the old table to move at all.

I cannot add any text to the inside cells within a table that was sent to me in a Powerpoint presentation. Any ideas?

This is really a frustrating issue with this program. Who really wants to see decimals calculated from start to finish date? Is there a way to take these out? I'd rather it say 3 days NOT 2.68 days!!!!!!!!!!!!!!!!1

I'm new to MS Project and am taking over someone else's project. Why are some of there start/finish dates highlighted in blue on the Gantt Chart? I figured out the red highlight was past due that had not been completed. - but what does blue mean?

What code do I use if all the fields are the same type and just appending table(region0) to table (region1)?

I have a numeric field called ups_active I need to cut leading and trailing blanks from; however, my SQL isn't working: UPDATE r00_test SET up TRIM(STR (UPS_s_active =ACTIVE)) What am I doing wrong?

How do I set up my macro to automatically close that database and open a brand new database on my c drive to run another autoexec macro?

What do I name the macro to make it run automatically?

I want to create a query that deletes any phone numbers that DO NOT match area codes in my area code table. However, it's not working. For example it shows it will delete area code 413 but 413 IS in the area code table! SQL: SELECT Left([r00]![phonenum],3) AS Expr1 FROM r00, areacodes WHERE...

I am unable to fix my corrupt database. I've tried creating a new database and importing, compacting and repairing, jet compact program, save as dbf, etc. I cannot seem to query my table!! I have approximately 1.2 million records. I keep having "Record is deleted" error. Now I am...

I am creating hyperlinks in my file to link to another page inside the same powerpoint document; however, once I e-mail the presentation, the hyperlink doesn't work. When I go to edit hyperlink, the hyperlink has changed to a location on my hard drive (e.g. ../../Local Settings/Temporary...