Search results

Hi, I have a form, frmUsers, based on tblUsers which stores info about usernames, userlevel, password. Only one Admin user has access to go to this form and add/delete users. It works fine. I have another form, frmOpp, that has a combobox that display the usernames which is based on...

Hi: I have a main form that has 3 subforms on it, a button on the main form that opens another form(lets say form1) related to the current record on the main form and users also add word n excel documents to the main form, it does not import the documents but just stores the path. Users want...

Hi: I have a combobox that shows my database tables. I want that when user selects a table, all the fields in that table should be displayed in the listbox. How can I do that? Thanks, Ekta

Hi: I have a combox on my form and if the user changes its value to "Active" or "Pending" a message box pops up that tells the user to make an entry in a subform. This is the code that I have on the After_Update event of the combobox If Me.NewRecord = False If Me.Combo = "Active" or Me.Combo...

I have a main form that opens maximised. I have a button onthis form that opens another form but for some reason this form also opens maximised, which I don't want. I used Docmd.movesize command but it doesn't seem to work. I would really appreciate if anyone can tell why it's doing that. I am...

Hi: I want to pass the value from one form to another. The field is a checkbox and I want it displayed on CHecklistsubform? I am having trouble doing that. Both the tables have a one-to-one relationship. I am attaching my sample db. I would appreciate any help. Thanks, Ekta

Hi: I want to know if it is possible to create a custom report where user selects the fields from the tables. I have one main table and tables linked to the many side of this table. Users want that they should be able select any fields from these tables and create their own reports. I don't see...

Hi: I want to create a report that would display only those records entered in the current year. So if I run the report it will show records only for the year 2004. I have a date field in the table that records the date when the record was created. How should I use this date to achieve the...

Hi: I have a combobox on my form that has values: Active, Leads, Lost, Pending, Retired, Won. Users want that when the value in the combo box is changed to Pending or changed to Active a message box should pop-up telling them to make an entry in another field. The message box should NOT pop up...

Hi: I use the code below to first convert files of type .ACY to .txt and then import them in access tables. But now I want that it should convert files of any types. They can be .LAS, .ORD etc. How should I modify the code to do this. My code is below: Private Sub btnImport_Click() Dim...

Hi: I have two tables, table1 and table2, that have a one to one relationship and I have two forms based on these two tables. Lets say form1(table1) and form2(table2). Right now user goes to form1 and click on a button to go form2. I want to pass a value of a field on form1 to a field on form2...

Hi: I have a database that converts datafiles of type .ACY into .txt and then imports them in access tables. Instead of using the import wizard I automated the task of importing . Initially,I had entered the path where the datafiles were saved on the hard drive manually...C:\Datafiles\ and that...

Hi: I have been asked to work on a database. I need some advice on how I should go about it. I have these text files which contain data and I need to import it in Access tables. The data looks like this: ACY, 0001, SUBCER1A, 1, N, 11 ACY, 0001, SUBCER1A...

Hi All: Users log in my database using their username and password. Once they login their username and userlevel is stored in a table temporarily using update query. I have a form which displays records for all the users but a user can edit only his/her record. I do this by checking the user...

Hi, I have 3 listboxes on my form. I want to reset them with one click. How can i do that? Thanks, Ekta

Hi, I have the code below on the No data event of my form. Cancel = True MsgBox " No Records were found. Please make a different selection" It displays the above message if no records are found but after that it also displays "The OpenReport action was cancelled" How to get rid of this...

Hi: I have a combobox on my form called cboType. The values in this combobox are Active, Pending, Retired, Lost. I want to display a custom message box when a user changes value in the combobox. The msgbox will display different message everytime depending on the selection. I don't want the...

Hi: I have a form that has a multiselect listbox and a text box. User enters criteria in either one of these or both and based on that report is generated. I am having trouble passing the criteria from the listbox to the query. I am attaching the db with what I have so far. I will appreciate...

Hi: I want to know if "All" criteria can be added to a listbox. Right now if users don't make any selection in a listbox it returns all the records. But users want to add "All" criteria in a list box to that. I know it can be done in a combo box. I searched on the forums but did not see it for...

Hi: I want to create my own custom error message dialog boxes. For example I have a number field on my form. If user enters text in that field I want to display my own error message instead of the error message displayed by access. Thanks Ekta