Recent content by BattleDroid42

Do the subforms contain a blank row for adding new entries or are they locked? If they're locked and don't show the blank entry row this may be why they're printing blanks. Remember, wherever you go...there you are.

You're trying to insert the time as text into a date field. Thus 'type mismatch'. This error message is always the wrong data type being inserted into a field. Try formating the time like this: CDate(Format([check_in_time],"Long Time")) Remember, wherever you go...there you are.

Are we talking about MS Access? Remember, wherever you go...there you are.

Use the DateAdd() function; see the Visual basic help file. Remember, wherever you go...there you are.

I would avoid using these functions because they tend to be slow. Relating the tables and summing the values in a query behind the report would be better if possible. Remember, wherever you go...there you are.

You could also use Tools > Analyze > Documenter. Remember, wherever you go...there you are.

You're correct in that Access cannot handle importing a file of that size. The file size limit for an Access 97 database is 1GB. I would imagine that Access is having trouble sustaining a link of that magnitude due to a ODBC driver limitation. The work around for this is if you must stay...

While this didn't turn out to be the solution your advice still helped me locate the problem because it gave me the idea to remove or toggle the vhost information. Basically I commented out each directive to see which one Apache would not start on. It turned out that Apache had a problem with...

The key to figuring out any coding problem in Excel is to record the steps you would take manually and then look at the macro code that's generated. You can add variables and expand the code from there. In general, if you can do it manually, you can do it in code. Remember, wherever you...

Are you importing to an existing table? Try to import to an existing table with that field set to text and see if you get the same results. Remember, wherever you go...there you are.

I wrote an article for SmartAccess (by Pinnacle Publishing) a few moons ago on this very topic. The article is "Send Data Without Attachments!" by Richard A. Hunt. I'm not sure how you can get a copy of the article though? Remember, wherever you go...there you are.

Set the default value property value of the field on the form to whatever you like. Also, depending on your purposes you can use this function to test if a form is open. Public Function IsLoaded(frmName) ' Determines if a form is loaded. Const conFormDesign = 0 Dim intX As Integer...

Greetings! Thanks for your reply! Here are the results: # tail -f /var/apache/logs/error_log & [Fri Jul 16 14:54:07 2004] [notice] child pid 1238 exit signal Bus Error (10) [Fri Jul 16 16:27:27 2004] [notice] child pid 2449 exit signal Bus Error (10) [Sat Jul 17 11:12:54 2004] [notice]...

Hi All, I'm running an Intel box with Solaris 8 and Apache. I have little knowledge of UNIX web hosting and inherited the box from former coworkers. The box hosts two websites which are currently down. The power recently went out and for some reason the httpd service will no longer start as...

Why don't you move the code instead of the data?