Recent content by rochelle

I haven't tried it myself yet but have you looked at easyBASE? There's a downloadable version that should let you try it out. Let me know how it works out because it sure did look simple!

I converted a system from Access97 to Access 2000. Everything works fine for all users EXCEPT the ones who are on Windows 98. Their reports look fine in print preview but when they get printed, all the punctuation is missing. As you can imagine, that doesn't work too well for formatted currency...

Is there a way that I can use Exchange to see all the calendars and tasks of my team members AT THE SAME TIME AND ON THE SAME PAGE and also change their schedules?

One of your tables is pointing to a different database from all the others. If instead of selecting all the tables, you select only the tables that are all from the same database, it will let you repoint all of these tables in one hit. Open the Linked Table Manager and very carefully review the...

I have Office 2000 installed on my computer running under Windows NT. I use Access 2000 to open a read-only Access 97 application that has links to an Access97 backend database. The tables in this backend are being updated by a different Access97 application operating on the network. I can't...

Assuming the following:<br>Your report name is Project Estimate Report.<br>The record source for the report has in it a field named Project which let's you identify each record uniquely.<br>Your form is called Project Estimate Form and there's a field on it called Project that identifies the...

Hi Tmat<br><br>Try changing the query to be: <br>SELECT IIf([StartDate]&lt;[Forms]![AskYear]![BOY],[Forms]![AskYear]![BOY],[StartDate]) AS CalcStart, IIf([EndDate]&gt;[Forms]![AskYear]![EOY],[Forms]![AskYear]![EOY],[EndDate]) AS CalcEnd, 1+DateDiff(&quot;m&quot;,[CalcStart],[CalcEnd]) AS...

First of all make sure the form is open when your run your code and that there is data in the appropriate text boxes.&nbsp;&nbsp;You don't have to point to it in your code.&nbsp;&nbsp;Can you give me the exact error message you're getting?<br><br>One thing I would try is to paste the SQL into...

Why not change your inventory table so that the style number is made up of two columns: the four digit style number that matches the master table and another column that shows the color.&nbsp;&nbsp;Your key in the inventory table can be a combination of the two columns.&nbsp;&nbsp;You can make...

Assume your form is called A and you have two textboxes on it called [StartDate] and [EndDate].&nbsp;&nbsp;Change your SQL as follows:<br><br>SQL = &quot;SELECT Contacts.EmailName, Transactions.ShipDate, Contacts.Name, Contacts.Address, Contacts.City, Contacts.StateorProvince...

Why not change SupportTime to:<br><br>=datepart(&quot;h&quot;,[LogEndTime]-[LogStartTime]) + (datepart(&quot;n&quot;,[LogEndTime]-[LogStartTime])/60)

I created a table called Table1 based on your data.&nbsp;&nbsp;Then I created a form called AskYear with a textbox in it called ReportYear and I typed the year number into the textbox.&nbsp;&nbsp;I added two other textboxes called BOY (beginning of year) whose controlsource is...

Thanks.&nbsp;&nbsp;That will handle importing the file once it has been saved to a separate file location.&nbsp;&nbsp;But is there any way of getting to it while it's still attached to an e-mail?&nbsp;&nbsp;I don't think it exists as a separate file until the e-mail has been...

Let's call the textboxes containing the subreport totals in the two forms Sub1Total and Sub2Total.<br>Your main report textbox control source should be:<br><br>=nz([Sub1Total])+nz([Sub2Total])<br><br>I'm not absolutely sure this will work since I haven't tested it.&nbsp;&nbsp;Let me know if it...

In your query that is the recordsource for the form, create a calculated column where the Field is HoursOnly: DatePart(&quot;h&quot;,[DateTimeField]). (This assumes that the name of your field is DateTimeField.)&nbsp;&nbsp;<br><br>This will create an integer field of hours only called HoursOnly...