Search results

Thanks for replying Wayne. I added "\" but now when I click on the import button it gives Error 53 "File Not Found". I havn't changed anything in code. The only difference is that before I had manually typed in the file path and now I am using the browse button to give users more flexibility. I...

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...

Thanks for your valuable advice. I really appreciate it. I was told by the user that I just need to import the data from the text files in the access tables. It won't be used for anything else. But I am going to talk to the user once more and confirm that he won't ask me to create report...

Thanks so much for replying gmlwong. I tried your suggestion and created normalised tables. I am still not sure how I should import data in the main table. I also created another db with just one table with all the required fields and imported the data in it from the text files. It worked just...

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...

Figured it out. Private Sub ClearListBoxes() Dim i As Integer Dim ctl As Control Dim varItem As Variant For Each ctl In Me.Controls If ctl.ControlType = acListBox Then For Each varItem In ctl.ItemsSelected ctl.Selected(varItem) = False...

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

Great. Thanks

Hi Dave: I tried using your code for adding custom icon to the forms. But it doesn't seem to work. Can you please take a look at it. I am attaching the db and ico file. Thanks -Ekta

still getting the same error.

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...

Thanx

Thanks for replying a.sinatra. It is close to what I want. It shows the message box even when a user adds a new record. I want to see it only when they change the value in an existing record. -Ekta

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...

Thanx for all your help Wayne. I figured it out. It works just fine.

Hi Wayne: I already did. If you scroll up you will see it. Ekta

Wayne, I did take a look at the code behind the query button. I tried to incorporate that in my code as my code is a little different because of multiple listboxes but I am having a little trouble with it.

Hi Wayne: Thanx for the sample. That is what I want to do. But I am having trouble adding the "All" criteria in my code. My code loops through multiple listboxes and then builds the where clause. -Ekta