Search results

Bob, I have no experience with 2013 but just as an added suggestion, you might look at a db I wrote which is in the sample section named Group Emailer which you may be able to adapt to your needs. Other than that, it's above my pay grade.

Bob, are you talking about sending out multiple statements at a time? If so, I would suggest saving them to a folder and then attaching them to a email.

I'm assuming you didn't write that code! Anyway, here is a example: Of course adapt to your situation. It would be called via your module. 'Closes db in 30 seconds, form timer interval is set to 1000 Static StVarExpiredTime As Variant Dim varElapsed As Variant varElapsed...

Idle is your best option. It's what I use myself.

Steve R I have been a long time user of Linux. My distro of choice is Mint/Rafaela Combine it with Crossover and your set. Windows 10 will be the New XP. Downside is privacy.

Sorry, I rarely use Macros. As has been suggested, use the wizard to obtain your results. Also search on here and Google it. Good Luck!

Not sure what you mean by send! By email, to folder on hard drive? What? Anyway, here are 2 examples: DoCmd.OutputTo acOutputForm, "YourFormName", acFormatPDF, "C:\YourDir\OutputFile.PDF" 'Print Single Record on Form. Dim myForm As Form Dim PageNo As Integer PageNo = Me.CurrentRecord Set...

Will you be upgrading to Windows 10 and if so, why/why not?

The Register reports that Windows 10 will include, defaulted on, "Wi-Fi Sense" which shares wifi passwords with Outlook.com contacts, Skype contacts and, with an opt-in, Facebook friends. This involves Microsoft storing the wifi passwords entered into your laptop which can then be used by any...

Surely Microsoft and the NSA are sleeping together! Hey, thanks for sharing my password with the world! :banghead:

You can have an unbound search form and then bind the control on the form to the value in your query. Criteria in your query = [Forms]![yourformnamehere]![controlonyourformhere]

Those forms refer to table/queries for the data and so you use that as the criteria on your form for a search. Also, if you do a search, there are already pre-built search forms that you might be able to use. Good Luck !

Can't you just do that from the form that contains that info? Example: Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[jobid] = " & str(Nz(Me![cbosearch], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Can you show us a pic of what your trying to do? Need more details.

Refer to your query field and add the forms field to reference. Example:

I still don't know how you are trying to get this information. Normally it is trapped when you log into the database. Is this your setup? Your syntax is all over the place? You can only retrieve what is stored! UserName will not give you what is stored in your table.

Try something like this: Unsure of your setup. Here is an example: Me.txtwhoareyou = DLookup("[UserID]", "tblUserSecurity_Sec", "[UserID]='" & Me.txtuserid.Value & "'")

Do you have the full name of the user stored in your table?

Something like: Of course adjust to your needs. Me.SomeCombobox = Environ("UserName") HTH

Resistance is futile, you will be assimilated !