Search results for query: *

...How is the statement built (i.e. hard coded or dynamically stringed together)?? The second line of your query statement that fails states... "*OR MHAGNT *EQ "23256L" *OR MHAGNT *EQ "23574K" *OR MHAGNT *EQ "23575W" *OR MHAGNT *EQ "23576L" *OR MHAGNT EQ " The very last "EQ" should be...

irethedo, Is someone else in the database? Or do you have another form already opened? When you close the database does the .LDB get deleted? I had this problem once, no matter what I did I could not get rid of the error. So I created a new empty database (not a copy) and imported evrything...

Another way... You can see that the user defined functions lack any description other than the unhelpful "No help available" message, but you can add a short description... Make sure you are in the workbook that contains the functions. Go to Tools > Macro > Macros. You won't see your...

...Module. 7. Simply right click on the name of your UDF and select "Properties". 8. Type a description for your UDF, then click Ok and then Save. ********************************** OR ********************** Here is the little known method. This is best done before you write your UDF. 1. Go...

pvcc, I ran into a simliar problem. It was related to the coversion of the JPG and the spooling size. Have a look at this thread In there you will find some code to covert the JPG to BMP on the fly. This should spool better.. Hope this helps. [thumbsup]

Opppssss... Sorry use this code. Dim dbs As DAO.Database Dim prp As DAO.Property Dim strTitleAddition As String, strCurrentAppTitle As String, strTry As String On Error Resume Next Set dbs = CurrentDb ' This changes the Title .. strCurrentAppTitle = "YourNewTitleDB" strTitleAddition = "" '...

ReluctantDataGuy, Here is a possible option.. Why not just change the Title Bar description. There are two properties you can change. The Title and or the title addition. If you use the title addtion, it will show up surrounded by "< >". Doing this will allow the users to see the info...

...resource file (Excel) has become corrupt. To test if a corruption has occurred, search the local hard drives to find all instances of Normal.dot or *.xlb. (Please note that if you are running Windows 2000, Windows NT, or Windows 95/98 with profiles enabled, you may find multiple copies of...

If I understand your request correctly... Your will find your answer HERE. Just use the code with your startup.. Good luck... [thumbsup]

Ramin, I had a similar problem... Start with this... Open the database on the machine with the problem. Bring up the VBA Macro Editor and check the References (Tools->References) for anything thats missing. The entry will be there but a message of MISSING will be beside it. Select it and take...

vttech, One suggestion is to store your pay periods in a table. then you can create a function that will look up the current pay period based on the current date. This way if you can control each period (in case they change).

Here is my 2 cents worth ... Since your application requires XP... I suggest you use MS Access. Access can then display a GUI screen for your prompting. Then use VBA (plenty examples on the net) to read the COM1 port. The data can we written to a text file (again simple examples on the...

Cather, You did not specify what version on OS/400 you are on so here goes... This is for version V5R3... Open the Information Center (or go online) Click "Printing" Click "Printer Device Programming" In the resulting PDF document, jump to page 207. You can do that by clicking on the numbers...

GSC, Here are a few... SendScheduler Sperryemail OfficeAddin SendLater I am sure there are more... Hope this helps...

Tee, Here is one that I believe would meet your needs. It is called Membership.mdb It is included with a book. You will find more info here. It includes some screen prints etc. Hope this helps.

Connie, If you have an Office XP CD (or an Office 2000 CD). I believe the installer is looking for vba6.msi. It should be located on the CD somewhere. Insert this CD when the installer asks for vba6.msi and see what happens. Browse to the folder on the Office XP CD where vba6.msi is...

Cather, What does your Printer file look like?? It should look something like this. A R TEXT * Sonoran Serif 12p A FROM1 20A POSITION(0.20 .50) A FONT(2304) A...

...Or you could use the File field API. This example (not mine) displays to the screen. You can modify to suit your needs. Display file A*%%TS SD 20050803 115601 E730BZ REL-V5R2M0 5722-WDS A*%%EC A DSPSIZ(24 80 *DS3) A...

...use a CL program with a DLYJOB command before calling the program you wish to debug. A note, if the program is an OPM program you can use.. STRISDB PGM(MYLIB/MYPGM) INVPGM(*NO) SRVJOB(*SELECT) It will allow you to select the job to service when you start the debug session. I hope this...

SusieW, Have a look here IBM. You can retrieve the column description using EXTCOLINFO. Let us know..