Search results for query: *

I agree Max thanks for the heads up, my head is still spinning from this one, another set of brain cells is always good in working out problems. Once again thanks

Max I appreciate all of your efforts, I have gone to a backup from last Friday, I have some updating to do to maintain continuity but it does seem to be the best option. Once again thank you for your help

No problem, I'll give it a go and let you know.

I was able to edit and manipulate every field in datasheet view.

Yes, the form -> orders table, subform -> order details table. I am thinking that when there was a momentary loss of a network connection that the DB was put into a locked state. When I initially began looking into this problem I began by going through the various tables looking for anything...

Hey there Max still no go after the decompile and I have been working with a local copy since the problem

I found a webpage that describes how to decompile the frontend

How exactly do I decompile the FE?

Max, that was one of the first things I tried. I am about to lose my religion

No, I spoke with one of the users, he was inputing data then as he was saving the record he lost his network connection. He is on a laptop with a wireless connection. From what I have been able to figure is that the database is in some form of a locked state. What is strange is that on some...

Yes

Hello Max, thanks for the reply, yes I do have a fe and be, however when no one is in the DB the ldb deletes, currently no one is in and therefore there is no ldb. Any other suggestions?

Hello All, today something very strange happened to our DB, none of the records will update, the command buttons do not point were they are supposed to, if I click on a calendar control (example here) I get a cannot update error, I cannot select anything from any combo box controls because this...

Thanks Ace worked like a charm

Hello all, I have an event that executes when the user double clicks a partNumber Control: code: DoCmd.OpenForm "Product Details", , , "[Products]![ID] = " & Me![Product ID] This opens a details form for that partNumber. Is it possible for it to open a blank Product Details form if there...

Hello All, I have a DB that mimics a CRM to some extent, the area for this question I am most intrested in is in the inventory portion of the DB. Throughout the year pricing changes. For the industry I work in sometimes monthly if not weekly, at times depending on the Asian markets we have seen...

I believe I got it to work properly, but if you could help me understand I would appreciate it. I replaced Me.CustCode.Column(1).Value with Me.CustCode.Column(1) and it works properly, like I said I don't know exactly why, but if you have further insight I appreciate it. Thanks MissingLinq

I put the following code in after update: Private Sub CustCode_AfterUpdate() If IsNull(Me.CustCodeList) Then Me.CustCodeList = Me.CustCode.Column(1).Value Else Me.CustCodeList = Me.CustCodeList & "; " & Me.CustCode.Column(1).Value End If End Sub I am getting and Errore 424, object...

Thank again for the help

I tried your suggestion and it works, however, how do I get the holdingbox to show the Code Name and not the ID number. The structure is like this: On the form the Combo Box Control is labeled "CustCode" The combo box control source is a table with Three fields 1. ID (autonumber, primary) 2...