Search results

I need to export a large text file to excel, as sequel server can't read the text file due to some unrecognizable character issues from oracle I am using acSpreadsheetTypeExcel12Xml in the VBA code, and the file exports with no lines visible in excel. . . acSpreadsheetTypeExcel12 gives an...

Hi Gina, yeppers. . . all my databases are in trusted locations. . . the error must be some sort of corruption issue during conversion, but I compact and repair all FE databases on close. . . have any other suggestions?? thanks in advance sportsguy

Public btn1 as Byte Public btn2 as Byte Public btn3 as Byte Public dtNow as Date Function StartDate(btn1, btn2, btn3) as Date dtNow = Format(Now(), "Short Date") If btn1 = 1 Then StartDate = dtNow Elseif btn2 = 1 then StartDate = DateAdd("d", 30, dtNow ) Elseif btn3 = 1 then StartDate...

you can remove the dtNow reference, in the Public and when set. . I was thinking that Date() = Now() sportsguy

accidently hit the submit reply button somehow previously Put this code in a module and then put the function in a query Public btn1 as Byte Public btn2 as Byte Public btn3 as Byte Public dtNow as Date Function StartDate(btn1, btn2, btn3, asofDate as Date) as Date dtNow = Format(Now()...

IIf([Forms]![Punch List Report Filter]![Past_Due]=1,"<Date()",IIf([Forms]![Punch List Report Filter]![Past_Due_Plus_30]=1,"<=Date()+30",IIf([Forms]![Punch List Report Filter]![Past_Due_Plus_60]=1,"<=Date()+60","*"))) Put this code in a module and then put the function in a query

Converted FE and BE to Access 2007 from 2003. Append query won't append to BE table as it did in 2003, error message unable to append all due to key violations. BUT i can copy and paste the output into the BE table from the FE database. . . what am i missing here???? thanks in advance sportsguy

FX table is about 10 rows, and i only use one row for every record. . . The table runs within memory ranges with FX for other queries. . . not sure why its balking at this query. . .

This query just totals about 10% of the 3.2 million records. . . Any suggestions?? SCB048M is a 631MB access2007 database. . . any suggestions?? other than windows 7 x64 which i need and have at home. SELECT PRODUCT_CODES.Market, Sum([Net_Revenue]*[US$Rate]) AS RevenueUSD FROM...

I have a newly created ms2007 access database. contains only data. i clear data from an external database. I open the backend data database, and close it to repair and compact to remove deleted data I add data from front end calculations, I open the backend database to review the data, and...

Its "stuck" back on the XP OS system, I agree with the fact that XP is opening a database with a higher level reference, but I have never had "unrecognized format" before. I hd just done an UPDATE on the Vista x64 system, and there were OFFICE updates, so potentially, a recent 2007 OFFICE...

Don't confuse Access XP (2002) with the operating system. The only difference is that I used the database on a Vista x64 system, and then back on an XP OS system. I realize that the OS should not matter, but that is the only difference when I saved the database thanks

Why do I need to back to *mdb?? Both systems are Access 2007 *.accdb, and the database was created in Access 2007 *accdb. what does *.mdb have to do with anything? I don't understand, you are asking me to rename the database *.mdb to be able to be opened by Access 2007? even though *.mdb was...

original database was XP created Access 2007.accdb I used the *.accdb database on a Vista x64 machine, now the same *.accdb database is in an unrecognized format by XP. . . Its not supposed to happen doesn't help! and i have switched platforms several times with no issues. . . any...

now the database format is unrecognized by XP access 2007. . . any suggestions or totally corrupted? have not had this problem going between OS platforms before. thanks in advance sportsguy

Like "*1083*" Or Like "*4048*" Or Like "*1083*" Or Like "*4049*" Or Like "*4050*" Or Like "*4052*" Or Like "*6001*" Or Like "*6464*" Or Like "*8602*" Or Like "*8603*" Or Like "*8609*" Or Like "*8627*" Or Like "*8628*" Or Like "*8629*" Or Like "870*" Or Like "871*" Or Like "872*" Or Like "873*"...

I can open the backend database in access 2007, i can open the linked table in the front end database. The backend database has a single table in it and the table is empty. I have repaired and compacted the backend db several times. I can't run an append query to the linked table, as I get...

SELECT [Car Hires].Hire_CarID, Cars.Car_Reg, [Car Hires].Hire_Start, [Car Hires].Hire_End, [txthire_start] AS StartRequest, [txthire_end] AS EndRequest FROM Cars INNER JOIN [Car Hires] ON Cars.CarID = [Car Hires].Hire_CarID WHERE ((([txthire_start])<=[Hire_End]) AND...

I keep getting an invalid database reference error message when closing and compacting a table and data only database. . . is that the result of moving 2007 databases between XP and Vista x64?? thanks sportsguy

SELECT BOOKINGS.strProject, PROJECTMASTER.prjDescription, BOOKINGS_NEW.P4100U, PROJECTMASTER.[T$CCAM], BOOKINGS.FacePrice, [FacePrice]/[P4100U] AS AVGFP, BOOKINGS.Est_Material, BOOKINGS.Est_Margin, [Est_Margin]/[FacePrice] AS EMP, PROJECTMASTER.INSTALL, PROJECTMASTER.[T$ITBP]...