Recent content by JeanMarc22

I know this is an old post but I noticed an error. There was an extra vbCr at the beginning of the attribute param. DBEngine.RegisterDatabase "FinancialPlanningAnalysis", "SQL Server", True, _ "Server=itasql55pr" & vbCr & "Database=FinancialPlanningAnalysis" & vbCr &...

Yes, I couldn't find the answer anywhere so I shared my solution here so it can be found by others.

I've had this issue where the user calls the Spell Checker to check one textbox but it runs away and checks every field on the form. I tried bringing the text in a "Zoombox" form to isolate it, similar to the behavious of Shift-F2, but the spell checker would keep checking the form behind after...

Hi omarrr128. I had a similar situation. I won't repeat all the good advices above. My solution was this: when users click on the link to start the database it calls a script that copies the frontend to the users' profile. This way you can continue to develop and you deploy to a hidden folder...

Good ideas about simplifying the query. I will try that.

To clarify, I'm using the regular interface search not using code. And using the asterisk means any character (0 or more). If it was in the query I would enter Like 'A*' or Like '*'. That works. I'm talking about a glitch using the simple search, ie from the menu or ctrl-F.

So, I'm analyzing data and I'm building a query where I can see all of table B and matching table A. It's like an "Unmatched Query" without the "WHERE A.MAINCODE = Null;". Here's a simplified version of my query: SELECT B.*, A.* FROM A RIGHT JOIN B ON A.MAINCODE = B.MAINCODE WHERE...

Yes and it is fast. There might be faster solution out there but I did it on a table of 1.5M rows relatively quickly. I don't remember how many seconds.

I like the answer from The_Doc_Man. The one exception I have made to split tables of similar data is when the database was near 2GB. I split it on a field that is a primary filter. Then when you query your data then you can pick the query based on your filter. The field could be an added field...

Silva is asking for a query to remove time. In MS-SQL there a covert function. But in Access I use: update [tablename] set datefield = format("yyyy-mm-dd", datefield) where datefield condition criteria Format is designed to output text sting but if your datefield is already of type datetime...

Very true and I use this often but the originator of this thread was asking about doing it in code.

My bad. I didn't look at the date when I posted.

Hello everyone. I'm Jean-Marc from Ottawa, Canada. I work in the government, mostly with HR data. I've been using, building and programing MS-Access since version 97. This is 50-75% of my work depending on the feature requested. Some features I've developed use interoperability with Excel, Word...

Yes there is a way in VBA to do this: DoCmd.OpenQuery strQueryName, acViewDesign DoCmd.RunCommand acCmdDatasheetView No elegant but it works. And if it's a long running query you can interrupt it with Ctrl-Break.