Search results

I have a popup form listing records in a query. Three buttons in the header are used to specify the sort order. They work well--they sort properly and load a text box in the header with a number for later reference as to the preferred sort order. When datum is entered in one of the fields of...

My apologies! Dumb mistake--EntryOrderNumber wasn't in the query upon which the form was based. It is happy now!

What in the world am I doing wrong? Macro for OnClick checkbox: SetValue [EntryOrderNumber],DMax("[EntryOrderNumber]","[MembersAscending]")+1 I get ERror 2950.

Ranman256, I finally found it--SendTo isn't in the action list, but EmailDatabaseObject is, and it did exactly what I needed! Thank you.

I still can't figure out how to do this in a query or in vba. All I have is a query that has to be sent to a recipient as an Excel file.

I have a button that exports a query as an Excel file and lets the user browse to the location to save to on their computer. Is it possible with one click of a button to open the email "send to" and send it as an attachment in one step? It works just fine as it is, but the user is only saving...

Thanks to both MarkK and CJ. The solution ended up being so easy thanks to your insights. All I did was add a query to empty the input file table whose field was defined as numeric, then import the spreadsheet into it. It changed the field in question to the defined type of the existing empty...

I am importing into a temporary table--how do I specify the datatype? The code lines: Dim vFilePaths As Variant vFilePaths = fGetFile(e_MultiSelect + e_FileMustExist + e_Explorer, , , , , , _ "Choose file to Import", , 4096) If Len(vFilePaths) > 0 Then...

I get that storing numbers as numbers is proper for a number of reasons. If I change the definition of the field to integer in my table and the incoming Excel file, the format of which I have no control, comes in as text, I still need to programatically make it match the table def before the...

My table has an item # defined as text, although it is all numbers ( inherited this). I will be receiving an excel file from time to time with the item # and a value for another field to be updated. My problem is that the Excel file sometimes arrives with the item # as text and other times it...

You might be right, sneuberg! However, these are volunteers and I don't wish to tick them off! Whether or not they log off isn't central to the running of the program. My curiousity is the problem, and I might need to understand the what is happening here in the future.

I have a hidden form that opens via the autoexec macro and grabs the computer name. If it is the first time that computer has accessed the (mysql backend) database, it asks what name should be associated with it. One of the tables in the backend is "users" which keeps user names, computer...

Hi all: thanks for all of your help. What finally worked was moving my code to the AfterUpdate event. Yay!

I have a popup for entering a password -- if the correct password is entered, another form opens and I want the popup to close automatically without the user having to click a close button. I get runtime error 2585 when I put DoCmd.Close acForm, "EnterPWord" in the onOpen event of the new form...

I am using ODBC tables as backend for organization's Access 2010 database. I have passworded the entry form for the treasurer's data. Private Sub Form_Open(Cancel As Integer) Cancel = (InputBox("Password?") <> "xxxx") DoCmd.Echo False, "" DoCmd.GoToRecord acForm, "FinAccount"...

Thank you The_Doc_Man. I have added .sender to my code and that seems to work. Still have a few issues, so I may be back, but this solves one.

I have written an Access program with its tables in backend odbc db online, shared with about ten ladies for keeping up with organization's membership. One important feature is the ability to send emails to any member whose "send email" box is checked. The vba routine uses old cdo code and for...

It works! It works! Thank you so much!

speakers_86, I am finally back to working on this. Obviously, I really don't know what I am doing. I copied your code into module1. Then in code for the form in question, I tried to enter in the mouse wheel event: call scroll ( , ) No matter what I try to put in the (), it errs. If...

Thanks speakers_86! I may give this a try. Let me know after you test it on a 64 bit installation if you run into any problems. I'll wait to be sure before I add it to the program and send it out to a lady who is running out of patience with me!