Search results for query: *

Thanks for the quick response PHV I entered a default 1 so that in the case of an Undo, there is already a valid amount. But it can happen that the number is changed by the user to a valid number and then changed again to one that is not. My main issue is that the Undo doesn't work. It makes...

hey guys/gals I must've used this code 1000 times before and I dont understand where the problem is. Can anyone figure it out? I have an unbound textbox and I want to make sure that the number is positive. I assign a 1 as default and would like it to revert to that if the number is negative. I...

Hi plcman, From what I understand, you want ot change the amounts directly on the record of that item. So that if there was 50 and the user changes it to 40 then he has taken 10, right? In my opinion Inventory Management application should always have records of transactions so that if the...

Hey guys, I have a very peculior situation and maybe someone can help (or has seen it before). I have a report with a subreport in the detail section. The subreport contains MS Image ActiveX Controls on the left and are loaded using the LoadPicture method (but I don't think the LoadPicture...

Thanks PHV that's exactly what I did! Here's a star!

Hi muppet123, In the Form_OnCurrent of your subform enter following Me.OrderByOn = True Me.OrderBy = "ConversationDate DESC" Hope this helps, Lawrence

Hi PaulBol, Maybe I can help with certain aspects of your question. First, you may need to do a little bit of programming to get this done. The record_id should've been automnumber to begin with... I think. But we'll work with what we have. 1) and 2) In the BeforeInsert Event of you form...

Hello everyone, I have created a table with a list of Error Numbers and Error Descriptions in order to avoid having to rewrite error messages. I call the error message found in a text field using a function similar to MsgBox. Sometimes, the error description is quite long and I want to be able...

Hi benrob82 How are you filtering the form? You may have to elaborate a little more. But if you are programatically using Filters like: strFilter = "Country = 'USA'" Me.filter = strFilter Me.Filter = true Also, if you are generating a report from the Form by clicking a button, then you could...

Hi scoobey, Perhaps this is what you are looking for: Dim ctl As Control Set ctl = Me.Controls(0) ctl.SetFocus This will not go to the TabIndex(0) as you are looking for though. However I also use a module to disable/enable controls in a form. One trick I use is to create a box and...

Hi Bill, I retested the scenario and couldn't find any problems. However, sometimes Access reacts in ways that doesn't always make sense so what I would do if I were you is to delete the ComboBox you are using right now and create a new one with the same parameters. If it still doesn't work...

Hi stillwillyboy, When does the error message occur? Right after you type in the first digit or after you press enter or tab out? Is there additional code in your AfterUpdate event? The code I gave you is pretty straight forward. Is your BoundColumn the SalesNumber field? Make sure also that...

Hi StillWillyBoy, In order to get the name of the SalesName in the text box you need to send the second column information of your ComboBox to your TextBox. In order to do so type the following in the AfterUpdate procedure of your ComboBox: Private Sub SalesNumber_AfterUpdate() SalesName =...

Good Afternoon, Is there a way by using code to convert a single avi frame to an image file format like .jpg or .gif or .bmp? I hope someone can help me, Lawrence.

Good morning everyone, I really need help with this one... I've been looking for hours but nothing is close to what I need. Simply put, I have a memo field which contains all the code to generate an HTML page. I just want to export that information into a new .html formatted doc so that I...

Good Afternoon, I've been going through posts all morning trying to figure out the best course of actions. I've developed an access application for a retail chain. I need to figure out the best way for the stores' Parent Company to view (preferable in real-time) the stores' activities (total...

Hope a guru can help. I have a split DB. The FE contains to types of tables: the first are Permanent tables linked to the BE and Temporary table that reside on the FE. When installing a FE on a workstation, I would like to programatically link ONLY the Permanent tables to the BE. Thinking...

Appreciate the help and effort. You both get stars !!!

Thanks HiTechUser for the response, I have already looked at these threads however it doesn't exactly fit my needs. I have used the comma delimited approach in the OpenArgs a few times but I was wondering if there was a way to do the following: I send a form name "FormA" as an OpenArgs...

Good Afternoon, I presently have FormA containing a SubFormA, a FormB containing a SubformB and a FormC containing a SubformC. Users enter information in the Subforms and sometimes a FormZ needs to be opened in Dialog Mode. Once information is entered in the FormZ, certain information are...