Search results

No problem, You've bailed me out several times. Thanks again for your help,

Sorry, I guess I didn't look hard enough. Thanks, Still learning...

I have a subforum and the default font is Arial 10. I would like to programmitically change that when the forum is opened. Any ideas how to do that? Thank you,

It took some playing but I think I have got it working. Thank you,

Is there a way to add an AutoNumber to a query? Since it is a query (rather than a table) the AutoNumber will always start at one and count up. Anyone know how to do this???

Wow!! Thanks guys, Have a great weekend...

I have a string where all characters are upper case. Is there a command to converall all characters to lower case except the first one. P.S. I also have strings with more that one word. Like city names i.e. PALM SPRINGS s/b Palm Springs. Thank you,

I use something like this If Me.RecordsetClone.RecordCount = 0 Then Do something like close the form, open a message box, both, etc... End If

Thanks, I'll give it a try.

If I understand correctly, I should be able to use DMin and DMax to find the min/max values of a field in the disconnected recordset?????

I have to read files names from a shared folder on the network. But only briefly to select the correct file, which will be based on the file name, which I won't know until I read them in. I would like to store these names in a (virtual table) recordset. Is there a way to create a recordset...

Awesome, Thanks Bob!

I tried Dim RetVal RetVal = Shell("C:\Documents and Settings\kennis\My Documents\speed_up_xp.pdf", 1) and I got 'Invalid Procedure Call of Argument'

I need to select the PDF based on the current record (the PDF name is not fixed). I believe I can select the proper file name (I think). But since it changes I'm not sure if a hyperlink will work. How would I shell?

Does anyone know how to open a PDF from Access?

Can I call this from the Main (non-popup) or do I need to execute it from a seperate VBA module?

Is there a way to force the saving of a record in a different form? I would like to update/save the record of a pop-up form from another open form.

The Business System we are on is a purchased system for construction companies. I am not sure how in deals with dates under the hood. I know that most of the older tables use dates like YYYYMMDD for Posting, Journal Enteries, etc.... I'm on the other end. Access front end reteriving and...

The data comes from a business system on an iSeries (AS-400 Main Frame) running DB2. Some of the date fields have been updated. Most are still YYYYMMDD format.

you could try this "CurrentProject.Path" This shows the path of the database so.... dim strFolder as string strFolder = me.MyTextBoxName mkDir(CurrentProject.Path & strFolder)