Recent content by Mezta1988

Use an update query or rather two of them to set the values for all records. can you please elaborate it properly, as you know I'm not really good in access so I'm having a hard time to understand you reply. Thanks,

Hi, I have a query with multiple fields, Three of those fields are named "FirstName","Condition" and "Status". The condition field can be one the following, either "Working","Under Maintenance" or "Damage" and for the status, it's either "Availbale, Unavailable or Assigned". If the condition...

Thanks Plog and Ranman for the very informative info. it's working now.

Hi experts, I have a trouble filtering my query and report using combo boxes, I also use a wildcard on the criteria field to do the filtering. These are the following table that I made for this specific practice. 1. Employee -ID -FirstName -LastName -Occupation 2...

@isladog Sorry if it's took a while for me respond, I got busy yesterday on one our site and just got home right now. By the way I'm creating a simple query filter using a form and a combo box but the problem is when every time I put a criteria on one of the fields then the records get missed...

I don't think I missed something, All I know is I copied all the necessary codes both from the main form and subform.

I dug every corner of you database but I'm still getting an error, I'm even still working on it right now but those error codes seems to be so keen to show up :D.

@isladog I didn't know that it was meant for multiple selection, I just saw a that on youtube. I tried to follow the codes that you gave me but everytime I solve an error then another error again will come up. by the way what type of frame you use for the "errormsg" which the Photo not available...

Hi, Run-Time Error '438': Object Doesn't support this property or method. I'm creating a button to upload a picture file but I'm getting the above error code. Private Sub CmdAddPhoto_Click() Dim f As Object Dim strfile As String Dim strfolder As String Dim VarItem As Variant Set f =...

Hi, I solved the error for object library by following the picture you posted earlier, but new error comes up again from the "GetPathWithoutFilename". Compile Error: Sub or Function not defined.

I think the User-define type not defined error an object library issue. But anyway thank you again for your help...

I did not saved it because nothing has changed, like I said the checkbox as the default propoerty of YES/NO cannot be changed to text box. By thae way I did solve the issue for the label error, but unfortunately after I compile again I get another error.

I did not save the table after making some changes. I tried to run the VB code again but same error message is showing.

Alright, I noticed also that you PhotoAvailable field in the table is set to yes/no but when I looked at the Lookup beside general tab is set to textbox, I'm trying to change mine but it's not changing. What I mean is, if I select the textbox it switch right away back to checkbox even though I...

I'm sorry if I can't help my self not to address you using that salutation:D . Anyway, I have a question regarding the PhotoAvailable inside your table and when I checked your frmContactDetails it seems like that field is hidden. And one more thing I attached a JPG image of the code which I...