Search results for query: *

I need to import a csv file into a new Access 2003 table using VBA. The file I'm given has 24 fields, but I only need 8 of them, and if I could change their field names that would be nice. DoCmd.TransferText acImportDelim, , "tblTestCSV2", "S:\WI\ACS\ACS QA\weektest.csv", True, "" brings in...

I have 24 workbooks, each with a summary row. I need to link each row with a similar row in a workbook that summarizes everything. I can do them manually by going to each cell, hitting =, then clicking on the cell in the other workbook, but selecting each cell individually will take forever. I...

I have Vista Home Premium on a 5 year old Dell Dimension E521. Over the weekend I was downloading a program to print business cards. I got an error message saying it couldn't download to Vista, but after I clicked OK it apparently kept trying, and the download shut the machine off. On reboot, it...

I have copied a table from another database into a new db. I've added a field, and want the default data in that field to be "CR". New records will get this default, but is there any way, without writing code, to push the default entry into the existing records? I'm in Access 2003. If the...

I have a report that needs to be viewed as well as printed. I have a button that prints it, and a button that views it. The coding on the VIEW button is simply DoCmd.OpenReport "rptOpenTickets", acViewPreview This doesn't work, however, because the Access framework is not up when the button is...

This time I'm just looking for theory on how to do something; I'll do the code once I figure out how I want to do this. I'm in Access 2003, using VBA. I have a textbox on a trouble ticket where the user can enter up to 250 characters to describe a situation. The user can subsequently edit this...

I'm having a problem inserting a carriage return in Outlook HTML being sent via Access VBA. Here's the pertinent line of code. objMail.HTMLBody = "Ticket " & intTixNum & " has been entered into Ticket Tracker by " & strEmpName & " concerning " & strIssue & ". " & strSomestr & " " I understand...

I have a table with autonumbers (field is ID), and I need to refer to the highest one in code. I want something like intTixNum = Max(tables!tblMaster!ID), but something that works. If the square peg won't fit in the round hole, sand off the corners.

I'm trying to send automated email from Access 2003 via Outlook 2003 SP3. I know there's a problem with Outlook's security that pops up 4 user intimidating messages. I'm using the following code, and wondering if I put a SendKeys command in, would it solve this problem. Public Sub SendEMail()...

I have a password on the Admin section of a db. If the password box has focus, and the user presses ctrl-pause/break, the user can bypass the password and get into the db. I'd like to disable ctrl-pause/break in vba to prevent this. How do I do this? If the square peg won't fit in the round...

I have a number of forms in the db, all of which open another form, then close themselves. The code DoCmd.OpenForm "frmA" DoCmd.Close acForm, "frmB"is in a button on each form. I have one form, however, where I want the exact same action, but from the form close event instead of a...

I'm taking data from a form and putting it into a table. ID is an autonumber in the table and Description is memo. Dim db As DAO.Database Dim rst As DAO.Recordset Dim strUpdate As String Dim varID As Variant Dim strSQL As String varID = Forms!frmEditTicket!ID strUpdate =...

I'm using VBA and SQL to input data from a form into a table using autonumber as the primary. I then need to retrieve the autonumber of the row just entered into another form. I'm getting a number, but it's the number of the beginning row in the table, not the one just entered. What's the SQL...

I know this is really simple, but I can't remember part of this SQL phrase. Call it a Senior Moment. I'm taking data that a user has input into a form and dumping it into an existing table. I have this so far strSQL = "INSERT INTO tblMaster ([InputDt]),Issue" _ & "SELECT Date() AS [InputDt] " _...

From my opening screen, I'm inserting a password feature for the Administrator on one of the buttons. I want the frmMain to close when frmAdmin opens. Here's the code: Private Sub btnAdmin_Enter() Dim strPW As String Dim strInput As Variant strPW = "password" strInput = InputBox("Enter...

I just inherited another db where the developer has used both modules and macros. I normally use modules exclusively. When is it appropriate to use macros as opposed to modules, and what's the advantage? If the square peg won't fit in the round hole, sand off the corners.

I'm trying to compare the ActiveCell in one worksheet to a range in another sheet looking for a match. strLead = Application.WorksheetFunction.VLookup(Worksheets("Perfect").ActiveCell, Worksheets("Lists").Range("$b$197:f$202"),2, False) It's giving me bad info and I can't figure out why. Row b...

I have a query of all calls into a callsite. Those that were transferred from someplace show the number dialed; those that were dialed direct I have blanked the number (ending in 7650) with the expression CallTrfdFrom: IIf(Right([calldata_b],4)<>"7650",Right([calldata_b],10)) I would like to...

When I use On Error Resume Next, I know that allows the following code to run, errors or not. Do I need to close with Err.Clear to clear any errors raised, or will On Error GoTo 0 do it? If the square peg won't fit in the round hole, sand off the corners.

I have a query with Group By, Sum, Expression and Count fields. I understand the Group By fields need to be at the front, but is there any specific order I should put the remaining types of fields? If the square peg won't fit in the round hole, sand off the corners.