Search results

Thanks, I'll pass that info along to my IS people and see what they want to do. Interestingly, I e-mailed the db to myself and downloaded it to my notebook, and it seems to work fine there. But of course it isn't hooked up to the printer. :rolleyes:

I can print forms. I do have a default printer set up on my machine, and if I highlight a report and go to File | Print... the printer listed is my default printer (which IS available). So I'm stumped.

For some reason, the reports function in Access isn't working on my desktop PC. When I try to create a new report in design view or access existing reports (even in design view) I get the following error message: "There was a problem retrieving printer information for this object. The object...

Another aside: is there a reason why your court and youth court fields are text instead of number fields? You can't type into a list box, but you CAN type into a combo box. You may want to try that.

Hi Aaron, You'll probably have better luck posting the db than asking to e-mail it. You can decrease the size of it by deleting data from the tables and any forms that don't relate to your question, running a "compact and repair", then zipping it. It's hard to know what you're asking for...

I've been playing around with the database for a while, but I'm afraid I can't get the autofill to work the way you want it to. The correct syntax is: DLookUp("[MilageStop]","MilageTbl","[AutoNumber] = Forms![MilageFrm]![AutoNumber]-1") But I haven't been able to figure out where to put it so...

This should work - insert the following code so that when you open a new record, you set the value of your beginning mileage field to: DLookUp("Forms![FORMNAME]![END]","TABLENAME","[AUTO]=Forms![FORMNAME]![AUTO]-1") Insert your form/table names and the name of the ending mileage field. This...

trish, Yes, make sure that StudentID is on both the main and the subform. If you don't need to see it on the subform, you can set the field's Visible property to "No". That should take care of both your original problem and the new error message you're getting (I think the reason for that is...

The reason that you're getting that error message is because the value that you have for StudentID (FK) in your subform doesn't exist in the main table Student. Are you sure you're entering the Student ID in the main form before you try to add data to the subform? Also, the Data Entry = Yes...

I've used DLookup to do this sort of thing with pretty good success. http://support.microsoft.com/default.aspx?scid=kb;en-us;101081

Put the code in the tab page's "On Click" event property.

Remember that the only piece of data you're storing is the date of the request. Every time you open the form, Access will automatically subtract that date from the current date and display the result in a text box that isn't linked to the table. Also, if you change the date of the request the...

Yes, Access is case-sensitive.

Alix, The form isn't recognizing [Date of Request] as a valid control on the form. Are you sure that this is exactly how it's spelled in the Name property of the text box? I noticed that in one place in your post you capitalized "request" and in the other you didn't. Double check this and post...

Here's a partial answer for you - the code to compute the number of days between 2 dates is: =DateDiff("d",[StartDate],[EndDate])

I know this, hair - I just like to tease them from time to time. :D

Oh my Lord, you guys are like this even with a newbie in the serious forums? ;)

Alix, If what you want to do is display the difference between 2 dates, put an unbound textbox on your form and use the DateDiff statement as its control source. For example, if you want to display the number of days that have elapsed since an event, use the statement...

In the form's properties, set AutoResize to "No" and make sure Border Style is not "None".

Maximize On Got Focus.