Recent content by TonyLackey

SELECT DISTINCTROW Format$([amos_WorkOrder].[DueDate],'mmmm yyyy') AS [DueDate By Month], Count(amos_WorkOrder.WONo) AS [OverDue WO] FROM amos_WorkOrder GROUP BY Format$([amos_WorkOrder].[DueDate],'mmmm yyyy'), amos_WorkOrder.WOStatus HAVING (((Format$(amos_WorkOrder.DueDate,'mmmm yyyy')) Is Not...

The criteria is a value on another field, i.e 1-6

Hi, Sorry of this is a daft question but I’m not a regular user of Access. I have a requirement to sum a Value on a report twice, based on two different criteria and I’m not sure how to go about it. Have tried creating two queries but Access won't let me use both of them on the same report...

That worked, but next problem Cheers, That worked, but now it crashes at following line rst.Fields(Mid(myString, 2, InStr(1, myString, "_") - 2)) = Mid(myString, InStr(1, myString, "_") + 1) Will work on it, may ask for help later Thanks :)

Dim rst As DAO.Recordset Namliam, Thanks for your input.... Having the following error "User defined Type not Defined" As you can guess i'm not a VB programmer. Can modify code and fairly useful at using Access. Any advise appreciated.... T

Thanks That would be so useful. Appreciate if you could, i can then modify for other tables etc... Thanks :D

*0_ is always the begining of the initial data set. C = Component Table However, if there is no data contained in a field, then the representing column ID is not exported... (reduces file size).

Hi, I have the following Text file that can be extracted from our legacy system (see example below..) but it is extracted as a list. Is it possible to import this in such a way so that it is in a standard table foramt (accross)? Thanks in advance T C0_1000000ð860001 C1_*** M/T "SHIP" ***...

Hello again.... I'm trying to export data to excel and at the same time restrict the field sizes to match my table info. Is there an easy way to accomplish this without using code? Example:- My Query is exporting the following Fields CompTypeNo, Text, 30 CompName, Text, 40 LastReported...

Unique record identifier Pat, Thanks for you r help with this matter, i used the ALTER TABLE routine to solf my problem. Thanks for your help, it's appreciated Cheers Tony

Hi, I use access as a tool to manipulate data and then update our master database (Sybase). When selecting tables in the first instance you can select the "unique record identifier" and Access will allow you to update the specific data happily. If i send this database to a collegue in a...

Sorted ! When linking tables (seems to be Sybase specific) you must define the primary key for each linked table that you intend to update using Access. I tried this and it worked, Thanks for your help FoFa and Pat ! :cool:

Pat, Thanks for that, the unique key is CompJobID but still get the same error. Can you use this type of query in Access to update Sybase, one of our 'Technical bods' doesn't think you can? i.e Updating from a table external to Sybase. MOFE_LastDone_Engine is an Access table, AMOS_CompJob is...

Same error FoFa, Thanks for your response, i have tried modifying the code as suggested but get the same error. Any other suggestions?

Hi, Firstly i'm not an expert, so apologies if this is a dum question! I am linking Access 97 to Sybase via ODBC. Get the following message 'Access operation must use an updateable query'. I get round it by creating a new table in sybase and then running my query within sybase. Code...