Search results

I'm working on a contract tracking database for our Legal section, made up mostly of dates. And I'm still trying to fully comprehend Normalization. (I want to be good at this!! :) ) The tracking changes a little bit based on the type of contract. (ie they all have to go certain places, but...

Hi, everyone! I want to make a message box that has these customized buttons: Print Preview Print Summary Cancel I've got a message box set up with the message I want, but it has vbYesNo as its button type. I don't know much about this, and the programming portion of Help is not installed...

Hi, All! I'm trying to calculate an average in a group footer in a report. In my underlying query I have calculated a DateDiff, and this is what I want to average. I've tried using an unbound text box and using =Avg([FileToMail]), but it tells me my sql includes an invalid data type. So...

Hi, all! I need to import a large text file into a table. I was showed how to do this on a colleague's computer, where I set up all the specs and all that for the text strings to go into the correct fields and all that. Trouble is, on my PC for some reason, it does not allow me to import a...

Hi, everyone. I'm working on creating a report that has a pretty detailed summary at the report footer. In the detail section, all the appellate cases for a certain month (inputted by user) are displayed, including the type/level of case, the issue of the case, the decision (outcome), how...

Hi everyone. I'm working on a new project where I get all my data from an outside source imported as a .txt file. The Main table has already been created, my job is just basically to manipulate data, calculate some stuff, and basically just make it easy to understand. The calculations I...

I just wanted to say thanks to everyone who helped me with my last Database. I finally can say (with 95% certainty) that it is FINISHED! Anyway, I definitely could not have done it without help from this forum, so THANK YOU! Especially thanks to ColinEssex, Ally, HayleyBaxter, The_Doc_Man...

Hi, everyone... I've got another problem... I've created a query to try to generate a report, but it's giving me some duplicate results. It doesn't duplicate every result, just some of them... Here's my sql: SELECT qryApplication.AnnouncementNo, [qryApplicant].[LastName] & ", " &...

Hi. I've searched for this topic, but the only thing I found was from April and had no replies... So here goes: Anyone know why my percents are rounding? I have a field for TestScore, which should hold a percent... I have the field set up as a number field, Integer, Percent, with Decimal...

Anyone have any idea why creating an index (no duplicates) on a field in my db screws up my relationships? There were already no duplicates. I can provide more information if it's needed, but I thought someone might have a thought... The field in question is a foreign key to another table...

Hey everyone, I've searched the forums, and found some stuff on this topic, but somehow it doesn't seem to quite answer my question. I'm creating a db in two parts. The users have part One already and use it. It's been going pretty well, but then this problem occured. I made a copy of the...

Hi (again)! All right, I have something more I'd like to do that I think will make my users' lives easier (and allow for fewer mistakes, hopefully.) Problem is, I'm not sure how to do this... I've got a database which holds all the employees in the agency, plus information on their positions...

Hi. I have a form with a subform laid out tabularly (is that a word?) so you can view multiple records in the subform for each record in the main form. Is it possible to take one of the fields on the subform (a lookup field with three options) and color the text the record is in according to...

If Else (*Wicked* easy question!!) Hi. I'm totally new at VBA so please bear with me... I'm working on an IF Else statement that has three different options. I've tried a few different things... I'm not sure how I would do this. If Certified = 1 then Do this Else If Certified = 2...

I have made a form from a query. The query has no calculations in it or anything, but still the recordset is not updatable. I've tried using different types of joins for this, but the query doesn't work with outer joins. Here's my SQL. I'm probably missing something pretty basic, but I'm...

I have a couple radio buttons on my form. Is it possible to enable or disable other fields on my form based on what the user has selected as an option? I've done a search of the forum, but I don't think I found what I was looking for... just a lot of Code talk... Which I'm not too good...

Hi! I'm working on a database that tracks postings for vacant positions, and applications to those positions. There are four main tables, plus a few lookup tables so far. tblPositions PositionNo (PK) CostCenter (Office the position is in) ClassCode (Title of Position) VacancyDate (Date...

Hi! Another question from the resident idiot. ;) I'm working with a form that I'm using to edit employee data. It is built from a query which uses the following fields: TD# (primary key, employee ID number) Last (last name of employee) First (first name) PositionNo (Unique number...

Hi, all... I'd just like some simple advice. I'm nearly finished a db for Human resources that lists all employees and all of their information. It has six tables (hopefully created correctly and normalized...) Anyway, they also want something that will track applications for vacant...

I am trying to create a query which will generate a report based on a date entered by the user. I can't, however, get the formatting right... When I create a prompt, the calculations in other fields return #ERROR. When I enter a date manually into the query, they return working fine. I'm...