Search results

Mark Knopfler, every day of the week!

I'm a guitarist, play in a band semi professionally.

Fantastic, thanks alot for your help!

Apologies, i know very little about vb coding. I've tried implementing "acCmdImportAttachExcel" into the onclick of a button, and i recieve a compile error, invalid use of a property. I take it the code im using as below is incorrect? Private Sub Command10_Click() acCmdImportAttachExcel End Sub

Just tried that code, and it says "you have tried to run an operation involving a function or feature that was not installed in this version of Microsoft Office Access" What am i missing?

Do custom menus display even if they're running a compatibility pack? If they do, then i will look down that route also! Thanks for your reply!

See example :)

Morning all! The title explains it all... I have designed a database that's being used by people in my team, however we have an issue with people using compatibility packs. Menus don't show up for some users, and these menus are vital as they need the "Get External Data" function. Does...

Personally, i'd use conditional formatting. But that's just me!

Hey there, Just a quick one.. Has anyone here ever used MS CRM Dynamics? I'm testing it at the moment, and wondering whether i can link external SQL tables into the CRM? I've done some research, and there isn't a clear answer. Thanks in advance :) Tom

Afternoon all! Just to re-open this thread... My project is nearing completion, and upon testing with live data, i've found that the query using the above criteria hangs. Not Between [grn]![goods]-3 And [grn]![goods]+3 I've tested a few variations of this, and it continues to hang. If i take...

A burpee starts off in a press up position. You then bring your knees to your chin, then back to the start position. Then you stand up, do a star jump. Finally, you bend down back into the press-up position. There are plenty of youtube videos to demonstrate this. Burpees are absolute killers...

Ah i see, my bad! Thanks to both of you for your help, is much appreciated!

When i try to use "or", it tells me that i have not entered the keyword And in the Between...And operator. Will the And keyword work? Or will i need to find a new code to include the Or keyword?

That worked great, thank you very much John for your help!

Hi John, unfortunately that didn't work. The syntax was valid, but it returned no records, when it should have. I'm a loss, is it possible?

Hey there, My query validates the Total from the Hold table against the Total from the grn table. I've got this working fine using <>[grn]![Total]I want to now add an allowance of (lets say) £1.00 either side of the Total. i.e. If a total in Hold is £25.00, and the total for the same...

The 100 day burpee challenge is tough, but a great workout! For anyone who doesn't know what this is... Day 1: 1 burpee Day 2: 2 burpees etc etc Day 99: 99 burpees Day 100: 100 burpees Bearing in mind i used to be an athlete for my country, trust me when i say this improves your core...

I've resolved this now, if you add in "<>[grn]![Total]" into the Criteria for the total, it will perform the action for all OrderNo's that match, but Total's differ. And if the OrderNo's don't match, it will skip it! Because this is doing a "to the penny" check on the totals, would there be a...

I have uploaded my test db for your persual. The tables of interest here are GRN and Hold. The \pq query is populating the pqreason field with an X, if the criteria is met. It is the criteria in the query that is incorrect. Currently, if the OrderNo's don't match, then it is STILL...