Search results

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...

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...

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...

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...

I have this code:- Function ChangeDate(adate As String) As String Dim t As Integer Dim num As String Dim num2 As String Dim zyear As String Dim yyear As String Set dbcurrent = currentdb() num2 = Right(adate, 4) 'This is assigning the last 4 digits in the number to...

Hi, I'm currently working on a project that includes migration from legacy systems, and as part of this will be conducting some data mapping. To create the mapping documents i would like to export the table properties, from Access to Excel. Fields required are, TableName, FieldName, DataType...