Search results

I have a report that has 2 fields of interest. One is [AmtChk] and the other is [CheckNum] (an alpha text field). What I want to do is set a condition based on the first letter in [CheckNum] that changes the color of the [AmtChk]. This is used to flag different accounts. For example if a...

I went to the Microsoft knowledge base (304408) and found a routine that automatically logs off users with a short warning. It works fine, but depends on the presence or absence of a small text file which is named chkfile.ozx. The file is referenced in a form timer function as follows: Dim...

I am preparing mailing label for a political campaign. On my list of voters, many times two or more people are listed at a single address. By consolidating the labels (and postage) I am able to save a lot of money. I have written a query to group these names into those with 1,2, or 3 or...

I have an orders database using Ac2K. Main tables are: tblOrders: Has OrderID which is autonumber, key index (no duplicates) tblOrderDetail: Has OrderDetailID --long integer Tables are related in one to many relationships on OrderID-OrderDetailID with both cascades set. Database is split with...

I have a table with the following fields for each record: StudentID CsrID Average FinalExam For most StudentID/CsrID there are two records, one with the Average and a null FinalExam, one with the FinalExam and a null Average. If there is no FinalExam, no record is...

I have an application running on a network with 5-10 simultaneous users. Main tables are "Orders" and "OrderDetails" in a one to many relationship with integrity set. For some reason (possibly network problems) a few "OrderDetails" got created without corresponding "Orders" in spite of the...

I have an invoice program that allows users to select a shipping cost option as a toggle in a frame object. When selected "On_Click", the percentage is used to calculate the shipping of the items ordered. Occasionally users will then add additional items, re-click the toggle, but nothing...

This seems easy, but I can't get it right. I need to find the DATE of the THIRD Wednesday each month. (Actually, it is for a query criteria that will return TRUE if Now() is a "third Wednesday.") The problem is that depending on the month starting date, number of days in month prior etc. this...

Does anyone know how to set up a report so that by default it prints to the screen at 75% with 2 pages side by side? I'm really looking for some VBA that fires when I hit my "Print Report" button on my form.

I have a database written in Ac2K. I have many Word documents in Word2K. I recently upgraded to Office 2003. Mail merge works OK in the old version, doesn't find queries in new. The difference between the 2 is this: When I open a “merge” letter they both ask for the data source. In the older...

I am building a personnel directory for a large school district. The booklet produced show names, addresses etc. and is sorted alphabetically within buildings but there are 8 different buildings. The whole booklet is about 30 pages long. What I want to do is print another report to include...

I have a budget application with two tables: tblTitles: TitleID (key long int) PastYrBudgetAmt CurrentYrAmt NextYrAmt tblDetail: DetLinkID (matches TitleID) DetailID DetailDescription DetailPastYr...

I have a database that essentially is a complete check printer and check register. I have a query (qryLastCheck) that returns the variable LastCheckNumPrinted which I would like to use as the starting point for automatically adding +1 for a new check. I also want to see this as a value on my...

I have a command button that runs an append query in its On_Click event. I need to make sure it is only clicked once. I've tried to make the button disabled or invisible, but I get the error message that I can't do that with the focus on the control. I'd like a simple solution that doesn't...

I am working on a school database which has two tables (tblStudents and tblParents). What I need is a field to link each student to his parents and each parent to their child. BUT, it's no longer one set of parents to a set of children. Many children have two (or more with foster care and/or...

I have just converted and compiled a major application from Ac 97 to Ac 2K. It has been installed on a network with linked tables on the network drive and front ends on individual computers. Users are getting 2 errors: Linked table manager won't open and many reports etc have "Unknown function...

I've searched the archives and a seemingly simple solution still evades me. I have a report that essentially prints envelopes and has one textbox, control source=fldZip, that prints the USA zip code (5 or 5+4). I want to also print the postal barcode on the line below based on the value of...

I have a combobox that opens when a form opens. It has a studentID (hidden) and an expression for LastName&Firstname as shown in this SQL. I have it sorted alpha on the names. When the combo opens it is alpha but shows the name of the Lowest StudentID. I would like it to show the lowest ALPHA...

I have an option group that adds shipping charges after all items are ordered. See below: Private Sub Frame95_Click() If Me!Frame95 = 1 Then Me!txtOrd_Shipping = 0 End If If Me!Frame95 = 2 Then Me!txtOrd_Shipping = Me!frmOrderDetailSub!Text19 * 0.1 'rem Text19 = total...

I tried to set up a 2 computer network at my house and somehow locked myself out of the linked table manager. When I try to link (or get external data) I get the message "You do not have access to the folder C:\Documents and Settings\Administrator\My Documents\*.mdb. See your administrator for...