Search results

Is it possible to somehow get a name and the respective amount of money to be paid from 2 columns in an excel file and put them in a report to print onto cheques?

Hi, I got a problem with the cancel button in my form. I made a macro which sets all values to Null and then close the form. However, an unwanted blank field is created in the table each time the users opens the form and closes it using the cancel button. Any ideas?

Hi, I have a question about the Mod function in the Expression Builder. Is that the modulus of number (ie. returns the positive value of any number)? What is the syntax to use it? Brackets, square brackets...?

Hi, I need to change the Data Type of a field from AutoNumber to Number, however I'm getting an error message that the field is in one or more relationships. The thing is that there are no relationships linked to its table. I checked the relationships windows, tried "show all", but still no...

Hi, In the Before Update event of a text box I put this procedure, such that the user would get a message if he tries to enter a duplicate entry. Private Sub Tool_BeforeUpdate(Cancel As Integer) If DCount("[Tool]", "Tools Table", "[Tool]='" & Me.Tool & "'") Then MsgBox "This Tool already...

Hi, I need a validation rule that checks all values in a field for duplicates, before writing anything to the table. I already have the field set not to accept duplicates, however the form would try to write the value before checking it. If the value is a duplicate, the auto number set as...

Is there a way to restart the AutoNumber of a field (set as a primary key) to increment from 1? The only method I know of is to delete the field from the table design view and put it back, however I can't do this coz of the relationships. Thanks.

I need to make a validation rule so that a user is not allowed to enter duplicate values in a "tools" table. How can I make it look in the Tool Name field to search for duplicate values?

Is there a command or something that would clear all entries in a form (as if the user has pressed Esc)?

Hi, I want to show all transactions which took place on the current date, so I put Date() in the criteria. However, I'm getting an error: "This expression is typed incorrectly, or it is too complex to be evaluated." If I type a date (say 28-7-3), it would work perfectly. Can't find where the...

Hi, Is it possible to filter data in a report? I need to show results of today's date. The results are sorted by Date, however I would like to show only the trasactions which happened today. Thanks, Mike

Hi, I am using access97 at work and need to work on the same database at home, where I have the 2002 version. Will I have any problem, or are they fully compatible?

I have a query which selects the transactions made on the current date by using Date() in the criteria. I did this so that I can make a report of today's transactions. Problem is that the query only returns the transactions with a positive quantity (positive means item returned to stores...

I have a form open in a dialog window mode, which prompts the user to either print the report being displayed, or close it and go back to main menu. Is it possible to set a position where the form opens, so that I can place on the side and the user won't have to drag it to be able to view the...

Hi, I have a database with tools, divided into categories. In a form I need to hae 2 combo boxes - one in which the user chooses the category, and the second in which he chooses from the tools in that category. How can I make the tools in the tool combo box change, depending on what the chosen...

I have a text box in a form which shows the quantity of a particular tool a person has from a query. I am using DLookUp, however I have 2 criteria: person and tool. First, is it possible to have 2 criteria in a query? And, is it possible to use DLookUp in the control for this? Thanks, Mike

Is there a way of showing data of a query in a text box in a form? I have a Query "Balance in stores", which is updated with every entry in a form (ie. with a tool being issued or received). In the form I have a combo box in which one selects a tool from the list for issuing/returning in...

I have a Query "Balance in stores", which is updated with every entry in a form (ie. with a tool being issued or received). In the form I have a combo box in which one selects a tool from the list for issuing/returning in stores. I need a text box showing the balance of the tool selected from...

I need a value entered from a form to be changed before being written in a table. The users enters a value in "Quantity Issued" in a form, which is then written in a field "Quantity" in a table. Now, I need the value entered (say 9) to be written as (-9) in the table. Is it possible to...

I need a value entered from a form to be changed before being written in a table. The users enters a value in "Quantity Issued" in a form, which is then written in a field "Quantity" in a table. Now, I need the value entered (say 9) to be written as (-9) in the table. Is it possible to multiply...