Recent content by JimH

Thanks Bob, That was exactly what I was looking for! thanks!!!!! Jim

I placed a long button on a form that on the mouse over event basically changes the caption of the button to read a record number based on the percentage the mouse is moved from left to right. Then on the OnClick event I move to that record. I would like to add one more line of code that looks...

This may not be what your looking for, but your table design is probably not exactly wriiten the best way possible. You might consider ExpenseDate Item Purchased Cost Then run your output grouping on all items purchased in any given month. HTH Jim

On a form I call for an image from a specificed folder outside access. Photo's vary in size from a few kb to over 1 mb. I use the Oncurrent event of the form to assign the photo to the image box. An access created progress bar automattically appears as I move from one record to the next. My...

Got it... thanks (no msg) used .lngview which handles 0-6 options.

Hello, I have almost got this licked... In Ken Gertz's code for calling the common dialog box four options for initial view are listed in the code: ' Views in the Office Find File dialog Public Const adhcGfniViewDetails = 0 ' Details Public Const adhcGfniViewPreview = 1...

Still Looking SJ - Thanks but I dont know the first thing about VB, VBA I do ok with, that is what I am looking for, but just about everyline in that code when pasted in Access is coming up with an issue. Still looking :(

Hello, I am successfully using the LaunchCD code to call a common dialog window. I would like to add a line of code to change the default view from FILE NAME VIEW to THUMBNAIL view. I have looked on the web and searched this site, but have not found it addressed. Does anyone know how do...

Disreguard Hello again, I hate it when I figure out my own problems. It is the lenght of the string causing the difficulties and not the network. Not sure what will resolvbe it, but will come up with a fix. thanks for listening... Jim

Hello, I am using a form which I had got from this site to Add/Copy/Paste folders and files. I modified the form to suit my needs and everything was working fine. I brought the database and folder containing reference material to work and set the folder(s) up on my net vice standalone/local...

Old problem, new twist(?) Hello, I am using a form which I had got from this site to Add/Copy/Paste folders and files. I modified the form to suit my needs and everything was working fine. I brought the database and folder containing reference material to work and set the folder(s) up on...

Nevermind, I had forgot to add a bit of code to make the table and if wasnt error trapped. Sorry

Hello! I am attempting to add a new section of code in an already exsisting and working unload event. This section of code was added immediatly after code which ran a query which created the tables I am now calling on. The tables are created fine, but the new code is not modifying the table...

Hi, You didnt mention wether or not your using a query to create your web page, if so, simply add another colum in your query: Right now you have: AutoNumber Websiteaddress Filename Change to: Desiredoutput: [websiteaddress] & [autoNumber] & [filename] Then, on...

For some reason I cant get the OR portion of this argument to work. The statement worked fine prior to adding the OR and all after. Thanks! stSQLA65 = "SELECT tblDuty.Pilot, tblMembers.Lname, tblAircraft.AircraftType INTO tblDailyA65 FROM tblAircraft INNER JOIN (tblMembers INNER JOIN tblDuty...