Recent content by maudedo

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