Search results for query: *

I haven't seen this anywhere else, not sure why it doesn't work. I want to open a form with an underlying user table, then run a module to get the current username from the operating system, position on that user's record, then hide the form and proceed to a menu. This way I can refer back to...

I have a form for purchase orders and a subform with payments against the PO in the parent record. If a payment type on the subform is identified as a closing entry, a piece of code runs which verifies that the amount entered properly zeros the balance. To do this, I open a recordset of the...

I've looked at several threads and can't find the exact code to finish this. How do I move to a record on a form based on a value in a second form? The forms are not related, e.g. form/subform. There is a key field on the main form which also exists in the second form, but the records in the...

I have a database with a table of employees (key field Pay_ID) and a table of training classes (key field Class_ID). I'd like to create a simple form/subform where main form is the class (date, location, content, etc) and the subform would be employees in attendance. Where I'm stuck is I'd...

I want to do validity checking on a field on a subform, but am a bit confused about how to refer to the field in VBA. The main form is "Frm_Receipts_Header_Admin" and the subform is "Frm_Receipts_Detail_Admin". I created a module on the afterupdate property of the field "OL3_Code". In the...

I have a procedure which I have checked and rechecked for syntax, but when I try to run it I get a compiler error "Loop without Do". The proc populates a table for generating a report. Sorry for the length, but I didn't want to leave anything out. The code follows: Sub...

I have two current queries, one with employee info including sick time balance, the second with sick leave taken, linked one-to-many by payId. I'd like to combine these in a query that will show the employee's current balance. I used the expression builder to create: Sick_Bal: [Earned Sick...

Pretty new to VB coding. I am trying to create a VB module within an Access2000 database to populate a record in a table. This record will then serve as the datasource for a report. The requirements of the report make this too complicated to do within queries. My plan is to open a table with...

Using Access 2000 I have two tables that list empl. absences - Absences lists hours by date, Reasons lists a reason code, i.e. sick, vacation, etc. The relationship is many (absences) to one (reasons), that is a single reason may relate to an absence of more than one day. I have a query...

I have a report that prints from a form/subform. At this time, the report asks for a date to identify which record to print. I'd like the report to automatically print the currently displayed record - in other words, pass a parameter from the current record to the report. How do I set the...

I have an NT4 (SP6) server running an internet application. We bought it IN '99 with NT pre-installed from Dell and it has never been reinstalled/reformatted. Patching has been kept up-to-date until recently. Now when I attempt to install a patch (e.g. blaster worm fix) I get the message...

In trying to eliminate several popups asking for report parameters, I created a one-record table containing the parameters. User selects the item ID from a combo box (bound to a second table) and then enters the other parameters on the rest of the form. A button at the bottom of the form...

I need help writing a vb module that will open a table (Access 2000) and change the value of one field in each record. The field name is 'Include' and it is a Yes/No field. I would like a loop to change each record. I am somewhat of a newbie when it comes to vb code and the book I am using...

This seems a very basic function in Access, but I can't get it to work right. I have a form and subform, both from tables with a one-many rela. In the subform there are two fields, footage and mileage. I want the user to be able to update either field and the subform to then calculate the...

This is probably simple: I have a table of employee absences with a field 'absencedate'. There is also a table of annual pay periods with fields for period number and begin and end dates. I want a query to filter out absence records from previous years by using the criteria...

I've read numerous threads of XP users unable to connect to an NT4.0 domain, but have not seen my particular problem. Our domain is a single server domain on the same subnet. We use static IP addressing. When first setting up the XP-Pro box I join the computer to the domain and create a user...

I have a query created by the query builder in Access 2000. SEI is a table containing all employees. SAI contains absence info, including sick and vacation, etc. The query prompts for payid. I enter a valid id (the record definitely exists in SEI). The only records for the employee in SEI...

I have a form which pulls data from a single table. The user would like to have an add mode where it's not necessary to click the mouse between adds. In other words, after hitting <Enter> from the last field, the cursor should go to the top field in a new record. I expect what's needed is a...

Just starting out adding to VB code to Access 2000 apps, and I'm not sure how to do this. I used a query to populate a table with employees and their sick days, sorted by empl name, then by sick day descending. I'm only interested in the most recent date - the first record for each employee...

I have a user who runs an old DOS program on his networked XP machine, but is unable to print to a networked printer. The program is limited to print to the lpt ports. In Win98 printers could be 'captured' to printer ports, but I can't find the corresponding function in XP. I tried 'Net Use...