I ask this question last week, but I didn't explain myself very well. I have a table with over 187,000 records. From Jan 2001 to today. This table contains...

Hi, On ms excel I have a sub to send a sql command to ms access Dim objAcc As Object Set objAcc =...

I have a main form and a subform Whe the subform is not showing any record I want to stop my code on the main form Private Sub Form_Current() 'Setup...

Hi, I have this query but is not working. SELECT BKAR_INV_NUM, BKAR_INV_SONUM, BKAR_INV_INVCD, BKAR_INV_INVDTE, BKAR_INV_CUSCOD FROM BKARINV

Public Function my_dates(the_date As Date) As Integer Select Case the_date Case Between "07/31/2005" And "08/01/2006" my_dates = 2006 case Between...

How do I create my autoincrement number? My Table main_index (AutoNumber), payee_id (Number), main_amount (Currency), main_receipt (Number) if my Last...

Hi I am using this code to send data into excel Set rst = CurrentDb.OpenRecordset("SELECT Temp.* FROM Temp;") rst.MoveFirst Do While Not...

Hi, I need some help here, no matter what I do I can not close the FS form. On my FS For I have on single text box (tlogin) and I am using the Enter event...

Hi, I am working on a Time Clock. I need some help to create two rouding functions. PUNCH IN TO between 8:00:01 to 8:14:59 ...

Hi, I have a table with the following fiels ID, Date, Time, Program, Status 1,11/25/09, 6:45 AM, 6261000, Send 2,11/25/09, 6:47 AM, 6261000, Send 3,11/26/09,...

Hi From this text "N:\1CNCACCESSAPPS\UMW\525\CASSTE0100" how do I extract: "CASSTE0100" or what ever is to the left of "N:\1CNCACCESSAPPS\UMW\525\" the...

Hi, Our Table (MAIN) has over 87,000 records. Here is the table...

Hi, I have two pieces of information Start_Date and End_Date I would like to populate a table with each single date between these values. Values:...

Hi, When I import a MS Excel spreadsheet using a "TransferSpreadsheet" macro, text data is imported as number: In Excel abcdf 1234567891010 Once in Access

Does the newer version of MS Access (2003, 2007) have drag-and-drop capabilities? Is Microsoft planning to add this feature anytime soon? Regards, Bre-x

The table in question have a Number Type Field, its field size is Decimal. It is posible to create a query like this: select * from mytable where myfield ...

Hi How do I set the a field default value? Dim var_empid as Integer Dim var_sql as String var_empid = 34 var_sql = "ALTER TABLE Local_gl ALTER COLUMN...

Hi, I have this sub on ms outlook. I saves an attachement then opens access. Why MS Access open then it closes. Public Sub import_supplypro() On Error Resume...

Hi, Why this sql script doesnt work? 'UPDATE COLUMNS DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE print_mainlines SET C1= (SELECT pt_l1 FROM...

Hi, Why this function is not working? If a time follows between 12AM and 3PM it should show Day shift, anything else Night Shift If Time #12:01:00 AM# ...