Search results

I'm just trying to code this without using the function, and I coudn't get it to work. I tried: If InStr(Me.txtProposedMix.Value, "%") = 0 Then NewValue = OldValue / 100 Else NewValue = OldValue End If Any help would certainly be appreciated...

Thanks gemma-the-husky, The problem seems to be twofold because if the user leaves the % at the end, then the user can simply type the percentage value directly, i.e. (99 for 99%). However, if the user enters their value without the % at the end, what they type gets interpreted as a decimal...

Hi everyone, I am trying to solve the problem in Access 2003 of users wanting to type in a Percentage. I am aware of Allen Browne's tip to Enter a Value as a percent at http://www.allenbrowne.com/casu-16.html However, his example requires setting the Afterupdate Event to...

Well, basically, the database that I'm developing is not a standard Access Database. It's a database of the current State of the Manufacturing System. For instance, a process in one state of the manufacturing system may be done at Station 1, while the same process at another state may be done...

Hello All, My users have requested a complicated feature that I'm not exactly sure how to deliever. They would like to have the ability to make a copy of the current state of the database (i.e. all the values of the backend). And have a copy of the front end whose tables are linked to the...

This is a great suggestion. I'm definitely gonna try this! :) Sincerely, Bill

Thanks Kiwiman, Why does this database hide its forms and tables, and how can I unhide them? Sincerely, Bill

I tried making a command button using Microsoft's default Command Button Maker to duplicate "Filter By Selection." I can Filter by Selection if I use the Toolbar. However, the Code from VBA does not work. The Code Microsoft imported is: DoCmd.DoMenuItem acFormBar, AcForm_View, 14, ...

The first one did the trick. Thanks pbaldy! :D I have gained even more knowledge! Sincerely, Bill

Dear Rich, I have tried adding Public Sub txtProcessSEQ_AfterUpdate() Dim qryName8 As String Dim qryName9 As String Dim strFormName As String strFormName = "frmProcessSelectLSRS" qryName8 = "qupdProcessSelectProposedSEQ" qryName9 = "qupdProcessSelectCurrentSEQ"...

I still don't know why AfterUpdate demands to be run twice. My current solution is to run my code once in AfterUpdate, and then again on Lose Focus. I tried using code only once on lose focus but for some reason it failed. Any help is appreciated. Sincerely, Bill

On my Subform I have a textbox whose AfterUpdate Event runs a query that Updates the Value listed in the Textbox to a Table. When this button is clicked the first time, the Table Value does not actually update. When Clicked a Second Time, the Table Value does update. The VBA Code is...

HiTechCoach, Thanks for the response and the solution. I have been told that Deleting and then Appending a Table is more efficient, and I wanted to know if it was possible for me to implement it a different way. I may end up doing your suggestion later anyway. :p Thanks, Bill

I have a Make Table Query that has several fields from different Tables. I have two fields that I want in this new table of this that are AutoNumber Fields. Whenver I try to execute this Make Table Query, I get an error saying "Resultant Table not allowed to have more than one AutoNumber...

My goodness, I'm such a noob. :o Thanks, Bill

I would like my code to work like this: strQryName = "qryProcessSelectCurrentLSSubform" Forms!frmProcessSelectLSRS![frmProcessSelectLSSubform].RecordSource = strQryNameHowever, I get an error. I am aware of this example: Sub cmboCompanyName_AfterUpdate() Dim strNewRecord As String...

Dear all, I'd like to implement in my database some type of testing mode where the user would be able to modify records or add records. They could see how all these numbers change after altering or adding records. They could open and see several forms, and see how the changes in one form...

After Doing some work for another area of my database and running into other problems I suspect that the issue is one formula which has bad referencing. In my tests if one textbox had a bad reference then all of my textboxes suddenly got #Errors (even if they worked before). That is an...

Thanks for the reply, Alright, now to solve the timing issue though I must understand why it worked in one case and why it didn't work in the other. That's one thing I don't get. OptionMix and ProposedMix were both evaluated in subqueries before being used in the main query. And for some...

I have just discovered that apparently for Access2003, that if 1 Textbox tries to refer to another Textbox rather than the Control Source, then suddenly all my other textboxes get #Error Messages even if those Textboxes correctly refer to Control Sources as =Sum([ControlSource]). Perhaps this...