Recent content by QueenKirsty

brill! thanks vbaInet. Thank makes sense.

I want to export data from forms to excel. I can do the export to excel bit if I can get a copy of the recordset. I have a form with a filter (that the user can turn on and off) and I want to copy only the filtered data to the duplicate recordset but when I do: Set rs =...

Hi. I am trying to move to a particular record on a form where the form has a composite PK. The PK is made of 3 fields: ModuleID, Precedence and RecordTypeID I have always used docmd.findrecord before but I can't see how to do this with a composite PK. Any suggestions? Thanks Kirsty

Complete genius and total star! :) I had been searching this for hours!!! Thanks!!!

I have a form which can be in edit or non-edit modes. In non edit mode I DO NOT want the combo baxes to expand when clicked on but I do not want to disable them as the appear all faded and are not easy to read. Is there any way to make the combo box appear as normal but not expand when it is...

I have a popup dialog box that takes an input and then uses it to find a record on the previous screen. The code for the popup is as follows: dim searchTermGlobal as variant If Not IsNull(Me.inputTxt) Then searchTermGlobal = Me.inputTxt DoCmd.Close acForm...

Thanks HiTechCoach! That was exactly what I was looking for. I have fudged it abit to work with an .adp rather than .mdb and now it works beautifully!

Thanks! You're a star!!! :o)

Thanks Atomic_Shrimp. I see where you are going with this. OK. So following the general trend of advice, a massive db-wide search mightnot be practical. As an alternative, how can I replicate the inbuilt search that searches each form and moves to an appropriate record but instead of...

I understand that. Unfortunately it is not an unreasonable request. We have a very complicated database with lots of keywords and different IDs that relate to external systems so to be able to search everywhere for anything is useful. For example, if someone is searching for a particular piece...

I have been asked to create a "google" style search functon for my SQL server 2000 db using and access 2003 (.adp) front end form. I would like to be able to enter something into a text box and have all the records from different tables (where that string occurs in the record) shown in a popup...

I am creating an Access 2003 interface (.adp) for a SQL server 2000 backend and want to have some web browser-style features. I currently have a side panel that has the menu structure that can load various forms into a main panel but would like to have a tabbed pages feature like on web...

Excellent starting point! Thanks.

I have been asked to investigate replication of SQL Server 2000. We are looking to replicate our SQL Server 2000 DB for both a disaster recovery remote site backup (probably using transactional replication) access to the DB on a separate network without a continuous connection (probably using...

I have now solved the problem with a function to strip the serial number and a trigger to do the check. I have attached the code for anyones interest in the future. Thanks for all assistance given! FUNCTION Create function dbo.StripSerialNo (@MSerialNumber nvarchar(200)) RETURNS...