Recent content by tkoh78

hmm.. still problem Thanks again Peter. I am still having problem. Could you send me an example? When I put Me.PrviouseDate=Me.Date, the error message pops up saying that Me macro or module does not exist. Maybe I am doing something wrong. I am attaching a simple version of database that...

Thanks Dennisk.. However, if I understood correctly, in order to use datediff function, I need to have values in two columns. However, I have all my values in one field, namely Dates. Thanks Peter, Unfortunately, I did not understand "Me.Previousdate = Me.Date" code. What is "Me"? I guess...

Hi, maybe I am searching for wrong words. Hopefully this question has not been asked. I have values in column. I want to know if there is a way to do calculation of those values. Example: Date 1/1/07 2/4/07 3/2/07 I want to show days elapsed showed in the report. So, from 1/1/07 to 2/4/07...

Please explain more. I don't understand what you are trying to achieve.

1. Simple solution would be using update query. Do internet search for how to use update query. 2. More advance solution would be create a select query with both tables joined in a relationship. Set-up a creteria for dates. I'm sorry I can't go into details because I can't see your...

Hi, I have not written a trainer myself. But maybe I can help you out by asking few questions. 1. Is "stat" that you want to change numeric? 2. Do you know if the game checks for changes in memory? 3. Have you try gamewiz? Basically gamewiz is the one that I use the most for "cheating" or...

hopefully this helps Here is a simple solution, especially if you are new to the Access. I am assuming that you are using a form to view the page numbers. 1. Create a form with an unbound combo box containing ArtWorkNumber. 2. In the same form, create an unbound list box containing...

I have an unbound text box. I put a value, run an append query and append the value to the table. I want to know if I can delete the value in the text box automatically when the append query excutes. I am using a macro to run the append query. Thanks.

I have a form that is set as "continuous forms" view. I would like to run a single query or macro which will run for each record. For example, I Have 5 records. I have an append query. I would like to run a query once to append all five records. Here is a problem. I want to append first...

Well... problem solved. I found a way to do this without writing a code.

You can use macro for this purporse. When you first open the macro the "condition" column is hidden. Press "condition" icon from the menu bar. (the icon next to insert rows icon) Under condition column type the condition you want, such as [forms]![form name]![control box name] Is Not Null...

The macro action is "Save". Assign the macro to OnCurrent event on the form that you are trying to update.

Create an macro with "save" action. Assign this macro to OnCurrent event of your invoice form or whatever you want your record to be updated. Hope this helps.

I presume that you are using macro to excute your open form command. Create another macro with "save" action. Nothing more needed. Assign this macro to your search form under onCurrent event. Hopefully this works.

I need help with creating a macro. I want an user to input a record and number of replication to make and with a press of a button, a record will be replicated user input number of times into a table. How do I do this?