Search results

It is MS Access linked to SQL Server. I realized last night that although I gave the bit data types a default of 0 so that nothing would end up with Null that there was some in there with a null. I ran an update to change everything null to 0 which I had done in the past and then the locking...

I have a form that is bound to a query that is bound to a table that I recently added a few new fields to. I suddenly started to get a VBA error code 7787 when a user tried to edit a record. When I try to go directly to the table I also get the error. It turns out that only the records that...

For now I just moved this to the forms activate event: Dim vFlag As String vFlag = Me![EncounterNbr] Me.Requery With Me.Recordset .FindFirst "[EncounterNbr] = '" & vFlag & "'" Me.Bookmark = .Bookmark End With It will do what I want....keep my bookmark and get the updates to the changed...

I think I got the return piece working now......it just doesn't refresh the changed records unless I requery the entire form and when I do that it will lose my bookmark at that point. I am trying to just requery individual fields that they update but nothing happens when I do that until I close...

I tried to just requery a specific field on the form instead of the entire form (tried refresh too). Refresh does nothing. Requery gives me errors saying that object doesn't support this method or property on the close event of the form that triggers the requery.

The reason I chose to requery is because the change that is bad on the form that is closed and triggers the requery doesn't appear on the continuous form unless I requery. I did try me.refresh because I read that this would update the changed record without reloading the form, but for some...

I have this code: Public Sub cmdRequery_Click() Dim vFlag As String vFlag = Me![EncounterNbr] Me.Requery With Me.Recordset .FindFirst "[EncounterNbr] = '" & vFlag & "'" Me.Bookmark = .Bookmark End With The user starts on a continous form and opens a record, makes some changes, and then...

knichols, I put the code behind the click event of the button on the form that the user goes to when choosing their parameters to run the report. Once the click the button the pass thru query takes the parameters and runs it through sql and returns the results into a temp table. The temp...

The problem was that in the actual SQL table their was bit data types that didn't have a default value. When you try to delete or update from access, tables in SQL without a default value in a bit data type it will keep telling you that someone else is also editing the record.

Nevermind. YOu have to change every field in the table that is a bit datatype to have a default value and if anything has already been inserted as null you have to update all of those records. Then you can edit and delete. Otherwise it will keep giving you an error saying that it is still...

I have a subform that has 3 check boxes. If the record was an existing record in the SQL table and I want to change the value I can change it no problem. If I try to check the box for a new record added to the database then it doesn't allow me to save the change. I know that this is a problem...

I have also tried this....If Me.Dirty Then Me.Dirty = False in the click and after update event on the check box and I still get errors like its being edited still. This actually happens as soon as I click on the sub form check box before I even try clicking on the main form. Its the only...

What code do you put in your save button click event? I tried putting for example me.refresh and the checkboxname.refresh and various stuff like that in the after update event on the check box, although it doesn't error and I can step through and see it happens, it still locks everything up...

Whenever a user checks one of the check boxes on a subform linked to a main form and then tries to do anything on the main form the selections in the sub form are deleted because the main form thinks that the data in the sub form is still being edited. I have a case statement in vb for on error...

It turned out I just had my join wrong. There was no matching fields for it to join because I was joining on a custom field I created in my temp table to a custom field in the other temp table, but one had a space and the other didnt. :)

It is all in the same stored procedure. It just doesn't seem to get results. I will keep experimenting. If anyone has any experince with this problem please share. Thank you!

I have the temp table #ProviderReportCardTable_MeasureCounts that gets populated in my stored procedure in a step before the below code. I have confirmed that it does include all of the data that I want. Then I have another temp table that is created...

That space was just a paste error. Your right it was just the table name missing. I have done this same kind of query so many times. I can't believe I didn't see that. Thank you for catching that mistake for me!

I have a SQL statement that executes and I also get an error saying that there is something wrong with the insert statement. I know it has to do with the variable I am using as one of the values to insert. strAddCountTable = "INSERT INTO (FYQtrYear,FacilityID,FacilityCode,Fail,Pass,Measure) "...

I am sure your's is probably the better way to do it :). I am just learning as I go. I may switch it around later. I am just getting so close to go live. I can change it in phase 2! Thank you for your help and advice!