Search results for query: *

Hi, I have a form that is used for user to enter password, is there some setting in Access that when user enter their password it shows only asterick? Thanks.

Hi Everyone I have an Access DB that link table to an SQL Table that has about 75 fields. When I create queries, I noticed not every field are shown in Access. Is there a field size limit in Access? if there is, how can I make it to see the rest of the field? Thanks for help.

Hello, I have a send button in a form when clicked it put some text information on an Outlook email so I can email it. My question is is there a way I can underline or bold part of text body? Here is the body of my email: strBody = strBody & "UserName: " & Me!UserName & vbCrLf & vbCrLf...

Hi Everyone. I have a subform which in Detail line have Item#, DateShipped, Qty, and a Returned Checkbox. What I want to do is when the user check the Returned chkbox, I want to make the Item#, DateShipped, Qty Backcolor to grey for a better visual effect. My problem is when the checkbox is...

Hi, Let say I have a form with 5 records that displays: Last Fist Unit Cost TotCost chkbox Smith John 2 $5.00 $10.00 Hill Mary 3 $2.00 $6.00 . . When I check the chkbox for example on Smith record I need the Cost and...

Good Morning All. I have created a view from SQL2005 using a table that include a Primary key (named UserID). Let say in the view, I have something simplified like that: "Select TOP (100) Percent UserID, Last, First, Age From dbo.tblUser Order By Age" In the Design when I execute...

I was trying to learn ASP.NET and found something interesting that I though I can use in the future. This is the link http://mattberseth.com/blog/2007/09/freezing_gridview_column_heade_1.html I click on the live demo and I found it really slick. Unfortunately this is in C#. If I was to do...

I Keep having this error when I click on Newrecord button in my Access ADP form. "Object Variable or Block Variable Not Set". Could someone give me an advise, please. This is my code: On Error GoTo Err_CMDNEW_Click DoCmd.GoToRecord , , acNewRec Dim dbs As Object Dim qdf As Object...

I have an Access query that I am having difficulty to convert it to SQL view. Here is the Access03 Query: SELECT qryOrder.ID, qryOrder.PatientOwes, qryOrder.DOS, Now()-[dos] AS data...

Hi Everyone. Let say I have an Access DB with a report when run, would request to enter a parameter (as criteria filter) then would display a list of people. For ex: when i open the report it then run a query that will ask me the enter a first name and when I enter John, it will then display a...

Greeting. I have a situation where I have to display a comparison view of data of an input date to the data of a month earlier than the input date. Does it make sense? Let say I have a table as follow: Item Date Qty ----- ------ ----- AAA...

Hi, I want to create a textbox for user to enter a search criteria. Let say I have a SQL table Grocery with 2 columns "Manufactor" and "ItemDescription". The table will have entries like these: Manufactor Itemdescription ABA sardine with tomatoes sauce 8oz. ABA...

Good morning all, When my Gridview is empty (no data meeting a criteria), how can I reference the condition in vb? I tried this but obviously did not work "if Gridview.Text = Null then" Thanks for help

Hi, I have an Excel table that looks (in a smaller version) like this: Item Shp1 Qty1 Shp2 Qty2 Shp3 Qty3 ------ ---- ---- ---- ---- ---- ---- 1234 1/25 1 2/25 1 3/25 1 4567 1/26 1...

Happy Holiday I have a column that accept data as mm/dd/yy format. the problem happens only at this time of year. When user enter 01/05 and press enter it will automatically set to 1/5/2005, but what it really should be is 1/5/2006. I assume it gets the year from the system but is there a way...

I have a search Cells.Find(What:="n", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate End Sub When it find "n" how can I determine what row is "n" in. I need to use...

Good Morning! I have an Excel file that has 2 sheets. Sheet1 is as follow A B -- -- 1 Y 2 N Now on Sheet2 I have exactly the same as Sheet1 because the cells A1, A2, B1, B2 (of sheet2)are just referenced from sheet1_that is A1 (of sheet2) =sheet1!A1 and A2=sheet1!A2...

Good Morning! I have an inputbox I use to request date from users in an Excel sheet. And according what the user enter, it will perform certain fuctions and if the user click on Cancel I want to have an If statement to detect this event and perform other fuctions. I have...

Hello everyone, I have a table with column A as index and column D alphabets as follow A B C D ----------------------------- 1 a 2 b 3 c 4 d and I have this...

Morning, I have an Excel file that has 2 worksheets. Both of them have command buttons and macros and are protected and users are supposed to update the fields that they should be doing. However, some of them just Select the entire sheet and did a Copy and Paste in to a new one and modify it. My...