Search results

An Unbound TextBox with the Record Source set to =Now() will give you the Current Date and Time. But as Pat stated, a report is better for printing. You can use the same textbox in the report.

You need to add the Tenants table to your form in the forms Record Source, link it to the Security Deposits table and pull the Tenants name into the query. Also, hope that this is not real data, I wouldn't want someone sending out my Social Security number to a Forum where hundreds can see...

And there we are...another coding snafu thanks pb...

Ok, this is driving me nuts.... Utilizing Access 2007 I have a report that I want to export as a PDF. The report is based on a query that calls for the specific ID number from a form (ID = [Forms]![frmPeerValid]![ID]). Query works fine, and if you open the report it works fine, but when I...

You should be able to adapt the code into your form. My Espanol is a little rusty...can you translate the error you are getting?

Access 2007 actually implements this exact feature internally. You can create HTML email forms or InfoPath forms to send out for users to fill out. When you receive the emails the data will be automatically pulled into Access.

Me, the objective first person singular pronoun in English, see I (pronoun)... Wait, Max is right... :)

How many spaces do you have between the *' AND?? There should be 2...

Take a look at the attached Search Db sample

Add the following to the Before Update event of the Paid checkbox Me.NameofPaidField = Date HTH

If the Client View is a form then set the default Display Form to that form: Access 2007 - Windows Icon (Top left corner) / Access Options / Current Database / Display Form (select your form)

The String Conversion Function will accomplish this: StrConv([FIRST_NAME],3) StrConv([LAST_NAME],3)

You can apply a password to the buttons OnClick event If InputBox("What is password?", "Password Protected") = "scooby" Then DoCmd.OpenQuery "Nameofyourquesry", acViewNormal Else MsgBox("Incorrect password", vbOKOnly, "Invalid password") = vbOK End If

Search the forum for "security tables" there are many helpful posts that can lead you in the best direction for your database... http://www.access-programmers.co.uk/forums/showthread.php?t=93824&highlight=security+tables...

I'm not sure how your tables are set-up, but have a look at the following sample database. It uses a pricing tale and pricelist type to resolve a Pricelist that can be exported or written into a report.

Check out this post: http://www.access-programmers.co.uk/forums/showthread.php?t=50856&highlight=attachment+sendobject

Use the Sorting and Grouping button and add a Footer to your Department field. Do your calcuation in this footer area of your report

I believe this is what you are looking for. Add the following function to your database Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal...

Take a look at this example...

Here is one I use, see if this is any help... IIf([category] Between 0 And 1,"Current",(IIf([Category]=2,"Active","Legacy"))) This returns the following Category 0 = Current Category 1 = Current Category 2 = Active Category 3 = Legacy Category 4 = Legacy If you give us the other iif...