Recent content by LuigiX

Hi This appears to be all written for XP. Can you suggest anything for 2000? Cheers Luigi

Hi I've got an open excel spreadsheet with a user form. The user form has a button on it that will open a browser dialog which allows me to select an access database. Once I have selected the database the full file path and name of the selected database must populate a text box on the user form...

Hi Thanks however I cant turn ref integrity off. It is third party software that cant be altered. I cant understand that even when I'm putting unique keys into asset_details, the id of the parent asset, I still cant do this. I have had success with one record however. Cheers Luigi

Hi I'm trying to add records to the asset_details table. Basically for every record that exists for a Switch (SWIT) currently I want to create a corresponding record for the parent asset, a switch site (SWSI). The primary key on the asset_details table is the Asset_ID so I would not expect the...

Anciento The query works well in SQL query analyser ie 2 rows for each asset, null or not - which is why I'm so puzzled. Actually I want the query to provide the data source to a report where text boxes exist for OWNC and OWNN, so that is why I've specified them in the 'select'. Access seems...

Anciento You are correct. I want the query to return both values for each asset, whether they are null or not (in which case a record will exist in the asset_details table). Thanks for your help. Cheers Luigi

join not supported - no progress Hi again I've tried the suggestions without success and made up a small database (this is attached) to illustrate the problem. The query works well in SQL query analyser but when I paste it into a new Access query in the SQL window I get the "join not...

Hi The following query works okay in SQL Query Analyzer but when I try to paste it into the SQL view of an Access query I get a "Join not supported" error. I dont think it like the left outer join. Actually I have aseries of left outers in the full query but I've abridged it. SELECT...

Hi I use my laptop to retrieve data from a dB over our network. This Access id constantly being updated and I want to save the latest copy to my laptop before I leave the office. I am only interested in data retrieval and dont need anything fancy like a wirless VPN. I simply want to save a...

Hi Ray Somebody drop a MOAB on my head! Ray you're a legend. That pesky null value error has gone, however the only problem that remains is that the report creates a new page for each record returned. I've got a 15 page report! Is there a property somewhere that I might have inadvertently...

Hi Ray (how did I guess this the first time?) txtDefectNo in the form does not have a specific format the table stores asset_defects.defect_Ref as a number the report code declares defectNo as a string Here's the report code I'm using: Dim defectNo As String defectNo =...

Hi Wayne Without a default value in the textfield of ="*" I get an "invalid use of null" error. Entering the wild card * into the textfield I get the first record only returned. Entering a valid defect no into the text feild I get the correct record returned. The problem is I want all the...

Hi Harrah Oops sorrry about that. I got your name wrong. Its Harrah not Ray. Thanks again Cheers Luigi

Hi Ray Thanks for this. It works fine except for one thing. If I specify a defect no that record is returned. However if I leave the default value in the field on the form as ="*", it only returns the first defect from the table. However I want all defects to be returned. If I leave the field...

Hi Here's the code exactly as used. It works for a specific work pack no but just doesnt like the wild card in the form ="*" If Cancel = True Then GoTo StandardExit Else defectNo = Forms![AM_asset_maint_form_EMS].[txtDefectNo] SQL = "SELECT...