Search results

yes, RichO....that's exactly what my problem is....... thanks for your input....and it has solved my problem entirely......:D

Hey, I have searched through the forum for my problem, and I have got one solution that might work... which is turn off the auto correct feature......but I don't know where to find this auto correct feature....can someone help?? thanks

I wanted to create a Stock Movement Report, but I am not quite sure how.....I need some help..... I have these tables: M_Stock (Stock information) T_GRN & T_GRN_Detail (Good Received information) T_IIS & T_IIS_Detail (Internal Issue information) I need to do a report stating the opening...

Is there any way to convert an Access front-end to .EXE file? Please help!

Maybe you can try this code: Private Sub cmdButtonName_Click() On Error GoTo Exit_cmdButtonName_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "FormName" stLinkCriteria = "[SuppID]= '" & cmbSuppID & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria...

There was no error message. When I click on the button, it just do nothing. I tried to compile the code, and it went fine. So I couldn't find where I did wrongly.

Thanks for that! :) However, it doesn't work. :(

I have a Maintenance form in my database, where the user can change the ref. no of a particular supplier. This form contains one comboBox (list all the current RefNo of suppliers), and one text field for user to key in preferred RefNo. I have wrote the following code for the 'Assign' button...

Listbox requery Hi, I need some help on this. I have a form that used to display suppliers information, and I have a listbox to display the products supplied by a specific supplier.....what I want to do is that, I want the listbox to requery whenever the user select different supplier....Could...

Max, Your code works! I just went to double check my code, and realise I did something silly. :o :o ......Thanks for your help :D

Max, I tried your code, it doesn't work. I went to check the table, and the field data still remains 'New'. Anyway, I appreciate your help. :) Thanks

Hi all, I have another problem :( :eek: When a form is open, I want to change a specific field data to something else (e.g. from 'New' to 'Read'). I wrote the code using UPDATE statement however, when I debug, it keeps giving me error. Could someone guide me please? Thanks Private Sub...

That's fine, I figured that out. ;)

Hi all, I have some listboxes on my form, I want to do like when the user double-click on one of the options in the list, a form will automatically pop up......is there a way to do this?

Hi, I have another question. I want to make one of my page refreshes every 5 minutes, I have already wrote the code for the Timer(), but how do I set the Time Interval? I don't know how to calculate that one. Thanks!

That's great, Wayne. Thanks a lot. :D

Hi all, I have a T_Log table in my database, which basically records all the log histories of users. I want to create a command button where the user can delete all the log records. How should I write the code? Thanks.

Hi, all I am trying to make a progress bar from this thread , however I keeps getting this message: Run-time error '2763': ProgCtrl returned the error: Invalid property value. When I go to debug, I found that this line of code ctlProgBar.Value = intCount is getting the error. Could anyone...

Is there any code to make the database screens always stay in maximized? Especially when the user opens up the database. I want Access maximizes itself when someone executes the database. Any idea? Thanks.

Thanks Wayne, but unfortunately, the code is not working as well. Anyway, what does the 'Nz' mean?