Search results

I was able to just revert to a back up copy. I am just trying to understand how to prevent it in the future. It seems to be related to a button that uses the send object macro and opens outlook. We never had an issue until we started using that.

Has anyone ever had all of their forms and reports delete after a database froze?

I just tested another querydef example and it works. It must not have worked before because of the strings in my variables that I passed in? Not sure. Function MedianAutoF(pDisposition As Integer, pFacility As Integer, pStartDate As Date, pEndDate As Date) As String Dim dbs As Database Dim...

Thank you both. First I checked the pFacility and pDisposition because Bob mentioned how I passed those as strings and I didn't represent that in my sql statement. They are actually numbers so I fixed that. Next I just tested it with >0 instead of 1 and I got the result of True so that must...

Hello, I have spent all day debugging issues having to do with passing variables to my function. I finally know that the variables are passing and the sql statement is formatted correctly. The main problem I am having is that when I create the recordset no matter how I do it whether I use...

This is how I finally formatted my date reference to get rid of the too few parameters expected error in case anyone needs it :). mainsql = "SELECT tble_TempLOSDate.PtAcctNbr, tble_TempLOSDate.AdmitDateTime, tble_TempLOSDate.LOS, tble_TempLOSDate.DispID, tble_TempLOSDate.FacilityID " & _...

I like this! I never knew I could do that :) So if it says between pStartDate and pEndDate instead of the dates I know that were passed into the function that is how I know that it isn't actually using the dates correctly in the sql statement. It should say the actual date there. That is...

Thank you for replying. I updated the names in my table so that they no longer have spaces or special characters. I still get the error though. I commented out the Where clause and I am able to get past this error...to another one that I will address later :)....so I decided to comment out...

Hello, I have a function I built that takes in values from a form. I am trying to add an additional sql statement to it so that I can have two separate record sets. The mainsql is the main recordset that I want the strSql recordset to be able to take from. I keep getting a Run Time Error...

I just realized that another thing stood out to me when I just ran that query. It deleted the record after it ran my sql code, but for my sql code to know what to update the record had to be deleted first so the Form_Delete event is the wrong event. I changed to this event. I have never...

Thank you for replying! I tried what you said and I see that I don't get any errors, but it adds 0 rows and updates 0 rows when I know it should be updating 1 row because I have checked in the queries manually. Here is my updated code. I tried some other examples I found online with...

In case anyone was following this the problem had to do with me excluding the 0's in the where clause. It was looking at my data set as an even number because the total record set added up to smaller than I was exporting out because I was excluding the 0 records in the export to excel when I...

Hello, I have a form that when I delete a record I want two queries to run that go through and determine if any records need to be updated in the table because of that delete. There are two tables involved. When the delete occurs it deletes from the Issues table. If there is no longer a...

Hello, I have a median function that has worked well up until today. We passed a new data set to it and just for testing we copied the raw data into excel as we did with the other data sets and this time the median in Access was 250 intead of 249 that it is in excel. Has anyone ever...

I used the tool in the macro that says convert macro to VBA and all it did was create a module with the macro. I just copied the code from the macro that got converted into a module into the click event of the actual object on the form. For example I went to VB and looked at modules and...

I forgot to import the query tied to the form that the double click event was opening so it couldn't link the criteria. I guess I need something in the click event to state that there isn't a record, but in this case there would always be a record so as long as I don't forget to import the...

Has anyone ever got the open form action was cancelled error on a double click event on a continous form? I am unsure as to what is making this come up because the form was working fine.

I see what you mean now about separating them! Okay I will try that in my live database soon. I am getting pulled into a meeting. Thank you so much for your time and help today :).

Okay here is a very basic view of the problem I am having. qry_measurelist is what I want to be unduplicated.

I understand. I will work on getting you a copy. Thanks.