Search results

I finally found a solution to this problem. I noticed today that the error only happened if the field I was trying to update didn't change so I just added an If statement check the values and only run if the values were different.

This is the last bug I am having in my code. Any ideas what could be causing it?

I am not sure what you mean by this. If it helps, my tables are on a mysql server . No I just tested with finished section and it has the same errors. My Work_Details_tbl is also accessed by my main form that is always open and it could be open in a secondary form as well but at the moment it...

I was hoping that would take care of it but it didn't. I just did a quick test changing over one of my tables to a query but I get the same results.

Okay good to know. I will work on getting all of them converted over and let you know how it goes.

I added Option Explicit and had one problem come up from doing that but I fixed it. The form that this code runs from is unbound. It is only used to collect the number from the barcode and what type of code it is. The recordsets I define and use the modify the data are based off tables. Should I...

No problem. It is a long one and not too much of it is commented. Basically It runs after a text field is updated on my form. The conditions are based on radio buttons on the form. Let me know if you need any more info on it. Private Sub BarCode_AfterUpdate() Dim rst As DAO.Recordset Dim...

I specified the record set as a dynaset but it still acts the same as before.

I am working on a piece of code that takes a bar code as input and modifies the related record. It all seemed to be working okay but I have found that if you scan the same bar code twice it gives you an error about the record not being able to be edited because someone else is editing it. It...

That is pretty neat. I will keep that in mind for later projects.

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) Dim tmp As String Dim rst As dao.Recordset Set rst = CurrentDb.OpenRecordset("Report_qry") With rst Do While Not .EOF tmp = tmp & _ Option_1 + vbCrLf & _ Option_2 + vbCrLf & _...

I am trying to reduce the size of a report I have by hiding any empty columns or columns with a "None" value. After searching around for a while I found this http://www.utteraccess.com/forum/Shrink-empty-textboxs-re-t1955986.html&gopid=2045156#entry2045156. I thought it was going to work great...

It is a very neat module. I think what I came up with works better in my situation but I am going to hold on to this for later use. I reattached it on here so that smig could get it.

Yeah that is my plan. It only needs to be on one control but depending on the value of the control it will display different text on the pop-up. I will look into it. Thank you for the link.

It would be a description of the equipment and it could end up being kind of lengthy in some cases. I think I have come up with a solution that I like. I used Uncle Gizmo's suggestion to open a new form and bound that to a keypress event. I have it open a pop-up form and move it to a good...

Yeah I already tried that one but like I said before. It is limited and it displays as one long line all the way across the page. Thank you for the suggestion though.

Yeah I thought about that. I haven't tried it out yet to see if I like how it works. I like the idea of it just being a mouse over but I don't think that it is possible.

Have attached a mock-up of what I want to do. I am not sure if it something that is possible. My google searches did not turn anything up so I was hoping someone on here might be able to point me in the right direction. I tried using tooltips to do this but the amount of text is kind of limited...

Well I feel stupid. I changed my old Order_num control to a label to hold the name of the form and made a new control that held my Order_num. I didn't however rename the original control after I changed it. Renamed the two controls to their proper names and that fixed it.

I have a form with a subform on it. The subform is linked but the field Order_num. The field name is the same on the subform and parent form. When I file out the info on the parent form specifying the Order_num and then go to add the info on the subform it does not populate the Order_num field...