Search results

If IsNull(rsEmailAddress.Fields("emailAddress")) Then msgbox "This Client does not have an email address etc etc." Else slEmailAddress = rsEmailAddress.Fields("emailAddress") 'Call the function SendEmailDisplayOutlook Call SendEmailDisplayOutlook(slEmailAddress, "Redwatch Invoice"...

Filtering forms on open can be confusing. I think what you're after is:DoCmd.OpenForm "frmRAW" [Forms]![frmRAW].Filter = "[frmRAW].[FID]= " & Me.FID.Value [Forms]![frmRAW].FilterOn = Truealthough I'm morbidly curious why you need to have two synchronized forms open to multiple records... can you...

The code for that smiley is ":D"... your connection string included things like "OLEDB:Database Locking Mode"

Heh, gotta love users... What happens if you add a dummy Click event? Me.SetFocus or something might be enough...

While true, a unique membership number satisfies the requirements of a Primary Key just fine.

Yep, events can be a little tricky to find at times (some are form-specific, some are control-specific). Glad you got it working.

Do you want to do it fast or right?

I think your computer is laughing at you... :D (you can disable smilies in the post editor, or wrap your strings in [code] tags)

Are you in Private Sub Detail_Format ? I've certainly used that to hide fields from printing...

When you say "I had 2 days of data in one table" do you mean it was twice as long as expected? That's an append, not an overwrite, and the solution is almost the same. :p Build a delete query "DELETE * FROM ImportedTable;" and run that as an earlier step in your macro (I don't do Macros so I...

This pseudocode assumes that you have a switchboard that your users will start your forms from. You should be able to use your existing Release form, just with a different filter. On your switchboard, build a new button. Call it buttonQA if you like.Private Sub buttonQA_Click() If...

Did you click the [...] button at the end of the Load event, before you copy-and-pasted? You have to tell Access that there's an event procedure to run, and if you just open the VBA window raw it won't always notice. Good news is you can 'associate' your pasted code with the event after the...

Is tblTransfer a table or a form? I hate Macros... (not your fault) Anyway, if this is a form you just need Subject = [Form].[comboMaterialSupply].Column(X) & " is ready for QA" If it's a table you can should be able to do it with a dlookup, but it will run somewhat slower.Subject =...

You're very close, but change the last line toHAVING (((Count(SkillList.CandidateID))=DCount("*","searchlist")));That way it will work if you're searching 2, 3, or 17 skills.

Post the SQL of the update query you tried.

Are you saying it imports as "TableLinkData1" instead of "TableLinkData" like you expected? This is a feature/bug. You should delete (rename, archive, whatever) the old table first before reimporting. If you're saying it overwrote without warning you first, I'd be VERY surprised. What version...

edit: hang on, that didn't work as expected.

The trick here is ColumnWidth = -2, which tells the datasheet to resize to Optimal. http://msdn.microsoft.com/en-us/library/office/aa224081%28v=office.11%29.aspx You can do this from Form_Load (you could write a loop, but for just three columns it's not worth it)Private Sub Form_Load()...

Just at a guess, is the Image set to Enabled=False? Nevermind, apparently Images don't have that property... Does the Image have a Click event associated with it (in other words, why are you clicking on it, or is it just blank real estate that you would like to be an easy place for users to...

No you didn't. You posted the SQL of your query attempt, which tells us SOME things but not enough to be truly useful. Remember, we're volunteers here, help us help you by being specific and complete. What does tableCandidates' structure look like? tableSkills? Also surely you also have a...