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
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
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
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
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,
I want the value of href to be dynamically set. I know that the link address needs to be surrounded by double quotes but dont know how to do this when inserting it with Response.write.
Session("link") is www.google.com but it doesnt work when i click it. Any idea how to make this work...
Hi,
I'm trying to create a query based on the users input. However the query falls over if i add the value of Request.Form("SongChoice") to the query. The value expected in the query is a long integer. If i explicitly set songid to 6 in the code then the query works. I just need to know how to...
Hi,
If you send data over a network and it is broken into packets, is there a set size for each packet? Does it depend on the type of network being sent across?
Thanks
Millzy
Hi,
I am using TcpClient/TcpListener Sockets and C#. It works perfectly.
Except when i have a lot of clients trying to make a connection to the server at the same time.
Can i handle this with TcpClient/TcpListener, is there a way of telling it to queue up the attempts to connect rather than...
Hi,
I have a C++ client app on one machine and a C# app on a different machine and i need the client to access the C# server.
Can i use .Net remoting or does the C++ client create issues?
Thanks
Millzy
Hi,
I need to make my C# .exe run out of process.
I am using Excel to test. At the moment, if i open two spreadsheets and run the code, they create two different instances of the object. I want the first one to create the object and the second one to be able to see the changes made by the...
Hi,
I'm trying to write an Out of proc DCOM server in C#. I have the Server written, its now a COM object so thats done.b
Where i'm stuck is this. As far as I kmow, DCOM works by having a stub object on the machine that the server is running on, and then a proxy on each of the client machines...
Hi,
I'm trying to write an Out of proc DCOM server in C#. I have the Server written, its now a COM object so thats done.
Where i'm stuck is this. As far as I kmow, DCOM works by having a stub object on the machine that the server is running on, and then a proxy on each of the client machines...
Hi,
I have a timer control which writes to a file every 5 seconds but the application closes down before it gets to the second firing of the timer. How can i get the application to stay alive until the next timer interval comes around?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.