Recent content by HitechUser

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.