Search results

Like This ? DoCmd.OpenForm "rettool1" Forms![rettool1]![TPassID] = Forms![Select Cus fm]![OrdersSub]![TID] I cant beleive it It was working. If I go to a backup The same code works????? I must have changed something, just seems like I go 2 steps forward and one back !

it does exist It is there in the DB window spelt the same I can open it directly but Obviously I get prompted for the [TID] Value when going direct. I have had this a couple of times and each time it seems due to a different reason. I have a value in [TID] just cant pass it to the form??

Here is the code If Me![OrdStatID] = 1 Then TDP = MsgBox("Are You Taking The Deposit Now?", vbYesNo) If TDP = 7 Then Me![OrdStatID] = 2 DoCmd.Save Else getdp: getdp = InputBox("How Much Deposit Are You Taking?"...

?? I'm not sure what line of code you mean ? Access seems not to be able to find my form but it is there im not sure why it cant find it??

I have a button on a form and ON CLick It Opend a second form which is based on query. The Button is actually on a subform in the 1st Form and it needs to pass a value to the second form when it opens for the query criterion. It was working yesterday but I went on too late and changed something...

operators Yes great i'll try that. I had forgotten those possibilities from school. :) Thanks

I have a form with two figures a.(Deposit) and b.(Actual charge) To discover if the deposit was sufficient I take the actual charge (b)from the deposit (a) When the deposit is less than the charge the Result is a minus. eg deposit 100 Less Charge 150 = -50 I want to use that result to say...

The Cancel button is on the "default" Dialog box that access puts up when you have a parameter criteria. So it's not like one i have defined! thats my problem im not sure how to deal with it. If the cancel button is clicked the query gets no data passed but the form still opens with a blank...

I have a form based on a query with a criteria which pops up a dialog box asking for the parameter for the query. It works great unless the user clicks the cancel button...Then The form continues to open but is blank as the query didn't get its criteria, i guess. What can i do to stop the form...

Suppose you have a function that calculates The gross figure from a net figure(entered on form) and you want to store the gross figure in your (sales) table along with other fields. What would you bind to ?

Ok The User Selected the customer previously at an input box which may have been a barcode scan.. on click ..The current "New Order Form" opens and it is passed the customerID That was previously selected. On this form Other data is also passed to unbound textboxes Via functions. What I...

Is it possible to use Dlookup to enter a value into a textbox on a form and then save the value it passed to the text box into a record in a table? Is it also Possible to do the same thing with text box and pass the value to a query criteria? So in the first instance you lookup the customers...

I have a Message box yes no cancel I would like a box which has 3 buttons with caption Morning Afternoon Full day, do I have to create a form like a dialogue box or is there some cool trick

I have an Access database which accepts input from a barcode reader using Inputbox function. However I need to know what one needs to Printout a barcode? Is it just a special printer driver or a whole application. The Scanner worked directly i pluged it into the ps2 port. So I need Advice on...

No Here is the code Public Function AddRecord() Dim Wks As DAO.Workspace Dim Mydab As DAO.Database Dim MyRecordset As DAO.Recordset Set Db = CurrentDb() Set Mydab = DBEngine.Workspaces(0).OpenDatabase(0) ' Open the table as type recordset Set MyRecordset = Mydab.OpenRecordset("HireDetails"...

Not sure I have tried all of this i think,, here is code but when it runs i get MsgBox "Can't find file 0" ?????

Well, I've tried what you said but no luck it seems that the vb editor is highlighting the "Set Myrecordset " line in yellow when it reports mismatch type 13:confused: It has to be a simple error

Hmmmn Well I did that but now im getting an error 13 type mismatch Any further suggestions. Heres the code Public Function AddRecord() wcustid = 999 Dim Mydab As DAO.Database, MyRecordset As Recordset Set Mydab = DBEngine.Workspaces(0).Databases(0) ' Open the table as type recordset Set...

Excellent Thanks I had forgotten about those things and was really worried i had a Duff Version :p

I am using Access ver2002 from Office Xp professional. I wanted to dim MyDb As Database but the drop down list does not have (As) Database only data accesspage? Is there something i need to activate or is there another way of doing this. When I simply type the line: Dim MyDb As Database I get...