Search results

When I go to properties, I don't see the unblock checkbox like in some tutorials? Thanks.

I have a table that has data that looks like this... I need to create a query that gives me everything before the first space ADVA80403 Advanced AIRC23072 Air BETV16523 Tom Need it to look like this. ADVA80403 AIRC23072 BETV16523

I'm combining a few fields and need to have a return (next line) after each. =[Street Address] & [Street Address Line 2] & [City] Street Address Street Address Line 2 City

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.

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 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.

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'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] &...

[Mlink] = "#\comps\pdf\" & [Msample] & ".pdf#" Msample data looks like this: 12345.SPA, so the above results is: \comps\pdf\12345.SPA.pdf How can I remove the .SPA? So it looks like \comps\pdf\12345.pdf in vba.

I'm using the following code to lookup if a number already exists. Works fine. I would like it to search in three other fields as well. Msamplenumber2, Msamplenumber3, Msamplenumber4 So when it does a lookup, it would look in all four fields. How can I combine those extra three fields below...

I'm using the following... .Attachments.Add "\\Web\bass\pdf\" & [Msample] & ".pdf" I would like to create an if statement for the attachment line. If IsNull([Msample]) Then .Attachments.Add "\\Web\bass1\pdf\" & [Msample] & ".pdf" Else .Attachments.Add "\\Web\bass2\pdf\" & [Msample] & ".pdf"...

I'm working with a hyperlink field. I know they can be tricky. I'm trying to do a find and replace but it changes the format? In the past, I had to export to excel but wondering if a better way exists. \\server\testing\custom\12345.pdf file:///\\server\testing\custom\.pdf (after replace)

If IsNull([sampleid2]) Then [field1] = [sampleid1] & ".RPT" Else [field1] = [sampleid1] & ".RPT" or [sampleid2] & ".RPT" I have a command button that checks for the this. How can I have "the Else" prompt the user to select either [sampleid1] or [sampleid2]

I have a report that normally has two pages to it. Is there any way to not have the second page based on if [results] = "fail" Rather than having to creating a separate report. Thanks

How do I add these two together in on line? If ([standard] <> "apple") And ([frequency] = "annual") Then strDocName = "report1" msgbox "all good"