Thanks for your replies.
I changed the text boxes to UNBOUD and in the form LOAD event i entered simple text such as: me.level1label. value = dlookup(")....a nd it works great. Now the boxes only load with the form and not every time the user changes records.
im still very new with access and writing code and was wondering whats the use or difference between what i did and using "functions" such the one...
Gilberto
Last Activity: Nov 29 '07, 08:48 AM
Joined: Aug 28 '07
Location:
-
Calculated Query with user "margin" input
Hello,
I have two tables: COSTING and PRICING, both with the following fields:
product name French
packaging
transportation
ddp
I want to create a query so that from a text box in the pricing form the user could enter a desired "margin" (ie. 10%) and the query would replace everything in the pricing table with the data from the costing table multiplied times the margin entered in... -
Run dlookup only ONCE at form load
Hello,
I have a form with a couple of text boxes with dlookup as control source. They work alright the problem is that every time i navigate across records the lookup runs again as i can clearly see how the text disappears and appears again...taking some time...
Is there a way to run the lookup ONLY when the form loads and to keep them "static" while working on the form???
Thanks,
Gil... -
How to AVOID / SKIP run-time error 2105 and 2499
Hello, in several forms i have a NEXT, PREVIOUS and SAVE command buttons which were working perfectly...no errors showing...nothi ng!!! i had to convert my DB to 2003 so i could create the .mde. I did the conversion and now my forms give me a run-time error 2105 or 2499 every time i reach the first/last record and try to go one more previous/next record. Im new with access and dont want any fancy error handler i just need to AVOID the error and be... -
I just fixed the problem by DELETING "Call FindAsUTypeLoad (Me)" from the Form Load event, however this makes NO sense as: 1) it USED to work having that line, 2) it SHOULD NEED that line to call the function....am i wrong???
WHATS HAPPENING with my access???????? I opened this SAME db at another computer and it worked WITH the code line and there were NO errors 2465 at all.
Any ideas???...Leave a comment:
-
Problem: SUDDEN error 2465 EVERYWHERE!!!
Hello
I have a big BIG problem. Im new with acces and ive been creating a db for a month now. It was working perfectly and just after i did a db SPLIT some functions began displaying error 2465. I first thought it was caused by the SPLIT but now ive opened backedup files from weeks ago and it ALSO gives me error 2465 which it didnt give me before. What could have happened??? What can i do???
Example: this function worked... -
Thanks Mmccarthy. Could you specify a bit more how to do this???? Im kind of new with access...Leave a comment:
-
hahahah. That was simple. Thanks, it works now....Leave a comment:
-
Thanks ive done so and the size decreased around 15mb.
Thanks a lot!!!...Leave a comment:
-
Split MDB created problem with FindAsYouType
Hello,
I have a couple of forms using the code to FIND AS YOU TYPE from Allen Browne (http://allenbrowne.com/AppFindAsUType.html). It worked PERFECTLY until yesterday when i splitted the db into FE/BE. The tables link ok and everything works ok EXCEPT this function. When i open the form it gives me a underlining line (iReturn = ctl.Parent.Page Index IN THE PARENTNUMBER function in BOLD) and indicating that iReturn=0. I am new with... -
Its TEXT, and contains the image files paths....Leave a comment:
-
Null value after cleaning table
Hello i have 7 tables, 7 forms and one query calculating a total for each table. Everything works perfect but every time i delete all the records from the tables ("clean") if i run the query it returns NOTHING....NULL , empty fields, NOT even "0", which is what im expecting. Its only AFTER opening and closing the form of the "cleaned" table, that the query returns the proper "0". The easiest solution i could... -
Bound Image Control problem
Hello
Ive been trying to find a way to reduce database size (image related) and the only solution ive found (http://support.microso ft.com/default.aspx?sc id=kb;en-us;285820) only deals with continuous forms in order to create some kind of "image catalog".
What im trying to find is a way to display the SWITCHBOARD FORM "background picture", which would be the same for ALL records, hoping i can reduce... -
Thanks, it worked perfectly....Leave a comment:
-
Hello, thnks for the reply.
Just to be clear this is the situaction:
I simly dragged the form into the reports detail section, this section DOESNT have any ON RENDER event (it has on format, print, retreat), i actually COULDT find any ON RENDER on any section of or actual report. On the form i just inserted i found a BEFORE RENDER, AFTER RENDER and AFTER FINAL RENDER. The formatting code (if isnull([text1]...) i need...Leave a comment:
-
Subform NOT working in REPORT
Hello,
I have a form with some code to HIDE textboxes and labels when information is not used. I need this information in a report so i added the form as a Subform/Subreport in a report. The problem is that when runing the REPORT, it seems like the SUBFORM CODE DOESNT WORK, as it displays EVERYTHING. Its not following the code to HIDE the textboxes and labels, which are correctly hidden when running the FORM on its own.
... -
Finding/Moving into RECORD
Hello,
I have a form (COSTING) where the user has to enter information for every product (PRODUCT NAME FRENCH). That same form includes a subform (COSTING MISSING PRODUCTS) where the user can see products with missing information. Right now, the user has to identify the name of each product then go back to the base form (COSTING) and "navigate" record by record until he can find the required product that is missing information.... -
Yes it is. I have other controls using DlookUp to get its value, the problem with THIS specific control is the IIF, which i cant get to work....Leave a comment:
-
Thanks but no luck...again it asks for: "LevelTexts "....Leave a comment:
-
Thanks guys, i used the ACTIVE event for the form, modified the code and it WORKED hahah.
Thanks for the replies. The code that worked is:...Code:Private Sub Form_Activate() Me.Refresh Me.Requery Me.costingmissingtxt.Requery Me.pricingmissingtxt.Requery If Me.costingmissingtxt.Value = 0 Then Me.missingtxt.Visible = False Me.missingtxt.ForeColor = 255: Me.missingtxt.Value = "MISSING:"
Leave a comment:
No activity results to display
Leave a comment: