Search results

Thanks for that I will look at it. Initially it appears to be for the numeric keypad. I'm after the Shift and + on the main keyboard.

I am using keycodes to move dates in a text box forwards and backwards. Keycodes 189 & 187 represent the + and - on the QWERTY part of the keyboard. I want to use Shift and + but don't know how to get the two to work together. What I have so far is posted below. Private Sub...

Slightly different Slant. PicLocations holds the path to all of the pictures Members Holds member information MemberPics Holds the Picture Name. The Photo button only becomes visible if the member has a photo stored. Clicking the photo button then loads the picture form and displays the...

If the images are all in one folder it makes life easier. Put the image control on your form and update the image file in the On Current event of the form. I make a button visible or not according to whether the record has an image, this button opens a second form loading the image. This speeds...

Use the Insert Image control from within the toolbox. You can then use either Jpegs or Gifs. I store the pics in a folder and link them to the form by setting the path and picture name as the form opens i.e. Forms!F_MemberPicture!image1.Picture = "C:\Mi_Pics\image1.jpg" hth John

You could try the following: Filecopy from a to b Then compact b and remove the password at this time DBEngine.CompactDatabase YourFile, YourTemp, dbLangGeneral & ";pwd=yourPword", , ";pwd=" or similar

Excellent Thank you NZ works. Now why didn't I think of that:confused:

I have the following sql statement. strSQL = "SELECT RevEntry.OperatorID, RevEntry.RevTypeID, RevEntry.CampaignID, RevEntry.HolidayProgramID, " _ & "RevEntry_Sub.MemberID, Sum(RevEntry_Sub.Pax) AS SumOfPax, Sum(RevEntry_Sub.Bookings) AS SumOfBookings, " _ & "Sum(RevEntry_Sub.Revenue) AS...

Totally agree with Pat. You need to go the fe/be route. You can then test the fe where you are and know that you havn't missed anything out. Also if their data entry isn't what youv'e expected then that could lead you up a wrong path. In the short term you could use an access db and transfer...

This might be a slightly different approach but it gives flexibility on the sort order. You should be able to grab the data from your form using an SQL string shouldn't you?

I've looked at this facility before and got it to work. The problems encountered by users were: Changing screen res and alt+Tab meant other programs were not in the correct resolution. Some monitors would flicker as refresh frequency would need adjusting, particularly on tfts'. This lead me...

Yes you need Office 97 installed to use ADT 97

Thats better but technically it is still possible for 2 users to save and get the same number. Chance in a million but if it can go wrong it ..... I use the following: Public Sub NextInvoiceNo() On Error Resume Next If IsNull(DMax("InvoiceNo", "Invoice")) Then Forms!F_Invoice!InvoiceNo = 1...

With Developer you will create an installation image, which you can burn to CD etc. When you install this on each PC it will install the runtime version of Access 2002 along with your chosen options e.g. graph.exe. When you open your application it will use Access 2002 and not 97 even if both...

Fixed it. I've taken the SQL and used it to create a query, the query being the recordsource for the report. It seems to work fine with the limited data I've got, have to try it when several thousand records are in there. I'd still be interested to know why you can't change the recordsource to...

I have a problem with the code below. The sql statements work fine, the line giving me the problem is Reports!R_RevenueByOp.RecordSource = strSQL When I open the db and run the code it works perfectly. When I run the code for a 2nd time it crashes the db. It exits in less than 1/2 a second and...

Thanks all I think I'm on the right track now. It's amazing the little bits that bypass you. John

Probably, Can't see the woods for the trees at the moment. I have Fields for CompanyID & Revenue amoungst others, Sort Revenue Desc but limit the list to the top 5 or 10 determined by a control on a form. Could you elaborate a bit for me please?

Does anyone know of an easy way to set up a report showing the top 10 results only? I Can do this using the counter method and cancel event etc but the totals on the report footer sum all of the figures in the query and so are incorrect. I know microsoft document a Dynamic Counter but due to...

http://www.peterssoftware.com/ss.htm ShrinkerStretcher resizes datasheet view subforms as well as much more. I ran in to a problem when moving my presized db on to another PC. It did not appear to hold the settings on the datasheet view subforms, but you may have more luck. Any way it's a site...