Search results

I have a form that has a field (name) that has all CAPS. How can I create a command button (vba) that will convert that field to lower case? Thanks.

Is it possible to copy the value from a field on form1 to a field in form2? Would like to do it in a command button if possible. Thanks.

Thanks Doc. I've looked at all the permissions, folder, etc.. all look correct with the "modify" permission applied.

Don't bother!!

Does anyone have any ideas on this?

Yes

So, yesterday I was having an issue with QuickBooks and multi-user function. A tech from QuickBooks remoted in and changed some things on my computer that has the QuickBooks file. That same computer also holds my Access Database. I did not actually witness what might have been changed. So...

I did but it happens so fast. Sometimes the barcode scanner is a bit slow and has a lage. I will try it though.

I have a form for data entry. I use a barcode scanner that simply enters a value into that field. I have some code on the after update the moves it to the next record. My barcode scanner comes with the "enter" after each entry. Problem is I have that disabled for other software/s that I use...

DoCmd.OutputTo acOutputReport, , acFormatPDF, "\\SERVER\Billing\" & [Mdid] & ".pdf" How can I make the above include the date as part of the file name?

I'm having some trouble with this... I can't get the Is Not to work? I basically need the correct use of Is Not. If ([Mstandard] Is Not "1989") And ([Mfrequency] = "Semi-Annual") Then strDocName = "Report-Semi": MsgBox "Semi-Annual", vbInformation

I have a report that has several buttons on it. Send to a folder as a pdf, email, etc... I created a sub rountine for those buttons. How can I use that same sub routine on other reports? Thanks.

after update

I just want a simple msgbox alerting them but not let them continue. Nothing super secure.

I'm using the following code to notify the user that they can only use a certain amount of characters. How can I prevent them from continuing instead of just a text box? If (Len(Msite) > 29) Then MsgBox "Text too long - Max 29 Characters", vbOKOnly

I have a form that has four fields, date fields. I would like to find the records where any of those four fields match? What is the best way to approach this?

I see it now. Thanks!!

Thanks!

I'm using the following code. How to do I get the value "comps" to appear where test is? Because it's wrapped in the quotes, I'm getting just the word test. What am I doing wrong? Dim test As String If ([Mdid] = "COMP32145") Then test = "comps" [Mlink] = "#\test\pdf\" & [Mspectraid1] &...

need to remove the period and characters to the right.