Search results

I have two subforms on a main form. Both use similar queries and nearly the same set of records and PK. The first subform is for data entry and the 2nd subform is a continuous form that lists the entries in order that are made from the 1st Subform. (for entering in vacation days and...

Before I distributed my database frontend, I went into the Access Options and set the Confirm Record Changes, Deletions, and Action Queries all to unchecked (off). My db runs many update and delete queries and I do not want those message boxes confusing my users. For some reason, I am having a...

I am trying to open a report in normal view, popup & modal so the user can view the report prior to printing it. Problem is, the report will only open to a certain height and ends up cutting off the bottom inch of the report. The report is only about 7 inches high by 6 inches wide to begin with...

I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further : I want to have a splash...

Here's an easy one, although I've never had to do this before so I am a bit unsure. I have a continuous form that lists a group of records in a main form based on a query. On each line of this continuous form, there is a button that can be clicked to open the main form based on that record...

I would consider myself at a novice level when it comes to VBA. Mostly basic functions, but not declaring variables much yet. I have a db using 3 large tables with 1:1 relationships. Before you question my normalization, I stress that these tables are strictly used to temporarily store user...

I am already aware that it is impossible to utilize digital signatures on forms or reports within Access. Digital signatures are my only option. I have created a 2 page report that prints and saves beautifully. I am particularly using .pdf as the format to save the report to. On the report...

I have searched with no avail for this simple and common and very annoying problem that I have seen on every computer I've used Access 2007 on: When side scrolling from left to right in the query window or on tables, once I start moving to the right, all the text in the fields becomes distorted...

I am making a specialty form where it must toggle on or off when the user clicks on a boxed area. Since toggle backgrounds cannot be set to transparent, I need to do it some other way. I thought of either using a button to control a hidden checkbox, or just writing code altogether. The problem...

Hi all, Kind of long- winded, but I want to get this right before I deploy it. I am re-employing an Access 2007 database that I designed a few years ago, after making numerous improvements. This database is 3 tables. 1 table is personnel, another is files, and they are joined at a table...

I am using a continuous form which is strictly for reference (user enters no information.) It is a list of names from one table, and to the right of the names it has a spreadsheet appearance with a box conditionally formatted based on certain events for each day of the month. (Customer insists...

I have 3 HUGE 500+ page Access manuals that all have the same exact damn database examples in them in regards to the basics of forms, queries, and table structure. I have been designing much of my database project automation using macros and Expressions. I know the basic rules when it comes to...

I figured this out today...after searching everywhere with no avail. I didn't like limit to list property because users could still click on the control. Also, due to the code I was running, clicking on caetain combobox text in my continuous form caused a repeat of the original IIF conditions...

BORING PART: First off, I wanna say thanks to the help I have had in the past. I heard that my first database is still in full use without a hitch, and has just passed its 2 year anniversary. This forum is a godsend, and without you guys' help it would not have been so successful. I am still...

I am really new to VBA; having gotten by designing most of my database with macros so far. I have a query that I designed that pulls up a list of people and their email addresses, as well as 4 other fields of information. The query has no Nulls anywhere. I need to send an email through Outlook...

When I try to click on the event drop down in the property sheet on a new event, The embedded macro and condition options are no longer available. I only get the 'event procedure' option. What do I need to do to enable the embedded macro feature? I've looked all over for advice on this with no...

I'm having an issue with my database; 2007. I designed it at work, and it runs seamlessly there on the work computers. However, when I bring it home and load it from a burned disc to my home PC, it is extremely problematic. The count function in one of my textboxes on a form returns no results...

I have a form where users enter their personal information. Everyone who uses this shares email under the same domain. Is there a way to make the field for entering their email address automatically just add the "@here.address.com" to the end of the field, so they dont have to type that in...

I'm working on an expression in my Query. So far I have Year([Query2.DateIssued])=Year(Date()) This returns everything in the current year. I need also for it to return the last 3 months of last year as well, in addition to the current year. Can someone please tell me how I would write it...

This is probably easy. Need to have access purge all files from one of my tables annually on the very beginning of q3 (October 1st) of each year. I understand I need to use a delete query. What is the expression for specifying this same date each year to run this query?