Recent content by mdr0906

Thank you, boblarson.

Thank you for your response. You are right. I am not familiar with VBA. Any sample codes that you could share? Or sites that I could use as a resource? mdr0906

Hi, I would like to perform a conditional formatting in a form and would like your help. I currently have a form where users enter in data. To aid them in identifying the fields they would complete, I am interested in using a conditional formatting. For instance, if a user would select...

Hello, On a subform, I would like a text box to be filled in before the user saves the record and enters in a new one. Perhaps, have a message pop up when that particular box is not complete? Moreover, the box that I'm referring to is not the field that links to the main form. Hopefully, my...

Hello, sorry for the delayed response. gemma-the-husky, 1) The Access version that I have is 2002. 2) I am not asked for a password when I open Access without opening any database. 3) I created a workgroup called "sharedatabase.mdw" and it is saved in a shared drive. irish634, I tried to...

Hello everyone, I followed the methods described in the paper, "How I Use Security with Microsoft Access", and right now, Access is asking for a password to open every database and workgroup file. I also have a shortcut created to use the correct workgroup and it, too, is asking for a...

Thank you for your quick response. I think I'm grasping the concept better now.:)

Hello, I read the paper, "How I Use Security with Microsoft Access" that was suggested by a member in the forum. I followed the instructions on creating short cuts to use the correct workgroup. My question is once I created the short cut and opened the file, the workgroup path in the workgroup...

Thanks Thanks for the prompt response!

Hello, I would like a message box to appear after a user selects the value" yes" from a drop down in a form. Any examples that you might be able to share? Thanks. mdr0906

Thank you The form works now. Thanks.

Hello, I am receiving a "#Name?" message when writing the following expression as a control source of a text box in the main form: =[Account Info.Subform].Form!MFAAmountUsed There is a main form and a subform. I would like to include a simple calculation on the main form using a data from a...

Thanks This is good resource. Thanks:)

Hello, Combo 2 within a subform lists Products available to purchase upon the selection of a Supplier in Combo 1 within a main form. Upon completing the first product to purchase, I try to select another product to purchase with the same supplier in the second line, but it automatically...

Hello, I am new to VB programming and need help with writing a SQL query statement. I am creating a database with a Microsoft template, and I would like to incorporate interactive combo boxes. For instance, if I were to select a particular supplier in the combo box in the main form, then the...