Search results

I have a field in a table containing date/time values, and want to use a parameter query with a form from which the user can enter a value in a date picker textbox. When a date is entered, however, no matching records are found because of the time in the field values. I can get it to work by...

I'm creating a form tied to a table with only a date in it. The subform's table has the date and a filename as the PK (multiple files per day). The Form_Load event goes to the last record and checks the date. If it is < today's date, it creates a new record with the current date, so the first...

I have a db that includes buttons the users click to send queries as email attachments. It has been working fine, but now they get the error "can't complete the Output operation.". It works fine when I run it. I'm on Office 2013, and they are on 2010. If I log in to a 2010 machine, it doesn't...

Sorry, but this will take a bit of explaining. I'm developing a Pre-Underwriting QC Checklist for our loan processors. It includes 66 questions that are divided into 15 sections. The main form, Audits, has one record per loan, and 15 subforms (Section1, Section2, etc.) on a tab control, since...

I'm creating an Audit form with a combobox from which the employee name performing the audit can be selected. The data source is the EmpNames query which selects from the Employees table, linked to another database. The EmpNames query includes a record selection criteria where...

I have a perplexing problem. I'm creating a simple db to enter borrower audit checklist data with the following tables: Questions -- A list of 17 pre-defined audit questions, with fields QNum and Question Audits -- One record for each audit (pk AuditKey is an Autonumber), and some borrower...

I have an append query that adds data to a table in another database, but I want it to replace the data every time it's run. How do I clear the data before running the append query? The databases are not linked, and I don't want them linked.

I have a security-enabled .mdb file. It services multiple branch offices, and each branch is set up as a "user". The branch managers are set up with a desktop shortcut with /user and /pwd switches. The user is simply the branch number, so when they open the db, code and filters are used so...

I have a subroutine that works well for sending emails. A need has arisen to, in some cases, send an Access report as a PDF attachment. I know how to do this using the SendObject method, but that won't work in this app. I also don't want to have to first save the report as a pdf file. I...

When I run the following code, I get the "Too few parameters. Expected 1." message when it hits the Set rsQry line. However, if I go to the Immediate pane, extract the TxtVal value, and paste it into the SQL window of a query, it runs just fine. Why would I get this message from VBA when it's...

My db includes two tables, Employees and Users, both with a pk of EmpNum (Autonumber in Employees; Number in Users). Users is a subset of Employees, and in the Users table, the row source for EmpNum is a query of the Employees table. I had a relationship defined with a one-to-one between the...

I have a .mdb file I administer in Access 2010, and it utilizes user-level security. I read the link at http://office.microsoft.com/en-us/access-help/what-happened-to-user-level-security-HA010342116.aspx, but on my ribbon in the Database Tools - Administer group, it only has Replication Options...

I'm trying to upgrade a .mdb file to .accdb. When I open the file, it displays a message saying it's an old version, and do I want to update? If I click Yes, it says, "The Microsoft Access db engine cannot find the input table or query MSysAccessObjects. Make sure it exists and the name is...

I have two forms, EA (a Continuous form) and EADetail (a Single form). They're not a form/subform, but they sit side-by-side, and the EA_Current event synchronizes EADetail so it shows detail information for the selected record in EA. They both have the same base query recordsource, but...

I am receiving the No Current Record message, but have been unable to determine the code that generates it. The database is a system that creates tasks and assigns them to users. In the header section of the Tasks form are several controls they can use to select Active or Completed tasks...

I have a table structure that I guess could be called a dual one-to-many-to-one, as can be seen in the attached Relationships screen print. Customer loan files are maintained in an AllFiles table, tied to the Customers and Loans tables through the CustomerFiles and LoanFiles tables. Users...

I have an application that is used to assign tasks to users. In some cases, proof of authorization is required, so the record includes a bound object frame control into which email messages can be dropped. When the assignee gets the task, it is read-only (AllowEdits = No). When they open and...

I have a form that shows assigned tasks, with a due date (locked) and a completed date that the user enters on completion. I'm trying to add a 2nd optional due date/completion date for certain tasks that have dual roles. I only want the 2nd dates to be visible if the 2nd due date contains a...

We will be converting our employees from Office 2003 to 2010 over the next weeks, and I currently have both on my PC. In one of my applications, many of the forms set set various various property values in the Load event based on the user type. Setting the AllowAdditions property to true does...

I have a field called NoteMsg with a datatype of OLE Object. On the form, the field appears in a Bound Object Frame. MS Outlook messages are copied and pasted into the field to provide supervisor approval for projects. On the form where the messages can be opened and read, the Allow Edits, Allow...