Search results for query: *

I have a data entry screen with two input fields SLS PROD There are six columns on the page SLS PROD SLS PROD SLS PROD SLS PROD SLS PROD SLS PROD When the subfile loads it load vertically. Subfile records 1 - 12 in the first column, 13 - 26 in the second and so on. But when the user...

I have a program that generates invoices. We want to print these invoices on forms that will be passed through a laser printer. One Copy White (Drawer 1) and one Copy Yellow (Drawer 2). We'll print one page from one drawer and then the same page from the second drawer with ONE print file...

I have a subfile that contains a numeric field that is 9 digits long. I want to be able to change the decimal positions "on the fly". If a user select type 1 I want the numeric field to be 9 with 4 decimal places. If it's a 2 I want it to be 3 with 2 decimal place. Is that possible? And if...

When display an input screen how do I position the cursor to a SPECIFIC field rather then the first input field on the screen? This is standard screen not a subfile. Thanks

I have a Windows 2000 server that runs DHCP. If ANY computer attaches itself to the network this server will give them an IP address. Is there a way to only allow domain computers to get IP address from this server? Or a way to block a specific computer name or mac address from getting an...

I use lansa to create my fields and files. Lansa does NOT support date fields (you have to create virtual fields that only work within lansa) I have a file with a 6 digit numeric field that I store a MDY formatted Delivery Date. I want to be able to make a selection from this file using this...

I have a Windows 2003 network with XP Pro Clients. I'm using Outlook 2003. We use an ISP to provide us with email. The problem I'm having is when a user changes his/her password on the network. The password field in outlook clears (even though the save password box is checked) and the user...

I have a date format that gives me Year and Week. I need to calculate based on that "date" the last Saturday of that week. Example 0515 is Year 2005 and Week 15. The last Saturday would be 04/09/2005. Does anyone have a technique that would give me my result? Thank you.

I have an entry screen where I would like to display the leading zero on a numeric field, but I don't want to show zero balances. What edit code do I use? Thank you.

I'm trying to design an application in Access that uses a touch screen. The computer running the application will not have a keyboard. On my form I have a couple of fields where the user needs to enter numbers. Is there an active x control (like the calendar control) that will display a...

We have recently replaced our laser printer that was used for payroll check printing. Was Brother HL-10V not it's a Brother 5170DNLT. When we print the checks the fonts are "super" large. What we discovered (through lots of trial and error) is if we DON'T print the PRE CHECK REGISTER it works...

I have a two column report which lists Ice Cream products sorted by size. The first group of products to print are size 36 and the rest are 37 and above. I want to print products with size 36 on one side of the report and then force all other sizes into the second column. I tried setting the...

I have an Access Module that imports a text file and then changes the data types of several columns. I want to change one of the columns to single fixed with 1 decimal place. I have the following code in my module: DoCmd.RunSQL ("alter table tbl_loadouts_worktable alter [Rt Code] single")...

I have the following snippet of code in one of my databases. When an option is taken from the menu I want to run a module that updates ANOTHER database's tables. Option Compare Database Option Explicit Dim dbs As DAO.Database Dim ShortHist As DAO.Recordset Dim WrkFile As DAO.Recordset Dim...

I have an accounts receivable file. The file has a field for storing an invoice date. But it's a NUMERIC 6 digit field (used to store in MMDDYY format). I want to use a sql statement to pull a date range using BETWEEN but I don't think I'll get the results I'm looking for as this field is a...

What's the best/easiest way to test a logical file to see if contains records. I have two files. One contains customer charges/credits VRFADJ and the other contains No Good Credits VRFNGC. Each file may or may not contain data. In my procedure(s) I READ each record. On the first read...

I have an SQLRPGILE program. In the program I have several SQL statements AND I call a service program that's in a binding directory named BINDPGM. When I go to compile the program there's no option to enter the binding directory BINDIR so I'm getting compile errors stating that there are...

We use an odd date format. Year Week Day YYWWD. I have four variables: CurYear 4 0 WeekOfYear 5 0 DayNum 1 0 YYWWD 5 0 Example Values: CurYear = 2004 WeekOfYear = 00019 DayNum = 2 I want YYWWD to equal 04192. I can do this using a couple of extra...

BELOW IS A MODULE I FOUND THAT PERFORMS TWO DATE CALCULATIONS THAT I NEED. DAY OF WEEK AND WEEK OF YEAR. I CREATED THE MODULE AND THEN CREATED A SERVICE PROGRAM AND INCLUDED THE MODULE. I THEN CREATED A BIND DIRECTORY AND ADDED THE SERVICE PROGRAM TO THIS DIRECTORY. I UNDERSTAND THAT I NEED...

I have two files. One is a full detailed file named OOVSH containing Route, Day Number, Product Number and Quantity Ordered. The keys are Route, Day and Prod Number. The other is an output totals file named WSX that will contain the summary records. I want to read through the input detail...