Is there a performance benefit of having variables dimensioned in the beginning of a function verses having them declared just before they are used? I am using VBA in MS Access 2003. Example, Function f(y As Long) As Long Dim x As Long If y <> 0 Then x = 1000000 End If End Function Verses Function f(...
I have an optional field in a database that I'm pulling out using a DAO Record Set. I need to check whether or not the field is set before I concatenate it with other fields. So far I have the following code snippet which I've tried with both Is and = (that's the obviously wrong syntax [[Is | =]]) to no avail. It appears that if I use...
Is it possible? If it is possible, how do I do it and is it problematic? ...
We are about to start a project which involves using a Sql Server 2005 with lakhs of records. In the past I have used NHibernate with good results. But now I am evaluating Linq to entity for the data access. I have these questions on L2E, How good is the caching that the L2E does compared to NHibernate (basically how is the performanc...
I am trying to make a small form in MS Access 2003 SP3, I use some function that some other people made and these function has msgbox in it. I would like to disable msgbox while I am running the form. Is it possible in Access to disable msgbox? ...
Can NHibernate be used as ORM tool for MS Access? We are using Nhibernate to access Sql Server, so wondering if it can be reused. If it can be used how has the experience been? ...
Hey, I've included an MS Access database in my WPF VB app, and I'm trying to link the data to an XCEED Datagrid. I have the following code in my testerDataSet.Designer.vb file which I assume is the funcion I should be referencing Public ReadOnly Property Contact() As ContactDataTable Get Return Me.tableContact End Get En...
I have a .mdf which I need to import into MS Access. I have read that .mdf is a Sql Server format so Access wont recognize it. But is there some way I can get the database created in MS Access. I am using Access 2003 and Sql Server 2005 ...
Anyone knows if it is possible to install Access 2003 standalone without the rest of the Office 2003? I seem not to locate my installation disks to test this out, but thought someone might have an answer... ...
Does anyone know of a web-based database system similar in function to Microsoft Access? Basically I'm looking for a frontend to an RDBMS that can be used to: create, modfy and delete database objects enter data directly into tables view data in a grid format easily create forms for data entry add programming logic behind such forms (...
I have a database that is locking mdb's and such that I'd like to backup. However the tool (I have the source) I am using opens the file before backing it up and finds that it is locked. Is there a way I can open it for read-only purposes? For reference the tool uses C# and .NET 2.0 (but can be updated to 3.5). ...
Hi I am trying to link an MS access mdb to my sql server 2005, the problem is that the MDB is located on a shared network drive which will require login/password. How do I pass the username and password into the "Linked server Access MDB" template? I assume I have to @datsrc parameter? ...
I want to get the name of user who have logged-in ,in the access vba. What is the best way to get it Duplicates of this question: Is there a way for MS Access to grab the current Active Directory user? Using VB6, how do I get the current user and domain on Windows XP? How can I get the currently logged-in windows user in Access VBA?...
I have a set of ComboBox's in an MS Access 2003 DB that are all bound to fields in a single table. However, the data that they allow you to select doesn't come from that table and instead comes from various other tables. This works fine for the record creation story but now I want to be able to edit the record retroactively. The probl...
There are Cognos PowerPlay Cubes (Cognos v7.3) which are distributed via Email and then stored on local clients. At the moment, users use MS Access as an interface to access the data and reports in the Cubes. Is there any other tool, application or programming language which allows to access the PowerPlay Cubes and the tables/graphs wit...
Can anyone please explain the following HAVING clause from an Access database? How can Format with all '0' ever return a string of spaces? HAVING Format([PerNr],'0000000') <> ' ' ...
I have a linked table in ms-access that pulls data from a mysql database. In it is a field titled 'job' that should have three possible values, 'Chairperson', 'Vice-Chair' and NULL. I have a local table I have titled jobs that has two columns, title and value. title|value Chairperson|Chairperson Vice-Chair|Vice-Chair Member|NULL It...
Hi, I need to calculate the backlog from a table: components(ProductId, ComponentId, Status, StatusDate) where ComponentId, Status and StatusDate are the primary key. ProductId is a foreign key. Example: prod1, comp1, 01, 05/01/2009 prod1, comp1, 02, 05/01/2009 prod1, comp1, 03, 06/01/2009 prod1, comp1, 01, 07/01/2009 prod1, comp1, ...
This seems like it would be a simple affair, and I am sure I have done this before, but it has been a while since I have done any UI programming in Access. What I need to do is put a button on a form to toggle between datasheet and form view for a subform. I have found a defaultview property, but nothing that looks like it would toggle ...
This should be easy but for some reason it will not work. I have a form named MainForm and the selection in the Option Group I want to select is called PickMe. I have a text box called TxtHere that I set to not be visible. I wrote this: Private Sub PickMe_Click() Me!TxtHere.Visible = True End Sub So it should set the text box to...