Search results

Just to let you know that I've found the solution now... I'd made I mistake in the module where I declared my variables thanks Mike

Hi Thanks for your reply to my post "adding tables to word docs". I'm finding you database incredibly useful! just one snag... I'm finding the following code throws up an error at the following line... Set BMRange = WordDoc.Bookmarks(strBkmk).range the error is 424 - Object Required I was...

Hi Can anyone help with this... I've want to write the contents of a table to a word document so that the information appears as a table in the document. The code below opens a template and writes each row from the table on a different line (fields on the same row are tab separated)...

Hi I hope the following question makes sense.... Does anyone know if the is any way of copying the contents of a table into a word document. I would like to do this in VBA so that when a button is clicked on a form this action is performed. Thanks for your help Mike Wood:confused:

Hi DCrake I've literally just posted a reply to the other thread! I've sorted it out - I pasted the results into one large text box and used the split() function with vbLf as the delimiter argument and put the results into an array. Thanks for your time + help! Mike

Found the solution!! used vbLf and it worked Thanks alot!! Mike

hi guys Ive posted it into notepad and get the following result: Still not sure how to refer the unknown "box" character to use it as the delimiter.... Anyone any ideas - this is starting to drive me crazy!! :D Mike

Sorry Guys - i replied straight from my email and thought I was replying to a later thread!! I've pasted the data into a text file and it looks like this: any ideas?? Thanks again Mike

Thanks Dee Cee Yeah - it works fine when pasting from excel, but I would rather paste straight from the NorSonic program that we are using straight into the form is this is possible (otherwise we would have to open excel too during the data entry process) Thanks again Mike Wood

Hi I've got a small problem with the parsing data using the split() function. The code below functions when the "PasteClipBoard" button is pressed. The code pastes the results in the box and uses the split function to put each value into 22.2, 32.1 etc into each field of the array...

Thanks... The list will be copied from excel like this 1 2 3 4 5 6 etc... Then (if possible) pasted into the form like this 1 2 3 4 5 6 etc... Each number 1, 2, 3, 4, etc will then be written to SEPARATE records. Hope this clear this up! Thanks for getting back so quick! MikeW

Hello Everyone I don't know whether this is possible but, I am creating a data entry form and it would be helpful to be able to paste contents of a column in excel into a field in my form (to save typing the data in cell by cell). Is this possible? If so, can you suggest how I might go about...

That worked! Thanks Kenn!

Thanks - code is: Private Sub save_Click() Dim dbCurr As Database Set dbCurr = DBEngine.Workspaces(0).Databases(0) Dim rsReportInfo As Recordset Set rsReportInfo = dbCurr.OpenRecordset("tblReportInfo") 'if report ID doent already exist then add the report ID If...

Hi I am trying to get my form to have a pop up box if there is nothing entered into one of the text boxes. I have tried the following code, but it doesnt seem to be working!? anyone any ideas? If Me.txtReportID = "" Then MsgBox ("Report ID field is empty. Please enter a new ID...

Hi I would like to use a combo box in a form, but would like to control the contents using VBA code. Im not sure how to get started - can anyone give me an example of how to populate a combo box from another table in the database? (I know that this can be done using queries - but I need more...

Heres the AddRecord Function: Public Sub AddRecord() Dim dbCurr As Database Set dbCurr = DBEngine.Workspaces(0).Databases(0) Dim rsTest As Recordset Set rsTest = dbCurr.OpenRecordset("tblTest") rsTest.AddNew rsTest("txtData").Value = Me.OuterBoard1...

Ok - I've tried that but its still not working!!! I wonder if its some sort of bug?

Thanks Ken a) AddRecord is a function that i have written to append the contents of the form to various tables... (ie data the user has entered). This function does what it is supposed to do and works fine... b) The idea behind closing the form is to save the data then close so that no...

Hi I have a save button on my form which when clicked adds a record to a form, then closes the form. I thought the following code would work: Private Sub save_Click() AddRecord DoCmd.close End Sub However, it adds the record and doesnt close the form... if I comment out the...