Search results

Sorry I was called away unexpectedly. Is this the type of think you are trying to acheive. Simon

Hi Gina I will try Creating a Form overnight. Simon

Somewhat the same principle. Create a Flag and increment it as each time segment is processed and show the SourceObject progressively on subsequent Tabs. Simon

This is just a simple explanation. On the Variants Table there needs to be Model - Lock Down the Variant to a Model. On the Interior Colour there is already the Variant. So after inputting the Model and Exterior Colour a dropdown Interior Colour with [Variant]=combiVariant That way only the...

To get around your problem of 50 fields, I agree put the main ones on a subForm. You could try puttting Fields on a pop-up dialogue like this, this is additional information relating to the Stock Record. Simon

Have you tried Arrange > Tabular and then setting the Buttons sizes accordingly. In theory the controls should shuffle along. Simon

I did see this when my mistake I used the Form Wizard and was left with a Line, I'm sure it was related to the Image at the top of the Form which was embedded so I removed Form Property Picture. Oh, I do love how MS is still in love with bitmaps when you can do this! Simon

Here is an example of a tabulated Form using this OnChange Event, There is also a Control [PageNo] Function ArtistsEntry_PageNo() ' This function is designed to speed up the Artists Forms, by making the History Pages and Consignments On Demand only With CodeContextObject...

Tty remiving the Picture from the Form Property. We don't do lines! Simon

An image is an just an Object and to be dynamic you have associate the Image file with an Unique Identifier from the RecordSet. The first step is to identity where the images are stored. Function GetPictureDir() As String GetPictureDir = "C:\Images\" End Function An inventory Record has...

Try: Function IsRunning() As Integer ' DoCmd.Maximize Dim db As DAO.Database Set db = CurrentDb() If IsRunningDDELink(db.Name) Then MsgBox "The database is already open" Application.Quit Set Application = Nothing End If End Function...

In a Query you need the full name of jpg file shall we call it the ImageFile. Two Parts 1) DirectoryPath eg: C:\Images\ 2) Employee Image ImageFile: DirectoryPath & EmployeeID & ".jpg" Create an Image with a Control Source =[ImageFile] Result C:\Images\1.jpg Simon

You could try Tabulated forms and show each sub-Form / report as you toggle between tabs. Simon

Why not leave the images as jpegs. I have over 20,000 images and these render automatically onto the form or report because the image file name is the Stock Reference. Simon

I still prefer doing Menus as Forms - no problem with upgrading. Simon

What do you call a Englishman with a World Cup Winners Medal? Grandpa! Simon

More than anything else spaces in record identifier is bad. If can mean end of field or create problems for web based applications. Emails may fail with spaces in the email header syntax. Simon

This looks like a parent child situation. Keep the student information separate and then pull the student into the referrals. Things like Address and Phone number remain with the Student Information. Your interest in referral and should not have impact on core Student information. If does...

We kmow that. But try creating another query using your co-joined information. There maybe a question of performance. Another alternative maybe to consider consolidating the tables with each source being identified. Simon

One does wonder if Px=9 then Merit and PX=10 then Distinction. Simon