Search results for query: *

I have 2 tables, Price (Date, Price, SiteID) and Transaction (Account, Date, Site, Quantity). Price is updated periodically as changes occur, could be many days between changes. Transactions can occur many times a day. I need a query to match the transaction with the price for the date and site...

Please help me. I am having difficulty assigning values to array elements. When I use this method: Dim y y = Array(7,6,5,4,etc) I get an error when I try to compile, "Invalid outside procedure" I get the same error when I use this method: Option Base = 1 Dim y(4) As Integer y(1) = 1 I...

I'll start by saying I'm new at Crystal but have a lot of experience with VB and VBA. So, I'm using Basic syntax in 8.5 because that's what I'm familiar with. My problem is that I need to manipulate integers to construct an account number with a check digit at the end and all my numbers wind up...

I have been developing with Access 2000 for several years now and have an opportunity to do some SQL Server work coming up. I loaded the SQL 7 cd that came with my Office 2000 Developer's Tools to see what I'd be dealing with and found that I couldn't make the standard installation, only the...

I'm using Crystal 11 to query an Access 2k database. I have quite a bit of experience using Access and its built-in report tool but am very new at Crystal. The objective is to get a total of billable hours of several technicians. In the report I have a formula (@Money) to calculate the billable...

We have an inventory database that stores a record of each transaction using a number field called "audit_trail" which increments for each transaction. Each transaction also includes fields for the posting period which corresponds to the month (i.e. January = 1, etc.), the year, and a...

Dear friends, I am having a little problem displaying help in Access 2000. When I try to display help, I get the message “Microsoft Access can’t display Help. An error occurred and this feature is no longer working properly. Would you like to repair this feature now?”. I have tried to repair...

Hello, I'm building a payroll worksheet. Does anyone know where I can find the formula used by the feds to calculate income tax withholding? Also, is there a way to find the same for state taxes? Thanks, Bear

Hi, I'm having a problem with an error message stating that I have a .cancelupdate without an .addnew or .edit. First of all, that's not true and second, it crops up at strange times. I know you will want code, but believe me, you don't want to look at all the code I'd have to send to show...

Hello out there, Has any one been able to successfully use the html help API to make help topics available to users? I've followed the directions as given in the Microsoft Office 2000 Visual Basic Programmer's Guide that comes with the developer's tools. However, when I run the code, I get an...

I recently upgraded my laptop from Win98 to Win2K and now it won't let any of my other computers have access to it. There are no passwords anywhere and I have allowed full access from every wizard and dialog box I can find. Can anyone give me suggestions about how to let other computers have...

Hi, I am looking for an inexpensive laptop computer for my wife to run an Access application I wrote for her. My question is: What is the least powerful system I can use to run an Access 2000 runtime application i.e. what is the slowest processor and least ram I can realistically use. Thanks, Bear

Hello gurus! I just put a bigger hard drive into my Gateway Solo 9300. I now dual boot with my original Windows 98SE and Windows 2K Pro. 98 has no problem with the modem but 2K just can't seem to use it. I have tried many times to delete and reinstall the modem and after I do, the OS tells me...

Hello, I am doing a project involving formatting of a bunch of Word2000 documents. One of them is giving me a serious problem...I can't save any of my changes. After I make any change and try to close the file, I am prompted as to whether I want to save the changes I made. If I choose yes...

I have a database with clients being the main table. There can be several clients living at the same address. The total number of clients will be less than 500. I already have an option for data entry to add a client at an existing address that fills in the address and phone info to save data...

Hi! I do some Access development and keep track of my time and tasks with Outlook's Journal. I have created an Access application that accepts the Journal data and can print a report with details on my Access sessions. The way I go about transferring the Journal data is by choosing...

I have a field, Duration which contains a time value. However, the time can come in either as a number of hours or as a number of minutes. On my report I use an unbound textbox to display the time as hours derived by using Format(IIF([Duration] < 8, [Duration],[Duration]/60),&quot;Fixed&quot;)...

Hello I have two combo boxes on a form. cboResource is based on tblResources and has a ResourceKey column and a Name Column. cboTeam is based on tblTeam and has TeamKey and TeamName. When a user chooses a Resource and a Team, the Resource is added to tblTeamResource which has all the necessary...

I have to create a form that displays data from 4 tables, and hopefully allows users to update that data. I can get the data to display by basing the form on a query. However, all the text boxes seem to be locked and I can't create new records. My client would like to see all this data on one...

Hello, I have distributed an application and now find it necessary to patch it. Is there a way to use the Package and Deployment Wizard to do this so that existing data will be preserved? The data is in a separate, back-end database and the patch will go to the front-end. Thanks in advance! Bear