Help

Navigation AddNew Record woes
Hello and TIA for your consideration. I have created several db's for a non-profit and they want custom navigation buttons to display "You are on the first record, last record, etc". With this ng help I've created code for all except the add new record command button. If I create individual sub functions behi... 2 Jul 2008 19:07

Incorrect display of values in Form !!
Hi, I have an excel file that I link as a table to MS-Access 2003. In the excel file I have a column called "Shape" with the following values: 805 603 402 603 1210 THRU THRU THRU It is saved in text format in Excel and is also set as text in the database. But for some reason it shows the values "THRU" c... 2 Jul 2008 17:03

Auto-fill Subform Reference
Hi, I have a subform in a main form. When I create new records in the subform I would like the Subform. [Issue Ref] to autofill with the MainForm.[Ref] It sounds quite simple, but ive been bustin my brains trying to get it to work with no success. Any help would be greatly appreciated. Cheers ... 3 Jul 2008 01:15

Need to change the table for bounded Forms !!
Hi, I have a linked table called tbltest and some bounded forms (which add, update, delete records) that were created using that linked table. For some necessary reasons I had to create another linked table called tblComponents and then I bounded the original forms to this new table. I did change the control... 2 Jul 2008 14:59

Chart problem
I am using a scatter chart on a form to show a map and points of interest that I want labelled. After a struggle I have loaded the map, loaded the point and from a recordset, copied and pasted the label information into column 3 of the chart's Datasheet. Set DtaSheet = Cht.Application.DataSheet For... 2 Jul 2008 13:57

How to export an Image field from Sql Server to Access 2003
We have a forms application that captures comments digitally entered by an inspector and saved as an image in Sql Server. The manager of this inspector wants to be able to transfer the data in Sql Server to Access 2003 table. However, when I try to export the data into an Access table and into an OLE field, the f... 3 Jul 2008 01:15

Matching the first 3 letters of the field
I have 2 tables with 1 field each the filed of the fist table has a 3 digit number stored as text and the field of the second table has a 6 digit number stored as text I'd like to select each 6 digit number where the first 3 digits match the field in the first table I'm not sure If I can use the "LIKE" ... 2 Jul 2008 12:55

long proccess time when sending SQL string to form record source
Hi i built a form that getting dynamic SQL string,the SQL string is placed in the record source when the form is opened. i notice when trying to reduce some proccess time from the form that it takes quite alot of time for the SQL string to be pass to the form record source i guess one of the reasons depend on t... 2 Jul 2008 11:53

Error when compact/repair on start-up
My client has asked if it's possible to Compact and Repair his Front End database programmatically. I remember doing this from a VB application about 10 years ago, so I wondered if it was possible in Access. The application is Access 2003 in 2002-2003 File Format. I've added the following function to the Fron... 2 Jul 2008 11:53

Yellowfin Business Intelligence Release 4.0 Announced to Industry
(CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst most of the activity in the BI space has been busy with merger and acquisitions, Yellowfin has continued focussing its efforts to develop web Business Intelligence soft... 2 Jul 2008 07:47