Search results

I had this happen when using an AC97 backend and a Ac2K frontend. When all users eventually had Ac2K installed, I tried to convert the back end and no convert option was showing. Presumably, one of the users had already (unsuccessfully and/or inadvertently) done so. My solution was to create...

This is the code Notes: Frame95 is option group Text19 is sum of items ordered on order subform Text104 holds shipping cost in table ==================== Private Sub Frame95_Click() If Me!Frame95 = 1 Then Me!txtOrd_Shipping = [frmOrderDetailSub].[Form]![Text19] * 0.1...

Frame is actually an OPTION group I should have been a little clearer. I have 3 option choices (1,2,3) and a default of null. Clicking the option box is supposed to fire a routine that performs calculations. This works if it is not a prior, immediate choice. If choice "1" is selected, then...

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...

I did have to rename the Hatten font I did have to do the renaming of the Hatten font to get the Access97 to run, but I did this prior to trying to re-install the OfficeXP. Most of the problems with the Office XP re-install concern missing functionality in the Word component.

You may have to UNinstall first-be careful My computer came preInstalled with Office XP (2002). I needed to add both Ac97 and Ac2000 to use for clients with those versions. To get them to work I had to uninstall XP and load the prior versions (97 then XP) in their own separate folders. They...

Thanks -- just what I needed This was just what I wanted. I had tried something similar from the open event of the report itself and kept running into just the problem you described. I just hadn't thought to use the line in the open report method on my calling form. Where does Microsoft...

I guess I meant to say print "preview" What I'm looking for is a way to automatically show the print preview screen display as two pages and 75% in the same way you can manually do it by clicking the 2 page icon and the 75% scale from the Access report toolbar. My rationale is that I often...

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...

Are you serious!! You have posted on this forum before. I can't believe that you are asking about a FE-BE split without looking at the hundreds -- maybe thousands --of prior posts on this topic. One last comment -- spelling counts! SEPARATE. There are many, many very helpful people on this...

Get paid for "scope creap" No matter how carefully you write your application, the client will want changes as he uses it, and will require support if problems develop. With an employer it may be difficult, but I always sell an application with an "add-on" to get paid a set fee or per/hour...

Work arounds Zip is best, but if that is impossible (no WinZip etc.), you can rename the files with an .abc extension, send them and then have recipient rename them back to .mdb. (.abc is not standard extension so it doesn't get blocked.) If it is being blocked by Outlook or Outlook Express...

Use autotab and input mask I use the following to rapidly input survey data from keyboard, but it might work with barcode reader as well. Benefit is that it goes to next field without need for carriage return etc. In the textbox that holds your input: Set Autotab to Yes Set input...

Reply not too helpful I like to use this forum to extend my knowledge on using Access for both my benefit and the benefit of others who may visit. I did indicate I could make a list by names with buildings, but I wanted to create an index of page numbers in a report. I can think of any number...

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...

Been there, done that I had a similiar situation - linked back end on the server, individual front end on the C-drives This worked fine until the school district this ran on wanted to make it available on all of the district computers (hundreds) even though there probably wouldn't be more than...

There's more to it unfortunately To Neileg: I agree that the form-subform would be a lot easier, but here is the problem. The "Titles" field are budget categories for a very large school district and there are hundreds and each differs by only one digit in a string eg. 2110-490-02-0012...

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