Search results for query: *

Hello I require importing unix format data files into Access for some data comparisons, however, the limitation of using Access is its inability to exceed more than 1.9GB. Some of the files I wish to compare can exceed 2-9GB. I do not have access to a SQL server which would be the preferred...

Hi On a report I would like to give a value of 1-30 on the first page, 31-61 on 2nd page etc. In otherwords each page break should be where it has reached 30, and then the next 30 be shown on the 2nd page. If I have 300 records in total then this should equal 10 pages with 30 on each, and the...

Hello We have a query which does not have Case When within the sql code. When we want to design view on this query we are shown all of the tables etc with the criteria in the pane window. However, if a query/procedure has a 'case when' statement within it, for some reason the design view and...

Hi If I run a report and then export that to excel then all of the excel file runs ok, with totals calculated. However, if I output the same report to excel 2003, I get an error when opening that excel file - File error data maybe lost, and any totals come up with N/A if at all. Can anyone...

Hello All Apologies in advance for this ambiguous request, but I am sure someone will have an idea of some solutions to this issue..please?? ;) we have a database designed in New Era, and the data is backed up to a Unix server overnight. This database and data is held on a Novell network. We...

Hello All Apologies in advance for this ambiguous request, but I am sure someone will have an idea of some solutions to this issue..please?? ;) we have a database designed in New Era, and the data is backed up to a Unix server overnight. This database and data is held on a Novell network. We...

Hello. scenario I have one form that has two subforms. I have a subform that looks similar to a datasheet, but currently it is in continuous forms format due to better formatting and ability to summarise this form. It has 30+ controls which fill the full width of a form allowed (hoping no...

Hello I have exported 30 records from Access into individual Excel files. I need to create a macro that will import each sheet 1 from these 30 excel files into one Excel workbook. Is this possible? Also, is there anyway that we can name the Sheet tab to be the value of the excel file we are...

Hello I have built a report within access that will output every record to an individual excel file per record. the specific report has two sub reports (3 layers) in total so the excel file output results in grouped format. However, the end user wants all of the records in one Excel Workbook...

Hello All I have a text file which has two fields, a unique number and a description. LogID, Description 1, "blah, blah (character return) ! ***" etc there are thousands of these unique numbers with free text descriptions of upto 255 characters. This has been downloaded from a business...

environment. an access 97 format database running in AccessXP on a peer to peer network. When users click on the Cross to close access, as opposed to the Close combo box corrupts their database. Ran compile and no errors. Checked systems files and there are two MSysModule tables, but cannot...

Hello I am trying to send an email using access. This email will have an xml attachment, the details of which will be the results of data in a form. I have created the code for the email, and to attach the file and this works ok. However, everytime I try to read the resulting xml file, i...

Hello Would like to know if it is possible to have a detail of a form (which is set as continuous form not datasheet) in alternative colours.. ie record 1 = colour 1 record 2 = colour 2 record 3 = colour 1 record 4 = colour 2 record 5 = colour 1 etc.? Many thanks in anticipation..

Hello I have created a duplicate record button on a form, but when I click it, I get an error message 'command or action PasteAppend isn't available now'. I am running Access97. I also have Access XP on my machine but runs from a partition drive. Anyone have a clue on why this is happening? or...

current code: Private Sub Form_DblClick(Cancel As Integer) Dim stAppName As String stAppName = "C:\program files\microsoft office\office\EXCEL.EXE" Call Shell(stAppName, 1) end sub however, i only want this to run if the file is not currently open on this machine.. how...

Hello All Please help. currently outside bodies use and need to keep an Access97 database. These users have different versions of Office products, and also use newer versions of access but arent allowed to convert their access version from 97 (their vb front end only accepts 97 format and is...

Hello I have an Access 97 database which is being used by remote users on their local machines/networks, all of which are using different versions of Access. I need to build a batch file which will repair this database but will remain as an Access 97 file no matter which version is repairing...