A2010 Data validation on a form3252 (11/30/2009 11:29:22 PM) comp.databases.ms-access I was wondering how a field might be updated in a form. This example is
pretty stupid but let's say you had an employee form with a termination
date field. In the BeforeUpdate event of the form I might ha... Salad
Question on Albert's video regarding A20101640 (11/22/2009 7:25:20 PM) comp.databases.ms-access In the vid Albert has on A2010, http://www.youtube.com/watch?v=AU4mH0jPntI, he placed the temp of the area on the page. How is that done? He mentioned a web control. Do you drag a web control to the form ... Salad
OT. Spellcheck this! Ded.040 (11/12/2009 2:58:37 AM) comp.databases.ms-access Something to amuse you regarding Office 2010...Office 2010: The Movie http://www.youtube.com/watch?v=VUawhjxLS2I ... Salad
Multi-line heading on continuous form461 (10/28/2009 8:23:34 PM) comp.databases.ms-access I have a form listing Part Number and Part Desciption. PartNo is a small field and description is a wide field. So I wanted my heading to look like Part Number Description instead of Part Descriptinn Nu... Salad
FindFirsting unique strings333 (10/25/2009 4:19:04 PM) comp.databases.ms-access I am wondering what methodology you use, if you use FindFirst, to find exact matches in a string. If one uses linked tables, one can't use Seek. One can't store different cases in a table and be unique. Ex:... Salad
Property sheet ?168 (9/22/2009 12:48:53 PM) comp.databases.ms-access Access 2003. I may design a form and have the property sheet open when I save the form. When I open it, the property sheet is open as well. Is this normal? In a form I might give the user the ability to fil... Salad
Encrypting a database and linking037 (9/12/2009 10:56:18 PM) comp.databases.ms-access I have A2007. I created a dummy database (BE.Accdb) and encrypted it. I then created a front end (FE.Accdb). I linked the files in BE to it. It prompted me for the password, I entered it correctly, then s... Salad
Encrypting data and networking question234 (9/11/2009 7:50:47 PM) comp.databases.ms-access I was asked to import some data from an Excel file into an Access table. Currently they use A2003 but want their main app ported to A2007. The Access app uses mdw security. The Excel file is in a folder... Salad
Do you use a tool for managing ribbons551 (9/10/2009 3:25:03 PM) comp.databases.ms-access If you are working with A2007, do you do any work with ribbons? If so, do you do it manually or do you use a tool? I found the following 3. Do you use any of these. Any recommendations? Or is manual the w... Salad
Error 7965150 (11/18/2009 10:13:47 AM) comp.databases.ms-access Hello, AfterUpdate event of ComboBox is resulting in error 7965 it is exactly in line with: "Set Me.Recordset = rs" code below Private Sub cboWYSZUKAJ_AfterUpdate() Dim cn As ADODB.Connection Dim rs As ADODB.... maciejfr(8)
Question on Albert's video regarding A20101640 (11/22/2009 7:25:20 PM) comp.databases.ms-access In the vid Albert has on A2010, http://www.youtube.com/watch?v=AU4mH0jPntI, he placed the temp of the area on the page. How is that done? He mentioned a web control. Do you drag a web control to the form ... oil(4032)
User Login Question242 (11/30/2009 7:14:18 PM) comp.databases.ms-access Using this method of creating a user login form: http://www.databasedev.co.uk/login.html is it possible to capture the username and have that information automatically inserted into a form? ... paladinfreelance1(2)
Access 2010 with Sharepoint 20106153 (11/7/2009 7:52:16 PM) comp.databases.ms-access I found this article http://sharepointproconnections.com/Articles/tabid/149/nodeid/1996/SharePoint-Wish-List--Does-SharePoint-2010-Deliver-.aspx Of key interest to me was these two points: "You can run S... bobalston9(384)
File Name problems.250 (11/9/2009 5:08:12 PM) comp.databases.ms-access Please help. I have a program that automatically runs each morning to pick up the latest fund information files from various companies. They all work except one that puts a 4 digit time stamp of when the file w... lhowey(116)
Combine many tables in to one large table638 (11/9/2009 11:16:07 PM) comp.databases.ms-access Thanks for any help on this. I have about 150 tables with the same datatypes and field names. I would like to, on a regular basis, create (or append to) a table which combines them all and adds one extra fiel... lackeysc(7)
Invoice numbers with text847 (11/10/2009 12:53:20 AM) comp.databases.ms-access I am trying to construct invoice numbers in the series D0000001/ D0000002 etc etc. I ma importing records to a temporary table and then poulating the invoice no field (among other things). The code I am using... gorsoft(29)
AddNew355 (11/10/2009 10:11:09 PM) comp.databases.ms-access Hi all I'm importing a txt-file to an SQL-server db via Access (linked files). I therefore use ado, with of course the addnew method of a recordset opened with CurrentProject.Connection, adOpenDynamic, adLoc... fdprojects(21)
Auto number #3347 (11/11/2009 8:22:08 PM) comp.databases.ms-access I have an autonumber field to generate a REF. I need to copy my table because of problem but when I do this I loose my auto-number ref, how can I get around this (some records have been deleted therefore can n... burnspaul(17)