Search results for query: *

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.

...for this is if you must stay with Access is to clip the file into smaller pieces and create a database for each piece. Personally, since my backend is in Oracle, I would import the data into Oracle using SQL*Loader which handles text files very well. Remember, wherever you go...there you are.

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

...telco.spc.com ErrorLog logs/telco.com-error_log CustomLog logs/telco.com-access_log common </VirtualHost> #<VirtualHost _default_:*> #</VirtualHost> #<IfModule mod_perl.c> # #<Location /perl-status> # SetHandler perl-script # PerlHandler Apache::Status # order deny,allow...

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

You can't run a macro from a second database but you can run code from the second database by setting a referrence to it in the first.

What line of code is the error breaking on? BD42

This is just a hunch based on the information you provided so far, but it sounds like you might need to create a master cross reference table listing all the codes and their descriptions and join your code records to it. Cheers, BD42

You could import the text file without the defined import specification (all fields will likely default to text or number data types) and then use an append query to both format (using the Format() and CVDate()/CDate() functions; see help file for these) and append the records to your table as...

Nice! Bravo!