Search results

Turn the Tables: Psychological Summary Depiction of everyone who has posted on this site's Thread "Are you an Atheist" :D

Theorem Proof of to apply Table Matrix from Vertical to Horizontal

Why Indexing Table Relationships should be applied to Movie Theater seating

Continue to the Table Join ... SQL joke

Oh snap! I was hoping it would be something challenging! Like some binary file in one of the photo objects, with encrypted usernames and passwords to offshore nefarious bank accounts.

Range("Q:Q").Select = Yes Don't think Select recognized a value. Give some idea about the goal. Is this trying to simulate a Form for someone to fill in?

That just anin't right! Almost sounds like a binary image is stuck in it somewhere. Open up a brand new Excel Workbook and name it so it allows macros. Check its size. A long time ago, there was a macro virus that didn't delete Excel, it made them so large instead. I haven't seen that since...

Even my Comcast email they claim is "free" with my $100 a month internet subscription has advertisements. Many of them are very irritating and insulting. http://www.wired.com/2012/08/exclusive-clip-branded-mind-altering-marketing/ The sci-fi movie Branded in 2012 was one of my favorite movies...

Great point mate! (instead of in-mate, is that where the term 'ello Mate came from?) Never mind, in the US, we have a place called Wyoming. ;) In one point of biblical times, they were given a chance to go to a Sanctuary. They had to live under the rules of the priests. They were allowed...

I only have a minute of two before an appointment. After attending several working demonstrations, this would be the highlight. AZURE uses SQL Server Native Client - The same code that I and others have listed for Linked Servers. Of course the DB connect information is a long encrypted...

Summary: So it worked, then behaved differently. This is why I keep a copy of each version released (and sometimes code between releases) Do you have a copy of your front-end from say a month before? Does the older version do the same thing? - if No - Then what did you change. It could be a...

On A4 todays date was added, on A5 tomorrows date, A6 the day after tomorrow, .... A29 28 Days Later (opps, movie name rights violation) Just small changes to your code, this ran just fine. Highly recommend you add Option Explicit to the very first line of code. Then use the Debug - Compile...

http://www.access-programmers.co.uk/forums/showthread.php?t=259139&highlight=priority While on a break, had to peek into the forum. The code to boost priority on the microprocessor thread is on the startup form. While the deployment is run on Citrix, the same code runs on the desktop during...

Yes, anything can be done. Would you upload a small sample of some general data to show what the goal is? Just guessing your goal has some business rules dealing with duplicates. A visual would be very helpful. :D

Working on a deadline, could you, would you please upload a tiny sample with just enough to get the point across? Thanks!

This at least causes the old records to show as #Deleted AND it automatically updates the OPEN TABLE!!! No error if table is closed. Dim acIsDeficientInRefreshingOpenTableAs Long acIsDeficientInRefreshingOpenTable= acTable DoCmd.SelectObject acIsDeficientInRefreshingOpenTable, "MyOpenTableName"...

Thanks, that does not work.

Right now, the local table must be selected and the F5 clicked to see the result Trying to automate the F5 refresh A local table is used to evaluate many records in a process. When a 2nd list box item is selected, there is vba code that 1 Deletes all records in MyLocalTable 2 Repopulates with...

Wow, so simple! thanks Added a column at the end of the Select IIf(([APD_FieldWorkDates]=30121),0,1) AS TopSort Then added at the end an Order By: ORDER BY IIf(([APD_FieldWorkDates]=30121),0,1); Since the SQL Statement is dynamically created with VBA Code, it will be right every time...

See Attachment: A SQL Statement receives criteria from the selections on two listboxes. In the first two Fields APD_FieldWorkdates is a PK long Autocounter The ID_Wells is a FK long Autocounter The query is based on a single table Listbox 1 chooses a specific record with a known...