Search results

hahaha... thanks bob you've saved some unnecesary typings for me so I'm spending it on you.... Is worth.

on AfterUpdate event of of field2: Me.field1=Me.Field2

yeah true, but seems that this is not happening as the record is saved only when you leave the curent record and move to the next or by dooing it programatically... the requierement seems to be to lock the controls automatically after the user has entered the data, so the user will stay on the...

sorry pressed by mistake the Post button... anyway the issue here might be your your approach... the subforms works as tree if they are linked trough their parent/child properties. You have also ensure that the subforms are requery-ed every time you are mooving to another record. You can have...

if the tables are used at the moment by you to ype in I guess that the tables are correctly defined...

Okay, I think that your problem is that the on current event is not fired you prob want the user to do something else... looking at the form :p . Kidding. Now, Couple of choices... Take the code you have been told and: 1.Determine which one is the last box they are filling and in the OnExit...

nothing is simple... as Paul suggested you should create a a teble for temporary operations then save the data source sql in a string variable alter it as necessary then anytime you need a simulation just replace the data source of your form with the string you have modified.

If frmEditContact is not set as data entry or the filter is not disabled, why you are not trying to display the Filter content in a message box by using [] to see what you have passed to frmEditContact and what is in the Me.lboRecent ant the passing time.

add a button say btnToggleFilter with the text "Show all" and in the on click event add: select case Me.FilterOn Case True Me.FilterOn = False Me.btnToggleFilter.Caption = "Show initial" case False Me.FilterOn = True Me.btnToggleFilter.Caption = "Show All" end select...

use combination of mid(),left(),Right() to detach and instr() to find [Space] character and val() to convert the results into a number.

Thanks workmad3 This is what I did... But I was tried to put together something like: Combo values(cboObject): proTransferFtp; proDeleteSomething;funCountResults;frmList;qryAllData Select case left(cboObject,3) case "pro", 'start Procedure Application.Run cboObject...

Thanks guys! What I want is to be able to execute different Functions and procedures from a form... I will create a module, send it to the users who will import in the DB then will use its Functions and Procedures by selecting them from a combo box. RunCode from a macro runs only functions but...

I would like to lunch Procedures and Functions within VBA. Looking in Help, Application.Run can do this but I can't make it work. Can anybody post a piece of code which can run a Procedure from a stand alone module in the same database please? Thanks.

Try: DoCmd.RunSQL ("DELETE FROM STOCK_TMP_STORES WHERE StockNo ='" & txtNewStockId & "'") or: CurrentDb.Execute ("DELETE FROM STOCK_TMP_STORES WHERE StockNo ='" & txtNewStockId & "'")

Regarding "Multiuser" database.... I would create a logon form and append each logon to a table having an autonumber as ID then I would save this value in a global variable. You can then include this number somewhere in your temporary table name and delete the table if is no longer needed.

Use .adp not .mdb...

Try to open a recordset and loop between the records or create a query and use the Sevcalc function... if is saved in a module then your function is available in the Expression builder... it will slow down your query but will work...

Try this: Combo box - AfterUpdate Event 'Transfer Row source if necessary Me.List4.RowSourceType = "Table/Query" Me.List4.RowSource = " ... " 'Refresh the control Me.List4.Requery

Hi, You can use sendkeys function but what I would do is to transfer the record source to the report from vba or to design a form which will look like a report or something similar....

Thanks Travis, The problem is that is not working in Access 2003. Do you know any other solutions?