Search results

Thanks for the look John! First, there are 2 versions of this 2007 and 2003... I posted the 2003. 2007 has date picker built in....... I was looking at adding my Binoculars and lightning bolt when I discovered them missing from 2007...... But then a simple right click on any field allows for...

Well, a critique, or some suggestions for further improvements. This is the first DB I have ever done that has nothing to do with business! An Image Catalog DB. I utilize 3 interesting things learned here on the forum... One hiding the Access wrapper, two, using one form that opens with...

Thanks Paul, I'll give it a shot.

Paul, I think that is correct. So I would need to add that change to each "Case" statement? eg..... Case 1 strRS = "qry1" Textbox1ID.controlsource = WhateverfieldID Textbox2.controlsource = Whateverfield2 Using whatever field is neede from "qry1" ??

Working on a small DB, one form has 4 combo boxes to pick information. This will be choices, in each combo, that the users adds from another form. So what I am trying to do is use the same form for each combo but changing the source.. Something like this... Should do that... Public Sub...

Sounds like something has corrupted the form. Do you have a backup for the DB? If so, delete that one form from the current DB and import it from your backup. If not, your probably looking at reconstructing the form. Always a good idea to do periodic saves when working on a project. You'll be...

Thanks again Byte.... You are referring to the spaces between words in the path? I saw that when comparing paths that worked and those that didn't... You don't know how many hours I looked at different examples of this and NO ONE took this into consideration! Workin good now! Thanks again!

Your the man Byte!!!! Works like a charm now....With all programs...... Could you explain what the difference makes? Inserting empty string???

OK< I started this in another post, but it has come down to being a coding problem. So I thought I would post that part here....... I am opening a program via the path (photo programs) and also opening the image (also via path) As below Private Sub cmdRun_Click() On Error GoTo Err_cmdRun_Click...

I have several other photo programs that work fine.. on the developing system. I'm guessing they would also work on another computer..... But a few programs, won't open with the concatenated line......MSpaint, Gimp, and also Paint.net has problems..... stAppName = ([txtPathToProg] & " " &...

On this computer I only have ms paint and I added Gimp..... But I add path to program.... Add picture (works fine) But when I try to open it in paint it returns Paint error..... " C:\Documents.bmp was not found" ?????????

OK..... Thats what its suppose to do.. :) Now I just need to figure out why it won't on this machine.... If you remove the apostrophe from the Onload event of the menu, it will hide the Access wrapper too....

Mr B....... No missing references..... Simon..... Can you add a path to a photo program and open the photo in that program with the command button?

Title about says it!! This is a little DB for photos I am playing with... trying to incorporate all the fun little things I've learned from the forum.... A Photo program, a program that hides the Access wrapper, and a program that opens other programs.... It worked perfectly on my laptop during...

Thanks for the look Paul.... I think this one comes from not living up to my motto of "plan far ahead...VERY far ahead"...... I went back to step one.... One form. I'm starting from there. I'll plan out the whole app and continue. We'll see if I still have any problems then.... I already am of...

Bump....Bump.... Anyone?

HELP!!!!!!!!!!!!!!!!!!! OK....... I got the second part working...after I got home did a little tinkering to add some things...... So now when I go to add a new photo.......IT DOESN"T DO IT!! I have looked at this for hours.... The code is messed up someplace... But I can't see where!! Can...

OK got it......... You were close Paul!! Private Sub cmdTest_Click() Dim strFullPath As String strFullPath = ([txtAppName] & " " & [txtImagePath]) Call Shell(strFullPath, 1) End Sub This works fine...... I may post this DB after it is complete... I think it may be very usefull and havent...

Same thing........ No errors...... but nothing happens.

Something not there yet.......... trying ShellExecute..... Basically have this...... Private Declare Function ShellExecute _ Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, _ ByVal lpDirectory As...