Search results

The issue is not related to any other form I have open. If I open the popup form directly from the nav bar, I get the same problem. I get this problem is I call a function in another module or if I update some fields on the form in the Before Update event. If I do not do either of these...

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...

That gives me what I need.

THanks for all the help. I wound up testing and using vbaInet Post#6. It returns the data I needed, although I needed to add an instr to return just the version.

There appears to be a problem with the environ function. I'm using windows 7, but the function returns windows_nt. This problem was reported earlier in other posts.

THis appears to be returning the version of MS Access, not the version of Windows.

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 inserted the line of code. It ran but did not change the display of the Navigation Pane. Thanks.

THe database is an old MSA2003 database in mdb format. Sounds like I can't set this option programmatically. 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...

Thanks for the quick response. I had already discovered the resolution to my problem. Scott Mitchell mentioned it in his article. I set the CausesValidation property of the button false. Too bad he didn't mention this in his book !@#$% This worked like a champ. Thanks again.

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...

Furthermore the error messages I'm getting are ridiculuous. 1) I get a file not found message. When I click OK, the file opens. DUH! 2) I get field '' not found. Yet when I set breakpoints, the field exists and has a value. DUH! 3) I get Out of Memory when I open small database and I...

I'm really happy for you guys. However I have two new Dell Notebooks right out of the box with Vista and 2GB. I'm having problems with all my Access databases and when I load a client database on my systems they crash. The client databases were developed on client systems and developed by...

Are you aware that there are some issues with using Access 2003 with more than 1 GB? I'm using 2 GB.