Search results for query: *

Hi All, The strangest thing is occuring when I try to open my DB. I have the DB protected by password, each user with its own password. The DB opens directly to a main form, with all the options for the DB. When I open it from a certain PC, It asks me for the user ID ans Password. I enter...

Hi all, When a field is a combobox you can decide if the values will be limited to the list or not. In a list, they are always limited to the list. Is there a way for the users to enter any data, and not only that of the list? Thanks. Edgar

Hi all, I have a an order form. Each order has it's own ID. On of the fileds in the form is company. When I select a company from a list, it automatically fills other list fileds with data from older orders from that particular company. If that company had only one previous order it only...

Hi all, I am Having trouble with an update statement. I have a form with a list which populates through a simple search. Once It populates, I double click on one of the items. When I double click, I would like to update a record in a table based on records in another table. I use the...

Hi all, I have a main form and a subform within it. I have an undo changes button in the main form. When I press this button it reverts any changes made to the main form but not to the sub form. Is there a way to rever changes in both forms when I press this button? Thanks in advance

Hi, I am using a form to filter a report by different criteria. These are a Order ID (number), Date (date) and Client (string). I have no problem when filtering by client and Order Id, but I do have a problem with the date. I do not use the american format for dates (mm/dd/yyy), instead I...

Is there an Easy way to auto fill certain fields in a form from data of a previous record? In my case I have an order, and I wish to create a new one using data from a previous record. I need this new record to have its own ID, but re use some of the date of a previous record. It should be...

Hi, I Have the following code. Tha idea is that if tblPedido.Anulado is equal to False (Anulado is has a Yes/no type) when I double click a line in a listbox it will open a form. This listbox is populated by a search function. I need to open two different forms depending on the information...

Hi to all, I am adding numbers with decimals to a table using a form. The problem is that access keeps rounding up the the nearest full number. For example, if I imput 0,25 access saves 0, but if I input 0,51 it saves 1. What should I do for access to save the exact number I enter?? Thanks.

I have found another way to do this which I fond more easy to use by the users. I am using a search form which filters the records by date and depending on the date it will let me edit the record or not. By the way, I want to put a yes/no button which will let me display a message box before...

Hi to all, Is there a way to "commit" a record in a form and make it "unchangeable". In other words, I need to put a button in a form wich will save the current record and won´t let anyone change it anymore. Is this possible??? Thanks

Hi, I am using a combo box which, after selecting an option automatically fills a text box. In my case, I choose our clients name from the combo box and it should automatically fill his telephone number in the text box. The problem is the it does not fill it automatically. I have to click on...

Hi, I am using a combo box which, after selecting an option automatically fills a text box. In my case, I choose our clients name from the combo box and it should automatically fill his telephone number in the text box. The problem is the it does not fill it automatically. I have to click on...

Hi to all, I have found in the web a microsoft example how to filter a report using combo boxes in a form. I have found it to be really usefull for what I need to do. The problem is that I ma having trouble with the data type. Here is the code for the filter command button: Private Sub...

Hi to all, I need to create a command button which will let me filter a delete query? In other words, I need to have a button that when clicked will ask me for the delete criteria of the delete query. In my case I have an orders table and i want, through a delete query, decide which order to...

Hi to all, I have two como boxes. The first combo box which it's source is a list with two values (1 and 2) determines what information will show up in the second combo box. I am using this code in the afterupdate event of the fist combo box to acomplish this: Private Sub...

Hi to All, I am a new user to access and trying to build a small application for my Company. I have a Report which shows all client orders. I also have a form with a command button which I use to filter the results of the report by date. If I enter a date for which an order exists I have no...