Search results

Can anybody please confirm for me that it is usual/expected behavior for breakpoints to stop working after unticking the "Use Access Special Keys" setting?

I seem to remember reading some years ago that the use of "Compact on Close" should be avoided because it could cause a file to become corrupted. Is this still the case or is my memory failing me, once again?

How can I catch when a user "Pastes" several rows of data into a DataSheet Subform?

Does anyone know of a way to prevent the setting of the AllowBypassKey property being changed by another db

Can anybody tell me why I get this message box when trying to Compact and Repair the database. It is not split. It is on my machine. I am the only user>

A little surprised that nobody has made any comment (that I've seen) on the recent events in Ukraine

MERRY CHRISTMAS EVERYONE ☃️

How well would an Access frontend work with an SQL Express 2019 backend if the linking had to be done wirelessly? I've developed many split apps but I've never had to use anything other than Access for both ends. SQL Express would be a new adventure :eek:. Should it be fairly straightforward...

I have the following code in the NotInList event of an unbound combo box but the combo doesn't recognize added data unless it is selected from the list. It just repeats the message saying that the new data is not in the list :unsure:. I have also attached a db to illustrate the problem. Private...

Last night I grilled a chicken for over two hours......and it still wouldn't tell me why it crossed the road 🤣🤣

In my app I have a table called "tblHistoricalDataMASTER" that is derived from a spreadsheet. It has data about the price of shares e.g. ID Open High Low Close Ticker StockDate2 1 42.049999 45 38 38.23 FB 5/18/12 I have written a function that steps through this table and writes the...

Please forgive me if I'm just having a "Senior Moment". They seem to be getting more frequent with every passing day :rolleyes: Some years ago I found/copied/wrote some code to disable the use of the Red Cross in an app, forcing users to use a Quit button on a form. Naturally, I can't find...

If you have a button on a form which sends a report to the printer, is there any way to establish whether or not the printer worked correctly.

Can anybody explain why I get the error message in this thread title when I try to open query1 of the attached db. The SQL for this query is:SELECT Table1.ID, Nz([Num],0) AS n, Table1.txt FROM Table1; DB attached Thanks in advance

Can someone please look at this and tell me what I'm doing wrong. The code adds the NewData to the table but I get a message which tells me, "The text you entered isn't an item in the list" Private Sub cboCusFilter_NotInList(NewData As String, Response As Integer) Dim rec As Recordset If...

MySQL backend residing on Azure. Single Access frontend on MS OneDrive which will be shared by five or six users. Two or three of these users will be away from the main office and using the shared front end on laptops. Would be interested to hear any thoughts or advice on this setup.

Hi folks Has anybody used an Access app with "Remote Access" software like "Team Viewer" or "Go To My PC" and if so, what was the experience like? Thanks for taking an interest in this post. Bob

Just wondering if anyone has tried using an access app on a data stick. Any one have any pros and cons or opinions on its success.

Using Access 2016 DoCmd.RunSavedImportExport "UpdateCo" Anybody know why this line of code would cause the following error: Run-time error '31602': The specification with the specified index does not exist. Specify a different index. 'UpdateCo'.

Is it possible to import data from an Excel.xlsx file into Access 2013 if you don't have Excel application installed.