Search results

What happens if the state needs to be changed with only one image visible? Simon

Have you thought about evaluating the cost for each sale and storing it in the table. What you are trying to do retroactively determine the cost when it would be easier to do at the time of sale, particularly as the cost can be variable. Simon

An image does have an OnClick event and Double Click Event so you could use that but then you need ot inform the users that state the checkbox is in graphically. Perhaps if the checkbox is one state then the graphic is normal and the other state create another image with reduced opacity and...

A Barcode is simply a font so look around the web for a downloadable font (ttf). Simon

The real question is what is the total quantity of backorders that can not be supplied and then which orders that can not be fulfilled. Doing crosstab is fine but you soon need a a vey wide screen to see the information. Personally, I would produce two reports Total Stock Qty, Total Order Qty...

Create a Query behind your report 2 elements FullPath where the images are located. The dynamic File Name taken form the Data. Here is an eample: ImageFile: [Company Artist Directory] & [Artist] & ".jpg" Simon

You need to map the full filename onto the UrgentPicture control. Simon

You should really use a SiteID rather than description But try this: Simon

AfterUpdate Function ArticleAfterUpdate () With CodeContextObject If ArticleAttribute = "D" Then DoCmd.SetWarnings False DoCmd.OpenQuery "UpdateArticle", acNormal, acEdit DoCmd.Close acQuery, "UpdateArticle"...

Why. The image is perfectly happy being outside the database and then referential coding to render the image. Simon

Try: Arrange > Tabular and then if necessary Remove or Stack. The later makes a mess but generally I have found the association is impossible if the label is on the header and the control in the detail section. Simon

I'll try the short version using C:\Users\john.smith\Pictures\4.jpg as Imagefile Function GetPicture() Dim FullPath As String With CodeContextObject FullPath = .[ImageFile] If Dir([FullPath]) <> Empty Then .[ImageControl].Visible = True...

When you open a Form you can do this: Function Originals_DialogueCosts() With CodeContextObject DoCmd.OpenForm "Originals Dialogue Costs", acNormal, "", "[Orig Cost Old Stock]= " & .[Orig Old Stock], acFormEdit, acWindowNormal End With End Function Simon

My example works for any record, providing that is, the query and form Order is the same. You simply can't Double-click a record in one form and not tell the next form which record you are looking for. If it is a single record, when opening the second form you to create a filter with the...

Try something like this: Function ClientsInterestClient() With CodeContextObject DoCmd.OpenForm "Clients Interest Enquiry", acNormal, "", ClientsFilter, acFormEdit, acWindowNormal DoCmd.GoToRecord acDataForm, "Clients Interest Enquiry", acGoTo, .CurrentRecord...

There is lot you can do to help yourself: Going backwards: =trim(fieldname) gets rid of empty Address Lines. You could have more tables but to gey started: Clients Table Invoices Table Invoices_Items Table. On your temp input I have a flag updated. Set this to yes is the orders have...

This may sound a little wierd but I would create a combibox (hidden) with the office locations and when a location is click set the Location combi to the value that the office represents. Then add a filter to the report opening statement asking Office Location with the location of the main...

That does quite unusual. There is no chance that the Imagecontrol has a control source attached a data table? Or the Proerty Picture Type set to Embedded. Secondly which Image control are you using the Bound Image Frame control or the Image control? You should set just in the Picture...

Try two Functions: Function ImageGotFocus() With Screen.ActiveControl .BackColor = RGB(188, 232, 163) End With End Function Function ImageLostFocus() With Screen.ActiveControl .BackColor = RGB(255, 255, 255) End With End Function Simon

Go small and use Horizontal and Vertical anchoring. Limitations: Form: Horizontal or Vertical anchoring can cause controls to overlap. Continuous Forms only one control can grow horizontally. How it works take the example of Tabulated forms. The Tab Horizontal Anchor set to Both The Tab...