Search results for query: *

Suzie, Did you "cut and paste" accurately??? If so, could your error be syntax related?? 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...

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...

bpeirson Try this, it may be what you are looking for... There are at least 2 ways you can use to add a description to you UDF's, one is relatively well known, while the other is a simple but little known method. Lets use the better known method first. 1. Open up the VBE (Alt+F11) and...

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...

Some of this may help. It did for us. Checking the Automation Server The most common reasons for an error with CreateObject or New are problems with the server application itself. Typically, these problems are with the configuration or setup of the application. Here are some items to check: •...

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...

jsplice, 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)...

kaysweet, Some more answers, DSPFD (Display file desc.) In a CL program you can use... RTVMBRD FILE(MYLIB/AA) NBRCURRCD(&TOTALRECS) This requires the appropriate authority... STRDBG (as normal)... then use STRSRVJOB. The job must be active (or on hold) for you to service it. A simple...

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