Search results

Thanks, just tried it but not working, it's hanging up..

Hi All, I have a table that has a device column and a tag # column, I want to pull out a report that shows duplicate tag # for different devices, the tag # can only be assigned to one device, I received an excel sheet that has to be fixed, I have the sheet in an access table. Please help. For...

if someone please can help I have used the obove code the only problem i have is that i can't open word application, it highlts -----> Set appWord = GetObject(, "Word.Application"), can someone help. Everything else is working.

Ok guys got it, thanks, it's combobox.listcount

Hi guys I know how to count a listbox value, but how can I count a combobox, I'm trying to count the results in the combobox. for example if the comobobox has three itmes in it how can I count them in a textbox?Thanks.

Last Question ok Sir, I promise that this is the last quesiton, I'm about to give up, maybe my english language is not helping, ok forget all the above comments, what method do u advise me to use, I have a form and I want to run a check using two table, for example when I enter a serial number...

thanks ok thanks sorry to bother you, but i'm trying to debug the problem, i put msgbox change_order_effective_date but i'm getting blank msgbox?

Error Msg Thanks for your help but i got this error msg when I tried to run it from a button, attached is the error msg, here is the full code, Private Sub Command65_Click() Dim mySQL As String Dim db As Database Dim rs As Recordset Dim x As Long Set db = CurrentDb mySQL = "SELECT...

Thank you Thanks sir.

guys, can someone help, i copied this sql from the wizard window, i'm trying to put the sql in a vba code here is what i did, the select is not working it has syntax, can someone help? Dim mySQL As String Dim db As Database Dim rs As Recordset Dim x As Long Set db = CurrentDb mySQL = "SELECT...

Guys Help Please It's Holidays Ok Should I try to write dmax in sql and compare the results with the form input data? Please Please Please Assist, I know it's not as simple as you think.

sample copy here is a sample copy.

sample copy ok attached is a simple sample copy, open the form, what I want to do is create a new change order and in the form, I want to choose for example serial number ABC which is already in the table"it has three records" and then I want to choose "Add" Status and I want to put a date for...

I want to do this in a code because I want to run the code in the after update statment for the serial num field. so should I do it thru a select statment and then if the locatoin.field.inform is = to dmax in table then dislpay message???

I have a database the keeps tracks of printers by serial number. There is a form for doing this, the form has a serial number field, and a status field "example move, add, remove" , effective date and a location field. Here is what I want to do, lets say that the current location for serial#ABC...

Thanks Great Advice. This worked very good.

Hi, I have a text box in a from for data entry, how do I disable a space. For example I don't want the user to have a space between charaters or before and after a charater. Thanks.

Guys, Can someone help in this, is there a way to create an autofill feature similar to excel. For example if typed a value in the previous record and when i start typing it again, i want it to auto fill it just like excel. Thanks.

Hi guys, I created an input field in a form, I'm only alowing the user to input 4 numbers maximum no alpha, example 1234. How can I not let the user enter zero as the first number, example 0123. Thanks.

Oups Sorry,