Replies

Thanks Peter. That worked great!!!

Thanks Hans. That was the problem..

Thanks that does work on the form but how can I have it subtract 1 from the value of the underlying table? This only subtracts the value when the form is open…

Your right ImportTemp is a Variant for a table named ImportTemp.

Thanks Charlotte. Good advice. I was able to get the help I needed from the AddNew examples in help. Thanks again.

Sorry to be so vague Charlotte. I mean sorting a table. I’m importing a text file into a new access table and I would like to see if I can find some code to index or sort that table.

That does work Mark. But what if the form and the field already have a record and control souce? Basically what I’m trying to do is if the user chooses the can have the fields on form1 populate the selected fields on form 2. Does this make more sense? Thanks.

Charlotte can you give me an example of how I could use the Nz function in the report.. I think that would solve the problem.

tried that with no luck.. Thanks..

I’ve experimented with the windows scheduler and it does work well but my users are completely clueless.. The whine and complain if the have to do anything.. I made a batch file that the user needs to run to update the database to a new version and they compalin about that.. I mean it is tough to type r:system.bat and the run command.. Sorry just venting.. But to use Scheduler I would have to go to each users pc about 30 and set the appointments.. Unless there is another way?

Hey Mark.. I messed with that a little.. I had it printing every 10 minutes or so.. Would you know how to make it print at a certain time.. Like 9:30.. I got this code from another post but it keeps failing (Run time error 13 type mismatch.. I used this on the ON timer event and set the Time interval to run every mintue but it failed..
From what I gather it should check the time see if it’s 8:00 if it is it print the report.. Don’t know why it failed though..

If Format(Time(), “hh”) = 8 Then
docmd.openreport “ReportName”,acNormal,””,””
else
exit sub

LOL!!! Unbelieveable!!! Thanks a bunch Mark!!! I can’t believe it was that easy again.. Your awesome!!!! I can go to bed with that load off my mind.. Thanks again Mark.. Your the man!!!!

Attached is a zipped Access 97 database I need help with.. The problem is with the detail section of the report called logsheet. If you double-click on the logsheet it will prompt you for Receipt #’s.. Enter in receipt numbers 1 through 30.. The report works well but as you can see the detail section run into the next page with out carrying over the Group header it is a part of.. Is the any way to tell the report that if the detail section goes to a new page to show the group header on page 2? Thanks for the help and if you can figure this out consider yourself a real expert..

thanks Mark.. works great.. what a simple solution.. never saw that feature before.. if you solve my next post then your tops in my book.. Thanks again..

I think I’ve had this problem when using the > or <. This will force the text field to either all upper or all lower case depending on what you use.. This is usually set in the default value of the text field on a form or in the default value of the underlying table. If this is set try removing it.. It may solve your problem..