Search results

Duplicating A Record Thanks David, Your guidance did the trick. Here is my working code for duplicating a record excluding the key field. Private Function Duplicate() Dim RS As DAO.Recordset Dim RsArray(254) Dim rCount As Integer, X As Integer strSelect = "SELECT...

Ok DCrake, I've gotten a little further. Private Function Duplicate() Dim RS As DAO.Recordset Dim RsArray() Dim rCount As Integer Dim X As Integer strSelect = "SELECT tblChemicalProperties.* " strFrom = "FROM tblChemicalProperties " strWhere = "WHERE tblChemicalProperties.ChemicalID = " &...

Copy & Paste A Record I guess I misnamed my posting. It should be "Copy & Paste A Record" or "Duplicate A Record". Thanks for your suggestion. I tried the button wizard, but I didn't see anything to accomplish this. I'm not sure what you are describing in your reply. Could you provide more...

I tried your code with some minimal changes and I'm getting a syntex error on the line code Set Rs = CurrentDb.OpenRecordset(strSQL). The ChemicalID is a AutoNumber field and I thought I made the where criteria correctly for a numeric field, but maybe not. Private Function DuplicateRow() Dim Rs...

Thanks DCrake for your suggestion. I'll give it a try. I think your idea of using arrays may be the way to go. I'm new to them and not too many users are familiar with them. I came accross some other code that I was testing too that deals with arrays, but I'm still going to try yours. Here...

Thanks for your reply. I'm trying to Copy & Paste A Row in Access 2007. In the code above, I don't get any errors, no response and no results. So I'm open to any other suggestions. In my database of chemicals, sometime I get new chemicals or waste chemicals with properties and components of...

I found this code somewhere, but I keep getting errors on it. Try it and see what I mean. Is anyone familiar with the Scripting Library and can you help me on this? =================================== Private Sub btnCopyRow_Click() Dim dict As New Scripting.Dictionary Dim ctl As...

I've adopted a programming style of switching between subforms, instead of opening and closing forms. Although I've linked between a main form and a popup form, now I need to link between opening and closing subforms. I've tried to use a global variable to store my key field's value...

HTML Editor Attached is an HTML Editor that I found somewhere. PC

HTML Editor Attached is a sample HTML Editor that I found somewhere. PC

You're rignt about normalization. I'm trying to make a quick fix to a db that I've already started adding data. My program manager asked for this change and I'm under deadline pressure. Originally, I had the two tables tblChemicalInventory and tblChemicalProperties. When I wanted to add a...

I'm trying to update a record in one table from data in a record from another table using a common field (ChemicalID). I don't get any errors, but the code is not udating the target table. Can someone help?Public Function UpdateInventory() 'On Error Resume Next On Error GoTo Whoops Dim Db...

Comments are welcome, but solutions are preferred. In fact, tested code proves to be the best answer. It is possible, because someone who knew the answer did help me. See code below. Public Function ChangeReports() Dim db As Database, c As Container, d As Document, r As Report Set db =...

I’m trying to globally change some of the properties of all my reports and I can’t get the code to work. Can someone advise me on this. See below. I get an error on the obj. ==>> Compile Error: Invalid Qualifier. =================================================== Public Function...

I recently upgraded to Access 2007, but I'm not familiar with all the advanced features. Thanks, PC

If I understand you correctly, everytime I enter data or print a report etc. that the database has to process the image module and refresh the image? Thanks, PC

Ok. I was able to get it to work; however, it still is dependant on an external image file. Is there a way to get it to utilize the image that I've placed on the form? Thanks, PC

I came across a module that I'm considering on using; however, I can't get it to work. It's called Image In Access Window and I got it from The Access Web website. I have some questions. 1) Has anyone been able to get this to work? 2) Has anyone tried to make this work with the image on the...

I've been trying to do the same exact thing with my reports. I've tried various approaches. Method 1: Import the MS Word form into Adobe Illustrator and then export it as in eps format. Then import the eps image into the reports background. Method 2: Select and copy the the report on the MS...

Can the space between characters in any word or numbers in a text field in a report be increased using code? I have Access 2K. Thanks, PC