Search results for query: *

How to explain this ! I have sales reps on the road, the boss wants them to count their house and stocks and sold items on a daily basis and calculate their comissions for each product! So i have a table called repsales with repid (primary), name, account#, date, amountscollected and a bill#...

I have a situation where i need to fill the many side of the table before the one side! Will this pause a problem! Past present or futur! I see no other possible venues to make this work! ex: to pay bills i need to fill what needs to be paid first! Any suggestions !

Syntax for main/subforms For these examples: Mainform is the name of the top level form Subform1 is the name of the subform CONTROL on mainform Subform2 is the name of the subform CONTROL on the 1st subform. If you are on Main form Sub 1 To refer to a form property, like...

On a form with a subform how does one handle the undo record, i have tried with the docmd but it will only undo the sub form, not the main form, basically what i am looking for is a rollback... Is there a way to do this programaticaly ???

Minor problem caused in form ! My form opens and goes to a new record. private sub docmd.gotonewrec now at the bottom of the form i have a macro wich calls another sub performs calculations and then goes to a new record ! I am not sure why but this causes 2 records to be added ! one blank...

I am having a problem with a combo who should filter the second combo ! The problem is that the second combo is a lookup field with a column count. Now because the value is numeric although it shows the text value. My combo 1 does not requery the second combo. Any one have a work around for...

DSum("[Quantity]","Order details","[ProdID] = " & Me![ProdId]) minus the below DSum("[Quantity]","Stock ordered","[ProdID] = " & Me![ProdId]) Using an update query to return the differencial values! In other words what I have bought...

I am using an update query to show the quantity of orders! Table products ProdId (key field) Table order details¨ProdId (key field) also lookup field bound column1 column count 2. The problem i have is that the bound column is 1 in the table with a column count of 2 to show the description...

My append query shows the correct results ! However the table i am appending to receives all the information except the currency values which a switched back to $0.00. Yet when i look at the query the amounts are not $0.00. Are there any special considerations to take into account when...

I have a subform with a key field set to no duplicates! Is the user accidently enters the same key number on another line in the subform, there is a violation of duplicates! The problem is that the subform will not allow me to change that number to another! Is there any way to handle this ...

I have an option box with 4 choices ! The option box name is courrier! the checkboxes within are 1, 2, 3 ,4 with names like canpar, lumis, etc. I have been trying to code it so that is the option4 is not checked and cost is = 0 then send a message box stating that the cost of the courrier has...

stDocName = "Ventes (Dernier)" DoCmd.OpenQuery stDocName, acNormal, acEdit lin3 DoCmd.GoToRecord , , acNewRec I have a sub witch runs a query, once the query has run! I want the form to goto a new record! The line 3 is not working, is this because the form has lost the focus...

When i try to append the data to the other table i get key violations! Yet i have no key fields in the destination table ??? Any ideas ! Thanks

Could someone please tell me where the code goes ! there are two functions Function english(ByVal N As Currency) As String and Private Function EnglishDigitGroup(ByVal N As Integer) As String I am trying to call the function off the lost focus of the amount entered. Private...

I have a form based on a query that returns only those records that have a balance ! Now if no records match the form opens with no fields or controls ? Since there is no event for onnodata for forms how can i handle this situation to tell the user that there are no records to be edited...

Is there a limit for the number of fields, combos subforms tabs etc, on a single form ? Thanks!

I am trying to use the dlookup function off the got focus in a sub form to get a value in a table.The field is set to number, single, percent, and 0 for decimals. All other lookups work fine! Can anyone help me with this ?????? Is there a specific way to dim the percent field ??? Why will it...

I have a form with a subform, the private sub below gets the banner code from the main form. Now i want the percentage field to get its value from the id field , which should lookup the product table, percentage field. works fine for the first record in the subform when it gets to the second...

Using the sendobject, to send a report to outlook, i would like to replace the vare with a path, so my message is formated rather that just a lousy text ! vare= "Hello this is annual report" docmd.sendobject ac report, "myreport","SnapshotFormat", varb, varc...

I have a sub with witch i need error handling! Since i have many conditions which must be met, i need to use several message boxes. How does one handle this situation, can someone post an example with multiple error handling on the same sub ???? Thanks