Search results for query: *

Hi, I've just started working on an Oracle Database. Is there any way to view the relationships between all the tables? Thanks Millzy

Hi, I am trying to call an user defined excel function from MS Access. I know the WorksheetFunction call exists but what similar function can i use to call a function that isnt a built-in Excel function? Thanks Millzy

Hi, in a query i ask the user for a name ie [Please enter name] But later in the code i want to use this value. Does Access store this in a variable that can be accessed? So my question is, Can i read this value from my VBA code? Thanks Millzy

Thanks!

Hi, I'm working on an access db that someone else created. The developer was obviously trying to protect the database as he has hidden some of the menu options such as "View". Also the options under "File" are a lot fewer than normal. How do i get these menu options back? Thanks Millzy

Ok, the reason for the sudden growth in the workbook was this. I added a new sheet and one of the columns contained a formula in every cell of that column all the way down to the row 65536. It was really only required down to row 200 so i deleted the formula from all the rows below that and...

Good point. Is there any "compact Excel" function??

Would the size of the access db affect the excel sheet?

Hi i was working on a workbook that was 1MB when i started, now i've added a module of code, added a reference to Microsoft Access and added one new sheet. Now my workbook is 20MB!!!! Anyone know what could have caused this jump? Thanks Frank

Thanks, thats helped a lot. If i want to select * from a query, how can i pass in the required parameters for the query? Thanks Millzy

hi i want to call a macro in an access database from my excel vba code. is this possible Thanks

Hi, I've found plenty of articles on importing Excel data into Access but I want my excel spreadsheet to connect and use data in an access db, ie read and write. Do you know of any good websites or articles that can help me? Thanks Millzy

Thanks very much Replacing Null with Nothing fixed it Thanks Millzy

I'm trying to create an xml document using asp.net using VB. dim writer as xmltextwriter writer=new xmltextwriter("photo.xml",null) But I get this error from this code. i tried replacing null with System.DBNull or just DBNull but that doesnt work either 'null' is not declared. 'Null' constant...

What is the tag i need to add to an asp.net file for it to supprt classic asp?

Do you mean manually import the data or is there some automated way of linking to the access tables? Can it handle more than one sheets worth of records?

How can i "break" the csv file into two? do you mean manually?

The resultset returned from my query is 120,000 records. I need to automatically export this data to excel but since excel only handles 65536 rows, i'm in trouble.. Whats the best way to go about this? Thanks Millzy

Hi, Is there something like a pivot table that i can use in access to show a breakdown of the results of my queries? Thanks Millzy

Thanks emozley Thats fixed it Cheers Millzy