Recent content by adrienne_r30

Worked great! Thanks

Hi All, I am trying to open a report based on a calculated text box. The Calculated text box is, cmdLowFunds: IIf([sqlAvailable]<10000,1,0) which works just fine. then I have a button on a form that opens the report, the code for that is; Private Sub CmdLowFunds_Click() On...

I figured it out!! Wow that took some work but here is the code for anyone interested. I was missing the first line in the code: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tbl_PHOTO") .FormFields("fldPhoto").Result = "****"...

the above code was put into my already existing code in access. Since that code works just find, and is lengthy, I just added the part of the code that included the loop. It does two things; it will either do nothing, or (when I tweak it), it will output the first continuous record and wont...

Do you have any experience using this VBA? I have been at this all day and just can't seem to get it to work. below is my code: Set rs = CurrentDb.OpenRecordset("tbl_PHOTO", dbOpenDynaset) Selection.GoTo What:=wdGoToBookmark, Name:="fldPhoto" With rs Do While Not .EOF...

Sorry about the late Friday entry: I have a form in Access that I use to create a word document (I created form fields in word and filled them from VBA code in Access). Everything works just fine. Now I am trying to create a table in Word that's filled with my Access fields. I am having...

Solution: I tinkered around long enough and figured it out. If anyone would like to export more than 255 characters from an Access field to a Word form field, use this code in Access: .FormFields("Word_Form_Field_Name").Result = "****" Selection.GoTo what:=wdGoToBookmark...

I am using this code in my access code I have already that exports all of my other fields. I am having a problem though. it will only export 1000 characters of the first letter in my field, 'Bridge_Description'. I have been trying for a while to mess with this code to make it export the whole...

First off, not sure if this is technically a Word question or Access question, but I'll try here first. I have a form in Access where there are many fields filled in. I've created code that, once a button is pressed, it transfers those fields into a word document by finding the form fields I...

Hi all, I have a subform, based on a query that I would like to filter but can't seem to quite get it. I have three check boxes, 'Local', 'State' and 'Federal'. I want to filter the form so only the records checked 'Local' are shown. (I don't want to filter the query). I have tried...

Hi All, I have a form based on Table A. When a yes/no tick is clicked in the form, I want to delete a record from Table B. The tables are joined by ID numbers. Can any one help me with the VBA here. Can't quite figure it out. Thanks so much, and Happy 4th!!

Awesome, thanks so much!

Hey All, Quick question I hope someone can lead me to a good answer. I am using code to concat some fields in VBA. I have no problem doing that, it works perfectly. But I am not knowledgeable of all the inner codes to make the output appearance change. I know that's confusing, sorry, let me...

Not sure if I was totally clear on what I am trying to do or if I just don't understand the suggestions given to me. There is no filter on my forms and I have all of the information that I need in my forms. I am exporting certain fields in my form to a word doc. In the word doc I created...

Hey All, I have a form that I have exported certain fields into a word doc (it is up and running just fine). I created bookmarks in word and put some VBA into my access form, so when I click on 'Create word report' it pops up and automatically populates the record I am on. Here is the tough...