Search results

I woke up this morning with a brainstorm that when i tried it this morning, solved my issue. @Bilbo_Boggins_ESQ, i did try your suggestion first and still got an error, but i might have missed something. Because this forum is so great at helping and fostering the learning process I'll post my...

Windows vista access 2007 I've hitting a wall here. I'm populating a report with a query which pulls criteria from a form. When the 'run' button is pressed it opens the report, running the query, to filter the data. What i'm attempting (and it works if there is data present). The data is...

Let's just say that i 'overlooked' something....namely the name of the combo box i pointed the code to...I'm an IDIOT lol For those of you looking for a solution These are the ones that worked for me. Maybe someone with some more knowledge can say what one the 'correct' way is. 1 If...

Windows vista Access 2007 I can't seem to figure out how to test a combo box null value. I try: If IsNull(Me.cboManufacturer) Then MsgBox ("Please select category") Else DoCmd.OpenReport "rptItemCategory", acViewPreview End If This works if the combo box IS NOT NULL, but if null it...

Thanks for the response cronk. I know i didn't mention this before but i have done just what you have suggested. I have only stored the path of the file in the database. I have done this in a tblPhoto that is linked to the tblItem. I have an 'item entry form' where i can view each item with...

Hello, Access 2007 Windows Vista I have a DB where i keep track of family heirlooms and valuables. As part of that i've allowed for the incorporation of images, although not every item has a picture but some items have multiple images. Because i only have the need to see one image i have...

Access 2007 Windows Vista GOAL: Display linked images in image control, and to ultimately to export reports to pdf to share with family by email or to print ERROR: “There isn’t enough free memory to update the display. Close unneeded programs and try again.” I’ve created a DB for family...

having that copy of the manifest is really neat! I'm on the trail of a couple manifests myself as I have a few relatives that served as officers on both tall ships and steam ships that traveled around the world. Very cool

Was wondering if anyone does any genealogy? I have been fiddling with it off and on for a year or so. I think it's fun, but never ending!! But the history behind it all is fascinating.

Access 2007 Windows Vista Norton Anti-virus A week ago my norton anti-virus account ran out. I know, I know it's bad to have those things lapse. But, when it lapsed and i tried to open an Access DB it would really struggle. Many times it would time out and cause access to go non-responsive. I...

Windows Vista Access 2007 I have added a button to a form that would delete a record. This works just fine. I would like to add a confirmation that this is something that i'd like to do. I'm not sure if this is goes in the form forum or the or the vba forum? Thanks for any pointers. rob

I think your idea of creating a table for your image objects is the right approach. But I wouldn't create the records pre-preemptively. If it were me i'd create a subform situation where the master accession is linked to the child object (picture, pdf, document) in a one to many relationship...

thanks lagbolt for the response and info. I like your naming suggestions. Removing the OwnerID and StewardID and replacing with PersonID is a good idea. If i understand what you correctly, storing information for the two types of people (original owner and current steward) in the same table is...

Access 2007 Windows Vista I'm working on creating a DB that will help keep track of the family heirlooms in our family. I've built it around each of the 'items.' My question arises around the original 'ownership' and the current 'steward' for each of the items. The owner and steward would...

Genius!!! Back to work! Thanks :)

I'm pretty confident that I have solved this issue. I had to remove office, then remove objects from the registry. For those people frustrated with this issue in the future i've attached my notes that i used to solve the problem. Best of luck rob

Good morning all, Windows Vista Access 2007 Yesterday I put together a small accdb file. On my last form I clicked the subform wizard and i get this thrown at me (see attachment). I had been using the subform wizard on a couple other forms and worked fine. I opened up a old 2003 file of mine...

wow that is simple! thank you for the help. rob

Hello all Access 2007 Windows Vista I'm opening a pdf file that is external to the database and should always be located in the same directory. I have found the code that will open the file with a click event. Private Sub btnFile_Click() 'use command button to open pdf file 'need to get path...

thanks so much. I've been away for a few days now and just getting back into things. I'll take a look at your example.'Unique compound indexes' are new to me. I'll be looking into those. I'll get back on when i've taken a look at things. Thanks again!!!