Search results

I'm trying to create 3 like fields on a form that show the last 5 field records for "casenumber" in a specific table. I'm trying to get this accomplished without having to create new "sub queries". I am able to accomplish this with some sql but i'm trying to apply this to three different form...

I've got an existing report that is dependent on an extremely large daisy chain of queries that I built a number of years ago when I was just learning Access and building a new database at that point. I'm trying to recreate the same report as I need to change the "work week" from what it was...

Subject should say DSUM with multiple criteria, sorry. I'm having a hard time getting this criteria to work for me. I have a table called Extractsales that contains the following Fields: RecordID SalesDate ItemSold - This is referenced to the id of an item in another table NumberSold...

So i'm sure this is an easy quick fix but its been a while since i've created a report that I cant recall how I did it previously. I have a report that is running off of an embedded query pulling data from a table. The fields i'm adding to the report are unbound sum if statements based on the...

I'm working on a report for two sets of data. This report essentially gives me the total count of cases in a period of time. The top portion of the report tells me how many total cases to date for the last 3 years. That information is coming up as expected and giving me the numbers i'm looking...

I know this is likely a simple issue that i'm overlooking but i'm not getting the results i'm expecting to see. CoverageStatus: IIf([employee]="X" or "Y" and IIf([Notes] Is Null,"pending","")) The intent is to use this calculated result to reference on a report for conditional formatting. I'm...

I've got a crosstab query set up as followed: Month: Row Heading Shift: Column Header EmpIDCount: value I have two questions regarding this same query which hopefully would apply to all future crosstab queries I build. Question 1: My shifts read as followed: Days, Swings, Mids In my query...

I've got a form which holds data for employees, fname, lname, ..... and an entered date which defaults to now(). On the before update event, i have the following. If DCount("*", "trainingdata", "[Empid]=" & Me!EmpID & _ " And [subjectid]=" &...

I'm trying to build a query with an iif statement to calculate expiration dates within a query. For some reason what i'm trying to do is not working as expected. Here's the situation. Every employees with an exception of two employees in the company has an expiration 2 years after the class...

I'm trying to build a report which will eventually be used as a subreport. I've got the general design of the report completed but now i'm having some issues with resolving further settings. The report consists of training classes and dates an individual participated in said training classes...

I've got a macro that converts five separate reports to .pdf files and saves them to a specific folder on the desktop for later use via button in a form. These .pdf reports are intended to be used for reference on a portable device in the field. What I am trying to do is create a single button...

I have a report with multiple fields and currently have two conditional formats affecting this report. CF1: Expression is [Covered By]="open open" - Highlights associated records yellow. CF2: Expression is [Status]="canceled" - Highlights associated records red I came across a situation...

I've got a secondary database that will be used in a portable device which will get its data from another db prior to being placed onto the portable device. What I would like to do is put a text box on the opening form of this database showing the date the table was built. To update the...

I have a database which contains a field with a .jpg attachment. I am in the process of decreasing the size of each attachment to reduce redundancy and increase consistency. I have roughly about 600 photographs I am currently working with and due to the nature of the database, additional...

I am trying to create a query to find missing sequential numbers in a text field. I am using this specific field as a case number which is designated as two letters, the # sign, two digits indicating the year, a dash, and then a four digit number; For Example: AB#13-1234. The reason for this...

I have a form that is being opened by a button with a vba command as followed. Private Sub Command33_Click() DoCmd.OpenForm "caseedit", , , , acFormReadOnly End Sub One of the fields in the form is a combo box that the user can choose an associated number to each field and open the data...

I've searched this only to find responses dated more than about 4 years ago and not exactly working for my issue, so hopefully someone here can help me out. I have a form with a combo box listing all my report names who's name is reportlist the row source for this combo box is as followed...

I currently have an unnormalized table that consists of individuals (employee profiles) which currently has a field for attachments. I am using the "attachments" for photographs of each employee however I dont want to maintain photographs for former employees, or if I do not forever. I was told...

I am trying to learn some aspects of vba and based on reading some things and pure trial and error, I dont think i'm getting very far. I'm really jumping the gun as i have a class next month. In any case, can anyone help me out with this. The intention for this is when i click a button on a...

In my data table, i have a "time" field whos format is "short time" (Military format). The primary user of the database is not all too avid with military conversion, I know its an easy conversion but; well i'll leave it at that. Because we are a 24 hour facility I want to keep the time in...