Search results

This what I had on the Detail Section of the report: Function Exhibitions_PriceImageDetail() Call GetPicture End Function Function GetPicture() With CodeContextObject If GetPictureExist = True Then .[ImageControl].Visible = True...

I do find disconcerting that if succedd in this process you become a MCP. Didn't anyone at Microsoft realise that this can stand for Male Chauvinist Pig! I have only seen on job wanting MCP or Oracle's equivalent you became a oral contraceptive pill. Simon

You try setting a Flag = CurrentMonth and StartDate in your table. That leaves identifying the user. Simon

This is anecdotal as I can't remember why I implemented this but I think there was a problem with Too many databases are open! DoCmd.SetWarnings True Call Delete_WebOriginals DoCmd.OpenQuery "UpdateOriginals", acNormal, acEdit DoCmd.Close acQuery, "UpdateOriginals"...

You could try closing each Query after execution. Simon

Try Selecting ALL the Detail fields and their Header Labels on the Subform then: Arrange > Tabulated. The TickBoxes may not align as seen in your example. See what happens??? Also check anchoring. Simon

Why not try: SELECT [tblAnimal Setup].AnimalSetupID, [tblAnimal Setup].AnimalID, [tblAnimal Setup].AnimalType, [tblAnimal Setup].Group, [tblAnimal Setup].location FROM [tblAnimal Setup], WHERE ((([tblAnimal Setup].AnimalType) = cboanimaltype & "*")) and ((([tblAnimal Setup].Group)=...

SampleID or any other ID relating to the parent need to on each SubForm as it creates the relationship. Another example is flattening many records to one record and look-down into the detail rather than looking at data from the detail perspective and looking-up. Ultimately how do you want to...

A Tab is a method to show more information. If your research information is extensive you can break up the info onto different tabs or if there is information that should be grouped together for better organisation use tabs. For subForms there need to be a direct relationship between...

If your Groups are the same length then Group like cboGroup & "*". If no Group then all Groups or partial or full search on Group. Simon

Perhaps you could try activating the image gathering on Current on SubForm and On Enter Make the Image visible. Simon

Don't use bitmaps unless you are running Access below 2007. I shape the images exactly to fit even if you have to place into a image that reflects the size of the button. These are all jpg files on Button. Simon

You then have a Sales Tax Field and Value Field with a dropdown list and you pick the applicable Sales Tax. AfterUpdate you set the Sales Value to relevant sales tax rate either by setting if to the column in the sales tax combi-box or via a query that links the Sales Tax Table with the Invoice...

You need a Sales Tax table and this is where you made accomodate the variety of sales tax. then underneath that the components so that the bean counters know is how much tax to pay for type of sales tax. It is actually comparatively simple just another dimension within sales tax data...

I'm aware of differing GST and State or Provincial Taxes in fact Florida has scalular (bands) taxes. I understand the difference between Federal and local sales taxes. Even more difficult is Margin Sales on the profit of individual sales and then again Europe has specific Art taxes just to be...

It would be tempting to consolidate the tax rates combinations and then have a separate table with the components. The only problem is when these rates change. Simon

Alternatively, Create a dialog form with the additional fields that reflects information on the original form. Simon

If you put a Header and Footer on your report For ID and the signature in the Footer. The idea here is the only when the ID Footer is encountered that the Page Footer controls are visible ontherwise the ID header sets the Controls to being invisible. On the ID Header (if I remember correctly...

The simplest way is to change the Label to a Text box. Simon

Hi Paul, If you are using Access 2007 you don't need to store the bmp files. Simon