Search:

I get a lot of spam with the Subject "Re:"

the body of the email varies so I can't pin down a rule there.

The outlook rules only seem to allow a 'With [text] in the Subject'.

Is there a way...

I want to import styles from another document but can't find where they've hidded the old style manager.
Where the * is it?

The contols are currently grouped in Layout so in design view -

Select the control, right click>slelect row

Now right click again Layout>remove Layout.

The controls are now independent.

I really like the improvements in 2010. There is nothing I don't like about it.
I'm using the 32 bit version

Major Likes -
The ease of modifying the ribbon. You can put stuff where you want it....

It is entirely possible and indeed most probable,

This notebook is using MS security essentials whereas my PC was using ZoneAlarm.

I'll check it out, thanks.

Setting a forms modal property in design view is a waste of time, it just makes it hard to Switch from from view to design view.

And only opens Modally if you open it from the database window /...

Outlook on my laptop (Win 7 Office 2010) is not displaying images.

I've unchecked "Don't download pictures automatically..." in Trust Center settings and now there is no right click option to...

Thanks

If I grab a cell and drag it, sometimes Excell increments numeric values (even if they are on the end of a string) and sometimes it doesn't. Sometimes I want it to and other times not.

What...

Once you've done what John suggests then you can use a WHERE clause to show just mother with kids or mothers without kids
eg for Mothers without kids

SELECT * FROM Mothers WHERE ChildID Is Null

if you put

MsgBox Me.Name
in the open event it will display the form name

so as RetiredGeek suggest, passing either the name of the form from the Open event


If DoWhatever(Me.Name) Then

Hi Jason,

I guess you have a table with the template names in it.

Now add another table with a list of variables required for each template.

Now you can have a form where the user selects...

what do you mean "modify"

Do you mean you want them to enter a value for the variables?

Or do you mean you want them to be able to change the name of the field being used?

you might like to give your button a meaningfull name instead of just leaving it as 'Command92'.

try this

On Error Resume Next

Do Until Err.Number <> 0
DoCmd.OpenReport "Agent Report...

Contrary to what I previously said, and although I haven't tried it, you can have multiple criteria in the subform links if you separate them by a semicolon.
you may like to try that.

Does it populate the BCT when you select a system?

The before insert won't fire until you enter your first bit of data on the form.

if you need it to populate when you move to a new record then...

the variables should be module level not global as they are only used by this form.

Don't try and set the default property at runtime, it screws up in later versions of Access.

the code behind...

I actually put the code in cmdNew_Click not in the Form_BeforeUpdate event, see if this makes a difference.

strEBC_Code should be a module level variable and you should name it mstrEBC_Code to make this obvious in your code.

a better test for Not isnull(strEBC_Code) would be to concatenate the...

using the criteria when you open the form is the best way to do this, so stick with what you have. I assume [State] is a long integer? Just a tip but to make your code easier to understand you should...

or you can just open the query in code to run it but set warnings to false first to suppress the message.

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryAppendStuff"
DoCmd.SetWarnings True

You could try using the substitue command to create a Z drive. I've done this in the past and it works fine.

create a batch file on your desktop


subst z: "c:\my Documents"

When you run it...

You can copy the sql from the append queries you created in the QBE, wrap them in quotes and use them like this -


Dim strSQL As String

strSQL = "INSERT INTO Travellers SELECT People.*...

What about using a continuous form with combo boxes in the header for filtering and command buttons in the header above each column to sort. You can then track the current filters and send them to...

First you need to understand that dates are just numbers. In fact they are more or less double, so the time now is 40438.6782638889

Anything to the left of the decimal point is the day, the...