Search results

Yes in fact I am.

Hmmm? I uploaded my DB for a user who has A2007 but he cannot open the file? Says it must be 2007 or earlier version? Any thoughts

Is it not possible to export or "save as" Access 2010 DB's in an earlier version? I'm trying to save as a 2007 file. Any advice? Thank you

Missinglinq, this is very important to me that you are willing to look at my work. Is this a typical issue with Access 2010 not being able to save in a earlier version or is my version missing something? Perhaps we can get someone else on this board to open the DB and save it in the format...

Even though I am using Access 2010, the file header says Database (Access 2007) ?? I try to save the DB "save type as" as an alternate or earlier version but the application only allows me to choose " Microsoft Access Database". Sooo..., what can I do?

Thank you Dale

Have been in the field all day. Wish I could have seen this earlier. Anyhow here is my code. I know it's crude. Option Compare Database Dim QTY_Being_Returned As Integer Dim QTY_Returned_to_Date As Integer Dim Asset_ID As Variant Dim Mat_ID As Variant Dim Record_Stat As String Private Sub...

Well, there are two Subs called by Combo Boxes's on this form. Do you really want to see my code?....... I'm sure you'll be surprised by how sophisticated it is? Missinglinq, More important question, Why is it after I select a record in a Combo Box, and perform my AfterUpdate Sub routine...

No only one routine running that I can see for this Combo Box by tabbing through view code window. Unless there is a way to see everything, this all I can see.

First Thank you, Me.Undo does the job and the form works great. Kinda feel like your logo. In any event, if you have an unbound Combo Box as the first field in a form which is triggered by a BeforeUpdate event, after you select a record from the Combo Box, the code runs however the cursor...

This one is a bit difficult for me to figure and understand how to solve. Please keep in mind, I am doing all I describe below in effort to handle an "escape" by the user. If the user "escapes" I want to clear the form and close it which I can do fine with the error handler and the following...

I agree, and you are correct...for the most part. These controls are unbound (5 out of 7 of them) because they are information only for the user. No data should or will be entered in these fields. They are disabled and locked. The only data I want the user to enter on this form is a number...

I am sorry Pr2. I hate to be ignorant and am learning but this test is failing: so my fileds are not updating. What does this test do and where is it? If Me.cboAsset_ID.ListIndex <> -1 Then

Thank you does this mean the Control Source of the text box should now be Null? or know an unbound text box?

I have tried to solve this problem using "AfterUpdate". I had the same issue that's why I tried "onclick"Same problem. It is clearly a timing issue in the display and perhaps it is in the way I am updating my fields. Is it OK to equate text boxes to a lookup as follows: In my text box...

Please help me understand! I have an unbound ComboBox which I am using to allow a user to select a record. On "click" the CB calls code so I can use the info in the combo box to populate text boxes in the form. Ok, it works great for a split second but as soon as I move to the next field of...

Plog thank you. You are correct. Removing the variable portion of the criteria works. Gemma thank you for your advice. Pr2 as always you have been a big help for me also.

Will someone please tell me what the problem is in this DLookup statement? I keep getting a syntax error on the "Me.cboAsset_ID.Column(6)". answer = DLookup("[Issued_Quantity]", "Materials", "Material_ID = Me.cboAsset_ID.Column(6)")

Hi, I'm hoping someone can help me figure out how I can get these forms to reset or fields correctly. I have two forms that are opened in the "add" mode using the switch board: Form A: For some reason, if I press the escape key in the first field the form will not clear the first field but...

This data will be entered by other people ( perhaps two) that stock and issue material. After it get working, I will not be entering this data.