Recent content by zonexs123

Thanks JHB.... yeah there are alternative which can solve my problem however I'm learning VBA... so would like to do in this way.... Can anyone, help me out in my code....

Hi Everyone, Just stuck in the middle of my project. What I'm trying to do here is, update my access table ("Table1") from excel sheet ("Myexcel.xls"). Excel file contains all the information however access table is not updated except "RefNo" field. Condition what I coded here is when once...

Hello experts, Just returned to my favorite forum after a long gap to get help from you all. Actually, I have a access database with table name: UserDetails. Its having three column: From Subject Received Status James Lewis Binder Task...

Hi, I have a table called "Data" with following fields: 1) CompDate 2) LOB 3) Task 4) User Need a query or VBA to bring random records with certain % (ie. 20% or 30%) of each User withTask wise For example: User "Abhinav Verma" has done in total 17 "Binders". Need to show only 30% of...

Appreciate if anyone help me out to solve my problem....

Hello Experts, Thanks to all who helped me out in past. I would say this is the best place to get your answers :) Need your help again .... I have a database where there is a table in which there are some set of data. Now I want a query (LastestInception) to display only the lastest...

Hello Experts, I am facing some problem while adding records into two tables from single form. I have used adodb.recordset to do so. However its work fine when its come to adding into single tables (example table: "Data1"). Table1: "Data1" contain following fields: > Task > User > Address >...

Anyone please help me here.... Any supporting link or file will work as I am unable to find anything related to this. Many thanks in advance ......

Hi All, I have an form with textbox (Text146) which is use for Hyperlink. I need to click command button to find the file and link it. However its showing full path into the textbox (Text146) which I don't want user to know the path. I would like to show only "Snapshot" word into the...

Thanks a lot for your explanation. Really helpfull & learning.... Have a good day ahead :)

Thank you so much dear for your help. Its work like a charm. But I am confuse in below code... What does it all about. I don't think its doing anything in calculation. Case should be either US or WW... Case Else ' Something else? End Select Once again appericate your prompt reply...

Hello, I have a form where there is three fields: 1) Combo376 (Combo box) = Value list "US" or "WW" 2) Text358 (Text box) = User need to enter number of locations (any numeric value) 3) Text378 = this field show the TAT calculation and this value comes from following formula: Me.Text378...

Thanks a lot.... work like charm :) Need one more help from you experts :) if you can. As my fields are locked if value exist, can I highlight these fields in some color so user can identify these are not editable and are in read only mode. Once again you all are great and appericate your...

Thanks Smig !!! your advice worked now !!! but how can I apply to all of my textboxes. its more than 10. Should I have to code for each fields ?? like: If IsNull(Me.Text360) Then Text360.Locked = False Else Text360.Locked = True End If Any shorter process to do so.....

Appreciate your prompt reply but my problem still not solved. I know the above method however confuse where to add this. Here is my code: Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize Text452.SetFocus If Me.Text360 = "" Then Text360.Enabled = True Else Text360.Enabled = False Exit...