Search results for query: *

There's and Access freeware program that does a great job...go to freeware and its the MDBTask http://www.pb-sys.com/

We have an Access Certified mail program and we scan certified mail cards and use Access with File Magic 5 Series. File Magic is a 32-bit file server document management software suite that provides capture, indexing, retrieval, editing, annotation and distribution of both paper and electronic...

Here's a Select example: SELECT [Sales Order].[Sales Order Number], [Sales Order].[Sales Date], IIf(Not IsNull([Company]),[Company],[Last name] & ", " & [First Name]) AS [Company Display], [Sales Order].Tax, [Sales Order].[Tax 2], [Sales Order].Freight, [Sales Order].Other, [Sales...

What type of query: select, make table...with an inner join? What are the table names and the fields you would like?

Aug 17 ok so no one has a generic payment plan in their database?... ah

get the developers version...from your title I think you want to just make it run time.

Hi, how do you relate the stored value from the Customer table with the SuffixDescription value from the Suffix table into the form so you see the related description(MR)? Customer table suffix this is foreign key to Suffix table (1) Suffix table...

Thanks, now my table lookup box for that field is MR and the field is still stored in the Customer table as 1; thats great...but on the form I am still getting the 1? I set the control source on the form to the Salutation from the Customer table?

Hi, table is Salutations SalutID is autonumber Salutation description ex. MR=1 MRS=2 from SalutID I store the 1 in the customer table for MR, In my form how do get the MR to show up instead of the 1? I just keep getting the 1 for the value. Thanks

Hi, what are you aging? Unpaid Invoices or just balance >0 from some field?, what is your table name and the fields?

Where does change in balance come from...what fields what tables...list the tables that you are using with the field names...please.

Sure...here is the info from my Finance Charge Default table that covers most of the questions. Minimum Days Past Due = 33 Minimum Customer Balance = 0 Minimum Finance Charge = 0 Number Days Between Charges = 33 Use One Month or...

It looks like its stored correctly to me...do you need it summarized for a form or report field?

Hi, in my Customers table I am converting certain fields into a new created field.<br><br>I created a select query that identifies the records and&nbsp;&nbsp;meets my criteria. I need to move/append them from the [Last Name] field to the [Company Name] field. <br><br><br>SELECT Customers.[First...

Start by using select queries getting the data you want...then you can add on criteria for what groups of past due periods you want 1-3 months 4-6 months, whatever.<br><br>You mean like this? I want to do an aging of inventory availability....&nbsp;&nbsp;<br><br>SELECT DISTINCTROW...

Can I use html and ODBC instead of Data Access Pages to eliminate the user from having to have the required Office Product installed on there PC; and still have them view the html)page? What would be the ups and downs?<br><br>Thanks

I don't think they round...I tried them both as functions in Access 2000, they are not allowed functions, don't know about earlier versions...as far as I can tell from what you have give me for fields and looking at your expressions...RoundCC is a supplied variable not a function. It seems as...

you sure it works they seem to be undefined functions...can you give us anymore information...like the tables that the fields are in and Data Types.

figured it out...for some reason I had set my table.billtype for a lookup...oh well

Ok thanks...I change the field names<br><br>BillNumber<br>DescriptionType<br>BillCode<br><br>I want to see these other fields in the drop down list from my Orders form but don't want to store it that way in the Orders table<br><br>Orders Form drop down -<br><br>Bill...