Search results for query: *

Mike's response looks helpful, but I need to use a relative path name. Not eveyone that uses the application has the related files in the same place...Is this possible to do or am I dreaming?

I have figured out how to build a custom toolbar that opens tables, queries, and forms within the access database. But how do I program buttons that will open word and excel docs related to that database but not IN the database?? Thanks.

How do I prevent my numbers from rounding in tables, forms, and reports? I have specified standard format with 1 decimal place. However, Access keeps rounding up/down and giving me a 0 for all decimals...

Hi Gus, I agree with Pamela's approach, except why not even put checks and deposits all in the same table? You can use a unique identifier (such as check number and random deposit number) that can be used to group items on a report (if deposit 1 had 3 items, then label them all "1&quot...

If your numbers are in the original table, then you can sort the fields using the group/sort button/command in the report design view. This seems like the obvious answer, so if you have tried it already and it didn't work, I do not know...However, if your numbers are merely lables, then I don't...

Thanks for your help. I actually figured it out. If you make a field a hyperlink, then right click on the field in form/datasheet view, you can add a hyperlink. By choosing "objects in this database" (access 2000, the link is just a click away. So, you can link and launch any query...

A general cron entry goes like this: 05 10 Mar Mon command here hour=5 am day of month month day of week command To run every day: 017 * * * command Good luck. I don't know the backup command...you might consider "tar"ing all the files on...

I am an IT auditor myself and took a somewhat round about route to get here. I would suggest investigating 2 certifications: CISA-Certified IS Auditor CISSP-Certified IS Security Professional While this was not the path I took, they are certifications I am obtaining now and contain extremely...

Thanks, I will look into this, but I don't think this is what I want. There are no related fields in the two forms, which is my understanding of subforms...but agian, I will look into it. I have also run into the same issue in trying to link a form field to a query or table in the same...

How do I change the default folder for attachments in Microsoft Outlook??

Is there a way to link a form field for another form in the same database (similar to a hyperlink or OLE to another document)? For example, the first form is a table of contents and the second form is the first item in the table of contents (so you can open the second form without going to the...

I have designed a very eye-pleasing report in access. However, it must be exported so that Officers and higher-ups can read it (asking them to use Access is not an option). Is there a way to export the report, format and all? Rich text, text, and html disregard colors and backgrounds, and...

The "can grow" does work on the form. But my experience isthat you can only see it in action when you print the form...

Is there a way to change the font color on a single record for changes made to the text field (to track changes in form from year to year.) I coded the onchange event for a field and it did change, but it changed the whole field for every record. I just want a portion of the field changed and...

I used a combination of the suggested solutions to find a workaround. First, I entered text (NA) in all blank fields**. Then coded the following: if [field] = "NA" then me.field.visible = False else me.field.visible = True. end if Next, as Mike said, make your text boxes a height...

I have multiple records in my database, of which different fields for each record are null. I want the report to show only fields for each record that are populated. For example, fields: a, b, and c for records one and two are 1, 3, null and null, 5, 7, respectively. How do I make the report...