Search results

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...

Hi I tried the code in the report exactly as provided thus: SQL = "SELECT defect_Ref, Asset_ID, Mtce_code " & _ "FROM asset_defects " & _ "WHERE asset_defects.defect_Ref = " & defectNo & "' Or " & _ "'" & defectNo & "' = '*'" in conjunction with a default...

Thanks guys but still no go I've stripped the code down a bit to make it clearer. Have tried a default value of defect_Ref in the form of both ="*" and ='*' in conjunction with the following code in the report: If Cancel = True Then GoTo StandardExit Else defectNo =...

Gotta field in a form called txtWorkPack with a default value of ="*" gotta report that takes a big sql string that includes txtWorkPack thus str3 = Forms![NP_Work_Pack_Filter].[txtWorkPack ] then: SQL = "SELECT work_tasks.Work_Task_No, "note from luigi "heavily edited" &...

Paddy You are an absolute legend! I'm gonna open a celebratory can o liffy water in your honour! Better still if you're ever down this way let me show you some legendary kiwi hospitality Cheers Luigi

Hi Patrick Many thanks for your help but there still remains one problem. The report is displaying all the records when the OK btn is hit, not just the Browns Bay and Poroti ones. If the cmbLocation is not enabled it should just pass Browns Bay and Poroti. ???? Cheers Luigi