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

Hi its an access adp file over a SQL database. the error code which shows is as follows once we click away from the SQL pane: this design does not graphically support the case sql construct the sql pane is out of synch with the other panes does this help?

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

Hi yes the two underlying problems is the business objects download and then resending the data to different databases. I think that is what our IT support person was attempting to achieve with having 2 databases but instead of replication or triggers he went down the option of copy...

Hi Crowley I use odbc links when accessing the SQL database through Access or excel for MI/reporting, however, I am unsure if we can odbc link to Unix to source the primary data, have i picked this up correctly? I will ask if this is possible. Thanks. also, the purpose of the SQL database is...

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

Thanks a great deal... spent ages looking for right forum to post it to, this one was a tad more general so ended up here. will do now. thanks again Donna

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

Hi Steve, sorry, have found... having a dum moment. regards Donna

Hi Steve I've simulated it in a test database, but i cant find format freeze columns in either the detail format or in the form format. Where is Freeze columns as a property? many thanks Donna

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

I think you need to change the settings in the properties of the form. Change it so that Allow additions is set to no. This will then mean that they can only see the record you want them to see.

oh yes, i will give this a shot.. thanks again :) regards Donna

Hi Zathras No worries. the whole process from downloading from business objects into access, out to excel is long winded enough, which is why i wanted to keep manual interaction to minimum. this is to be done every month, and the case numbers unique every time. therefore an automated routine...

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

Hi this is the code i used for a similar purpose Private Sub apprnoprices_Click() On Error GoTo Err_apprnoprices__Click Dim stDocName As String Dim stDocName1 As String Dim stpsno As String Dim stLinkCriteria As String Dim strtitle As String Dim strmsg As String...

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 GeekGirlau Many thanks for pointing me in the right direction. I have amended your code slightly to strip out all commas within the string as opposed to only the 1st one, and then strip out all the other characters I dont need. this is as follows Sub ImportData()...