Search results

I have an MS Access Application (originally MSA2003 but now MSA2007) with a SQL Server Backend (SS2008). I created a simple entry form based on a table in the SS. It is based on a single table. There are several date fields and two memo fields (SS = varchar(2000) each). There are three drop...

I have a table with a Lookup field. The field is a text field and the lookup table for the field is like: PK Code Value -- ----- ------- 1 AA AA Value 2 BB BB Value 3 CC CC Value THe code is displayed in the table, but the field is bound to column 1. I then created a...

I have a client that wants boxes around textboxes on reports (Clients !@#$%^&*). I have set the border color of the textboxes to black and they show up just fine. On course with one exception. The fields have the cangrow property set and so one field with comments will increase in size. I...

In Access 2003 and earlier, you could place a form icon on the Toolbar and open it up with one click. This was handy to quickly redisplay the Menu. Have not be able to figure out how to do this in Access 2007. Is it possible and if so how? Thanks for the help.

my client has a MSA2003 database that they now run under MSA2007. Despite the documentation that MSA 2007 is compatible with the existing MSA2003 security, It appears that the System.mdw and workgroup admin functions have been changed significantly in MSA2007. If an MSA2003 database running...

I'm getting the message The OLE Server isn't registered. To register the OLE Server, reinstall it. I have tried to run regsrvr32 to resolve this issue but get the message The module “C:\Program Files\Common Files\Microsoft Shared\Triedit\Triedit.dll” failed to load. … The specified module...

I have just installed windows 7 on my computer and reinstalled Office 2003. I tried to download the Snapshot Viewer but it failed. I got the message that it needed the file A4561408.cab and that I should insert my Office CD in my Drive. I did, but neither it or I could not find this file on...

I trying to run an MS Access 2003 database in Windows 7. The database is very unstable and seems to run out of memory. Is it just me or is anyone else experiencing this type of problem too? Thanks.

I'm using a popup form to enter data in MS Access 2007. If I hit the save button to save the record and then attempt to edit a field, I get the message. Another user editied this record and aved the changes before you attempted to save your changese. I have code on the Form_BeforeUpdate...

I would like to get the Version of Windows using MS Access 2007 VBA. I have looked at earlier posts to accomplish this but I was hoping beyond hope that in MSA 2007, MS added this capability. Has MS added this capability in MSA2007? Thanks for your help.

I would like to expose the Navigation Pane when I run an MS Access 2007 database but hide it when other users run it. I was hoping for Application.SetOption "Hide Navigation Pane", true/false But Access doesn't like this. What is the code I should use? Thanks for your help.

I generate a dynamic set of checkboxes in Classsic ASP <input type="checkbox" name="cbx1" id="cbx1" value = "abc" > <input type="checkbox" name="cbx2" id="cbx2" value = "def" > <input type="checkbox" name="cbx3" id="cbx3" value = "ghi" > When the ASP Page is posted, I need to loop thru the...

I recently updated some A2K databases to A2K3 on a Vista computer. Suddenly all my databases were crashing and throwing wierd error messages like field '' not found and form '' not found. I tracked the problem down to the use of vbNullString. When I replaced all the vbNullStrings in my code...

I'm an experienced Access Developer but new to VB.net. I'm trying to figure our how and if VB.net provides the equivalent to Global Variables and Global Functions. It looks like I need to use classes but I can't seem to figure out how. I know I'm using the wrong part of my brain but would...

I would like to change the SiteMapDataSource and the Menu to limit user access to specific pages. I have created a textbox on my Web Page with a User Role. Based on the UserRole, I would like to display either the full menu or a limited menu. Any suggestions on how and where to do this?

I would like to be able to set the value of a field in a DetailsView. Like for setting field defaults and UserLastFirst = UserL & UserF. In some cases the field I need to update is in a Template. I would like to do this using VB.nete Does anyone know how to do this or know of a book that...

I'm creating a web site using ASP.Net 2.0 and trying to use Microsoft's RequiredFieldValidator on a page with a DetailsView. I open the page in Insert mode. I have a button to link to another page. When the page is opened, nothing is added, and I click on the link button, the Required Field...

I have a new computer with Vista Business and MS Access 2003. ALthough I'm not sure I have Access 2003 because it keeps blowing up with lugubrous error messages 1) Cannot find field '' 2) Out of Memory (I have 2GB and this happens with one dbs open) I'm dying a slow death due to my...

I was brought up to believe in Santa Claus and that DLookups were slow. I browsed last night and found many threads mentioning speed issues with DLookups. My latest project consists of upgrading a database written at a Client Site that is chock full of (you guessed it) DLookups. My normal...

I have a Form with Tab Contols. When I move the mouse over a label control on one of the pages, the form jerks as if there was an event on the mousemove event, but there is no code on the event. I have created a new test label control with no code on its mousemove event and it does it too. I...