oil's articles:

Items(168) /17 Next >> Last >|

A2010 Data validation on a form 3 252 (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 A2010 16 40 (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. 0 40 (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

Linking an Excel file in Access with mixed data types in columns and #Num! 7 57 (11/3/2009 10:05:16 PM) comp.databases.ms-access I linked a speadsheet in an app and opened it and noticed I had some #Num! cells. I guess that called to my attention that there were number and alphas in that column and so the text values became errors. M... Salad

Multi-line heading on continuous form 4 61 (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 strings 3 33 (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 ? 1 68 (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 linking 0 37 (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 question 2 34 (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 ribbons 5 51 (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

oil's replies:

Items(2654) /266 Next >> Last >|

Error 7965 1 50 (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 A2010 16 40 (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 Question 2 42 (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 2010 61 53 (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. 2 50 (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)

Windows installer errors running Access 2003 MDE 3 64 (11/9/2009 7:08:42 PM) comp.databases.ms-access Hi, Now it is happening to another client all of a sudden. The last one had to reinstall XP to run our Access 2003 MDE. When they click on our icon, the Windows Installer program appears, then disappears and... emailaddyinsig (1895)

Combine many tables in to one large table 6 38 (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 text 8 47 (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)

AddNew 3 55 (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 #3 3 47 (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)