Search results

My code for saving the PO Private Sub cmdSavePo_Click() 'Insert PO number into MXDPORunningNo table If Me.txtCode.Tag & "" = "" Then CurrentDb.Execute "INSERT INTO MXDPORunningNo(CompanyCode,YearCode,PONumber,MRName)" & _ " Values ('" & Me.txtCode & "','" &...

Hello all, How do i prevent two user who are accessing the same Access database to have duplicate PO number (Running number) when both of the user click "Save PO" at the same time?

Thank you so much. If i have a textbox on my form and when i browse and select the image will the file location be shown on the textbox? As i want to save the file location in my database

Hi, I have uploaded my database

Yes i do have. In order to have a image source have to choose the last icon on the design tab right?

I am able to browse and select the image, but the selected image does not appear on my form

Hmm, if i set the path like this, means that my image will only that path then if i wan to have a new image for the next data i will have to set the path again?

Sorry, i don't quite get what you mean. Can you explain again?

My code: Private Sub Form_Current() Me.image88.Picture = Me.txtGarmentSketch End Sub The code does not work tho as in the picture does not appear on the form. Or can i use button to browse the image i want to insert in the form?

i am using single form. I will key in the image path in the garment sketch

oh yeah! That's what i am doing now is to store the image path for each of my PO. I do not have a button to click like yours. So i will have to have my code in the form current right?

I have a code whereby i will click on edit so that the data from subform appear on my form. When the data is on my form i will key in the image path before i save it. Is that consider as update?

Is this correct? Because it is not working. Private Sub Form_Current() Me.Image88.Requery End Sub I have remove the control source for the image control.

Hi guys, am facing a issue whereby my image is the same on my form even if i have change to another data with a different image. How can i solve this? I use control source to tied the image control on the form. I am thinking maybe VBA code would be able to help me solve this issue, however i do...

okay. I realize that the MainSampleData table have 100+ reocrds when my excel sheet only have 33 records.

Hi, what is the different between paste error table and the temp table?

Thank you! it works

Yeah, I know. As the data from my actual database is confidential. Therefore, i came up with this sample database with the exact same code and query.

If i delete some data from the Mainsampledata table, it will still still show no new data added

The first one is based on the sample database, as my data contain sensitive information hence i am unable to attached my actual database here.