Search results

Hello All, Why is Today not equal to Today??? So, if I filter a form with a date field, which contains today's date, where "Filter = Date()", it returns the record with today's date. However, if I use a formula to find the last day of the week, and convert that to a datedDate = (Date -...

Happened to find this thread today, and happened to have the book that Gizmo mentioned...a quick read on how to look into the Errors object looks like what I need to do to solve the problem here:https://access-programmers.co.uk/forums/showthread.php?p=1627693

After attempting to run an insert via VBA a few times, it still fails. So it appears the problem is in the VBA, perhaps. The first error that appears in the Errors collection states that the Connection is busy with results for another command. Researching... Update: I believe the fault was...

I do have a time stamp field, but there was no default setting. I ended up dropping the table and recreating, with a proper time default setting and all seems to work fine so far. The boolean fields all had default settings, so I'm going with the time stamp field. Thanks for your tips!

Yes, there is a primary key, marked as identity, so it should be ok, as long as i don't try to insert one, lol. I will check on the boolean fields... Update: It won't let me delete a record from Access either, using the record selector on the datasheet view.

Hello All, I have one table that is giving me problems. Access is the FE, SQL Server 2014 is where the BE is. I am currently using DAO to access the BE tables. I have one table that gives me an error stating the I cannot make changes because another user is already making changes. I've...

OMG, this was a lame experience. I renamed the folder...the tables are linked so the link was bad, lol.

Here's a strange one: I open up a FE to make changes to some queries, and I wanted to create a new temporary query to test some aggregate functions... Click Create - Query Design - Click Table - Add Table. It momentarily flashes on the design window. I've tried two different DB's, restarted...

A spell checker has started appearing on one of my forms, and only on one computer, that I know of. And it seems to have begun after a Windows update was applied. I have gone through the properties of the form and the Windows spell check setting and disabled all that, but it still pops...

I think I got it, after reading this post: https://access-programmers.co.uk/forums/showthread.php?t=294678

Is it possible to obtain the recordset of a datasheet sub form, nested in a structure like this: Navform --> Sub form --> Sub form(datasheet) The code i'm using: Set rst = [Forms]![Navform]![NavigationSubform].[Form]![DS].Recordsetclone The error code is 438: Object doesn't support this...

strName contains six characters: in this test i chose a png file named P00445.png, so strName would contain P00445. I just found out that if the form is tied to the record source, i get this error, but if no record source, then it works fine. Also, no objects are bound to the record source...

So I am using a file dialog to select a picture and display it for an item in our inventory. Private Sub cmdBrowse_Click() Dim strFile As String Dim strName As String strFile = ShowDialog strName = strFile Debug.Print strName strName = Right(strFile, 10)...

Well, Doc, I haven't watched "Night of the Nematodes", yet, but I did find something that might cause a problem. User A: opens program, opens form to create new purchase request User B: does the same thing, about the same time. A: begins entering line items on the sub form that he/she wants to...

Any idea how long it takes the server to kill the idle sessions?

The problem has arisen once again. I have not installed any timers, yet. So, I will go through the process once again, however, I do need to find out why this happens. Let's say Mark opens the DB, places a lock on the BE, first thing in the morning. He leaves the FE open most of the day...

Perhaps including a timer might solve this?

Also want to include this bit: I did realize that one of my forms was directly tied to a table, so i created a query for the record source instead. Perhaps this will prevent future problems...

I did not try importing from the copy file. However, I did mention (in an edit) that the command line "/repair" worked on the copy file. After which i was able to rename the BE file, and put it back into production. Restarting the server is definitely a no go. Thanks for all your help, oh, and...

Gina: i did try that, initially, as well. Forgot to include in the list above. As long as the BE is in an inconsistent state and "in use", no actions (save copy) can be taken on it, apparently.