Recent content by AlohaMichael

I guess I need to clarify something. The above solution wouldn't work because each period is its own field. The field name list is: ITEM, YEAR, PERIOD1, PERIOD2, PERIOD3, PERIOD4, PERIOD5, PERIOD6, PERIOD7, PERIOD8, PERIOD9, PERIOD10, PERIOD11, PERIOD12 The values stored would be something...

I need to create a report where the user will enter in a date and then can see the quantity sold on their items from the prior 12 months. It must run under version 8.5. Setup Table has the following fields Year, ItemNumber, Period1, Period2, Period3, Period4, Period5, Period6, Period7...

Code I use all the time to grab the network login name. Doesn't show who is currently logged in though. Function GetUserName() As String 'Buffer size for the return string. Const lpnLength As Long = 255 'Get return buffer space. Dim status As Integer 'For getting user information. Dim...

The macro assumes the following: 1. Worksheet name is "InventoryPriceSheet" (without the quotes) 2. You list the Item ID's on row 5 in Column A 3. You create the button to run the macro on the "InventoryPriceSheet" worksheet 4. You know what a macro is 5. You know what Peachtree is 6. You own a...

DoCmd.GoToRecord acDataForm, "theNameofyoursubform", acNewRec You must have the form open for it to work. Since its a subform I assume it will be open.

This is related to topic # 767-878823 http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/100/pid/767/qid/878823 I want to be able to group on the Integer portion and have all of the related documents listed underneath. for example +17.000 17.001 17.002 17.005 17.006 but CR is...

Thanks mbarron. I was over thinking the problem. Val function is exactly what I needed.

I have a list of ID's stored in a string field in an sql database. (see lists below) I would like to use a formula to get the proper sorting. The issue is CR is sorting them like below. Default Desired Sorting Sorting RFIID RFIID 001.001 001.001 002...

DOH! I feel like such an idiot for not remembering that. Thank you for your help. Works like a charm.

You seem to be going about it the wrong way. I would think if you can create another table in your database and link the fields. IF you can't create another table you could try a select case statement Select {SOP30200.ZIPCODE} case 0121 : "Glenbervie" case 0122 : "Hukerenui" default ...

I do the same thing for AR Statements to customers. One variable in the report header looks like this: shared numbervar ar_intrate; ar_intrate := 0.12; second variable in the detail section looks like this: shared numbervar ar_intrate; shared numbervar int30; if {JrnlHdr.MainAmount} -...

Using standard version 10 of Crystal Reports. Database is Peachtree = Btrieve (customized) does not allow for SQL expressions. I have multiple companies in Peachtree. Each Company has its own set of tables. Table definition for each company are identical but are not linked in any way. I would...