Search results

found this: http://members.iinet.net.au/~allenbrowne/ser-46.html

hi... i created a new form on a different version off access 2003 (diff computer). The same occurs - when using together they merge together and it looks like the screen is freezing. the flickering - well it flickers only when using a tab-control whether its style is buttons or tabs...

ive been doing some experimenting....... - using access 2003 - if i create a form and use a tab control, but set the style to buttons - the buttons merge together when selecting through them - if i create a file and load onto another computer with access 2003 - the...

Screen Flicker also to add to that...... since the upgrade. if i hover the mouse over the controls in form view the screen flickers.... i am not using any events which could cause this problem... ???

Hi I developed a database with some forms in access 2002 I have just upgraded to Access 2003 - Im having problems with all my tab controls - if i select one page, then another, and another... whether im in design view or form view the tab controls get messy.. what do i mean by messy...

Would I be able to deploy Access in runtime using the ADE provided by " Visual Studio Tools for Office 2003 Upgrade" i found it on amozon for £150 ??

Hey I already have proffessional 2003 - is it possible to buy addons... for the access deployment extentions i seen something in Visual Studio .NET 2003 Is this what i require - or can i get an alternative package cheaper ????

Sorry bit confused there..... so am I after 'Microsoft Office Developer' or can i use 'Microsoft Office Proffessional' ??

How much is that...?? Are the addins i can purchase for my Access 2000? rgrds

Hi I wish to package my database and deploy on a cd - as a runtime envionment - I have compiled the vb code and converted the file to accesss 2002 and as an MDE file - I have read some logs about using the 'package and deploment wizard'. I have an office suite with Access, Word, Excel...

i have designed a main screen - when i run the form and any events it 'runs' through ok. - is there another way to check whether it compiles? i have about 20 modules of code - for events and importing data. i know there are a few loose modules which i dont use. i guess i should clear these...

hey im trying not to panic here... all my code seems to run fine.. but it wont create an mde - i have never created an mde before. are there any special considerations - like eg. having a splashscreen/main menu launch on open ??

I have converted the database to 2002 - however.. I get a msg - "Microsft Access was unable to create an MDE" ??

Hi Im trying to create an .mde file from a database that appears to be in an Access 2000 file format. I get a message - saying convert to Access 2002.. Will this effect any of my vb code?? ?? rgrds

the table was only about 80 columns wide.. i tried to repair the database... no luck there so i deleted the spreadsheet and created a new one... this appears to have solved the problem.. Thanks

Hi I have used some code to export a query to a spreadsheet... For some reason i get the error msg "too many fields defined". I understand there is max number of columns for a spreadsheet - however, the data being exported does fit easily into a spreadsheet. (when pasted) ??? rgrds

Excellant - its working!! Thats helped so much - was planning on creating all the possible queries.. so thats saved so much time!!! rgrds

I have tried the example provided - however i get a compile msg... "User-defined type not defined" reffering to Dim db As DAO.Database ?? thanks

ive tried working this... but cannot get it working: getRowSource = me.salesbox.rowsource Set qryEx = currentDb.CreateQueryDef("", getRowSource) DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel19, qryEx, "C:\myfolder\exports\report.xls", true

- when exporting to a spreadsheet - can u only specify a saved query or table? - is it possible to export using a query select statement? - if not - is it possible to automate the creation of a query object - temporarily save the query object for refferal on export ??