Search results

Yes - this is it. The exact same thing happening to my co-worker. For those who want the short version: This affects Windows 10 update 1809 If you right-click on the database, you have the "Open" option and the "New" option. Windows 10 update 1809 defaults to "New" rather than "Open" --...

One of my co-workers is opening a database that several of us have access to. When he opens it, a copy of the database is immediately made in the folder. EG: User double-clicks MyDatabase.accdb -- immediately, a copy is created in the same folder called MyDatabase1.accdb (without the user...

Curious - since this thread has been going on for so long, has anyone changed their position on the topic since it was first introduced in 2008 (or since the time when you first read it)? If so, did this thread have anything to do with your decision?

Here are a few podcast recommendations - and acknowledging that sometimes the podcasts are hit-and-miss, I am specifying a particular episode of each...sort of a "if you don't like this episode of this podcast, no need to try any of their other episodes - you won't like it" -RadioLab: Season...

Quick update on how I solved this: In Group Policy Management - navigate to: >User Configuration >Preferences >Windows Settings >Drive Maps Select the drive and right-click on it. Go to Properties and set the Action: to Update Apply and closed the window. Haven't had a problem since.

Thanks Colin - I'll do that next time. Regards!

In case someone else runs into this... I had the same error with a subform. Code worked before - now, getting the error mentioned above. I solved it by first decompiling the database in a command prompt: "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE"...

If I use a SQL statement rather than a query - I have fewer queries in my FE. I am not sure if that makes a difference, but my gut says fewer queries are better. But that may just be the voices in my head? :D

I have a form and just wondering if there is any difference between setting the Record Source to "SELECT TblOven.* FROM TblOven;" versus a query that selects all fields from TblOven? Is it essentially the same thing? If not, which is the preferred method?

SOLVED> Short story: The code below will duplicate a quote along with all the additional tables that are involved in the quote. Long story for anyone who wants to do the same thing or is morbidly bored: I created a table (TblCopyQuoteTables) that has one field (CopyTableName). This table...

Thanks Minty - that was the problem. I put the following at the beginning of the For x loop: If IsNull(rs1.Fields(x)) Then fieldvalue = "Null" Else fieldvalue = rs1.Fields(x) End If Then I used that variable (fieldvalue) to build the SQL statement. So my final SQL statement looked...

I have the following code that builds and executes a SQL statement, but there is a syntax error somewhere in the final statement (getting Run-time error 3134 - Syntax error in INSERT INTO statement) and I am having trouble figuring it out. Dim sqlStatement As String Dim rs1 As Object Dim rs2...

Hi Mark - yes, I had some code that disabled the AllowBypassKey property. I suspect that may have been the culprit to my issues. It was quite a few versions ago and I don't have the code anymore, so I can't say exactly what it was, but I believe it was on one of the hidden system tables. I...

Yep - still looking over it. Thanks Paul.

These are industrial ovens and washers. They wouldn't fit in your house...most of them are larger than your house. Each oven and washer system contains dozens of fields (aspects). Aspects that apply to every oven will never apply to washers (and vice versa). Each oven is unique to that...

I have over a dozen tables that together represent a final quote. TblSys TblOven TblWasher TblMisc etc... They are all linked by PK QuoteNum. I want to duplicate any given quote so that with a new quote, most of the work is done with just a few changes that are needed. So I need to create...

Violent crime is down in America. It has been decreasing since the 1980's. Why? There are a few reasons that analyst point to, and probably not one single reason, but a combination of factors. None of that is relevant to this discussion except to point out that Americans are safer now than...

Thanks, everyone, for your help. Here is the final solution for anyone who is keeping track: 'This will copy the current quote into a new quote number Dim intNewNum As Integer On Error GoTo Err_Click If MsgBox("Are you sure you want to create a new quote using this quote as a template?"...

Much appreciated - thanks Paul.

Yep - saw them. I like #2 but I'll need to dig into that a bit and figure out how to filter a query in vba. Thanks pbaldy.